Joe <[email protected]> wrote: > On Wed, 1 Apr 2026 11:10:06 +0200 > didier gaumet <[email protected]> wrote: > > > Hello, > > > > for a GUI tool to enter SQLITE table values, *perhaps* (just a > > suggestion, I 've never done that) look at libreoffice-base with its > > suggested (but mandatory in this case) unixodbc dependency > > > > I hope that's improved *a lot* in the last few years. I found it almost > unusable, and the ODBC implementation was disastrous. At least it then > acquired native MySQL abilities, but it was still pretty buggy, and the > report writer only worked on alternate months. I just went away and > started writing my own PHP data access software. > > Here's another possibility: I have used HeidiSQL with MySQL on Windows > years ago, and found it very good. At the time there was no Linux > version. There is now, and it allegedly also works with SQLite. > > https://www.heidisql.com/ > > Disclaimer: I've just found out there is a Linux version and installed > the .deb, then tried it on one of my MariaDB databases, no obvious > instant problems, but I wouldn't endorse it fully without using it for > several months without incident. Yes, I do have regular backups, and > daily backups of the databases I actively use at the moment. > But HeidiSQL is just another database **management** program.
I just installed it and it took me ages to actually get to view the data in my database, lots of clicks and selects were involved. While it has command line parameters to bypass some of these it's still quite clumsy getting to the actual data grid display. The display formatting is a bit creaky on my (big) screen too, it doesn't seem to have scaled very well. -- Chris Green ·
