v16 QEA file - inspecting SQLite database in detail

[adamPL]

Hi,

Many people are using EA database directly and review issues directly in database. Because of that they really enjoyed any materials and whitepapers about EA JET 4.0 Database structure (EAP file).

Since v16 I switched to QEA file, which is SQLite (v3 I guess?) and I need to rewrite some tools that I've been using. It seems that, aside from some official announcements, there is no good analysis of new database.

Is there anything like this page https://leanpub.com/InsideEA/read, but for new database? Or is it not necessary, because nothing has changed?

[Geert Bellekens]

Pretty sure nothing has changed, the same database schema, just another technical format.

Geert

[qwerty]

There are only slight technical differences in the different DB formats. Basically they are all the same. And the format has not much changed since 2003.

q.

[adamPL]

Thank you for the answers.

In case you were wondering, right now SQLite version is 3.x

Data from EA About page:
Database Schema Version: 1558
Program Version: 16.0.1605 (Build: 1605)