Post #4071830
2026-07-24 18:20 UTC
Replies (2)
-
@EdTheDev@infosec.exchange 2026-07-24 20:18
@jzb@hachyderm.io I was very excited about LibreOffice Base, until I discovered that it doesn't default to using a SQLite for the back-end. I did get LibreOffice Base to use SQLite with some jiggery-pokery. But there were too many trade-offs for what I consider should be the default option. Ultimately I stopped using LibreOffice Base, and continued with pure SQLite and a bit of clever scripting. Since then, I can't shake the thought that "a bit of clever scripting" isn't a universally accessible fall-back. And that my clever scripts might be repurposed into something fairly friendly to folks who just want to store and retrieve local data in an organized way. If the recurring thought turns into code, I'll be sure to drop a link here.
-
@EdTheDev@infosec.exchange 2026-07-24 20:27
@jzb@hachyderm.io Lack of strong SQLite compatibility was the other person's challenge with LibreOffice Base, as well, I believe. Which is ironic, as MS Access also lacks strong SQLite compatibility, I imagine. But back when I was a Microsoft environment developer, I took for granted that I could make a quick messy data build prototype in MS Access, populate a few example records, and then quickly re-use most of it in MS SQL, later. I was surprised I didn't find a similar path from LibreOffice Base's default database layer to at least SQLite or Postgres. I could easily have missed it, if a preferred path exists.