Rapid Database Application Development
"Microsoft Access for Linux"
SQLite: Kexi Built-in DB Engine
We are using SQLite (http://www.sqlite.org) as default embedded engine for Kexi. SQLite source code is included within Kexi source code tree (in SVN repository: kexi/3rdparty/kexisql and kexi/3rdparty/kexisql3). Thus, no additional installartion efforts is needed to start use Kexi.
1. Ideas, recommendations
2. DB schema storage when no remote server is available
published: 2003-09-15 by js
Currently database schema is stored in database using special auto-created tables that is considered as system: kexiobjects, kexifields (there can be more).
In a situation when user cannot connect to network/remote database (or do not wants to do it), there is a requirement to offer him any local storage methods. In previous kexiDB release that was a storage from koffice libs, xml-based. Having effectife file-based driver that is always installed with Kexi (it is free of charge), we can just store DB schema in a file this database.
3. What's new (and interesting for Kexi Project)^ toc
2004-06-17 by js
2006-09-05 by js (SQLite > 3.3.6)
4. Changes made to SQLite
Since we have SQLite source ocde included in Kexi's source code tree, we were able to tweak it for our purposes. SQLite source distribution is powerfull enough, designed to be included in other projects (also for embedded systems), so for now there's no need for heavy tweaking.
Anyway, we're keeping all changes made to SQLite in this document: this will help when updating to newer SQLite versions will be performed.^ toc
4.1. All SQLite versions