BestHub
Sign in
Tagged articles
9 articles
Page 1 of 1
Laravel Tech Community
Laravel Tech Community
May 27, 2024 · Databases

SQLite 3.46.0 Release Highlights and New Features

SQLite 3.46.0 introduces extensive PRAGMA enhancements, new date‑time modifiers, support for underscore digits in numeric literals, a json_pretty() function, significant query planner optimizations, improved JSON handling, and the ability to use large hexadecimal literals as column defaults, all while maintaining its public‑domain, self‑contained nature.

Database EngineJSONPRAGMA
0 likes · 4 min read
SQLite 3.46.0 Release Highlights and New Features
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2023 · Databases

MySQL Deadlock Analysis and Index Optimization Using ICP

This article examines a MySQL deadlock case involving DELETE and UPDATE statements, explains why the primary key index is locked despite non‑key predicates, analyzes execution plans and optimizer trace, and proposes index restructuring and query hints to resolve the issue.

ICPIndex OptimizationQuery Planner
0 likes · 23 min read
MySQL Deadlock Analysis and Index Optimization Using ICP
Java Architect Essentials
Java Architect Essentials
Apr 18, 2023 · Databases

How MySQL Calculates Execution Cost for Index Selection and Why It May Choose Suboptimal Plans

This article explains how MySQL estimates the I/O and CPU costs of different indexes when executing COUNT(*) and other queries, demonstrates the calculations with a concrete example on a 100k‑row table, and shows why the optimizer sometimes picks a full‑table scan over a seemingly better index.

Database PerformanceIndex OptimizationQuery Planner
0 likes · 10 min read
How MySQL Calculates Execution Cost for Index Selection and Why It May Choose Suboptimal Plans
Laravel Tech Community
Laravel Tech Community
Feb 24, 2022 · Databases

SQLite 3.38.0 Released with New JSON Operators, Enhanced Date/Time Functions, and Query Planner Improvements

SQLite version 3.38.0 introduces new JSON operators compatible with MySQL and PostgreSQL, built‑in JSON functions, added unixepoch() and auto/julianday modifiers for date/time, renamed printf() to format(), enhanced virtual table interfaces, CLI columnar output options, and query planner optimizations using Bloom filters and balanced merge trees.

CLIDatabase EngineQuery Planner
0 likes · 4 min read
SQLite 3.38.0 Released with New JSON Operators, Enhanced Date/Time Functions, and Query Planner Improvements
ITPUB
ITPUB
Jul 11, 2016 · Databases

Inside PostgreSQL: How the Database Kernel Works and Can Be Extended

This article explains PostgreSQL's kernel architecture, from client connection handling through parsing, rewriting, planning, and execution, illustrates scan and join algorithms, shows how to extend the kernel and build clustered deployments, and introduces Foreign Data Wrappers for integrating external data sources.

ClusterForeign Data WrapperIndex Scan
0 likes · 13 min read
Inside PostgreSQL: How the Database Kernel Works and Can Be Extended
ITPUB
ITPUB
May 31, 2016 · Databases

Inside PostgreSQL: How SQL Queries Are Processed from Start to Finish

This article walks through PostgreSQL's complete SQL execution pipeline, detailing each component—from the Main entry point and Postmaster process to parsing, traffic coordination, query rewriting, plan generation, and execution—while comparing its process architecture to other database systems.

Database InternalsPostmasterQuery Planner
0 likes · 6 min read
Inside PostgreSQL: How SQL Queries Are Processed from Start to Finish