Apache OpenOffice (AOO) Bugzilla – Issue 32117
SQLite SDBC driver for OOo
Last modified: 2020-07-08 07:47:15 UTC
Many OOo users would like to see SQlite to become the main SQL database file based engine to be embedded with OOo 2.0. The first step would be to write a SDBC driver for SQLite. You can find here (http://dba.openoffice.org/miscellaneous/developer_projects.html#embed_sqlite) further informations. Anyone who's interested in this feature is requested for voting for this issue or for bringing help to write this SDBC driver.
thanks for submitting this confirming as valid feature request (which doesn't yet mean anything about it being implemented) correcting priority (see http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority, please) targeting to "OOo Later" for the moment
SQLite support should be considered as an obviously necessary DB functiunalty. It's a thin DB, which is adapted to the office users needs.
I've been using SQLite for some time now and I think it fits the bill here perfectly. Of course it does have it's limitations, but if's far from inadequate. As said earlyer, it lacks many enterprise features but it is the "best on the market" at the moment for what we, regular SOHO users, need it the most (easy, no hassle, exchange of lightweight db files). HSQLDB in my opinnion is not a very good choice since it has runtime dependencies.
In my opinion, not having an easy-to-use database has been the single largest factor to keep many people from switching from MS Office to Open Office. This would be a big step in the right direction. This built-in database capability that can be easily ported to other platforms is a key part of this technology.
Be nice to see this one working. I'm willing to help out with code. I use SQLite a good bit in my DB programming.
Is there any solution to import SQLite into OpenOffice? I would like to use Calc on SQLite tables.
You can try to use SQLite ODBC driver http://www.ch-werner.de/sqliteodbc/ (or even the JDBC one http://www.ch-werner.de/javasqlite/
It is important to have a single point of data accessible by different application easily. As the popularity of google gears increases the importance of sqlite as this single point of data will become all the more prominent to a point that it will be utterly missed by users if unable.
Reset the assignee to the default "issues@openoffice.apache.org".
*** Issue 105995 has been marked as a duplicate of this issue. ***