How dualdb validates that converted code still builds, and how it reports what was actually validated.
Build applications and features on the OpenSaaS Stack.
Workflow for optimizing ClickHouse and HogQL queries.
Build data ingestion pipelines for batch and streaming data from multiple sources.
Designs ETL/ELT data pipelines with proper extraction, transformation, and loading patterns, including orchestration, error handling, and…
Manage database schema changes safely with migration tools, zero-downtime strategies, and rollback procedures.
Designs and builds knowledge graphs to represent entities, relationships, and semantic connections, with query patterns for Neo4j, RDF…
Advanced PostgreSQL patterns for performance optimization, complex queries, indexing strategies, and database design
Use Redis effectively for caching, pub/sub messaging, rate limiting, distributed locks, and session storage.
Analyzes complex SQL queries to improve performance, suggesting indexing strategies, schema refactoring, and query rewrites.
Keep apps and templates loading fast. Read when adding a data model, a list/read action, a page or sidebar that loads data, or when…
Governs the on-device Drift/SQLite data layer: package:drift and package:sqlite3 confined to lib/data/ behind DAOs that map rows to…
Phase 2 of the pentaphase structural-overhaul protocol.
Phase 3 of the pentaphase structural-overhaul protocol.
Phase 4 of the pentaphase structural-overhaul protocol.
Maintaining packages/phoenix-sqlean, the vendored fork of nalgeon/sqlean.py published as arize-phoenix-sqlean.
Use when designing or auditing the analytical "evidence" of an ACM PODS paper — worst-case and average-case analyses, matching upper and…
How to keep template code database-agnostic and hosting-agnostic.
Author, validate, and test Power Query M expressions in semantic model partitions.
When to activate: slow query, EXPLAIN ANALYZE, N+1, index, query plan, performance, pagination, query tuning
Run ClickHouse `system.query_log` analysis via the internal Metabase API.