Blog
Page 209 of my articles, tutorials, and thoughts
Latest Articles
What database does Google use?
# What's Under the Hood: Google's Database Revealed! 💻🔍 Are you curious to know what database powers the mighty Google? 🤔 Is it Oracle? Maybe MySQL? Or perhaps a top-secret database they built themselves? Let's uncover the truth behind the scenes and e
Liquibase lock - reasons?
🔒 Unlocking the Mystery Behind Liquibase Locks 🔒 Have you ever encountered the dreaded "Waiting for changelog lock" error while working with Liquibase? Don't worry, you're not alone! Many developers have struggled with this issue, but fear not, for we a
How can I read inputs as numbers?
🔢 How can I read inputs as numbers? 🤔 Hey there tech enthusiasts! 👋 Are you scratching your head wondering why `x` and `y` are coming out as strings instead of ints in the code snippet above? 😖 Well, worry not, because I'm here to break it down for yo
How to compare only Date without Time in DateTime types?
# How to Compare Dates without Time in DateTime Types? 📅🕒 Are you struggling with comparing two `DateTime` variables but only care about the date and not the time? Don't worry, you're not alone! Many developers face the same challenge when working with
What"s the best strategy for unit-testing database-driven applications?
# Testing Database-Driven Applications: Finding the Best Strategy! 🧪🎯 Are you tired of dealing with the challenges and compromises of testing ORM and database-driven applications? 🤨 Do you find it difficult to keep your test database in sync with schem
When and why are database joins expensive?
# When and why are database joins expensive? 🤔💸 Are you facing performance issues when performing database joins? 😖 Don't worry, you're not alone! Join operations can indeed be quite costly, especially when dealing with large tables. But fear not, in t
Should each and every table have a primary key?
🔑 Should Each and Every Table Have a Primary Key? 🔑 Hey there, fellow tech enthusiasts! 👋 Are you currently in a dilemma about whether or not each and every table in your database should have a primary key? Well, worry not! In this blog post, I'm here
Is storing a delimited list in a database column really that bad?
# Is Storing a Delimited List in a Database Column Really That Bad? 😱📚 So, you have a web form with a bunch of checkboxes, and you decided to store the selected values in a single database column as a comma-separated list. You know this might not be the
Convert Dictionary to JSON in Swift
# Converting Dictionary to JSON in Swift: A Simple Guide 📝🔀🔢 So, you have a dictionary in Swift, and now you want to convert it to JSON. Don't worry, we've got you covered! In this guide, we'll walk you through the process step by step, addressing comm
Storing Images in DB - Yea or Nay?
# Storing Images in DB - Yea or Nay? 📸💾 So, you're pondering whether to store images directly in the database or save the location in the filesystem instead. 🤔 It's a common question that many developers face. Let's dive into the pros and cons of each