No upcoming presentations...

    Row Level Security - A practical use case

    Using Row Level Security to move access control from the application to the database

    In this talk we examine the use cases of Row Level Security (RLS) and its practical application.

    In traditional applications, it is very common to find a lot of access control code residing inside the application layer, where the application connects to the database with a single database user, but multiplexing multiple application users. The database user typically has more rights than the ...

    @ Postgres Conference 2025

    Mar 20 2025

    Dev

    In an automated testing environment it is often a requirement to create a clean database for each group of tests, but creating and initializing new databases can be slow and resource intensive.

    In this talk we will look at a collection of tips and tricks to optimize the setup and teardown of new databases in an effort to significantly reduce the overall execution time of tests.

    @ South Africa 2019

    Oct 8 2019

    Ops and Administration

    Row Level Security

    Using Row Level Security to move access control from the application to the database.

    In this talk we examine the use cases of Row Level Security (RLS) which was introduced in PostgreSQL 9.5.

    In traditional applications, it is very common to find a lot of access control code residing inside the application layer, where the application connects to the database with a single database user, but multiplexing multiple application users. The database user typically has more rights ...

    @ Postgres Conference

    Mar 21 2019

    Use Cases