Richard Nagle wrote:
Have a few question regarding sqlite ; 1. what standard is the current sqlite using: "92" or SQL:2003 ?
http://www.sqlite.org/omitted.html
2. how does sqlite compare to mysql in the pro's and con's, another words, what major benefits would we get using sqlite over mysql?
http://www.sqlite.org/cvstrac/wiki?p=WhenToUseSqlite
3. part of #2. what are the speed advantages?
You can't compare a car with a bus... BTW http://www.sqlite.org/cvstrac/wiki?p=SqliteCompetitors http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations
4. part of #2. import text or tab delimited files? spreadsheet files ?
What do you mean? CSV tables (or similar) or SQL commands?
5. are there any MAC gui interface apps, that would interface with sqlite ?
Check at http://www.sqlite.org/contrib and http://www.sqlite.org/cvstrac/wiki?p=SqliteTools
Please if there a website, with all this information or a white paper, please provide the link.
did you tried www.sqlite.org? Usually it contains some useful info about sqlite.
Paolo
