aboutsummaryrefslogtreecommitdiff
path: root/_posts/2020-08-31-the-database-i-wish-i-had.md
diff options
context:
space:
mode:
authorEuAndreh <eu@euandre.org>2020-09-03 16:41:16 -0300
committerEuAndreh <eu@euandre.org>2020-09-03 16:48:42 -0300
commitfb4f3ffa4ad0566829af5d356623b5beed6ba772 (patch)
tree84e8b531091d51213db8806d14827b163fad6c33 /_posts/2020-08-31-the-database-i-wish-i-had.md
parentdb post: Add correction on SQLite assumption of POSIX filesystem (diff)
downloadeuandre.org-fb4f3ffa4ad0566829af5d356623b5beed6ba772.tar.gz
euandre.org-fb4f3ffa4ad0566829af5d356623b5beed6ba772.tar.xz
db post: improve wording of posix-sqlite note
Diffstat (limited to '_posts/2020-08-31-the-database-i-wish-i-had.md')
-rw-r--r--_posts/2020-08-31-the-database-i-wish-i-had.md14
1 files changed, 7 insertions, 7 deletions
diff --git a/_posts/2020-08-31-the-database-i-wish-i-had.md b/_posts/2020-08-31-the-database-i-wish-i-had.md
index 4ba1885..73423ce 100644
--- a/_posts/2020-08-31-the-database-i-wish-i-had.md
+++ b/_posts/2020-08-31-the-database-i-wish-i-had.md
@@ -83,20 +83,20 @@ that would have to be emulated~~[^posix-sqlite].
page. SQLite still is an implementation of a relational, SQL, table-oriented
database. It is probably true that cherry-picking the relevant parts of
SQLite (like storage access, consistency, crash recovery, parser generator,
- etc.) and leaving out the unwanted parts (SQL, tables, FTS, etc.) would be
- better than using of all it just to building on top of the whole SQLite
- stack, but that's simply an optimization. Both could even coexist, if
- desired.
+ etc.) and leaving out the unwanted parts (SQL, tables, FTS, etc.) would be
+ better than including the full SQLite stack, but that's simply an
+ optimization. Both could even coexist, if desired.
SQLite would have to be treated similarly to how Datomic treats SQL
databases: instead of having a table for each entities, spread attributes
over the tables, etc., it treats SQL databases as a key-value storage so it
- doesn't have to re-implement interacting with the disk.
+ doesn't have to re-implement interacting with the disk that other databases
+ do well.
The tables would contain blocks of binary data, so there isn't a difference
on how the SQLite storage backend behaves and how the IndexedDB storage
- backend behaves, much like Datomic works the same regardless of the storage
- backend, same for PouchDB.
+ backend behaves, much like how Datomic works the same regardless of the
+ storage backend, same for PouchDB.
I welcome corrections on what I said above, too.