Tom Cloud wrote: > Does anyone on the list have experience with SQLite? > http://sqlite.org/
Yes, I'm using it in my main commercial project. And, Dabo uses it to store preferences. It is great for what it is: simple and lightweight. > ... their home page says it is a "self-contained, serverless, > zero-configuration, transactional SQL database engine" Yep. > I'm told it creates one file rather than multiple tables, which I don't > understand, as other SQL implementations use a DBC and tables ?? There's only one file (or, no files at all if you just keep it alive in memory). The file will grow in size as needed, but never shrink unless you explicitly tell it to 'vacuum'. > This looks great -- no separate server, etc. Is there a connector for VFP? It is great for *single user* applications running locally on the same machine as the app. I wouldn't consider it for multi-user, ever. I don't know about the VFP connector, sorry. I'm using it from Python for which there is a db-api module. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
