comdb2 VS sqlitebrowser

Bloomberg [1] uses SQLite in a custom distributed RDBMS engine of theirs in a way I lack the knowledge to completely understand its design.

I remember Richard Hipp mentioning Bloomberg in one of his interviews (don't ask me which one, I don't remember), that they use SQLite to serve billions of bank transaction on a daily basis without a problem.

  [1] https://github.com/bloomberg/comdb2

DB Browser for SQLite and SQLiteStudio both exists, not sure if this is what you are looking for.

Have you tried https://sqlitebrowser.org/ ?

SQLite DB file. You can view the DB contents with https://sqlitebrowser.org/

My recommendation would be to use Sqlite. It pretty simplistic and works well. The program, found here, https://sqlitebrowser.org/ is a UI for Sqlite that can be used for loading or interacting with your data. If your data is in CSV, you can use the UI to parse and load your data file(s).

https://support.mozilla.org/en-US/kb/compacting-folders https://www.crucial.com/articles/about-ssd/should-you-defrag-an-ssd Kind of interesting to poke around Firefox's and other programs sqlite database files, just be cautious. https://sqlitebrowser.org/

As far as looking at the database, it's located at 'Plug-in Support/Databases/comp.plexapp.plugins.library.db' within your data directory. While you need Plex's own Plex SQLite to write to some tables, if you're just combing through data it may be easier to use something like DB Browser. From there, watch history is stored in the metadata_item_views table. If you want a list of everything that's been played, but is no longer in Plex, the following query might do it (it's been very minimally tested, but I wouldn't be surprised if there are some things I missed:

You'll need to modify the database manually. If it's using SQLite, you can use DB Browser for SQLite (https://sqlitebrowser.org/).

Here are a few options * Calc from LibreOffice * DB Browser for SQLite * RStudio * Visualize data from CSV file in Python

They're database files that you can inspect with a program like DB Browser or SQLiteStudio. You should be able to import permissions.sqlite to different Firefox profiles by just copying it to the right profile directory.

I've used all H2, hsqldb and SQLite. For a desktop app you want SQLite, as it is explicitly designed for this scenario. One nice bonus is that there are a TON of apps and utilities that work with SQLite files directly, making it very easy to work with.