Tag: Database
-
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
-
Using Redis with FastAPI
Posted on September 12, 2025, Level intermediate Resource Length short
FastAPI is a Python web framework based on the Starlette microframework. With deep support for asyncio, FastAPI is indeed very fast. FastAPI also distinguishes itself with features like automatic OpenAPI (OAS) documentation for your API, easy-to-use data validation tools, and more. By Andrew Brookins.
Tags database web-development app-development nosql python
-
Microsoft entrusts DocumentDB to Linux Foundation
Posted on September 2, 2025, Level beginner Resource Length short
Microsoft has announced that DocumentDB, their distributed NoSQL database built on PostgreSQL, is joining the Linux Foundation. This represents a significant shift from Microsoft's traditional approach to database development. DocumentDB was initially created within Microsoft to handle document-oriented workloads (think JSON data) at scale, prioritizing high availability and flexibility. By Bobby Borisov.
Tags nosql database cio azure
-
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
-
The future of data processing: PostgreSQL evolution with YingJun Wu of Rising Wave
Posted on August 20, 2025, Level intermediate Resource Length medium
RisingWave, founded by YingJun Wu, is a stream processing system that has gained attention for its PostgreSQL compatibility and efficient resource utilization. Unlike traditional systems like Apache Flink, RisingWave leverages S3 as its primary storage, similar to Snowflake's architecture. This approach not only reduces storage costs but also enables seamless elastic scaling. By Firebolt Team.
Tags streaming app-development software-architecture database cio
-
Amazon DocumentDB serverless: Auto-scaling database solution for variable workloads
Posted on August 16, 2025, Level intermediate Resource Length medium
The primary goal of Amazon DocumentDB Serverless is to simplify operational overhead and reduce costs for developers using DocumentDB, a MongoDB-compatible database service. AWS recently announced the general availability (GA) of Amazon DocumentDB Serverless, an on-demand, auto-scaling configuration for Amazon DocumentDB. However, it's important to note that while AWS markets it as "serverless," it aligns more with an auto-scaling model rather than a scale-to-zero model, which is a key differentiator often associated with true serverless offerings. By Steef-Jan Wiggers.
Tags serverless app-development web-development database aws
-
Seven essential big data analytics tools every business needs in 2025
Posted on March 5, 2025, Level beginner Resource Length medium
Data floods in by the second, fueling every facet of business operations. Yet, raw data offers little value on its own — this is where big data analytics tools step in, transforming numbers into actionable insights. By Irina Prevalova.
Tags analytics cloud big-data database
-
The future of Data Lakehouses: Apache Iceberg explained
Posted on February 18, 2025, Level beginner Resource Length medium
The evolution from traditional data warehouses to modern data lakehouses marks a significant shift in how businesses approach data management. Data warehouses once served as the centralized repository for structured data and facilitated rapid query performance with robust governance mechanisms. However, companies faced challenges such as high storage costs, rigid schema enforcement, and limited support for AI and machine learning workloads. By Fawaz Ghali, PhD.
Tags apache database miscellaneous app-development streaming
-
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
-
Introduction to distributed NoSQL databases
Posted on December 3, 2024, Level beginner Resource Length medium
Distributed NoSQL databases are designed to handle large datasets efficiently. They are distributed across multiple servers, which allows them to scale horizontally. NoSQL databases are more flexible than traditional relational databases, which can make them a better choice for applications with changing data needs. By Alex Patino.
Tags cloud aws database nosql performance
-
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