Posts under postgres

Query RethinkDB tables from PostgreSQL with foreign data wrappers – RethinkDB

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 […]

Tree structure query with PostgreSQL

When dealing with hierarchical data, we usually use recursion for constructing the tree structure. It would be a performance problem if you query the tree node data from the database every time the recursion happens. Also, if you work with languages which are heavily based on callback like Javascript, you will find it is very […]

Embracing SQL In Postgres

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.