Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||SQLite SDBC driver for OOo|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||andre, davidf, issues, jason-ooo, kami911, mcepl, neteler, stp|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description yvesc 2004-07-26 22:25:16 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.
Comment 1 Frank Schönheit 2004-07-27 07:32:13 UTC
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
Comment 2 fheible 2004-08-21 19:44:02 UTC
SQLite support should be considered as an obviously necessary DB functiunalty. It's a thin DB, which is adapted to the office users needs.
Comment 3 urosmilos 2004-09-29 00:40:28 UTC
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.
Comment 4 davebaileync 2004-11-08 13:42:56 UTC
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.
Comment 5 dyrcona 2008-03-24 20:57:37 UTC
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.
Comment 6 neteler 2009-08-22 00:34:31 UTC
Is there any solution to import SQLite into OpenOffice? I would like to use Calc on SQLite tables.
Comment 7 ceplm 2009-09-25 07:19:59 UTC
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/
Comment 8 dipanpatel 2009-10-17 00:28:27 UTC
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.