Sign in to follow this  
Followers 0
tamnguyen

Use SQLite

6 posts in this topic

Hi All!

I'm using AutoIt to develop a software. I know that AutoIt can create SQLite database but some friend say SQLite isn't safe because it doesn't have data security.

Does AutoIt can create MySQL database? 

Can anyone give me a advice about MySQL and SQLite??

Share this post


Link to post
Share on other sites



#3 ·  Posted (edited)

I have a problem when i "Go" source demo code  of Help File. When i press "go", it has a notice " SQLite3.dll can't load".

I think that it can't find sqlite.dll but i find it in path "AutoIt3/Include/sqlite.dll".

Can anyone help me?

I want to use SQLite to create a database

Edited by tamnguyen

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

Download sqlite3.dll (from sqlite.org) and copy this dll either to C:\Windows\System32\ or to script directory.

You can download it also from here:

https://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/

https://www.autoitscript.com/autoit3/files/beta/autoit/archive/sqlite/sqlite3.dll

Edited by Zedna

Share this post


Link to post
Share on other sites

If mor than one process will be accessing the SQLite database concurrently, you may also want to look into a way of locking it during access to avoid problems.

I just updated my >Cooperative Semaphores UDF today.

Share this post


Link to post
Share on other sites

#6 ·  Posted (edited)

Just a idea.
I'm Using a Mysql database but I'm not talking direct to the mysql database but I used PHP scripts.
So If you used a php script between it you won't have to put your mysql username and password in your Autoit script (not safe)
 
You can use this to talk to your PHP script:
 
$link = "http://www.blabla.php"
$sendstring = "What ever your want to send to your PHP script"

$oMyError = ObjEvent("AutoIt.Error","_MyErrFunc")
$oHTTP = ObjCreate("winhttp.winhttprequest.5.1")
$oHTTP.Open("POST", $link)
$oHTTP.SetRequestHeader("Content-Type", "application/x-www-form-urlencoded")
$oHTTP.Send($sendstring)
consolewrite($oHTTP.ResponseText & @CRLF)
Edited by nend

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0