From d6728a85a1691609445152a70c03e9e5917a1fd2 Mon Sep 17 00:00:00 2001 From: alexpdp7 Date: Tue, 21 Jan 2020 09:33:12 +0100 Subject: [PATCH] Add streaming database --- IDEAS | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/IDEAS b/IDEAS index 7d9950b..065bf1b 100644 --- a/IDEAS +++ b/IDEAS @@ -85,3 +85,11 @@ SQL2 * Makes queries composable (e.g. declare a query object, then add paging/sorting, for framework usage) * Declarative join via foreign key constraint names * Better ordering for code completion (e.g. FROMs first) + +Streaming DB + +* Simple relational database +* Can act as replication target of other databases +* Supports a limited SQL subset that can be easily reasoned about functional dependencies +* Can stream efficiently the results of an SQL query (e.g. keep a query running and receive new/modified rows) +* Supports efficient replication of a subset of a database (initial checkpoint + streaming or batched updates) -- 2.47.3