On Wed, 1 Apr 2026 12:17:19 +0000 Andy Smith <[email protected]> wrote:
> Hi, > > Reading the other suggestions and your replies I don't think you're > going to find anything; you're mostly not happy that the suggestions > are too complicated, but databases *are* complicated and they're also > very generic in order to cover many use cases. > > Ultimately if you want something direct and bespoke to the data you > need to manage, I think you're going to have to build an application > for it. Depending on existing experience, there are a couple of ways to go. If the OP has Windows experience with an MS visual language, or Delphi, that's probably the way to go. Basic database work with Delphi is a few drags and drops and probably very little code. Lazarus is the Linux Delphi clone, and is quite mature now. This is about the simplest way to develop database code in Linux, but it helps enormously to have a bit of visual object-oriented experience, otherwise it's a bit of a learning curve. Heidi is written in Lazarus as a port from the original Delphi. Otherwise a PHP web application is probably the way to go, as I have done. PHP has libraries for all the common database formats, but it can be a bit of a slog. Pull a database table into an array, then construct an HTML table from the data. Add code to enter and edit records. I never delete anything from a database using an application, just have a 'deleted' Boolean if I need it. There is a quick-and-dirty method of using MySQL/MariaBD if the OP is prepared to migrate to it, along with PHP, called phpMyEdit https://www.phpmyedit.org/ Answer a few questions and you have a file which opens one specific table for the usual functions. I do use a few of these for particular jobs. > > However… > > On Wed, Apr 01, 2026 at 08:45:48AM +0100, Chris Green wrote: > > Can anyone suggest anything that might provide what I want? It > > doesn't absolutely **have** to work with sqlite3, I'm prepared to > > move to mariadb or postgresql if necessary (though I'd prefer not > > to). > > If you are familiar with phpmyadmin and phppgadmin then there is also > a phpliteadmin for SQLite, and it's packaged in Debian. I haven't > tried it myself. If it's anything like the other two it will need > quite a bit of setup. > phpMyAdmin is OK for casual data entry, presumably if you need to populate a lot of records you'd do it via a spreadsheet and CSV import anyway. -- Joe
