[[!template id="chapters" vidid="sqlite-mainVideo" data=""" 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 """]]

[[!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 """]]