Read this 2 minute article to understand how to make your Rails app faster with the ActiveRecord update_all method. GIF of Tombstone included!
Continue reading this postSQL Editor Reviews
Copyright © 2023. SQLBot.co
Read this 2 minute article to understand how to make your Rails app faster with the ActiveRecord update_all method. GIF of Tombstone included!
Continue reading this postEvery 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 ...
Continue reading this postSoooooo . . . 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 ...
Continue reading this postWhat 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.
Continue reading this postWant to connect to your Heroku database from a local SQL Editor, or to pump reports into Slack? Read our 5-minute tutorial.
Continue reading this postConnect to a local Postgres DB with ngrok and SQLBot. 5 minute tutorial, see your results in Slack in minutes.
Continue reading this postThe 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.
Continue reading this postIntroduction The volume, variety, and velocity of big data are all swelling dramatically. According to a survey by market intelligence firm IDC, the average company now manages a mind-boggling 163 terabytes (163,000 gigabytes) of information . How can businesses hope to manage and utilize these never ending streams of information ...
Continue reading this post