changelog shortlog graph tags branches changeset file revisions annotate raw help

Mercurial > org > blog / draft/a-lispy-database.org

revision 22: 8a6b4b2f68cb
parent 21: 1204cefcfd28
child 28: 6d54ccb29de4
     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]]