Libreoffice Sqlite

admin 11/22/2021
70 Comments
It's official. Or at least seems so in the LibreOffice development path:

Libreoffice Sqlite Odbc


default to SQLite not HSQLDB in Base

You can access SQLite data from Open Office Base or LibreOffice Base — desktop database management systems. Note that the Windows version of OpenOffice is 32-bit, and you may get the error “The specified DSN contains an architecture mismatch between the Driver and Application” when trying to access a data source through a 64-bit ODBC driver. You can access SQLite data from Open Office Base or LibreOffice Base — desktop database management systems. Note that the Windows version of OpenOffice is 32-bit, and you may get the error “The specified DSN contains an architecture mismatch between the Driver and Application” when trying to access a data source through a 64-bit ODBC driver. بعد محاولة للمساعدة وتعلم أمور جديدة عن libreoffice فكرت أن التحويل لـ SQL سيكون خطوة لتقريب المسافات 1 ومن ثم التحويل لـ SQLite أستخدم تلك القصاصة لذلك 2 مذكور في الرابط الأول أن هنالك تعليمات عليك.

Note: SQLite appeals to anyone frustrated with using MDB files under Linux, or who has had difficulty installing MySQL or other RDBMS server on their workstation. Using SQLite Database with OpenOffice.org 2. Installing the ODBC Driver for SQLite Installing the ODBC Driver for SQLite.


I was going to refrain from comment but perhaps I'll begin with a few Pros & Cons:

Libre Base Handbuch

Pros

Libreoffice Base Beispiele


    + Will result in a native SQLite 3.x driver for Base on all platforms
    + Eliminates Java dependencies from the back-end database engine
    + Might stabilize the 'Embedded database' product due to code rework or proper unzip to disk during use
    + Might result in auto-configurations (pre-sets & checkbox options) for various engines (including HSQLDB 1.8.0 & 2.x for migration purposes)
    + If implemented as a separate, external, database file: offers direct database access from other applications
    + If implemented as a separate, external, database file: only 1 file in addition to the Base (.odb) front-end file

Libreoffice Sqlite Windows

Libreoffice Sqlite
Cons

Libreoffice Slide

    - Significant step backwards from HSQLDB 2.x and even HSQLDB 1.8.0 in terms of SQL support and features
    - No easy or realistic migration path from default single-user to client-server like we enjoy with HSQLDB
    - May lack seamless support for legacy 'Embedded databases'
    - If implemented as a separate, external, database file (as it should be for stability and external .db access): now 2 files to distribute (.odb + .db)
    - Missed opportunity to integrate H2 'mixed mode' for maximum flexibility including multi-user environments; also 2 files to distribute just like SQLite; also an Android candidate like SQLite (LibO is apparently targeting Android as a future goal)