Tagged articles
database features
17 articles · Page 1 of 1
This article details SQLite's SQL enhancements from versions 3.22.0 to 3.26.0 in 2018, covering boolean literals with IS [NOT] TRUE/FALSE, window functions with OVER clause limitations, FILTER clause for aggregates, UPSERT via INSERT ON CONFLICT, and column renaming via ALTER TABLE RENAME COLUMN.
FILTER clauseSQLSQL standards
0 likes · 12 min read

This article reviews SQLite's 2018 enhancements, covering boolean literals, window functions, the FILTER clause, upsert syntax, column‑renaming support, and related API changes, while also noting the remaining limitations compared with other major database systems.
Boolean LiteralsSQLSQLite
0 likes · 10 min read

This article explores SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clauses, upsert syntax, and column renaming—detailing how each feature works, its syntax, and practical code examples, while also clarifying limitations compared to other major database systems.
Boolean LiteralsFILTER clauseSQL
0 likes · 10 min read


ITPUBMar 21, 2025 · Databases
This article reviews the SQL enhancements introduced in SQLite from version 3.22.0 through 3.26.0, covering boolean literals, window functions, the FILTER clause, upsert syntax, and column‑renaming support, while comparing SQLite's capabilities to other major database engines.
Boolean LiteralsFILTER clauseRename Column
0 likes · 11 min read

MySQL Innovation Edition 9.1.0, released on October 15 2024, introduces atomic DDL operations, enhanced audit and firewall handling, numerous compiler and SQL function fixes, JavaScript stored‑procedure improvements, new vector support, updated keyring security, pluggable authentication fixes, expanded GROUP REPLICATION logging, and several EXPLAIN and performance‑schema enhancements.
Group ReplicationJavaScript stored proceduresMySQL
0 likes · 10 min read


21CTOSep 27, 2024 · Databases
PostgreSQL 17 introduces a highly optimized incremental backup built into the core, expanded SQL/JSON functions aligned with the SQL:2023 standard, and a configurable SLRU cache, all aimed at improving performance, recovery speed, and developer productivity for modern database workloads.
PostgreSQLSLRU CacheSQL/JSON
0 likes · 6 min read

This article explores SQLite’s 2018 SQL feature updates—from boolean literals and truth testing to window functions, FILTER clauses, upsert syntax, column renaming, and related API changes—highlighting syntax details, limitations, and practical examples for developers seeking to leverage these modern capabilities in production.
SQLSQLiteUPSERT
0 likes · 10 min read


21CTONov 12, 2023 · Databases
This article traces PostgreSQL's origins from the 1980s INGRES project, compares navigation and relational databases, outlines its evolution through Postgres95 to PostgreSQL, and highlights ten modern features that make it a powerful, scalable, and secure choice for developers today.
PostgreSQLSQLdata types
0 likes · 17 min read

MySQL 8.2.0, released on October 25, 2023, introduces audit‑log cleanup scripts, FIDO‑based authentication, named‑parameter support, numerous deprecations, firewall reload scheduling, expanded SQL syntax options, and new client and server features while dropping outdated functions and variables.
MySQLSQLdatabase features
0 likes · 9 min read

Oracle 23c turns the converged database vision into reality by unifying relational, document, and graph data under a single SQL engine, offering built‑in microservice support, lock‑free reservations, immutable tables, and an integrated SQL firewall to reduce architecture complexity and development cost.
23cConverged DatabaseOracle
0 likes · 8 min read


ITPUBJul 22, 2023 · Databases
MySQL 8.1 and 8.0.34, released on July 18, 2023, introduce a mix of innovative features—such as JSON EXPLAIN INTO, enhanced replication controls, TLS certificate enforcement, and new SHOW PARSE_TREE—while also aligning many adjustments with 8.0.34, adding user‑management options, audit enhancements, binary‑log APIs, and a series of deprecations for future versions.
MySQLReplicationSQL
0 likes · 8 min read

The article explains SQLite’s 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—detailing how these features work, their syntax, limitations, and providing code examples for developers seeking to use SQLite in production environments.
FILTER clauseSQLSQLite
0 likes · 10 min read

SQLite, often underestimated, introduced several powerful SQL enhancements in 2018—including boolean literals, window functions, FILTER clauses, UPSERT syntax, and column renaming—bringing its capabilities closer to major RDBMSes while retaining its lightweight, file‑based design.
Boolean LiteralsSQLSQLite
0 likes · 11 min read

The talk explores PostgreSQL’s unique community-driven development, its commercial and innovative capabilities, new version features such as enhanced partitioning and parallel computing, and how its open‑source licensing, extensible architecture, and cloud integrations make it a compelling, enterprise‑ready database solution.
PostgreSQLVersion Updatescloud integration
0 likes · 17 min read

This article provides a comprehensive overview of Apache HBase, covering its core architecture, key features such as automatic sharding, LSM‑Tree storage, separation of storage and compute, the ecosystem, real‑world use cases, recent 2.0 enhancements, upgrade guidance, future plans, and community recruitment information.
ApacheHBaseNoSQL
0 likes · 10 min read


ITPUBSep 28, 2017 · Databases
MySQL 8.0 RC1 introduces major enhancements such as improved JSON handling, a full‑featured Document Store with transaction support, expanded Unicode and GIS capabilities, plus a suite of modern SQL features designed to better serve mobile‑first and cloud‑native applications.
Document StoreJSONMySQL
0 likes · 5 min read

This article walks through the major MySQL 5.7 enhancements—including InnoDB buffer‑dump improvements, multi‑threaded page cleaning, dynamic buffer‑pool resizing, global tablespaces, default DYNAMIC row format, native partitioning, truncate‑undo logs, native JSON support, sys schema, optimizer hints, trigger upgrades, syslog integration, and virtual columns—providing practical steps, examples, and usage tips for DBAs.
InnoDBJSONMySQL
0 likes · 12 min read
