Blog

All articles. All pillars. All authors.

Thales & Claude flin

#067 -- Tree Traversal and Integration Testing

How we tested hierarchical data, recursive queries, and tree traversal in FlinDB -- and why integration tests that mimic real applications matter more than unit tests.

9 min Mar 26, 2026
flinflindbtreetesting +1
Thales & Claude flin

#071 -- 409 Built-in Functions: The Complete Standard Library

How FLIN ships 409 built-in functions with zero imports -- text, math, time, HTTP, crypto, validation, and more, all available from the first line of code.

13 min Mar 26, 2026
flinstdlibfunctionsbuiltin
Thales & Claude flin

#072 -- 31 String Methods Built Into the Language

How we expanded FLIN's string methods from 11 basic operations to 31 comprehensive text manipulation functions in Session 050 -- covering search, transformation, validation, and encoding.

11 min Mar 26, 2026
flinstringmethodstext
Thales & Claude flin

#073 -- Math, Statistics, and Geometry Functions

How FLIN ships a complete mathematics library -- 100+ functions covering arithmetic, trigonometry, statistics, and geometry -- built into the language runtime with zero imports.

12 min Mar 26, 2026
flinmathstatisticsgeometry
Thales & Claude flin

#074 -- Time and Timezone Functions

How FLIN's built-in time system handles dates, durations, timezones, and formatting without a single import -- covering 26 time functions and natural duration syntax.

12 min Mar 26, 2026
flintimetimezonedatetime
Thales & Claude flin

#167 -- Entity Ordering and Time Format Bugs

When entity ordering produced wrong results due to time format parsing inconsistencies.

7 min Mar 26, 2026
flinbugorderingtime-format +2
Thales & Claude flin

#060 -- Aggregations and Analytics

How we added aggregation functions, GROUP BY, DISTINCT, and IN/NOT IN operators to FlinDB in a single session -- making embedded analytics possible without SQL.

9 min Mar 26, 2026
flinflindbaggregationsanalytics +1
Thales & Claude flin

#061 -- Index Utilization: Making Queries Fast

How Session 163 transformed FlinDB queries from O(n) full scans to O(1) index lookups -- automatic indexing, query optimization, and index maintenance in an embedded database.

9 min Mar 26, 2026
flinflindbindexesperformance +1
Thales & Claude flin

#062 -- Relationships and Eager/Lazy Loading

How FlinDB handles entity relationships with eager loading, lazy resolution, inverse queries, and auto-indexing -- all without SQL joins.

9 min Mar 26, 2026
flinflindbrelationshipsloading +1
Thales & Claude flin

#063 -- Transactions and Continuous Backup

How we implemented ACID transactions with savepoints, full and incremental backups with Zstd compression, continuous WAL streaming, and scheduled backup rotation in FlinDB.

8 min Mar 26, 2026
flinflindbtransactionsbackup +1
Thales & Claude flin

#065 -- The EAVT Storage Model

How FlinDB's Entity-Attribute-Value-Time event sourcing model provides complete audit trails, temporal queries, and entity replay -- inspired by Datomic and built in Rust.

9 min Mar 26, 2026
flinflindbeavtstorage +1
Thales & Claude flin

#070 -- Persistence in the Browser

How we made FlinDB work in the browser -- from SSR with hot module reload, to two-way data binding, form submission through server actions, and the persistence bug that almost broke everything.

10 min Mar 26, 2026
flinflindbbrowserpersistence +1