Doug Breaker, October 4, 2023

Postgres LIKE Operator - 1 Tip To Make Your Query 80 Times Faster I love SQL and I love Postgres. I've been playing around with the ~ 8 million unclaimed asset records in New York , and have been struggling with an efficient way to do a name search. My ...

Doug Breaker, August 23, 2023

Read this 2 minute article to understand how to make your Rails app faster with the ActiveRecord update_all method. GIF of Tombstone included!

Doug Breaker, October 6, 2022

Every wonder how to group by the week of the year in Postgres? MySQL comes with the handy WEEKOFYEAR() Function . How do you solve for the same thing in Postgres? Let's take an example, let's say we're measuring how many hearing tests get taken per week. Using MySQL, you'd ...

Doug Breaker, October 6, 2022

Want to group MySQL by quarter? Read our 30-second guide.

Doug Breaker, August 30, 2022

Soooooo . . . I can't stop building stuff. Love it. My latest little side project is a food/calorie/nutrition tracking app that does (nearly) everything via text message. I've gotten into TailwindCSS because I never took the time to properly learn CSS. Love it! Three cheers for laziness. Rails 7 ...

Doug Breaker, August 17, 2022

Use these simple SQL queries to identify bloated data in your database

Doug Breaker, April 28, 2022

What is Data Driven SEO? Read our short guide on what Data Driven SEO is, and how to use it to rocket up your site traffic.

Doug Breaker, April 16, 2022

Want to connect to your Heroku database from a local SQL Editor, or to pump reports into Slack? Read our 5-minute tutorial.

Doug Breaker, April 12, 2022

Connect to a local Postgres DB with ngrok and SQLBot. 5 minute tutorial, see your results in Slack in minutes.

Jeremy Hillpot, November 22, 2019

The MONEY data type in SQL Server is shrouded in mystery. What is it for? When should you avoid it? What advantages does it bring? What is the difference between it and the DECIMAL data type? Read our in-depth guide on the SQL MONEY data type.