From 7bcac292227ee37b9efc3d65699a3601700770f1 Mon Sep 17 00:00:00 2001 From: Sacha Chua Date: Fri, 10 Mar 2023 14:59:44 -0500 Subject: chapter markers for sqlite --- 2022/info/sqlite-before.md | 33 ++++++++++++++++++++++++++++++++- 2022/talks/sqlite.md | 7 ------- 2 files changed, 32 insertions(+), 8 deletions(-) diff --git a/2022/info/sqlite-before.md b/2022/info/sqlite-before.md index 4c4816f2..e0ada947 100644 --- a/2022/info/sqlite-before.md +++ b/2022/info/sqlite-before.md @@ -1,6 +1,20 @@ 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_CAPTION_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="chapters" vidid="sqlite-mainVideo" data=""" @@ -21,6 +35,23 @@ In this talk, Andrew Hyatt shows how to use SQLite to store and retrieve informa # Q&A -
Listen to just the audio:
+
[[!template id="chapters" vidid="sqlite-qanda" data=""" +00:29.040 Is this built into Emacs? Multiple schemas, multiple databases? +01:22.756 What about collaborative editing with this? +02:22.913 What about using this on multiple computers? How do you synchronize your data? +03:16.640 Are you planning to further develop EKG? +04:45.303 Is it then possible to combine the triples DB with some custom tables in the same SQLite file? +06:01.734 What are your thoughts on adding a timestamp attribute to triples so that the database becomes append-only and by default you return the latest fact for a subject-object pair? +08:37.040 With EKG what about views like org roam node mind map view? Or org mode virtual view for integration with other org packages? +09:46.220 Can ordinary lisp data types (lists, symbols, etc) be stored in the database? +13:41.041 Beyond note-taking, what kind of packages do you think would benefit from triples library? +15:03.200 Are you trying to create a PIM with EKG? What information do you primarily want to manage? +17:10.021 What about using other databases programs: PostgreSQL, MongoDB, etc.? +17:55.899 What is your preferred reference to understand triples/graph dbs? (e.g. think better about schema design) +18:49.200 Will it slow down with the growth of a database? +20:39.728 What are your thoughts on allowing for a true graph DB backend? +22:58.960 Challenges with recording + +"""]]
Listen to just the audio:
# Description \ No newline at end of file diff --git a/2022/talks/sqlite.md b/2022/talks/sqlite.md index 8982e91b..89146b51 100644 --- a/2022/talks/sqlite.md +++ b/2022/talks/sqlite.md @@ -11,13 +11,6 @@ Andrew Hyatt (he/him) [[!inline pages="internal(2022/info/sqlite-before)" raw="yes"]] -[[!template id="help" -volunteer="" -summary="Q&A could be indexed with chapter markers" -tags="help_with_chapter_markers" -message="""The Q&A session for this talk does not have chapter markers yet. -Would you like to help? See [[help_with_chapter_markers]] for more details. You can use the vidid="sqlite-qanda" if adding the markers to this wiki page, or e-mail your chapter notes to ."""]] - Emacs can now be built with SQLite, giving native support for reading and writing to a database. With this, we can start seriously -- cgit v1.2.3