SQLite semi Embedded database functionality in AutoIt

[piccaso]

you dont have to feel sorry for you opinion ptrex.

and i know better, at least fo mysql

i have been maintaining the technical side of a php/mysql based onlineshop for years

and even connected it to 2 stores and 7 resellers...

i'll allways feel sorrow for quitting there, i had the time of my life

edit:

i read you code, but allmost a year ago...

i dont remember much.

Edited September 29, 2006 by piccaso

[JSThePatriot]

JS, is your projects soruce open?

did you put it on a public repository?

... if not and you want to i would recomend https://opensvn.csie.org/

i would realy like to take a peek on what your up to

i cant realy write c/c++ just a little but i can read it.

and since there is a need for a autoit part maybe i could maintain it...

if you want, and i have enaugh time...

I will check into the repository, I have never used one. I generally release the source code with a release of any of my projects. What exactly is a repository good for? (Keeps copies of each version?)

I am about ready to release an alpha, and see how you guys like the feel of it so far. It wont be able to return any queries, but it can set them. I havent tried to run a returnable query yet.

@JS

I would keep the functionality as it is, for resultless Qry statements

I would prefer sqlite3_Query, but this is a matter of tasted of course.

Better would be that "sqlite3_exec" could handle both the resultless QRY and the normal QRY.

Like LikeX can do. This is one less function to memorize. The easier the better.

I am hoping that with some time that sqlite3_exec or rather plugin SQLite_Exec($hDB, $sSQL) will handle it completely. That will depend on how my callback functions will interface with AutoIt.

I agree about one less function to memorize. Not to mention sqlite3_get_table is just a wrapper for sqlite3_exec. If they can wrap it, then I can. Even if right now my plugin has to be bloated handling all the data for AutoIt until it can handle array outputs.

@Piccaso/JS

Did either of you take the effort to read through the script if SQLit_GUI (see first post).

Please do and take the time to study what SQLite (=LiteX) has to offer.

regards

ptrex

I have taken the time in the past to take a peek into all of the source code provided in this thread. It has been some time since I have looked at the source.

One thing to keep in mind using COM method is always going to "feel" a bit nicer in my opinion, it just depends on what you are used to programming with. I immediately went with the DllCall version even though I have never personally used DllCall, I didnt want to use COM . Just my personal preferences.

@ptrex

Just as a friend to a friend, I think you may not mean your words as harsh as they seem to come across, and that may be why you have seen me get a bit defensive, and I feel piccasso has also gotten a bit defensive of his work as he feels you are attacking his wonderful UDF.

JS

[ptrex]

@JS

There are no hard feeling

In real life I work with large DB systems, like Oracle and MS SQL.

When I see the power of this tiny SQLite DLL, I get a bit carried away.

Anyhow I hope I am not getting the Valik disease :">

see you all around !!

regards

ptrex

EDIT : Typo

Edited September 30, 2006 by ptrex

[GaryFrost]

@JS

There are no hard feeling

In real life I work with large DB systems, like Oravle and MS SQL.

When I see the power of this tiny SQLite DLL, I get a bit carried away.

Anyhow I hope I am not getting the Valik disease :">

see you all around !!

regards

ptrex

I'm guessing you meant Oracle

[piccaso]

I will check into the repository, I have never used one. I generally release the source code with a release of any of my projects. What exactly is a repository good for? (Keeps copies of each version?)

has some nice features for multiple people working on the same thing.

takes care of backups too...

and you can easily step back to an old revision if you messed it up...

everybody can see what your up to

there is much more, i havent used all features myself...

and you can 'blame' eache line of code on an author

google for TortioseSVN if you need a good windows client.

after a one time setup there is not much affort for updateing, just rightmouseclick -> commit

and if the repository is public you can use it as donload location (like i did with sqlite.zip) and dont have to

upload it to a webserver or something like that...

the simple features are quite self explaining.

if you dont want to do it all alone ist probably a step in the right direction

[JSThePatriot]

has some nice features for multiple people working on the same thing.

takes care of backups too...

and you can easily step back to an old revision if you messed it up...

everybody can see what your up to

there is much more, i havent used all features myself...

and you can 'blame' eache line of code on an author

google for TortioseSVN if you need a good windows client.

after a one time setup there is not much affort for updateing, just rightmouseclick -> commit

and if the repository is public you can use it as donload location (like i did with sqlite.zip) and dont have to

upload it to a webserver or something like that...

the simple features are quite self explaining.

