Extract it and then use make to compile and install 2 Go to the project website and download the tar file. In our case we need to install SQLite ODBC Driver for Linux. It is very specific to database and can vary for platforms. When it receives a specific query from the application it translates into a way that is required by the specific database. ODBC driver is a translation layer between the your application and database. Sudo apt-get install unixodbc-dev unixodbc-bin unixodbc You can install the unixodbc bin files and def files by running the UnixODBC is a standard ODBC implementation for *nix systems like Linux 1. Idea was to make the Application-DBMS interaction independent of platform or databases. Open Database Connectivity (ODBC) is a standard set of APIs for accessing database management systems (DBMS). My Ubuntu LibreOffice installation didn't have base installed by default.

Sudo apt-get install sqlite3 libsqlite3-dev This can be done by installing libsqlite3-dev We also need to install the SQLite3 development files. We are choosing the latest SQLite available. You might want to run the specific commands for your distro, specially sudo apt-get install part. Hence the commands to install are mostly for Ubuntu.

6 Configure databases to be used by ODBC - Data Source Name (DSN)Įven though the steps I have here should be some what reproducible on any Linux system, I use Ubuntu on daily basis.We will also create a report as a test case. But base does allow the user to connect to any database using ODBC. It would have been great if base allowed opening Sqlite file directly. So I thought it would be great to have SQLite work with Base.

In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to almost any other existing database engine as well. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. It allows the users to create reports, forms etc.īase is a full-featured desktop database front end, designed to meet the needs of a broad array of users. It makes interacting with the database (local or remote) easy. Base is a full-featured desktop database front end designed for non technical users. LibreOffice is a powerful, Free and Open Source office suite. But I still know some who like to use LibreOffice Base. For most I suggest using DB Browser for SQLite (DB4S) project which has a great UI, is open source and cross-platform. Most of my personal projects use SQLite as the database. I love SQLIte for its simplicity, portability and stability.

Libreoffice base sqlite