Schedule - PGConf.EU 2023
SQLPage — Building a full web application with nothing but Postgres and SQL queries
In this session, I will dive deep into an open-source tool I wrote: SQLPage. SQLPage is a web server written in rust that connects to a database, runs SQL queries, and uses the result to render web components, allowing developers to build entire web applications in SQL.
During this session, we will embark on an interactive journey where we explore the core features and architecture of SQLPage. Buckle up as we build a tiny Twitter clone entirely in SQL with postgres, right before your eyes!
Furthermore, we will delve into the world of PostgreSQL extensions, and see how we can leverage some of them to implement advanced features for our application directly in the database. We will explore how SQLPage facilitates the extremely fast development of powerful web applications while maintaining the data integrity and performance for which PostgreSQL is renowned.
By attending this session, you will:
- Discover an unconventional and thought-provoking approach to web application development that harnesses the power of SQL.
- Gain insights into SQLPage's architecture and its seamless integration with PostgreSQL.
- Learn practical techniques and best practices for developing dynamic web applications with SQLPage.
- Discover some lesser-known Postgres extensions.
Whether you're a seasoned PostgreSQL expert or a junior developer eager to build a stunning UI over your database, this session is designed to ignite your curiosity and challenge your perceptions. Are you ready to ask yourself, "Do I need anything more than PostgreSQL for my fancy web app?"
Join me in uncovering the untapped potential of SQL and witness how SQLPage can revolutionize the way we build dynamic web applications with PostgreSQL.