Tag: Database
-
The system design cheat sheet: Relational databases
Posted on March 14, 2024, Level beginner Resource Length long
In system design, relational databases are a traditional choice for data storage, offering structured schema and powerful query capabilities, contrasted with NoSQL databases' flexible schemes and scalability. By Aleksandr Gavrilenko.
Tags mysql database miscellaneous cloud software-architecture
-
What is a serverless database? Plus 8 picks for 2024
Posted on January 21, 2024, Level beginner Resource Length medium
Today, we're diving deep into serverless databases as one solution for aligning these goals. Specifically, we'll check out what they are, how they work, and what benefits they offer. See, when we build any kind of solution, a big portion of the cost is the infrastructure we use to store and host relevant data. This also has an outsized impact on the quality and success of whatever we're building. By Ronan McQuillan.
Tags nosql serverless open-source distributed database
-
Eleven good resources to learn SQL and NoSQL
Posted on January 20, 2024, Level beginner Resource Length medium
SQL and NoSQL are in demand, and learning these tech skills can help improve one's career prospects. These skills are essential for developers, data scientists, business analysts, or anyone working in related fields with data. By Durga Prasad Acharya.
Tags nosql app-development event-driven open-source mysql database
-
How to optimize SQL queries for faster data retrieval
Posted on October 30, 2023, Level beginner Resource Length medium
SQL (Structured Query Language), as you probably, know, helps you collect data from databases. It is specifically designed for that. In other words, it works with rows and columns, allowing you to manipulate data from databases using SQL queries. By Nate Rosidi.
Tags database software performance big-data analytics
-
Dynamic table partitioning in Postgres
Posted on October 29, 2023, Level intermediate Resource Length medium
We helped a customer recently who was storing 500 million chat messages in a single Postgres table. As the table was growing, their queries were slowing down. By Michel Pelletier.
Tags database mysql software performance
-
Bridging the gap between SQL and NoSQL in PostgreSQL with JSON
Posted on October 10, 2023, Level beginner Resource Length medium
PostgreSQL, a popular open-source relational database system can be used as a hybrid database to handle both structured and semi-structured data. PostgreSQL's support for JSON and JSONB object types allows for flexible data modelling and can solve many of the same problems that NoSQL databases are made to address. By Leslie S. Gyamfi.
Tags mysql big-data teams database nosql json
-
Running SQL server on Raspberry Pi using Docker
Posted on September 22, 2023, Level beginner Resource Length medium
The article walks through the process of installing Docker on Raspberry Pi and running Microsoft SQL Server using Docker1. It highlights the compatibility challenges between SQL Server and Raspberry Pi's ARM-compatible CPU and explains how Docker resolves this issue. By Manjiri Gaikwad.
Tags iot programming azure robotics app-development database
-
Artificial intelligence is a very real data center problem
Posted on September 16, 2023, Level beginner Resource Length medium
It would be stupid for us to not consider the consequences as tools like Open AI's ChatGPT or Google's Bard for example to proliferate and introduce machine intelligence to everyday people. That includes how our data centers are evolving amid the rapid growth in data that needs to be stored, processed, managed, and transferred. By Dr. Michael Lebby.
Tags ai data-science cio database big-data
-
Discussing PostgreSQL: What changes in version 16
Posted on September 15, 2023, Level beginner Resource Length long
The article discusses the new features and improvements in PostgreSQL 16, the latest version of the open source relational database. By Amit Kapila.
Tags mysql json cio database web-development
-
Working with Postgres JSON query
Posted on September 14, 2023, Level beginner Resource Length long
The article explains how to work with Postgres JSON Query, which is a feature that allows you to store and query JSON data in PostgreSQL. By Pratibha Sarin.
Tags mysql json microservices database web-development
-
Character sets and collations in MySQL
Posted on June 28, 2023, Level intermediate Resource Length medium
Understanding the differences between character sets and collations in MySQL. Character sets and collations are fundamentally important concepts to understand when dealing with string columns in MySQL. A slight misunderstanding of either can lead to poor performance or unexpected errors when inserting data. By planetscale.com.
Tags web-development app-development mysql database how-to
-
PayPal open sources key-value store JunoDB
Posted on June 27, 2023, Level beginner Resource Length long
PayPal last month released the source code for JunoDB, a distributed key-value store it developed internally and which today powers a variety of backend services at the payment site, including 350 billion transaction requests per day, the company says. By Alex Woodie.
Tags open-source performance web-development app-development database