Using LibreOffice with MariaDB [and Docker]

on YouTube ↗25m

" summary

Step‑by‑step instructions for connecting LibreOffice Base to MariaDB 10.5 using the MariaDB ODBC connector (tested with MariaDB ODBC connector 3.1.7), unixODBC and isql to verify the DSN and driver; shows creating a user anel with password anel, a libreoffice database, and pulling JSON into tables via the CONNECT storage engine JSON table feature (one source yields 10 rows, another 100). Demonstrates running LibreOffice Base from Docker, creating a custom docker image mariadbbase:odbc (≈1GB) and confirms the GUI, ODBC connection and table creation work.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to talk
2. 0:51MariaDB overview and setup
3. 2:53Installing MariaDB ODBC connector
4. 6:33Configuring ODBC driver and DSN
5. 9:49Testing ODBC connection with isql
6. 12:45Setting up LibreOffice Base
7. 15:25Using Docker for isolated environment
8. 20:38Automating with Dockerfile
9. 24:59Summary and closing

" related talks

• 17mState of MariaDBMichael Widenius · Percona Live 2022
• 18mBuilding Data Lake with MariaDB ColumnStoreSasha Vaniachine · Percona Live Online 2020
• 47mOn the past, present and future of Open Source databasesKaj Arnö · Shift Dev 2019
• 44mDockerize SQL Anywhere Connection for Your REST API and PS 2021 ProjectsMarco Meoni · ELEVATE 2021
• 01h 31mMySQL operations in DockerGiuseppe Maxia · FOSSASIA Summit 2017
• 40mExperience on build Database Docker Desktop ExtensionsMarcelo Fabian Ochoa · Docker Community All-Hands #6
• 20mMariaDB Shell: An Upgraded Admin ToolLuis Lizardo · MariaDB OpenWorks 2023
• 37mDelivery and Debugging MariaDB Docker Official ImagesDaniel Black · ContainerCon @ Open Source Summit Japan 2023