I published a course on Postgres with .NET a few months back and forgot to mention it!
Posts under postgres
The wrapper makes it possible to expose individual tables from a RethinkDB database in PostgreSQL, enabling users to access their RethinkDB data with with SQL queries. Foreign Data Wrappers are one of those features in Postgres that really makes it stand apart from other systems. I once queried Twitter live on stage at NDC Oslo […]
This is the Postgres membership system I wrote a few weeks back and thought I would share with you.
I needed a tool to do precisely what I want with a database; something that won’t tell me what to do, nor how to do it. So I built it.
We’ve been on the road for quite some time…
Working with JSON in Postgres is quite fun, but it takes a bit to get the syntax down as well as the supporting functions. That’s what I’ll do in this post.
Having the ability to work SQL in your favorite database engine is a life-long, good skill to have. In this post I’ll show you some of the favorite things I use in Postgres.
This post has been parked in my mind for a very long time – time to let it out. Running away from Stored Procedures is ridiculous, let your database do what it’s good at!
I love Postgres for many reasons – particularly the syntactic niceties it provides for doing complicated operations – like multiple inserts in the same transaction!