Sqlite Vs ODBC

[Douglas McDonald]

First off I know very little about database programming. I've played around with SQLighting but the documentation is a bit lacking for someone like me who knows nothing about basic databases. I have a simple problem I'm sure but I'll post on that in another topic.

My question is what is the proper tool for the job. I happen to have SQL tools pro(perfect sync) and have used that with success to connect to various Db's via ODBC in PB apps. Its obvious that buying SQLtools is a disadvantage if you don't need it for SQLighting.

Am I correct in thinking that SQLighting is faster since there is not an ODBC  interface driver involved? In my case a 100th of a millisecond won't make any difference.

I believe you can not 'create' a database in SQLtools but I may be wrong. I've been using Access or FoxPro(at work) to create the DB. So SQLighting is better in that respect.

Another issue I have is that my program may have to interact with other DB's so am I better off just using ODBC and SQL Tools for everything?

I really don't Know and would like some advice.

Thank you
Doug

[José Roca]

I believe you can not 'create' a database in SQLtools but I may be wrong. I've been using Access or FoxPro(at work) to create the DB. So SQLighting is better in that respect.

With SQL Tools Pro Version 2 you can use SQL_DataSourceModify to create new Access databases.

[Rolf Brandt]

Hi Jim,

I enjoyed those nice memories to the days of Turbo-Basic, Quick Basice etc. BTW you might want to check your link to "http//jimsworld.net/". It actually points to
http://%22http//jimsworld.net/".

[Martin Francom]

Jim,
   I am new to SQLite.  I am real glad I started to learn and use SQLitening and SQLite.  It's to there isn't a "Building Database with SQLitening/SQLite" book, it would have made the learning curve so much easier.   But, I have to say, i have recieved a lot of help from the programmers here and on the SQLitening website.

   If you like to learn from example,  you might want to download and play with a SQLitening/SQLite project that Rolf helped me write.   Here's the link:

   http://www.planetsquires.com/protect/forum/index.php?topic=2032.0

[Martin Francom]

Here's a link to a free SQLite Manager Program

http://osenxpsuite.net/?xp=3

[Douglas McDonald]

Thanks Jim, I know what you mean. I could do what I need with just a couple of type structures and store it in a binary file and just look up data with pointers. I'm just building a ham radio contact log, but I may need to interface into another type of DB to look up call signs and other data. So I think SQLtools and ODBC is the best approach in this case. SQL tools does seem to be very good with good documentation. Many times the documentation is worth more than the software

I started with SQLightning but I got stuck, some things are not too obvious and the documentation assumes you know it all already. I can see many uses for it though.
I did look through some examples here and they are good, thank you, but I just need a very simple non client / server sample  that creates a DB, adds some records, reads some records ect.....Maybe I'm just too stuck in my ways to really understand DB programming, SQL is as wired as C/C++ in its syntax and its totaly due to my lack of effort to really learn it I think or a big mental block. Most of the software I write is firmware for micro controllers or GUI front ends to interface the data from the MCU's. Its just a different style of programming.

Thank you all
Doug