Conversation

I'm excited to share the first public notes about the project that

and I have been working on for the past 6 months! Building apps is too hard. We think that the solution involves *databases*. ... what?

riffle.systems

Building data-centric apps with a reactive relational database

We're exploring an approach to simplifying app development: storing all application and UI state in a client-side reactive relational database that provides a structured dataflow model.

162

Replying to

and

Very cool that you tested out DuckDB! You mentioned that the serialization / deserialization to and from the worker was a bottleneck for you. Did you happen to try using Apache Arrow alongside DuckDB? That should remove that serdes! I love the idea of using a DB to track state!

Replying to

and

I was really impressed with DuckDB when we tried it! I think we did experiment with Apache Arrow, but then gave up on it when we moved back to SQLite. It definitely feels like the right solution.

3:20 AM · Mar 4, 2022Twitter Web App

Replying to

When we tried it, DuckDB was missing a couple of query optimizations that were really key for us, even though ti made almost all our queries faster (... the story of all query optimizer projects, I think). Looking forward to giving it another spin some time!

Replying to

Too bad which optimizations in particular?

Show replies