Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Ian Mitchell on January 04, 2022, 08:42:55 pm

Title: Inspecting QEA databases - Information only.
Post by: Ian Mitchell on January 04, 2022, 08:42:55 pm

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/

Title: Re: Inspecting QEA databases - Information only.
Post by: qwerty on January 04, 2022, 09:21:56 pm

https://sqlitebrowser.org/blog/version-3-12-2-released/ (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.

Title: Re: Inspecting QEA databases - Information only.
Post by: Geert Bellekens on January 04, 2022, 09:58:31 pm

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/ (https://www.sqlmaestro.com/products/anysql/maestro/)

There's a free version available as well.

Geert

Title: Re: Inspecting QEA databases - Information only.
Post by: Richard Freggi on January 05, 2022, 03:12:42 pm

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

Title: Re: Inspecting QEA databases - Information only.
Post by: timoc on January 11, 2022, 08:04:09 pm

When working with SQLite, a tool worth considering, created by the author of SQLite, is jsish (https://jsish.org/fossil/jsi/doc/ckout/README.md).

Jsish (https://jsish.org/fossil/jsi/doc/ckout/README.md) 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' (https://sparxsystems.com/enterprise_architect_user_guide/15.2/modeling/data_miner.html) feature.