© 2022 Hashnode
#databases
Who's ready for Hashnode's next Hackathon? 🎉 We are excited to announce that we're partnering with amazing folks at PlanetScale for the July Hashnode Hackathon, Yay!!! About PlanetScale PlanetScale…
Since Apache ShardingSphere 5.0.0-Beta version included DistSQL, it made the project increasingly loved by developers and Ops teams for its advantages such as dynamic effects, no restart, and elegant …
Redis is a simple in-memory key value database mainly used for caching. Redis used to be a simple in-memory database. Now Redis is much more than that. Thanks to Redis modules, apart from the simple d…
Recently, I needed to get a PostgreSQL database running on Heroku with some sample data. Here's what I had to do to make it happen - and some of the limitations I discovered in Heroku's PostgreSQL off…
Until now, we’ve been looking at tools from a specific developer or platform. We covered ApexSQL, dbForge, and native Azure tools. In this final list, we’ll be going through tools from different devel…
I came across Adrian Cantrill's mini AWS projects on Reddit and decided to give it a try. There are about twelve projects on his Github repo currently and I figured I'll try doing all of them. The very first project that caught my attention…
Master Slave/DB replication As the name suggests, master-slave is a concept where there is one master and multiple slaves. The concept of master slave is also known as DB replication. Replication means having a copy or replicating something…
Should you delete records from your database or instead use a soft delete? I was recently asked my view on this question by a follower on Twitter. So what's my answer? Well, I'm not usually thinking about "deleting" anything. Rather I'm thi…
As Java developers, we’re no strangers to the concept of garbage collection. Our apps generate garbage all the time, and that garbage is meticulously cleaned out by CMS, G1, Azul C4, and other types o…
Intro In this part I will be talking about: Trigger limitations Trigger use cases Trigger limitation and use cases Let's begin by discussing some of the advantages of using Triggers: Used for Datab…