Database Schema

Overview

Convexity input file format is an SQLite database (.db files). This is a lightweight but comprehensive format, which provides a good solution for energy systems modelling applications.

SQLite is a self-contained, serverless database that requires no configuration or separate database server. This means models are portable as single files can be easily shared, version controlled, and backed up. The relational structure allows efficient storage of complex networks with large numbers of components, scenarios and of time series data points, while maintaining data integrity through foreign key relationships and transactions.

Unlike proprietary formats or spreadsheets, SQLite files can be directly queried using standard SQL or accessed programmatically through pyconvexity, giving users full transparency and control over their model data. This approach also enables seamless integration with existing data pipelines and workflows, as SQLite is widely supported across programming languages and platforms.

Documentation Sections

• Design - Design principles, unified architecture, and entity relationship diagram
• Core Tables - Detailed reference for all database tables
• Query and Access - SQL examples and programmatic access patterns