SQLite semi Embedded database functionality in AutoIt

[ptrex]

@picasso

OK.

I will add the to do' s and the link to the first post in order to accomodate the visitors of this thread.

Speak to you later.

First Post has been updated

Edited November 25, 2005 by ptrex

[jpm]

@picasso

Tested !! Everything runs fine now !! Great job, Thanks.

I my first post I added a 'TO DO' list. This list came from your previous posts.

Everything seems to be finished. Is this correct ?

Could you review this so that all visitors know what the status is at the moment.

If there are open items please let me know, so I wil add them.

Thanks again.

PS: I hope that your SQLite.au3 could be added as a standard UDF in the AutoIT distribution.

One thing is not clear to me is can we include the sqlite3.dll in the AutoIt setup?

Does the distribution of such package can be only dowloaded by the user itself?

[ptrex]

@jpm

One thing is not clear to me is can we include the sqlite3.dll in the AutoIt setup?

It is very easy to include this in the AutoIT setup. It's just 1 sqlite.dll to add on.

This could be put somewhere in the BETA folder of the AutoIT3 folders.

The SQLite.au3 goes into the includes folder.

And that' s about it.

The only thing that needs to be set in the SQLite.au3 is the path to the SQLite.DLL folder (if the DLL is not in the Windows\System32 folder)

The user can of course download everything themselves, but why not supply everything whith it.

[jpm]

@jpm

It is very easy to include this in the AutoIT setup. It's just 1 sqlite.dll to add on.

This could be put somewhere in the BETA folder of the AutoIT3 folders.

The SQLite.au3 goes into the includes folder.

And that' s about it.

The only thing that needs to be set in the SQLite.au3 is the path to the SQLite.DLL folder (if the DLL is not in the Windows\System32 folder)

The user can of course download everything themselves, but why not supply everything whith it.

my question was from legal standpoint, some copyright to be included ...

if it is really free we can solve the path by installing the default sqlite3.dll in the autoit->extra dir

[ptrex]

@jpm

my question was from legal standpoint

SQLite Copyright

The original author of SQLite has dedicated the code to the public domain. Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original SQLite code, either in source code form or as a compiled binary, for any purpose, commerical or non-commerical, and by any means.

If you want to read to full story

http://www.sqlite.org/copyright.html

I hope this clears out the legal issues for distributing the DLL with AutoIT.

[piccaso]

implemented safemode partly, only db handles are monitored.

query handles will be monitored after functions for maual reset/finalize are made...

can be turned off (and on) again using

_SQLite_SaveMode(False)

Whoever can produce a crash with wrong db handles and postes the code gets a cookie

[piccaso]

added _SQLite_QueryReset(), _SQLite_QueryFinalize()

SaveMode is completed now.

[Greenseed]

it pretty nice! and i think you idea to implement to autoit is nice! because it bring efficient database server to small buisness without heavy cost!

and because autoit it the only language i know! and im not very experimented with dllcall() or objcreate()!

again nice job!

[piccaso]

it pretty nice! and i think you idea to implement to autoit is nice! because it bring efficient database server to small buisness without heavy cost!

its no database server just database functionality, and since everything is free there are no costs at all

again nice job!

Thanks :">

[piccaso]

Renamed _SQLite_FetchArray() -> _SQLite_FetchData()

Added _SQLite_FetchNames(), Example included

[piccaso]

Removed _SQLite_Commit(), _SQLite_Close() handles $SQLITE_BUSY issues

Added Function Headers

Fixed Bug in _SQLite_Exec(), $sErrorMsg was set to 0 instead of 'Successful result'

Edited November 29, 2005 by piccaso

[ptrex]

@picasso

I reviewed you last version and tested it against some examples.

I ran all the way !!!! Very nice job picasso

I think this version is ready to become a standard UDF

PS: One question left. You removed the Exec "COMMIT".

Where does this have to fit into when creating a application. Does the developer have to build in the commit himselve (which is fine for me) ?

Can you give us some more explenation about this.

Thanks

[ptrex]

New version 4.5 of the SQLite_GUI is available in post #1

- Added Icons to the TreeView

- Added Close Database in Menu

- Added Advanced View TAB (with a lot of parameters to set)

READ THE SQLite documentation before using - See Syntax PRAGMA statement)

- Added more datatypes

- Miscelanious Bug fixes

Still a lot to add before it's finished

Edited November 28, 2005 by ptrex

[piccaso]

I reviewed you last version and tested it against some examples.

I ran all the way !!!! Very nice job picasso

I think this version is ready to become a standard UDF

thanks :">

... still needs doc's and more samples

PS: One question left. You removed the Exec "COMMIT".

Where does this have to fit into when creating a application. Does the developer have to build in the commit himselve (which is fine for me) ?

Can you give us some more explenation about this.

Thanks

COMMITing is as easy as

_SQLite_QueryNoResult(-1,"COMMIT")

_SQLite_QueryNoResult() also handles $SQLITE_BUSY issues

Could you please update your 1'st post.

Everything is done exept Doc's & Samples

and maybe make a poll out of it, if people want it as standard udf...

i dont know... you decide, its your thread

thanks

[piccaso]

Changed _SQLite_Display2DResult(), Better Fromating for Lager Tables & Ability to Return the Result

Added (Very Simple!) Gui Example

[Walkabout]

Picasso,

You have been an absolute powerhouse. Thanks for all of your hard work.

Walkabout

[ptrex]

@picasso

Very nice job again !!

_SQLite_QueryNoResult(-1,"COMMIT")

Propably the documentation will prevent questions like mine,regarding the "COMMIT"

I ran some tests and no errors so far.

One REMARK. When you uploaded the ZIP, with the latest version and examples. I noticed that you included the SQLite3.DLL which is 120 Kb large.

The lastest version 3.2.7 is of a different size. See download page http://www.sqlite.org/download.html

Maybe it's wise to test against the latest DLL.

PS:

- I updated the to do list

- I am willing to set up a poll but I need to figure out how to do this in this forum. Anyone who can point me out whrere to start, let me know.

[ptrex]

@picasso

I am willing to set up a poll but I need to figure out how to do this in this forum

I think I am not authorized to set up a poll for voting for a standard UDF SQLite.au3

I think we will have to ask JPM to do this for us.

[jpm]

@picasso

I think I am not authorized to set up a poll for voting for a standard UDF SQLite.au3

I think we will have to ask JPM to do this for us.

I don't think I can change an already started topic but you can start a new one with a voting action

[Greenseed]

i do not know is some have a idea, or knowing someone who code in python!

Because! i have a database made with pySQlite3 it is SQLite For python! my probleme! is i can't access this database with original SQLite call! python do something i don't know!

i send you a example database, who work very well on my XBOX with python scripting! but unable to access it on my PC with any database viewer! if i open the file with a HEX editor i can see is in SQLite3 and all my data.

thx in advance!

MyMusic6.rar