diff -r 1204cefcfd28 -r 8a6b4b2f68cb draft/a-lispy-database.org --- a/draft/a-lispy-database.org Sat Jun 08 00:21:48 2024 -0400 +++ b/draft/a-lispy-database.org Sun Jun 16 01:14:25 2024 -0400 @@ -6,6 +6,9 @@ reliable [[https://en.wikipedia.org/wiki/Category:Database_management_systems][DBMS]]. It's something that I've worked towards in Rust, and now in Common Lisp, but haven't gotten to a production-ready state. * SQL +[[cdn:media/img/sql-architecture.jpg]] + + The first, and often /only/ choice for this need in companies of today is a SQL RDBMS. @@ -22,12 +25,27 @@ My answer is simply - just because SQL is good enough, doesn't mean it's always the best choice. It is designed for Table-oriented data and that is where it should remain according to the CC. + * Prolog + +#+ATTR_HTML: :width 50% +[[cdn:media/img/wam.webp]] + * Key-Value Stores ** RocksDB +[[cdn:media/img/rocksdb.png]] ** Blobs + +#+ATTR_HTML: :width 50% +[[cdn:media/img/blob.jpg]] + * Objects + +https://courses.cs.northwestern.edu/325/readings/clos.html + - [[https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping][ORM]] The ORM maps the object system of your lang to SQL tables, columns and rows and provides an API for you to manipulate the database in a more idiomatic way. + +[[cdn:media/img/orm.png]]