SQLPage
Create interactive websites and applications using only SQL queries. Generate maps, charts, forms, and dashboards directly from your existing database. Fast and open-source.
Build sophisticated, dynamic web applications by writing simple SQL queries. This open-source tool allows you to create beautiful user interfaces directly on top of your existing database, transforming your data into interactive websites, dashboards, and internal tools without traditional web programming.
Focus on your data and let the tool handle the complexities of web development. Key benefits include:
- Complete Components: Generate a wide range of elements including maps, charts, tables, forms, and navigation menus with a batteries-included approach.
- Rapid Development: Go from a SQL query to a functional web app in a single afternoon. The simplified process means you write up to 10 times less code.
- High Performance: Leverage the power of SQL to sort, filter, and aggregate millions of rows in milliseconds. Your application remains fast and scalable as your data grows.
- Broad Database Support: Connects natively to PostgreSQL, MySQL, SQLite, and MS SQL Server. Keep your data in place and stream query results directly to the user interface.
Create multi-page interactive experiences where users can drill down, comment, and edit data, moving beyond the limitations of static dashboards.
Directory Structure
sqlpage
sqlpage-app
sqlpage
.env
docker-compose.yml
docker-compose.yml
services:
sqlpage:
image: lovasoa/sqlpage:latest
container_name: sqlpage
ports:
- "8080:8080"
environment:
- DATABASE_URL=${DATABASE_URL}
volumes:
- ./sqlpage:/etc/sqlpage
restart: unless-stopped
.env
# Connection string to your database (SQLite, PostgreSQL, MySQL, Microsoft SQL Server, etc.)
# Example for PostgreSQL: postgres://user:password@host:5432/dbname
# Example for MySQL: mysql://user:password@host:3306/dbname
# Defaulting to a local SQLite database stored in the mapped volume for easy setup
DATABASE_URL=sqlite:////etc/sqlpage/sqlpage.db
Categories:
Tags:
Ad
Similar to SQLPage