1.1--- a/draft/a-lispy-database.org Sat Jun 08 00:21:48 2024 -0400
1.2+++ b/draft/a-lispy-database.org Sun Jun 16 01:14:25 2024 -0400
1.3@@ -6,6 +6,9 @@
1.4 reliable [[https://en.wikipedia.org/wiki/Category:Database_management_systems][DBMS]]. It's something that I've worked towards in Rust, and
1.5 now in Common Lisp, but haven't gotten to a production-ready state.
1.6 * SQL
1.7+[[cdn:media/img/sql-architecture.jpg]]
1.8+
1.9+
1.10 The first, and often /only/ choice for this need in companies of
1.11 today is a SQL RDBMS.
1.12
1.13@@ -22,12 +25,27 @@
1.14 My answer is simply - just because SQL is good enough, doesn't mean
1.15 it's always the best choice. It is designed for Table-oriented data
1.16 and that is where it should remain according to the CC.
1.17+
1.18 * Prolog
1.19+
1.20+#+ATTR_HTML: :width 50%
1.21+[[cdn:media/img/wam.webp]]
1.22+
1.23 * Key-Value Stores
1.24 ** RocksDB
1.25+[[cdn:media/img/rocksdb.png]]
1.26 ** Blobs
1.27+
1.28+#+ATTR_HTML: :width 50%
1.29+[[cdn:media/img/blob.jpg]]
1.30+
1.31 * Objects
1.32+
1.33+https://courses.cs.northwestern.edu/325/readings/clos.html
1.34+
1.35 - [[https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping][ORM]]
1.36 The ORM maps the object system of your lang to SQL tables, columns and
1.37 rows and provides an API for you to manipulate the database in a more
1.38 idiomatic way.
1.39+
1.40+[[cdn:media/img/orm.png]]