Tag: Mysql
-
Advanced SQL techniques to transform data analysis
Posted on November 30, 2024, Level intermediate Resource Length medium
This article covers the proactive way of presenting data analysis by using advanced SQL techniques and offers a step-by-step approach to improving the speed of your queries and their accuracy. By dasca.org.
Tags cloud big-data database mysql data-science
-
Write queries faster with Amazon Q generative SQL for Amazon Redshift
Posted on November 27, 2024, Level intermediate Resource Length medium
Amazon Redshift is a fully managed, AI-powered cloud data warehouse that delivers the best price-performance for your analytics workloads at any scale. Amazon Q generative SQL brings the capabilities of generative AI directly into the Amazon Redshift query editor. Amazon Q generative SQL for Amazon Redshift was launched in preview during AWS re:Invent 2023. With over 85,000 queries executed in preview, Amazon Redshift announced the general availability in September 2024. By Raghu Kuppala, Phil Bates, Xiao Qin, Erol Murtezaoglu, and Sushmita Barthakur.
Tags cloud aws database mysql
-
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
-
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
-
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
-
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
-
How to use systemd in Linux to configure and manage multiple MySQL instances
Posted on September 9, 2023, Level beginner Resource Length short
Systemd is a system and service manager for Linux systems. It provides a consistent way to start, stop, and manage system services. Systemd can also be used to manage multiple MySQL instances on a single server. By Mughees Ahmed.
Tags linux servers learning devops mysql
-
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
-
Building and deploying MySQL Raft at Meta
Posted on May 19, 2023, Level intermediate Resource Length medium
At Meta, we run one of the largest deployments of MySQL in the world. The deployment powers the social graph along with many other services, like Messaging, Ads, and Feed. Over the last few years, we have implemented MySQL Raft, a Raft consensus engine that was integrated with MySQL to build a replicated state machine. By Anirban Rahut, Abhinav Sharma, Yichen Shen, Ahsanul Haque.
Tags mysql database cloud software-architecture app-development
-
Comparisons of proxies for MySQL
Posted on April 11, 2023, Level intermediate Resource Length long
HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be considered before deciding on the best solution. By Marco Tusa.
Tags mysql database performance how-to devops