Also you can check an expanded list of ODBC drivers for Oracle, SQL Server, PostgreSQL, MySQL, SQLite. Previous by thread: [libreoffice-users] Using SQL functions in LibreOffice base (notation) Next by thread: [libreoffice-users] Re: Using SQL functions in LibreOffice base (notation) Prev by Date: [libreoffice-users] Using SQL functions in LibreOffice base (notation) Next by Date: [libreoffice-users] LO Writer won't let me manually hyphenate a name. SELECT and CALL. LibreOffice Base Database templates. LibreOffice Base is a free and open-source relational database management system that is part of the LibreOffice office suite.LibreOffice Base was built off of a fork of OpenOffice.org and was first released as version 3.4.0.1 on October 4, 2011.. But because Base is a powerful and flexible application, you need to be able to make some informed decisions while working with it and this, in turn, requires some preparation. ; PostgreSQL (LibreOffice.org 3.x) The component supports two views: GUI Query Designer (Designer View) Text editor (SQL View) Queries created and executed in Designer and SQL View support the use of named replaceable parameters in these statements, in most cases. See Database drivers page for overview. ... LibreOffice is available for Linux, Windows and Mac. There are drivers for PostgreSQL, SQLite and MS-Access mdb files. Purchase or download the latest LibreOffice base Handbook, written by community experts. Features of the template include macro buttons for opening different forms and SQL queries for document / account balance calculations and list filtering. Some examples of using SQL are Retrieve or SELECT data from a database LibreOffice, the best free and open source office suite. The first step is to select which database you want to select: The second step is to select which connection: The third step is to select your database: This tutorial will try to help you better understand the options offered by Base while at- database system with Base. The Query component in Base allows for SQL commands that return a result set, i.e. I am trying to connect LibreOffice Base with an MySQL database, in phpMyAdmin, with a JDBC-connection. Usage of OpenOffice-Base with various drivers. SQL is Structured Query Language Standard Language for accessing and manipulating databases SQL is an ANSI (American National Standards Institute) standard Some examples of DBMS using SQL: LibreOffice Base, MySQL, Microsoft SQL Server, Microsoft Access, Oracle, DB2. Similarly to the other packages in the LibreOffice suite, Base is supported across multiple platforms including Microsoft Windows, macOS, and Linux.