Overview

Molar (for Molecule Library) is a database management system for PostgreSQL. Its main focus is to enable chemists and material scientists to store the results of their experiment, whether computational or not!

It consists of a REST API implemented (using FastAPI) and a python client. Its main features are:

• Creation/deletion of database on user request.

• User management per database (using JWT tokens and OAuth2)

• Event sourcing to be sure not to lose any data

• Client integrated with PyData’s pandas

• Support to have different database structure, thanks to Alembic

• Ease of deployment (Deployed in 2 command lines!).

Contents:

• Client Usage
  • Installation
  • Login, credentials and authentication
  • Creating a new database
  • Managing users
  • Data Manipulation
    • Adding data
    • Event sourcing
    • Querying
      • Joins
      • Advanced joining
      • Filtering
      • Ordering
      • Debugging queries
  • Removing a database
• Backend Usage
  • Installation
    • Local installation
    • Keeping Molar up to date
    • Uninstalling Molar
    • Remote installation
    • Backend settings
  • Managing different database structure
    • Creating a new structure
• Client API