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.
Adding self to CC if not already on
I am also using sqlite and LibreOffice often, I'd love to use both of them together...
I#m also very interested on a direct support for sqlite
I am also interested in direct support to sqlite or sqlite odbc
sqlite and sqlite ODBC
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.
It is a legitimate wish/enhancement request. Whether any developer will spend time on it and do it is another question.