Issue 32117 - SQLite SDBC driver for OOo
Summary: SQLite SDBC driver for OOo
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial with 118 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-26 22:25 UTC by yvesc
Modified: 2017-05-20 10:45 UTC (History)
8 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.
Comment 9 Marcus 2017-05-20 10:45:20 UTC
Reset the assignee to the default "issues@openoffice.apache.org".