In this talk, Andrew Hyatt shows how to use SQLite to store and retrieve information using the triples package. Afterwards, he wil handle questions over BigBlueButton. The following image shows where the talk is in the schedule for Sat 2022-12-03. Solid lines show talks with Q&A via BigBlueButton. Dashed lines show talks with Q&A via IRC or Etherpad.
Schedule for Saturday Saturday 9:00- 9:05 Saturday opening remarks sat-open 9:05- 9:25 Emacs journalism (or everything's a nail if you hit it with Emacs) journalism 9:45- 9:55 Back to school with Emacs school 10:05-10:15 How to incorporate handwritten notes into Emacs Orgmode handwritten 10:45-11:05 Writing and organizing literature notes for scientific writing science 11:25-11:35 The Emacs Buddy initiative buddy 1:00- 1:20 Attending and organizing Emacs meetups meetups 1:40- 1:55 Linking personal info with Hyperbole implicit buttons buttons 2:15- 2:40 Real estate and Org table formulas realestate 3:00- 3:25 Health data journaling and visualization with Org Mode and gnuplot health 3:45- 4:05 Edit live Jupyter notebook cells with Emacs jupyter 4:50- 4:55 Saturday closing remarks sat-close 10:00-10:15 Tree-sitter beyond syntax highlighting treesitter 10:25-10:45 lsp-bridge: a smooth-as-butter asynchronous LSP client lspbridge 10:55-11:15 asm-blox: a game based on WebAssembly that no one asked for asmblox 11:25-11:35 Emacs should become a Wayland compositor wayland 1:00- 1:25 Using SQLite as a data source: a framework and an example sqlite 1:50- 2:30 Revisiting the anatomy of Emacs mail user agents mail 2:50- 3:10 Maintaining the Maintainers: Attribution as an Economic Model for Open Source maint 3:35- 3:40 Bidirectional links with eev eev 4:05- 4:35 Haskell code exploration with Emacs haskell 9 AM 10 AM 11 AM 12 PM 1 PM 2 PM 3 PM 4 PM 5 PM
[[!toc ]] Format: 22-min talk followed by live Q&A (done) Etherpad: Discuss on IRC: [#emacsconf-dev](https://chat.emacsconf.org/?join=emacsconf,emacsconf-dev) Status: TO_INDEX_QA
Times in different timezones:
Saturday, Dec 3 2022, ~1:00 PM - 1:25 PM EST (US/Eastern)
which is the same as:
Saturday, Dec 3 2022, ~12:00 PM - 12:25 PM CST (US/Central)
Saturday, Dec 3 2022, ~11:00 AM - 11:25 AM MST (US/Mountain)
Saturday, Dec 3 2022, ~10:00 AM - 10:25 AM PST (US/Pacific)
Saturday, Dec 3 2022, ~6:00 PM - 6:25 PM UTC
Saturday, Dec 3 2022, ~7:00 PM - 7:25 PM CET (Europe/Paris)
Saturday, Dec 3 2022, ~8:00 PM - 8:25 PM EET (Europe/Athens)
Saturday, Dec 3 2022, ~11:30 PM - 11:55 PM IST (Asia/Kolkata)
Sunday, Dec 4 2022, ~2:00 AM - 2:25 AM +08 (Asia/Singapore)
Sunday, Dec 4 2022, ~3:00 AM - 3:25 AM JST (Asia/Tokyo)
Find out how to watch and participate
# Talk [[!template id="vid" vidid="sqlite-mainVideo" src="https://media.emacsconf.org/2022/emacsconf-2022-sqlite--using-sqlite-as-a-data-source-a-framework-and-an-example--andrew-hyatt--main.webm" poster="${poster}" captions="""""" size="69M" duration="21:24" other_resources="""[Download --main.webm (69MB)](https://media.emacsconf.org/2022/emacsconf-2022-sqlite--using-sqlite-as-a-data-source-a-framework-and-an-example--andrew-hyatt--main.webm) [Download --main.vtt](https://media.emacsconf.org/2022/emacsconf-2022-sqlite--using-sqlite-as-a-data-source-a-framework-and-an-example--andrew-hyatt--main.vtt) [Download --main--chapters.vtt](https://media.emacsconf.org/2022/emacsconf-2022-sqlite--using-sqlite-as-a-data-source-a-framework-and-an-example--andrew-hyatt--main--chapters.vtt) [View transcript](https://emacsconf.org/2022/talks/sqlite#sqlite-mainVideo-transcript) [View on Toobnix](https://toobnix.org/w/a26FMpRuCKmn4YZU4ysdrd) """]] [[!template id="chapters" vidid="sqlite-mainVideo" data=""" 00:00:00.000 Introduction 00:56.220 Why SQLite 02:29.870 The triples package 04:50.209 Exercise: Emacs bookmarks 07:40.740 Creating bookmarks 09:31.366 Retrieving bookmarks 11:10.034 Backlinks 13:59.380 Extensible entities 15:57.008 EKG package 18:12.772 The code 19:43.780 Renaming tags 20:52.147 Conclusion """]] # Q&A [[!template id="vid" vidid="sqlite-qanda" src="https://media.emacsconf.org/2022/emacsconf-2022-sqlite--using-sqlite-as-a-data-source-a-framework-and-an-example--andrew-hyatt--answers.webm" poster="${poster}" ${captions} size="44M" duration="21:24" other_resources=""""""]] # Description