Scaling databases with AWS RDS and read replicas

Amazon Web Services (AWS) Relational Database Service (RDS) is a managed service that simplifies the process of configuring, operating, and scaling a relational database in the cloud. AWS RDS is a versatile choice that supports several database engines including PostgreSQL,...

June 30, 2024

SQL Data Modeling: Designing Effective Databases

News

SQL Data Modeling: Designing Effective Databases

SQL data modelling involves designing a database structure to meet the organisation’s needs for efficiently storing, managing, and retrieving data. Effective data modeling is crucial for creating scalable, maintainable, and high-performance databases. Here’s a comprehensive guide to SQL data modelling,...

June 27, 2024

Integrating multiple databases in a todos app (Personal project)

News

Integrating multiple databases in a todos app (Personal project)

Project Overview Project Name: cit_dr_todos_app Duration: 12 hrs 39 mins Team Members: Solo Objective: Learn how to integrate multiple databases in the same project Goals and Objectives Original Goals: Learn how to integrate multiple databases in the same project using...

June 25, 2024

Query SQL and NoSQL Databases Using Artificial Intelligence – DZone

News

Query SQL and NoSQL Databases Using Artificial Intelligence – DZone

The ability to seamlessly query and analyze data from multiple sources is a crucial advantage for businesses. With the rise of artificial intelligence, this process has become even more efficient and powerful. In this article, we will explore how to...

June 25, 2024

Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

News

Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

Relational databases first appeared in the 1970s—that was more than half a century ago! They have stood what one would call the “test of time” and remained the go-to persistence solution for software applications. Other database technologies like NoSQL have...

June 8, 2024

Instant API for databases adds automatic primary keys

News

Instant API for databases adds automatic primary keys

In a previous post, we saw how we can read and write data through an instant API provided by DB2Rest. It would be nice to have a way to automatically create chronological sequences of our written data so we do...

May 5, 2024

Mastering NestJS: Building Scalable Systems with Abstractions, ex: different databases

Development News

Mastering NestJS: Building Scalable Systems with Abstractions, ex: different databases

Hello, developers! Welcome to the second part of our NestJS + Clean Architecture + DDD series. In this post, we’ll delve into abstractions and explore how they can be used to create scalable systems that are agnostic to any technology....

March 16, 2024

A New Way to Provision Databases on Kubernetes

Development News

A New Way to Provision Databases on Kubernetes

Need to provide database self-service to internal teams? Can’t spare the resources to build and maintain your own private DBaaS solution? Sick of cloud DBaaS providers locking you in? Percona Everest is a cloud-native database platform to deploy and manage...

March 13, 2024