Tag: SQL
JSON in PostgreSQL
PostgreSQL’s JSONB type is fast, indexable, and incredibly flexible for semi-structured data. But it’s not a silver bullet, sometimes a traditional normalized table is still the better choice.Since I have PostgreSQL running on my laptop, I’ll show you real examples you can copy-paste and run yourself, complete with actual psql screenshots. When to use JSONB…
Read MoreFrankenstein tables
The horror of bloated schemas and premature partitioningAlso known as monster tables, out-of-control tables, or God tables (the ones that try to hold everything because it’s easier and joins are for the weak). I prefer frankenstein tables. These beasts start innocently enough, a few extra columns here, some quick fixes there, but before you know…
Read MoreDatabase indexes
What are database Indexes? Imagine you’re looking for a specific recipe in a massive cookbook with thousands of pages. Without an index at the back, you’d have to flip through every single page until you find it, that could take forever! A database index works the same way, but for data in a computer database.…
Read MoreInstall 5 major databases on Windows
The complete step-by-step guide to install MySQL, mariadb, sql server, postgresql, and sqlite on windows After 35 years installing databases in investment banking (where a failed install could cost serious money, I wrote the guide I always wished existed. This 77 page PDF shows you, with exact screenshots, how to download, install, configure, and test…
Read MoreDatabases for beginners
Why your data needs a better box than a junk drawerHey there! Welcome to my blog post on databases for beginners. If you are new to tech or coding, the word “database” might sound intimidating, like some mysterious black box only programmers understand. But trust me, it is not. Think of a database as a…
Read MoreStart SQL now
Start SQL now for Just $9.95: Unlock Data Skills Today! Want to boost your career with in-demand SQL skills? My Udemy SQL course is your ticket to mastering databases like PostgreSQL and MySQL! Whether you are a beginner or leveling up, this course makes SQL easy with hands-on lessons. 🎉 Special Offer: Use coupon code…
Read More