Use SQLite

[tamnguyen]

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??

[Zedna]

Search this forum, as far as I can remember there is UDF for MySQL.

Note that support (functions)  for SQLite is included in AutoIt as standard UDF.

Also look at http://www.sqlite.org/ to see what is SQLite and what it can/can't do.

Edited October 25, 2014 by Zedna

[tamnguyen]

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 October 25, 2014 by tamnguyen

[Zedna]

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 October 25, 2014 by Zedna

[willichan]

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.

[nend]

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 October 31, 2014 by nend