Bennie Swart

Mr at Quant Engineering Solutions

About

Bennie Swart has presented the following presentations

    Bennie Swart Tips and tricks for speeding up PostgreSQL in an automated testing environment at South Africa 2019

    presented by Bennie Swart

    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.

    Tue 8 2019 Ops and Administration
    Bennie Swart Row Level Security at Postgres Conference
    Using Row Level Security to move access control from the application to the database.

    presented by Bennie Swart

    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 ...

    more

    Thu 21 2019 Use Cases