$ lexprog.com

// notes from an old coder -- php, databases, and the occasional rant

[Jul 17, 2025] clickhouse

ClickHouse AggregatingMergeTree: State

ClickHouse AggregatingMergeTree: State

read -->

[Jul 10, 2025] mongodb

MongoDB ObjectId: Generation Strategies

MongoDB ObjectId: Generation Strategies

read -->

[Jul 07, 2025] clickhouse

ClickHouse ReplacingMergeTree: Deduplication

ClickHouse ReplacingMergeTree: Deduplication

read -->

[Jul 03, 2025] clickhouse

ClickHouse Backup and Restore: Strategies

ClickHouse Backup and Restore: Strategies

read -->

[Jun 25, 2025] eloquent-orm

Eloquent Factories and Seeders

Eloquent Factories: Tips & Tricks

read -->

[Jun 23, 2025] eloquent-orm

Eloquent Dynamic Scopes: Reusable Queries

Eloquent Dynamic Scopes: Reusable Queries

read -->

[Jun 22, 2025] postgresql

PostgreSQL Query Plan Analysis: EXPLAIN Deep Dive

PostgreSQL Query Plan Analysis: EXPLAIN Deep Dive

read -->

[Jun 20, 2025] postgresql

PostgreSQL Identity Columns: Modern Auto-Increment

PostgreSQL Identity Columns: Modern Auto-Increment

read -->

[Jun 18, 2025] laravel

Laravel Custom Validation: Rule Objects

Laravel Custom Validation: Rule Objects

read -->

[Jun 17, 2025] postgresql

PostgreSQL Foreign Data Wrappers: Query Remote Databases

PostgreSQL Foreign Data Wrappers: Query Remote Databases

read -->

════════════════════════════════════════════════════════

<-- 9 10 11 12 13 14 15 -->

// showing 111-120 of 225 posts • page 12/23