#postgresql-18

[ follow ]
Software development
fromInfoQ
9 hours ago

TigerFS Mounts PostgreSQL Databases as a Filesystem for Developers and AI Agents

TigerFS is an experimental filesystem that integrates PostgreSQL, allowing file operations through a standard filesystem interface.
DevOps
fromInfoQ
13 hours ago

Replacing Database Sequences at Scale Without Breaking 100+ Services

Validating requirements can simplify complex problems, and embedding sequence generation reduces network calls, enhancing performance and reliability.
Node JS
fromhowtocenterdiv.com
1 week ago

Database Performance Bottlenecks: N+1 Queries, Missing Indexes, and Connection Pools

Database issues, like missing indexes and N+1 queries, are often overlooked in software engineering, leading to persistent performance problems.
#mongodb
Django
fromInfoQ
1 week ago

Open Source, Community, and Consequence: The Story of MongoDB

The keynote focuses on the document model and the community behind MongoDB, rather than the database itself.
Django
fromInfoQ
1 week ago

Open Source, Community, and Consequence: The Story of MongoDB

The keynote focuses on the document model and the community behind MongoDB, rather than the database itself.
Python
fromRealpython
1 week ago

Understanding CRUD Operations in SQL - Real Python

CRUD operations are essential for creating, reading, updating, and deleting data in applications.
DevOps
fromInfoQ
6 days ago

ProxySQL Introduces Multi-Tier Release Strategy With Stable, Innovative, and AI Tracks

ProxySQL 3.0.6 introduces a multi-tier release strategy focusing on stability, innovation, and AI capabilities for diverse user needs.
Business intelligence
fromTheregister
2 weeks ago

Microsoft promises multi database wrangling hub on Fabric

Microsoft launched Database Hub, a unified management tool within Fabric that consolidates multiple database services across on-premises, PaaS, and SaaS environments with AI-assisted capabilities.
Business intelligence
fromInfoWorld
3 weeks ago

Why Postgres has won as the de facto database: Today and for the agentic future

Leading enterprises achieve 5x ROI by adopting open source databases like PostgreSQL to unify structured and unstructured data for agentic AI, with 81% of successful enterprises committed to open source strategies.
DevOps
fromInfoQ
1 week ago

AWS Expands Aurora DSQL with Playground, New Tool Integrations, and Driver Connectors

Amazon Aurora DSQL introduces usability enhancements, including a browser-based playground and integrations with popular SQL tools for improved developer experience.
Online Community Development
fromInfoWorld
3 weeks ago

Oracle rejects request it give up control of MySQL

Oracle refused to restructure MySQL Community Edition governance despite requests from database companies and 544 users, though it promised increased transparency and feature parity with commercial versions.
Data science
fromInfoWorld
4 weeks ago

The revenge of SQL: How a 50-year-old language reinvents itself

SQL has experienced a major comeback driven by SQLite in browsers, improved language tools, and PostgreSQL's jsonb type, making it both traditional and exciting for modern development.
DevOps
fromTheregister
2 weeks ago

AWS spurs Catch-22, ending PostgreSQL 13 support for RDS

AWS RDS PostgreSQL 13 end of support forces upgrades to PostgreSQL 14+, but this breaks AWS Glue ETL service due to incompatible authentication schemes, creating a production environment conflict.
fromTheregister
3 weeks ago

Oracle moves to assure MySQL community it really does care

Oracle firmly believes that MySQL's enduring strength arises from this vibrant global community. We are excited to work with the MySQL Community on the strategy we announced in Belgium, January 29, 2026, including adding more features and functionality, accelerating innovation directly in the MySQL core.
Online Community Development
#mariadb-acquisition
Business intelligence
fromInfoWorld
3 weeks ago

MariaDB taps GridGain to keep pace with AI-driven data demands

MariaDB's acquisition of GridGain aims to create an integrated platform combining relational database reliability with in-memory computing speed to compete with hyperscaler offerings.
Business intelligence
fromInfoWorld
3 weeks ago

MariaDB taps GridGain to keep pace with AI-driven data demands

MariaDB's acquisition of GridGain aims to create an integrated platform combining relational database reliability with in-memory computing speed to compete with hyperscaler offerings.
DevOps
fromInfoWorld
2 weeks ago

Update your databases now to avoid data debt

Multiple major open source databases reach end-of-life in 2026, requiring teams to plan upgrades and migrations to avoid security risks and higher costs.
#mariadb
Software development
fromInfoQ
1 month ago

