[lug] Something like MS Access for Linux?

[David L. Willson]

I don't know if DBeaver does all those things, but maybe it does.

----- Original Message -----
From: "Jed S. Baer" <blug at jbaer.cotse.net>
To: "BLUG" <lug at lug.boulder.co.us>
Sent: Sunday, January 5, 2020 5:18:59 PM
Subject: [lug] Something like MS Access for Linux?

Howdy folks.

I'm looking for something very simple, really, even simpler than MS
Access, to do a simple RDBMS here. 4 or 5 tables, a few foreign keys, and
the ability to do a grid view, where I can get drop-downs to select
values for the columns with foreign keys, and some simple constraints.

A few other features:
 - import into table from CSV
 - create table from CSV
 - export to CSV
 - SQL window for running queries with results in a grid, and doing DML.
 - export from query result into CSV
 - use MariaDB

So far, I've tried:

 - Kexi: I have no idea what the developer is thinking. I tried to simply
connect to my existing database, but it wouldn't just let me do that,
instead it went down a rabbit hole of trying to import an existing
"project" from the filesystem.

 - LibreOffice Base: Can't use the JDBC connector. I followed the
instructions here;
https://ask.libreoffice.org/en/question/79010/how-do-i-set-up-a-jdbc-connector-for-mariadb-or-mysql-in-base/
but no luck. It won't tell me why it can't load it. There's a dialog
where it lists the drivers it supposedly knows about. I tried a few of
those too, and using the "test class" button, I get the same "... could
not be loaded" message for those too. The org.mariadb.jdbc.Driver isn't
listed in that dialog where known drivers are listed -- it's the
"pooling" dialog.

I don't recall whether phpmyadmin will do what I want, but:
 - I'd rather not run a browser-based tool
 - I did try it, but despite my doing a 'grant all ..." for the
phpmyadmin user, it doesn't see the database I created.
 - Years ago, yes, I was a successful phpmyadmin user. It worked just
fine, without any tinkering.

I might try HeidiSQL, but I'd rather not sink more time, without hearing
some recommendations. Anyone have any?

Thanks.
_______________________________________________
Web Page:  http://lug.boulder.co.us
Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
Join us on IRC: irc.hackingsociety.org port=6667 channel=#hackingsociety