21CTO
21CTO
Oct 7, 2025 · Databases

What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More

PostgreSQL 18, released on September 25 2025, introduces developer‑focused features such as native UUID v7 generation, virtual generated columns, enhanced RETURNING clauses, automatic BUFFERS in EXPLAIN ANALYZE, and a unified pg_get_acl() permission function, all aimed at improving everyday database development.

Database DevelopmentEXPLAIN ANALYZEPostgreSQL
0 likes · 8 min read
What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More
ITPUB
ITPUB
Apr 18, 2024 · Databases

Essential PostgreSQL Features: Versioned Schemas, Online Migrations, Git‑Style Branching

The article outlines a developer‑focused wishlist for PostgreSQL, proposing built‑in versioned schemas, online schema changes, instant branch creation akin to Git, configurable archive tables, a flexible key‑value labeling system, and tighter Git integration, while highlighting industry examples such as Neon, Xata, Snaplet, Supabase and Bytebase.

Database DevelopmentGit IntegrationPostgreSQL
0 likes · 8 min read
Essential PostgreSQL Features: Versioned Schemas, Online Migrations, Git‑Style Branching
Liangxu Linux
Liangxu Linux
Mar 27, 2024 · Fundamentals

Where Can You Use C? 8 Major Development Areas Explained

This article outlines eight key domains where C is still widely used—including embedded systems, desktop applications, system components, operating systems, language compilers, signal processing, audio/video handling, and databases—highlighting typical projects, tools, and why C remains essential for low‑level, performance‑critical development.

C languageDatabase DevelopmentEmbedded Development
0 likes · 11 min read
Where Can You Use C? 8 Major Development Areas Explained
21CTO
21CTO
Jan 15, 2024 · Databases

How Oracle’s MySQL 8.2 Preview Brings JavaScript Stored Procedures

Oracle’s MySQL 8.2 preview introduces JavaScript stored procedures powered by GraalVM, allowing developers to write JavaScript or Java code inside the database, but the feature remains a technical preview with performance benefits, debugging support, and cautions about production use and global variable behavior.

Database DevelopmentGraalVMJavaScript
0 likes · 4 min read
How Oracle’s MySQL 8.2 Preview Brings JavaScript Stored Procedures
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 12, 2021 · Databases

Mastering Database Design: Six Essential Phases Explained

This article outlines the six-stage methodology for designing databases—system requirements analysis, conceptual design, logical design, physical design, implementation, and execution/maintenance—detailing each phase’s purpose, techniques, and visual illustrations to guide developers through a structured, standards‑compliant design process.

Database DevelopmentSystems Analysis
0 likes · 3 min read
Mastering Database Design: Six Essential Phases Explained
ITPUB
ITPUB
Nov 5, 2020 · Databases

Inside MySQL InnoDB: My Interview Journey and Development Insights

The author recounts his 2012 MySQL interview experience, describes the global InnoDB team structure, outlines the bug‑fix and feature‑development workflow, lists key contributions such as spatial indexes and transparent encryption, and reflects on leaving Oracle for Tencent Cloud.

Database DevelopmentInnoDBMySQL
0 likes · 9 min read
Inside MySQL InnoDB: My Interview Journey and Development Insights
ITPUB
ITPUB
Nov 3, 2020 · Databases

My MySQL InnoDB Journey: From Interview to Six Years of Core Development

The author recounts his 2012 MySQL interview experience, describes the flat, globally distributed InnoDB team structure, details the typical bug‑fix workflow, lists major InnoDB features he contributed to, and reflects on the lessons learned before moving to Tencent Cloud's database division.

Database DevelopmentInnoDBMySQL
0 likes · 11 min read
My MySQL InnoDB Journey: From Interview to Six Years of Core Development
Efficient Ops
Efficient Ops
Dec 8, 2015 · Databases

What’s the Ideal MySQL DBA Learning Path? Insights from an InnoDB Core Developer

This article shares a MySQL InnoDB core developer’s recommendations on DBA learning stages, Oracle’s stance on MySQL’s future, official comparisons with MariaDB and PostgreSQL, and how MySQL’s globally distributed development team collaborates, offering practical guidance for database professionals.

DBA Learning PathDatabase AdministrationDatabase Development
0 likes · 11 min read
What’s the Ideal MySQL DBA Learning Path? Insights from an InnoDB Core Developer