lovasoa
Add support for new database systems
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: https://github.com/sqlpage/sqlx-oldapi/issues/10
Snowflake would be a welcome addition, let me know if you need any help testing.
One option is to use datafusion-federation for cross database access.
https://github.com/datafusion-contrib/datafusion-federation/
I just merged in ODBC support to SQLPage. It's a big change, and it drastically widens the compatibility of SQLPage. Here are a few ODBC drivers for popular databases:
- ClickHouse,
- MongoDB,
- DuckDB, and through it many other data sources,
- Oracle,
- Snowflake,
- BigQuery,
- IBM DB2,
- Trino, and through it many other data sources
I'll make a first beta release soon, but in the meantime, here are the very first unstable builds; feedback welcome !