Description
SQLPage can currently connect to Postgres, MySQL, SQL Server, and SQLite databases. These OLTP databases are focused on managing real-time transactional data. This allows using SQLPage to build applications like front-ends for processing customer orders, managing inventory levels, handling user registrations...
Adding support for OLAP databases would allow creating dashboards and reporting tools that visualize large analytical datasets. A SQLPage application might then display sales trends over time, generate financial summaries, or provide insights into customer behavior by querying databases such as ClickHouse, Trino, DuckDB, Snowflake, BigQuery...
The current plan is to add support for a multitude of new database systems at once by adding an ODBC connector: sqlpage/sqlx-oldapi#10