#database

• #databases
• #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…

• #ruby-on-rails
• #databases
• #postgres

Race conditions A race condition or race hazard is the behavior of an electronic, software or other system where the output is dependent on…

• #mongodb
• #postgres
• #databases

Intro to MongoDB MongoDB is an object or document based database... in other words, a NoSQL database. This puts it in contrast to databases…

• #postgres
• #databases

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…

• #postgres
• #database
• #ruby-on-rails

What is PgHero? PgHero is a gem written by Andrew Kane for getting quick insights into how your Postgres database is performing and where…

• #psql
• #database

Overview PSQL is the command line tool for accessing the PostgreSQL database. I recommend anyone using Postgres to at least learn the basics…

• #postgres
• #database

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…