MySQL 9.6 Changes Foreign Key Constraints and Cascade Handling

MySQL 9.6 moves foreign key constraint and cascade management from InnoDB storage engine to SQL layer, improving CDC pipeline accuracy and data consistency across replication and analytics workloads.
DevOps
fromInfoQ
3 weeks ago

From Minutes to Seconds: Uber Boosts MySQL Cluster Uptime with Consensus Architecture

Uber redesigned MySQL infrastructure using Group Replication to reduce failover time from minutes to seconds while maintaining strong consistency across thousands of clusters.
DevOps
fromInfoQ
3 weeks ago

Netflix Automates RDS PostgreSQL to Aurora PostgreSQL Migration Across 400 Production Clusters

Netflix automated RDS to Aurora PostgreSQL migrations across 400 production clusters through infrastructure-level orchestration, eliminating manual intervention while maintaining data integrity and CDC pipeline correctness.
fromPaolo Melchiorre
1 month ago

Django ORM Standalone: Querying an existing database

For a long time I wanted to document something I have done many times in production systems but never explained clearly: using Django ORM as a standalone module to connect to an existing database. In my work I have often dealt with legacy systems where the only reliable source of truth was the database itself. In those situations, Django ORM became my Swiss army knife.
Web frameworks
Data science
fromInfoQ
1 month ago

Databricks Introduces Lakebase, a PostgreSQL Database for AI Workloads

Databricks Lakebase is a serverless PostgreSQL OLTP database that separates compute from storage and unifies transactional and analytical capabilities.
DevOps
fromInfoQ
3 weeks ago

Google BigQuery Previews Cross-Region SQL Queries for Distributed Data

BigQuery's global queries feature enables SQL queries across multiple geographic regions without data movement, eliminating ETL pipelines for distributed analytics.
Java
fromInfoWorld
1 month ago

GlassFish 8 Java server boosts data access, concurrency

GlassFish 8 adds virtual threads for massive concurrency, integrates Jakarta Security with MicroProfile JWT for flexible authentication, and supports JMX monitoring in Embedded mode.
#ai
#mysql
fromInfoWorld
1 month ago
Software development

Community push intensifies to free MySQL from Oracle's control amid stagnation fears

fromInfoWorld
1 month ago
Software development

Community push intensifies to free MySQL from Oracle's control amid stagnation fears

fromDbmaestro
4 years ago

5 Pillars of Database Compliance Automation |

There is a growing emphasis on database compliance today due to the stricter enforcement of compliance rules and regulations to safeguard user privacy. For example, GDPR fines can reach £17.5 million or 4% of annual global turnover (the higher of the two applies). Besides the direct monetary implications, companies also need to prioritize compliance to protect their brand reputation and achieve growth.
EU data protection
Tech industry
fromTheregister
1 month ago

Snowflake plugs PostgreSQL into its AI Data Cloud

Snowflake now offers a native PostgreSQL DBaaS in its AI Data Cloud to run transactional workloads alongside analytics and AI under unified governance.
#openeverest
Artificial intelligence
fromInfoWorld
2 months ago

Generative AI and the future of databases

Databases must evolve into AI-native systems that securely federate with LLMs, support real-time access, granular permissions, and tools for safe natural-language-to-SQL integration.
Tech industry
fromInfoQ
2 months ago

Google Introduces Managed Connection Pooling for AlloyDB

AlloyDB's managed connection pooling increases client connections and transactional throughput while reducing operational burden and latency for high-concurrency and serverless workloads.
Data science
fromTreehouse Blog
2 months ago

Beginning SQL: 10 Essential Query Patterns

Recognizing common SQL query patterns enables beginners to retrieve, filter, summarize, and reason about data effectively across industries.
#clickhouse
Tech industry
fromInfoQ
2 months ago

Expired Oracle Patent Opens Fast Sorting Algorithm to Open Source Databases

An expired Oracle patent enables open-source databases to implement an adaptive "Orasort" that speeds sorting of similar keys by skipping common prefixes and caching substrings.
Software development
fromDbmaestro
4 years ago

If You Don't Have Database Delivery Automation, Brace Yourself for These 10 Problems |

Manual database processes break DevOps pipelines; only 12% deploy database changes daily, causing configuration drift, frequent errors, slower time-to-market, and reduced productivity.
fromTheregister
1 month ago

