Ligare.database

Ligare.database is a library for working with SQLite and PostgreSQL databases. It integrates with SQLAlchemy as an ORM library, and extends Alembic to help manage your database as it changes over time.

Why Use Ligare.database?

Ligare.database offers:

• SQLite and PostgreSQL without having to worry about database-specific behaviors

  • SQLite is often used for tests, while PostgreSQL is used for live applications

  • As an application grows, moving from SQLite to PostgreSQL is made simpler through Ligare.database

  • Schemas with SQLite are made possible with Ligare.database

• Integration with other parts of Ligare, for example, the configuration system, or Ligare.web web applications

• The same flexibility as SQLAlchemy with the functionality of Ligare

• Managed connections so you can set aside the complexity of database connectivity in an application