diff options
author | Sacha Chua <sacha@sachachua.com> | 2022-09-30 15:59:56 -0400 |
---|---|---|
committer | Sacha Chua <sacha@sachachua.com> | 2022-09-30 15:59:56 -0400 |
commit | 67f0f1c500091db27a69cb3a05fffd20c137d6e4 (patch) | |
tree | 22f66de124999dca2f6d965795c8135d747aa6eb /2022/talks/sqlite.md | |
parent | 0e44a3f1f7dbc27c92aa51aa50e898b163d56ac3 (diff) | |
download | emacsconf-wiki-67f0f1c500091db27a69cb3a05fffd20c137d6e4.tar.xz emacsconf-wiki-67f0f1c500091db27a69cb3a05fffd20c137d6e4.zip |
Add 2022 talks
Diffstat (limited to '2022/talks/sqlite.md')
-rw-r--r-- | 2022/talks/sqlite.md | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/2022/talks/sqlite.md b/2022/talks/sqlite.md new file mode 100644 index 00000000..b84db6c5 --- /dev/null +++ b/2022/talks/sqlite.md @@ -0,0 +1,39 @@ +[[!meta title="Using SQLite as a data source: a framework and an example"]] +[[!meta copyright="Copyright © 2022 Andrew Hyatt"]] +[[!inline pages="internal(2022/info/sqlite-nav)" raw="yes"]] + +<!-- Initially generated with emacsconf-generate-talk-page and then left alone for manual editing --> +<!-- You can manually edit this file to update the abstract, add links, etc. ---> + + +# Using SQLite as a data source: a framework and an example +Andrew Hyatt (he/him) + +[[!inline pages="internal(2022/info/sqlite-before)" raw="yes"]] + +Emacs can now be built with SQLite, giving native support for reading +and writing to a database. With this, we can start seriously +considering a SQLite-first approach: instead of storing data on the +filesystem, and using various ad-hoc solutions for metadata, we can +use SQLite to store and search our data. This is essentially a +tradeoff between the power and speed of SQLite and the universality of +the filesystem. If we accept that this approach is useful, then a +standard way to store information in database, may be useful and +promote package interoperability, just as our single filesystem does. +The triples packages is a RDF-like database for supplying such a +flexible system for storing and retrieving data from SQLite. A sample +application, ekg, a replacement for org-roam, is shown using this, and +the advantages of the triple design are explained. + +Note to conference organizers: As of writing this abstract, I +haven't put either package on <http://github.com/ahyatt> yet, I plan +on doing that before the end of September. If you'd like to be +notified, let me know. + + + +[[!inline pages="internal(2022/info/sqlite-after)" raw="yes"]] + +[[!inline pages="internal(2022/info/sqlite-nav)" raw="yes"]] + +[[!taglink CategoryEmacsLisp]] |