unsubbed.co

SQLPage

SQLPage gives you SQL-only dynamic website builder on your own infrastructure.

Overview

Fast SQL-only data application builder. Automatically build a UI on top of SQL queries. Build interactive websites and apps with only SQL queries. SQLPage is an open-source tool to generate nice user interfaces on top of traditional databases. Maps, charts, tables, forms, and dashboards - without traditional web programming. The project has 2K+ GitHub stars and is licensed under MIT.

Getting Started

Source: GitHub README

SQLPage supports ODBC connections to connect to databases that don’t have native drivers. You can skip this section if you want to use one of the built-in database drivers (SQLite, PostgreSQL, MySQL, Microsoft SQL Server).

Linux and MacOS release binaries conatain a built-in statically linked ODBC driver manager (unixODBC). You still need to install or provide the database-specific ODBC driver for the database you want to connect to.

Install your ODBC database driver

  • DuckDB
    • If y

Normalized Features

Source: tool-features-normalized.json

brew, clickhouse, docker, mongodb, mssql, mysql, postgresql, rest api, sqlite, sso.

Features

Authentication & Access

  • Single Sign-On (SSO)

Integrations & APIs

  • REST API