Skip to content

Database

All data is stored in a SQL database of your choice. Available are all databases supported by the SqlAlchemy ORM.

SQLite

  • SQLite is the default option.
  • The database file is located at ~/.barbucket/database.sqlite.
  • If no database file exists, it will automatically be created on application start.
  • You can set the name of the file within the config file.

PostgreSQL

  • You can also use a PostgreSQL database.
  • See the config file for the corresponding connection parameters and change them to comply with your database.
  • You can also use the provided shellscript to run a PostgreSQL as a Docker container. This will also check for an available Docker engine, download the image, and create the volume and container if necessary.
  • Another shellscript is available to backup a PostgreSQL database.

Other DBMS

  • Other available databases are Microsoft SQL Server, MySql, Oracle, etc.
  • These are not tested but should be working out of the box, as they are supported by the ORM. Please use the config file to set up Barbucket to connect to these databases.

Direct SQL access

  • Some operations are best performed by directly accessing the database. For these, please use the SQL client of your choice, eg. DBeaver.
  • Some queries that I found useful running them against the database, are collected in a file within the repository. Feel free to use them.