BestHub
Sign in
Tagged articles

Virtual Tables

3 articles · Page 1 of 1
Lakehouse Research Base
Lakehouse Research Base
Sep 10, 2026 · Databases

Apache Fluss Virtual Tables: $changelog vs $binlog for Queryable Change Streams

This article deep-dives into Apache Fluss virtual tables, explaining how $changelog and $binlog suffixes expose change logs as read-only queryable tables, detailing their schemas, use cases, differences between PrimaryKey and Log tables, startup modes, limitations, and the design philosophy enabling native CDC consumption via SQL without external tools.

Apache FlussBinlogCDC
0 likes · 9 min read
Apache Fluss Virtual Tables: $changelog vs $binlog for Queryable Change Streams
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