Duckdb: [Question]: is there any graphical client to be used by non-tech?

[verajosemanuel]

I use extensively duckdb for my analytics but I need to share my database with some of my clients.
They do not know any programming language so they need a client software to open database.

is there any software available to open duckdb database?

thanks in advance

[hannesmuehleisen]

Could you describe that use case a bit more? What does "open" mean in this case? Look at data in tables?

[verajosemanuel]

yes, imagine another colleague from marketing department. Usually lives in windows, Word, Excel, Access, web browser...and the like

I can share the DuckDB file via shared folder and they want to open the file and have a look at the tables and content, maybe issue some simple SQL queries at most. Time ago they were using Dbeaver to open SQLite files . But that is not working now. maybe access linking? but a dedicated app should be cool

[Mause]

I have thrown together a very basic sqlalchemy driver for duckdb (https://pypi.org/project/duckdb-engine/), you could probably find a program that uses that to display the data contained in your database?

[verajosemanuel]

thanks @Mause but the users are non techies, and they cannot request support from me or IT on this matter

[Mause]

I mean that you could find a UI that supports sqlalchemy, and use that with the above

[verajosemanuel]

something like this:
https://sqlitebrowser.org/

[verajosemanuel]

anyone?

[hannesmuehleisen]

@verajosemanuel I am not aware of anything. I like the SQLite browser, I'm sure it could be patched to support DuckDB. Maybe you would like to give it a go?

[verajosemanuel]

Tried renaming duckdb file to sqlite.db but sqlitebrowser cannot open it

[hannesmuehleisen]

The database file formats of DuckDB and SQLite are very different, simply renaming is not enough.

[exaatto]

@verajosemanuel I personally use DBeaver for graphical DB view/admin. It does support DuckDB. Actually it's Java/Eclipse based and supports all generic JDBC-ready DBMSs. They also include a nice guide[1] to add new JDBC driver for new DBMS. The only drawback is it may be a bit too sophisticated for non-IT guys.

@Mause Thanks for the SQLAlchemy engine, it just works. It would be very nice if DuckDB can make it official support.

However, as for Python/SQLAlchemy based DB viewer sort of thing, I never success to find any good ones.

[1] https://github.com/dbeaver/dbeaver/wiki/Database-drivers

[verajosemanuel]

I LOVE dbeaver but all are corporate work laptop has no java installed .So It won't work

[alanpaulkwan]

How does one install this into DBeaver? Can someone post instructions? It's far from obvious.

[Mause]

@verajosemanuel fairly sure Dbeaver includes its own installation of java I believe?

@alanpaulkwan try the following driver settings:

[hannesmuehleisen]

@Mause @exaatto did not know that this worked, but sooo cool! Thanks for pointing this out.

[alanpaulkwan]

@Mause thank you. What do you enter on this screen when making the final connection?

[Mause]

@alanpaulkwan the path to your duckdb database file

[alanpaulkwan]

@Mause amazing

[alanpaulkwan]

Unfortunately, the bleeding edge DuckDB version is reverse incompatible with the available JAR. Oops. But definitely now this will help my students who I will teach via DuckDB, who won't use the bleeding edge version anyway ... (the command line is scary!)

[hannesmuehleisen]

You can download bleeding edge JARs from here: https://github.com/cwida/duckdb/releases/tag/master-builds

[verajosemanuel]

@verajosemanuel fairly sure Dbeaver includes its own installation of java I believe?

Yes, but I have no privileges to install anything

[exaatto]

Yes, but I have no privileges to install anything

I'm pretty sure DBeaver has a portable version with bundled JRE, download&unzip and it just works.