Announcing SQLPage: Build Dynamic Web Applications in SQL

## 👨‍💻 Introduction

SQLPage is a [free and open-source tool for building beautiful web apps entirely in SQL](https://sql.ophir.dev).

It is a small single binary executable that runs a web server, executes `.sql` files on demand, and renders the results using a wide array of pre-defined web components.

## ❓ Why

Writing an application entirely in SQL is quite unconventional. Here is why I still think it is a great choice in some cases :

- **Database-Centric Approach**: Keep your database at the heart of your application.
- **Rapid Prototyping**: Validate ideas and iterate quickly towards a minimum viable product. Write a basic web app in one tenth of the time it would have taken with a frontend and a backend framework.
- **Don't repeat yourself** : Model your problem domain just once: in your database. Don't repeat it across three code bases.
- **Spend your time on your core idea**: Don't spend time picking colors for your buttons or choosing the right ORM for your new backend language.

Of course, if you are designing a huge application with a complex backend logic, SQLPage is not for you. But if you have an idea for a cool CRUD app that you have been postponing for months, you should try building it with SQLPage !

## 🔑 Key Features

- **SQL-only**: Build a full web application with a nice frontend without writing a single line of HTML, CSS, of Javascript.
- **Full SQL Support**: Insert, update, and delete data through an auto-generated Web UI. Write nothing but raw SQL.
- **Seamless Integration**: Connect SQLPage to any existing PostgreSQL database effortlessly and start exploiting its data with a single standard `.sql` file.
- **Web Standards Support**: Read and write HTTP cookies, manage user authentication, handle form submissions and URL parameters.
- **Fast And Secure**: Written in Rust, no memory corruption, no SQL injections, no XSS.

## 💼 Use Cases:

Some cool things people have built with SQLPage include

- **Internal Dashboards**: Empower teams with data-driven insights.
- **Small Business Intelligence Apps**: Build powerful applications for analysis and exploration.
- **Admin Interfaces**: Manage and interact with PostgreSQL data effectively.
- **A game**: Validate and iterate on the idea swiftly.
- **A knowledge management tool**: Replace an excel file for knowledge management in an enterprise.

## 🌐 Examples

Here are the two SQL queries that build the [components list](https://sql.ophir.dev/documentation.sql) on SQLPage's official documentation website, which is itself built with SQLPage :

```
SELECT 'list' AS component, 'Built-In SQLPage components' AS title;
```

```
SELECT
name AS title,
description,
icon,
'?component='||name||'#component' AS link,
$component = name AS active
from component
order by name;
```

Check out the [website examples](https://github.com/lovasoa/SQLpage/tree/main/examples) in the official git repository for more examples.

## 💡 Get Started

Explore the possibilities and limitations of SQLPage on [the website builder's homepage](https://sql.ophir.dev) and read [the tutorial on building SQL websites](https://sql.ophir.dev/get%20started.sql).

Join [the SQLPage community](https://github.com/lovasoa/SQLpage/discussions) to discuss your PostgreSQL-powered web apps.
Don't hesitate to come to the forum to discuss your thoughts and ideas !

## 🤝 Contributing

Be part of the open-source project and contribute to SQLPage's growth [on GitHub](https://github.com/lovasoa/SQLpage). Come and leave us a star 🌟.

Unleash the power of SQL-driven web application development with SQLPage and elevate your PostgreSQL experience! Let's build together! 🚀