Oracle's Database 26ai goes on-prem, but draws skeptics

In 2024, Oracle launched its Database 23ai, dropping the "c" suffix it established for cloud in 2013. But the release never arrived as a general on-premises option beyond Oracle's own engineered systems, and the company later pushed back the Premier Support cutoff for 19c to December 31, 2029, with Extended Support running through December 31, 2032. Premier support was originally slated to end in 2024.
Tech industry
Artificial intelligence
fromInfoQ
1 month ago

MongoDB Introduces Embedding and Reranking API on Atlas

MongoDB Atlas now offers an Embedding and Reranking API with Voyage AI models, enabling unified semantic search, automated embeddings, and integrated monitoring and billing.
Software development
fromInfoWorld
1 month ago

4 self-contained databases for your apps

XAMPP provides a complete local web stack (MariaDB, Apache, PHP, Mercury SMTP, OpenSSL) while PostgreSQL can be run standalone or embedded via pgserver in Python.
Tech industry
fromTechzine Global
2 months ago

ScyllaDB: We're so over, overprovisioning

ScyllaDB X Cloud provides truly elastic, auto-scaling database capacity to reduce overprovisioning and deliver predictable high-throughput, ultra-low-latency performance.
Software development
fromMedium
1 month ago

The Complete Database Scaling Playbook: From 1 to 10,000 Queries Per Second

Database scaling to 10,000 QPS requires staged architectural strategies timed to traffic thresholds to avoid outages or unnecessary cost.
Artificial intelligence
fromInfoQ
2 months ago

LangGrant Unveils LEDGE MCP Server to Enable Agentic AI on Enterprise Databases

LEDGE MCP Server enables LLMs to generate multi-step analytics across enterprise databases securely without exposing raw data, reducing token costs and preserving governance.
fromInfoWorld
2 months ago

What's new in MySQL 9.0

But it still contains useful things and can be upgraded to from MySQL 8.4 LTS; the MySQL Configurator automatically does the upgrade without user intervention during MSI installations on Windows. The major changes include: A new Vector datatype is supported in CREATE and ALTER statements. JavaScript Stored Programs, which support JavaScript-based stored programs and functions, has come to MySQL Enterprise Edition. JavaScript Stored Programs can call SQL, and SQL can call them.
Software development
fromInfoQ
1 month ago

VillageSQL Launches as an Extension-Focused MySQL Fork

A new open-source project, VillageSQL, has been introduced as a tracking fork of MySQL aimed at expanding extensibility and addressing feature gaps increasingly relevant to AI and agent-based workloads. Announced by founder Dominic Preuss, VillageSQL Server for MySQL is positioned as a drop-in replacement that maintains compatibility with upstream MySQL while adding a structured extension framework. The alpha release is now available for experimentation.
Software development
#database-devops
Software development
fromDbmaestro
1 year ago

Why Do You Need Database Version Control?

Database version control tracks schema and code changes, enabling CI/CD integration, collaboration, rollback, and faster, more reliable deployments across multiple databases.
fromInfoWorld
2 months ago

AI is changing the way we think about databases

Developers have spent the past decade trying to forget databases exist. Not literally, of course. We still store petabytes. But for the average developer, the database became an implementation detail; an essential but staid utility layer we worked hard not to think about. We abstracted it behind object-relational mappers (ORM). We wrapped it in APIs. We stuffed semi-structured objects into columns and told ourselves it was flexible.
Software development
fromTechzine Global
1 month ago

Databricks makes serverless Postgress service Lakebase available

Databricks today announced the general availability of Lakebase on AWS, a new database architecture that separates compute and storage. The managed serverless Postgres service is designed to help organizations build faster without worrying about infrastructure management. When databases link compute and storage, every query must use the same CPU and memory resources. This can cause a single heavy query to affect all other operations. By separating compute and storage, resources automatically scale with the actual load.
Software development
Software development
fromInfoQ
1 month ago

OpenAI Scales Single Primary Postgresql to Millions of Queries per Second for ChatGPT

OpenAI scaled a single-primary PostgreSQL to millions of queries per second by optimizing instance size, query patterns, read replicas, and offloading write-heavy workloads.
Software development
fromInfoWorld
2 months ago

Why your next microservices should be streaming SQL-driven

Streaming SQL with UDFs, materialized results, and ML/AI integrations enables continuous, stateful processing of event streams for microservices.
[ Load more ]