Does any1 have experience with SQLite??

[minckle]

Hi, I've created an application using MySQL n Delphi 5, I now would like to create a cut down version, which i can distribute to customers where they just install the App and nothing else, basically im looking for a database that can totally be embedded into my application or a .dll, so that no extra installs or files need to be install.

Ive heard of a product called SQLite, but no1 was prepared to recommend it as theyve never used it before. Have you used it?? Would you recommend it?? Are there any alternatives you could recommend that would work for me???

Thanks

 

[xdracox]

Well, I have heard of it before and never looked it up until now. It looks like it's very useful by just looking at the website (

http://www.sqlite.org).

 

[towerbase]

Yes, I've used SQLite and it works. On the basis of my experience, I would recommend it.

I normally use MySQL and dbExpress for database work but I wrote a test application that used SQLite with a view to distributing an application with an embedded database. The test application worked okay. However, the real application is not a high priority at the moment so I have no experience of actually distributing an SQLite based application. But I feel fairly confident that SQLite is a sensible solution.

Andrew
Hampshire, UK

 

[xdracox]

I'm still new to Delphi, so I was wondering how to use SQLite with Delphi 7. Could anyone please explain how?

 

[Zoxc]

AbDatabase is just like BDE just faster can be totaly integrated to app except the small database file that you can put whereevery you want it, the personal version of it is free

 

[AP81]

Why do you just use text files like a database? I have done that in situations where I didn't want to connect to a database, e.g. lay you files out like this:

"1045","test1","test2","test3"
"1046","test1","test2","test3"

Then you write a small function which retrieves a column value based on the index of the delimiter, e.g. the above has four columns, so to access the fourth value, you would count the number of commas (index) and get the string after index=2.

Hope that helps






------------------------------------
There's no place like 127.0.0.1
------------------------------------

 

[xdracox]

Where can the personal version of AbDatabase be found for download?