Using sqlite3 as a notekeeping document graph

• bibliothecula

  2 150 1.9 Python

  Discontinued document organizer with tags and full-text-search, in a simple and clean sqlite3 schema

• pinotes

  3 38 0.0 Go

  Self hosted notes for Raspberry Pi

I run a self hosted notes application[1] on raspberry pi at home. I have been thinking about moving from .md files to sql. Both seem to have their own advantage/disadvantages. With SQLLite, I get easy search, tagging while with .md files I get easy editing along with viewing of notes.

[1]: https://github.com/quaintdev/pinotes

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• til

  20 965 9.6 HTML

  Today I Learned (by simonw)

I suggest having both.

My TILs site runs uses a GitHub repository where the notes live in markdown: https://github.com/simonw/til

Plus a build script running in a GitHub actions workflow that compiles the notes into a SQLite file using my markdown-to-sqlite tool and publishes the resulting SQLite file using Datasette to https://til.simonwillison.net - which gives me search and an Atom feed and suchlike.

The site has custom templates so it Durant look like regular Datasette, but you can run custom queries against it at https://til.simonwillison.net/tils

• TiddlyWiki

  273 7,704 9.6 JavaScript

  A self-contained JavaScript wiki for the browser, Node.js, AWS Lambda etc.

This looks like a proprietary clone of TiddlyWiki[1] with a slower, clunkier interface.

[1] https://tiddlywiki.com/

• org-roam-server

  7 634 0.0 HTML

  A Web Application to Visualize the Org-Roam Database

  

• datasette.io

  6 81 8.2 HTML

  The official project website for Datasette

I've been exploring this technique more over the past year and I really like it - https://datasette.io (code at https://github.com/simonw/datasette.io ) is a more recent and much more complicated example.

Extracting links from markdown and using them to populate some additional columns or tables at build time would be pretty straight forward.

• datasette

  187 8,881 9.2 Python

  An open source multi-tool for exploring and publishing data

I've been exploring this technique more over the past year and I really like it - https://datasette.io (code at https://github.com/simonw/datasette.io ) is a more recent and much more complicated example.

Extracting links from markdown and using them to populate some additional columns or tables at build time would be pretty straight forward.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project