SQL vs NoSQL: How to Choose —
A look at some different scenarios and applying the right criteria to choose whether the SQL or NoSQL route is right for them.
Craig Buckler opinion
9 Tips for Better Database Design —
Plan ahead, document your model, follow conventions, think carefully about your keys, use integrity checks carefully, and more.
Jeffrey Edison
Real-time Database Monitoring at Any Scale with Datadog — Use Datadog's turn-key integrations to seamlessly aggregate metrics and events across your databases and entire devops stack. Gain powerful insight into all your apps, tools and services. Begin your Free Datadog Trial today!
Datadog sponsored
Handling Circular Data Structures in Postgres —
If you’re dealing with groups that contain other groups, or any other kind of nested structure the default might be to simply make a bunch of separate database calls from within your app. Fortunately with recursive queries there is a better way.
Yesquel: Scalable SQL Storage for Webapps [PDF] —
“We design, develop, and evaluate Yesquel, a system that provides performance and scalability comparable to NoSQL with all the features of a SQL relational system.” An academic paper.
Working with Email Addresses in SQL —
Check if an email is valid (with a regexp - be careful!), split an email into its key parts, and more, all from SQL.
Delightful Database Seeding with Docker —
“Using Docker we have created a user friendly tool that anyone in our organization can use, (even sales) both when resetting a demo laptop, and when getting a new on-site installation quickly up and running.”
Storing Data with Redis —
“Would you stuff all of your data into one database table? That’s crazy, Mike, don’t be silly! What if I told you most people do just that with Redis?”
The SELECT Problem in Redis —
“The need to maintain your own indexes for structured data is the sole reason that makes Redis unsuitable for certain applications.”
