Inspecting QEA databases - Information only.

[Ian Mitchell]

Tip for those of you who also who spend your lives in the murky depths of the EA database.
If you are using the new default QEA database (uses SQLite technology), there is a good, free browser app which lets you look at the database contents, in the same way that MS Access lets us look into EAP and EAPX databases.
Try : https://sqlitebrowser.org/dl/

[qwerty]

https://sqlitebrowser.org/blog/version-3-12-2-released/ for the Mac users out there.

q.

P.S. Just noticed that they also got a Windoze version.

[Geert Bellekens]

My favorite SQL client for non SQL-Server databases is AnySQL Maestro, which supports both .eap(x), SQLite and a whole lot of other databases

https://www.sqlmaestro.com/products/anysql/maestro/

There's a free version available as well.

Geert

[Richard Freggi]

SQLite Studio is free I think and very good.
DBeaver works fine with SQLite.  That's what I use.
SQLite has a gajillion open source front ends and IDEs (SQLite is the most used DBMS in the world: your phone and computer have several instances of it running right now): you can google SQLite frontend or SQLite IDE.  Some are browser-based, others are clients

[timoc]

When working with SQLite, a tool worth considering, created by the author of SQLite, is jsish.

Jsish is a single binary CLI Javascript shell. It is available on most platforms, including on embedded, and has out of the box capabilities such as SQLite, MySQL, Websockets/Web server, including an SQLite Database Browser (SQLiteUI).

I have been experimenting with jsish as a way to mine data from various SQLite databases,  over REST/JSON, using the EA 'Data Miner Diagram' feature.