[lug] Something like MS Access for Linux?

[Steve Sullivan]

Not sure I understand your question ... is using MariaDB
a requirement or a possible option?

If you're looking for a simple RDMBS, have you tried sqlite3?
I think it has all the features you requested, and is
very straightforward.

Or are you looking for a GUI on top of an RDBMS?
If so, a google search will show some guis for sqlite3,
which don't require a browser.

Steve

On Sun, Jan 05, 2020 at 05:18:59PM -0700, Jed S. Baer wrote:
> 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

-- 

========================================
Steve Sullivan      steve.sullivan at mathcom.com
720-587-7498        http://www.mathcom.com
========================================