Analyzing iMessage with SQL
You can use SQL to search your old iMessage data - and learn some surprising facts about the people you text along the way.
3 months ago
Daniel Lifflander
Streaming Data with Postgres + Kafka + Debezium: Part 2
By the end of this guide, we will have a functioning Streams app that will take input from a topic that Debezium feeds into, make a simple arithmetic operation on one of the columns, then output the result into a new topic.
9 months ago
Streaming Data with PostgreSQL + Kafka + Debezium: Part 1
In this guide, we will use Postgres, Kafka, Kafka Connect, Debezium, and ZooKeeper to create a small API that keeps track of your stock & crypto purchases over time.
a year ago
Featured
public
Frameworks
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.
a year ago
PostgreSQL
public
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.
a year ago
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.
a year ago