This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

SQLPage — Building a full web application with nothing but Postgres and SQL queries

Date: 2023-12-14
Time: 09:30–10:20
Room: Zenit

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:

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.


This session has been made available on:


The following slides have been made available for this session:


Ophir Lojkine