if you dont want to do it all alone ist probably a step in the right direction

I will look into it further. I dont know that anyone other than myself has really expressed any interest in contributing. I have no problem releasing the source, and plan to do so. I know some people trust my work, but it is always better to relieve all doubt about a person.

I suppose that once I actually get something going a bit further I could add it to my sourceforge account as another "extension" of SQLite. There are alot of them.

JS

[CriCri]

Hello,

I'm sorry, but unable to get a working example of this project.

I have downloaed the sqlite.zip package from the first page of this thread, but, when i try to compile "example_browser.au3" for example, i get this Auto2exe error message : "Error reading the file : GuiList.au3".

I can't find this file. Could you tell me what's wrong please ?

Thanks.

[piccaso]

Hello,

I'm sorry, but unable to get a working example of this project.

I have downloaed the sqlite.zip package from the first page of this thread, but, when i try to compile "example_browser.au3" for example, i get this Auto2exe error message : "Error reading the file : GuiList.au3".

I can't find this file. Could you tell me what's wrong please ?

Thanks.

works fine here...

which autoit version do you use ?

[CriCri]

Hello,

I'm using 3.1.1.0.

Is GuiList.au3 part of AutoIt, or part of the AutoIt sqlite port ?

Thanks

[piccaso]

its part of autoit.

but example_browser.au3 was written shortly bevore 3.2 release

it should work with the latest stable autoit release (3.2.0.1).

but i would recomend the beta because it has sqlite included...

edit: and by the way this is no sqlite port, its just a wrapper for sqlite3.dll

Edited November 14, 2006 by piccaso

[ptrex]

@piccaso

Congratulations on getting the SQLite UDF included in the Beta !!!

This is the least you deserve.

I am still working on some functions from time to time so I will be in touch later.

Regards,

ptrex

[JSThePatriot]

I have a lot of functions working in my the SQLite Plugin. I am just waiting for the plugins to be completed or at least support array returns, so that completion of the plugin will be possible.

List of Functions:

SQLite_Open

SQLite_Close

SQLite_Exec (not fully complete)

SQLite_LibVersion

SQLite_ErrCode

SQLite_ErrMsg

SQLite_LastInsertRowID

SQLite_Interrupt

SQLite_GetAutoCommit

SQLite_Changes

SQLite_ExtResultCodes

SQLite_TotalChanges

I cannot wait for this to be completed!

JS

[CriCri]

its part of autoit.

but example_browser.au3 was written shortly bevore 3.2 release

it should work with the latest stable autoit release (3.2.0.1).

but i would recomend the beta because it has sqlite included...

[...]

Yes, you're right. It's work fine with the last beta version.

Thanks a lot !

[bearcav]

OK, now it works great! You repeated your error function.

Really cool!

I haven't been able to get any work done for all the playing.

[leecole]

I have seen examples of Creating and reading SQL databases, but could someone post an example of updating a single field in a multi-field record? I admit I don't know sql, but so far all my efforts have failed at updating a field's value, instead I end up adding a new record.

[ptrex]

@leecole

Here is all you need to know to get started.

SQL Tutorial

Look for "update"

Enjoy !!

ptrex

[leecole]

@leecole

Here is all you need to know to get started.

SQL Tutorial

Look for "update"

Enjoy !!

ptrex

Thanks, I didn't have to look far, before I found my answer.

[gadzail]

Hi All,

I have a question about upgrading SQLite.

• Is it possible upgrade SQLite to 3.3.13 (http://www.sqlite.org/) simply copying in the SQLite folder the new version? The functions still continue to works?

[ptrex]

@gadzail

Indead it is as simple as that.

But the new functions of the lastest DLL won't be there.

Regards

ptrex

[gadzail]

@gadzail

Indead it is as simple as that.

But the new functions of the lastest DLL won't be there.

Regards

ptrex

@ptrex

new functions of the lastest DLL ? Sorry, I don't understand.

There are new UDF functions for SQLite? Or you mean the new functionality in SQLite 3.3.13 cannot be present

in the DLL?

..And also, I have another question:

- I check the SQLite doc. but I don't understand if I can access SQLite DB from different Pc in a network in the same time.

For example: I create an autoit program on my Pc that use interacts with a local SQLite DB and i want to use the same program installed in other (remote) PC stations connected in a network. If I map the SQLiteDB folder in the remote Pc, all the PC can get and modify data in the DB in the same time or I can get errors?

I hope I was clear..