Showing similar results in Postgres
Correcting for spelling mistakes If you search "trgrams in pstgres" in Google, you'll get results for "trigrams in postgres". To say that is…
READ MORE#database
Avoid race conditions in Rails with Postgres locks
Race conditions A race condition or race hazard is the behavior of an electronic, software or other system where the output is dependent on…
READ MORE
Intro to MongoDB for Postgres developers
Intro to MongoDB MongoDB is an object or document based database... in other words, a NoSQL database. This puts it in contrast to databases…
READ MORE
Copying Postgres Table with its Attributes
Why do this? Recently at work we had 1 data model that was getting a bit out of control. When we first modelled the data it made sense, but…
READ MORE
Postgres Insights with PgHero
What is PgHero? PgHero is a gem written by Andrew Kane for getting quick insights into how your Postgres database is performing and where…
READ MORE
The Basics of PSQL
Overview PSQL is the command line tool for accessing the PostgreSQL database. I recommend anyone using Postgres to at least learn the basics…
READ MORE
Sorting null values in PostgresSQL
The Problem Say you have a table of people and you want to sort them alphabetically by their nickname in descending order (Z - A). That…
READ MORE