diff options
| author | alexpdp7 <alex@pdp7.net> | 2020-01-21 09:33:12 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-01-21 09:33:12 +0100 |
| commit | d6728a85a1691609445152a70c03e9e5917a1fd2 (patch) | |
| tree | 736c2ed69ca2d3da66fd22f2ddd3ebdb6984b724 /IDEAS | |
| parent | 0176c3d89cffd1bca3a57d5489d2a322349ad7e0 (diff) | |
Add streaming database
Diffstat (limited to 'IDEAS')
| -rw-r--r-- | IDEAS | 8 |
1 files changed, 8 insertions, 0 deletions
@@ -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) |
