Bug 86621 - direct SQLite open
Summary: direct SQLite open
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Connectivity
  Show dependency treegraph
 
Reported: 2014-11-23 12:08 UTC by emailcimem
Modified: 2025-06-02 14:53 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description emailcimem 2014-11-23 12:08:00 UTC
Please create a direct open possibility to the SQLite files in the Base.
"Open an existing database file -> Open -> SQLite database"

I tried the indirect way based on a lot of description, but did not work in my computer. There are lot of program which can open directly (in an easy way) the SQLite files (for example: SQLite database browser, Sqliteman) but I do not want to install a new program if the Base could handle the SQLite databases.
Comment 1 Alex Thurgood 2015-01-03 17:40:08 UTC Comment hidden (no-value)
Comment 2 jean.sanchez 2016-01-15 22:36:14 UTC
I am also using sqlite and LibreOffice often, I'd love to use both of them together...
Comment 3 lutz.neumann 2017-05-14 09:05:09 UTC
I#m also very interested on a direct support for sqlite
Comment 4 jorojmaqui 2019-01-18 08:39:40 UTC
I am also interested in direct support to sqlite or sqlite odbc
Comment 5 jorojmaqui 2019-01-18 08:40:05 UTC
sqlite and sqlite ODBC
Comment 6 Buovjaga 2025-06-02 13:43:42 UTC
There are instructions here now for connecting to SQLite databases: https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite

This report was self-confirmed in 2014 without any broader discussion.

In bug 38811 it was decided to not pick it as the default engine and instead we went with Firebird (yes, the migration story from HSQLDB is still unfinished due to incompatibilities). In the discussion it was said among other things: "SQLite3 has a rather weak notion of datatype, and uses dynamic typing instead of static typing which underlies the SQL data model. Also, it does not enforce that a column of a certain datatype actually contain values of that datatype."

So at the very least this report should not be in NEW status.
Comment 7 Lionel Elie Mamane 2025-06-02 14:53:46 UTC
It is a legitimate wish/enhancement request.

Whether any developer will spend time on it and do it is another question.