Browsing Tag
database
195 posts
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?
Choosing the right database is a pivotal decision for full-stack developers, impacting everything from application performance to scalability.…
What You Possibly Don’t Know About Columnar Storage
The columnar storage is a commonly used storage technique. Often it implies high performance, and has basically become…
End of ElephantSQL 😔
ElephantSQL started back in 2013 and it was one of the first services to offer postgreSQL at such…
Redis reborn, a new chapter begins
Redis has made a significant decision to adopt dual source-available licensing, announced by Rowan Trollope, the CEO of…
Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)
Introduction Databases from an on-premises SQL Server instance can be moved to an Azure SQL Database (offline) using…
ORM vs No ORM: Which to Choose?
ORM (Object-Relational Mapping) Choose to use an ORM, like Sequelize, Django ORM, Hibernate, or Entity Framework if: You…
SQL vs NoSQL: Which to Choose?
SQL Choose SQL databases, like MySQL, PostgreSQL, and SQLite, if: Your data is structured and relational. You need…
How to Implement Sharding in MongoDB
In the realm of database management, scaling is a fundamental challenge. As data grows, so do the demands…
How to Keep a History of MQTT Data With Python
The MQTT protocol is a simple way to connect different sources of data to applications, which makes it…
Functions in SQL
Functions are very similar to procedures in databases. In this article, I will try to break down functions…
