ERA Database

Posted on 08/06/2022

We got asked on HackerNews how we store drafts in ERA and if we use any proprietary format for that.

The database used

ERA uses SQLite internally in order to store drafts and app settings. SQLite is an open, portable, relational database system. As your notes are stored locally on your machine, the SQLite database is on your machine as well.

Where to find the database?

You can find the database on the following paths on your filesystem, depending on your host machine:

  • Windows: C:/Users/$USER/era-app/era.db
  • macOS: /Users/$USER/era-app/era.db
  • Linux: /home/$USER/era-app/era.db

Where "$USER" is your username.

How to open the database?

If you like to inspect the database yourself, you can do that by opening the “era.db” file with any database browser that supports SQLite. What we recommend is DB Browser for SQLite, because it's small, easy to use and supports all of the mentioned operating systems above.

What data is stored inside the database?

As of the time of this writing, the following data is stored:

  • Workspaces
  • Drafts
  • Internal Settings