# HG changeset patch # User Richard Westhaver # Date 1718514865 14400 # Node ID 8a6b4b2f68cbc2087cb0e8aaa95d3e57ea2f1457 # Parent 1204cefcfd28921a0eb43feb688cffbc57639afb clean 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]] diff -r 1204cefcfd28 -r 8a6b4b2f68cb readme.org --- a/readme.org Sat Jun 08 00:21:48 2024 -0400 +++ b/readme.org Sun Jun 16 01:14:25 2024 -0400 @@ -3,28 +3,28 @@ #+SETUPFILE: ../clean.theme * posts * drafts -** DRAFT A Bit of RISC +** DRAFT [[file:draft/a-bit-of-risc.org][A Bit of RISC]] :LOGBOOK: - State "DRAFT" from [2024-04-17 Wed 18:51] :END: -** OUTLINE A Lispy Database +** OUTLINE [[file:draft/a-lispy-database.org][A Lispy Database]] :LOGBOOK: - State "OUTLINE" from "DRAFT" [2024-04-17 Wed 18:53] :END: -** DRAFT Shared Library Skeletons +** DRAFT [[file:draft/dylib-skel.org][Shared Library Skeletons]] :LOGBOOK: - State "DRAFT" from [2024-04-17 Wed 18:53] :END: -** RESEARCH On Lisp Ecosystems +** RESEARCH [[file:draft/on-lisp-ecosystems.org][On Lisp Ecosystems]] :LOGBOOK: - State "DRAFT" from [2024-04-17 Wed 18:53] - State "RESEARCH" from "DRAFT" [2024-04-17 Wed 18:53] :END: -** DRAFT Outlines +** DRAFT [[file:draft/outlines.org][Outlines]] :LOGBOOK: - State "DRAFT" from [2024-04-17 Wed 18:53] :END: