search

pauleveritt / fdom

Template engine based on tag strings and functional ideas.
0 stars 0 forks source link

SQLite architecture examples #8

Open jimbaker opened 1 year ago

jimbaker commented 1 year ago

Here's an example of using SQLite for high performance across Docker containers, when compared to the usual database: https://rbranson.medium.com/sharing-sqlite-databases-across-containers-is-surprisingly-brilliant-bacb8d753054

Where something like this might come up for FDOM is managing multiple incremental builds (not necessarily across containers, but interesting possibility).

jimbaker commented 1 year ago

SQLite for storing build products in this thread: https://news.ycombinator.com/item?id=22151153

pauleveritt commented 1 year ago

This idea you are expressing -- an FDOM DSL backed by SQLite for build engines -- is very, very provocative. Broadly useful. And I bet you have the right abstractions to create something generally adaptable: not too broad, not too specific.

pauleveritt commented 1 year ago

That Medium article from segment about SQLite and multi-process concurrency at huge scale is FASCINATING. Especially for Python.