Daniel Lifflander

Articles

Featured

Decoding Django Sessions in PostgreSQL

When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.

By Daniel Lifflander

• a month ago

PostgreSQL

Postgres Notify for Real Time Dashboards

Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard.

By Daniel Lifflander

• a month ago

SQL

Trigger Warning! Setting up Database Tracking with Triggers in Postgres

SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.

By Daniel Lifflander

• 3 months ago