Tag: SQL
-
How to implement the Outbox pattern in Go and Postgres
Posted on September 26, 2025, Level intermediate Resource Length long
The article discusses implementing the Outbox pattern in Go and PostgreSQL for resilient system design. It addresses issues like failed message broker calls or crashes causing inconsistent states by ensuring database operations and message publishing are atomic. The solution involves saving messages to an outbox table within the same transaction as business data changes, using a background process called Message Dispatcher to handle delivery. By Alex Pliutau.
Tags golang sql software-architecture app-development database
-
MCP + SQL: The secret weapon to connect AI to enterprise systems
Posted on August 31, 2025, Level intermediate Resource Length medium
This article addresses the common challenge of integrating AI with existing enterprise systems like Salesforce and SAP. The core concept is leveraging Large Language Models' (LLMs) proficiency in SQL alongside a standardized communication protocol called the Model Context Protocol (MCP). By Manish Patel.
Tags sql database ai bots devops
-
Commenting in MySQL: Syntax, best practices, and examples
Posted on August 22, 2025, Level intermediate Resource Length medium
MySQL comments, in the structure of text, are ignored by the MySQL engine and used to explain and document your database code. They don't affect query execution. You should used your database comments as a resource to other individuals who will review or modify the database. Comments should adhere to best practices to increase readability to other developers. By Devart.
Tags sql database app-development learning
-
Relational vs non relational database
Posted on December 7, 2024, Level beginner Resource Length medium
A database is an organised collection of information, nowadays commonly stored electronically in a computer system. It is usually controlled by a database management system (DBMS), which, along with the applications associated with it, forms a database system. By ovhcloud.com.
Tags sql cio database nosql performance app-development
-
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 sql 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 sql
-
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 sql 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 sql 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 sql 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 sql 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 sql 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 sql json microservices database web-development