71 private links
Looks like an interesting tool when you need to diff databases. Definitely something I'd see myself using for large pin tests.
Nice primer on how Redis works and the type of deployments you can choose from.
This is not done often, but when you need it... you need it.
Nice little database pattern to avoid row contention with counters.
This shows quite well why I stay away from Spring Data JPA...
Interesting points about soft deletion... its usual pattern might not be what you need in the end. The proposed alternative is interesting to keep in mind.
Nice primer of important characteristics of databases and transactions. With doodles so I'm biased. ;-)
The tone of the article isn't exactly to my liking, sounds "too good to be true" at times ignoring important details driving the choices (despite some warnings early on). Still, depending on the amount of data stored in your database, SQLite looks increasingly viable on the server, replication even coming down the road.
Interesting tips for potential bottlenecks in your queries.
Using MySQL or MariaDB in production? Think again.
Interesting set of SQL optimizations. Also shows PostgreSQL still had (has?) some room for improvement.
A good reminder to use the right tool for the task. Sometimes all you need is really a POSIX shell with a couple of well optimized tools.
Interesting exploration and workaround for the Postgres query planner.
A good primer on full-text search features in Postgres. A nice way to get started. This is too often overlooked, you can wait before pulling another dependency like Elasticsearch.
Stay away from the hype and introduce complexity in your systems only if it's warranted by the problem space you have to tackle. Most organizations don't need microservices, use them responsibly.
A good example of using the best tool for the job. Having your whole data analysis pipeline in pandas might not be what you want for performance reason. Very often there's a relational database you can leverage first.
Not exactly new, but easy to loose sight of it when in the hamster wheel. Clearly a good reminder.
Interesting, I didn't know SQLite could have R-Tree indices. This can come in handy for three dimensions or geospatial problems.
Do you ever need to order items stored in SQL? There are ways to do it right and ways to do it wrong. Do it right and pick something meaningful for your case. This article does a good job at listing the typical approaches.