here you goThings I’ve made, read and saved — shared here.

Archive

9,698 entries: 94 from X, 8,929 from Pinboard, saved 1998 to 2026.

Browse by tag, site, author, folder or language

Tags

Sites

Authors

Folders

Languages

Showing 4,801–4,850 of 9,698

2018

Literate Programming

Let us change our traditional attitude to the construction of programs: Instead of imagining that our main task is to instruct a computer what to do, let us concentrate rather on explaining to humans what we want the computer to do. -- Donald E. Knuth, Literate Programming, 1984

Examples of literate programming

  • ulix a literate, teaching operating system.
  • knitr Elegant, flexible and fast dynamic report generation with R
  • stich -- is a small python library for writing reproducible reports in markdown. It's heavily inspired by (read: a python clone of) knitr and RMarkdown.
  • ferret.org the entire source of Ferret programming language as an emacs org file.

Tools

Literate -- A modern literate programming system written in D

brew tap zyedidia/literate
brew install --HEAD zyedidia/literate/literate

In addition to those of CWEB:

  • Markdown based -- very easy to read and write Literate source.
  • Generates readable and commented code in the target language (the generated code is usable by others)
  • Reports syntax errors back from the compiler to the right line in the literate source
  • Supports any language including syntax highlighting and pretty printing in HTML
  • Compatible with Vim (literate.vim)
  • Highly customizable (you can add your own HTML or CSS)
  • Runs fast -- wc.lit compiled for me in 7ms for both code and HTML output
  • Supports TeX equations with $ notation.

Inspired from CWEB:

  • Automatically generates hyperlinks between code sections
  • Formatted output similar to CWEB

I wrote lua4py page using Literate.


See also the Nimib project by Nim programmers.

notes#literate-programming

Build Systems

Writing

Build systems

Cloud

Earthly - Make Builds Super Simple; HN; See example use - Improving Testing & Continuous Integration in Phoenix - Phoenix Blog - Jan 2021.

notes

Sqlite

I wrote an article about SQLite for DeveloperIQ magazine published in Jan 2005 -- Move Over MySQL, SQLite is here!!


Query Parquet files in SQLite | Colin Dellow

Importing csv into sqlite: see this page for extended usage

sqlite> .import myfile.csv mytable

SQLite as a document database using Generated Columns and The JSON1 Extension

Tutorials

SQLite Date & Time - How To Handle Date and Time in SQLite (The site sqlitetutorial.net seems to have handy reference for common tasks with sqlite.)

SQLite as a Collaborative & Multiplayer Application File Format - YouTube

Optimizing SQLite for servers

60K RPS out of sqlite on a $5 VPS

Django

Tools around SQLite

sqlpkg

The list of packages are here - https://sqlpkg.org.

#TODO SQLPkg is written in go. install it manually.

Sqlite-utils

can do things like:

  • Running queries and returning JSON, CSV, markdown table
  • Inserting JSON data: `echo | sqlite-utils insert dogs.db dogs -
  • Inserting CSV data: sqlite-utils insert dogs.db dogs docs.csv --csv
  • Insert-replacing data.

sqlite-http

Introducing sqlite-http: A SQLite extension for making HTTP requests / Alex Garcia | Observable

Sqlean

nalgeon/sqlean: The ultimate set of SQLite extensions

  • crypto: hash functions
  • define: user-defined functions and dynamic sql
  • fileio: read and write files
  • fuzzy: fuzzy string matching and phonetics
  • ipaddr: IP address manipulation
  • json1: JSON functions
  • math: math functions
  • regexp: regular expressions
  • stats: math statistics
  • text: string functions
  • unicode: Unicode support
  • uuid: Universally Unique IDentifiers
  • vsv: CSV files as virtual tables

Pocketbase

Pocketbase is an open source backend that can be used to build API applications.

  • single binary download
  • written in Go
  • embedded database (SQLite)
  • built in user and files managment
  • built in admin UI
  • simple REST UI

Sqlsync

orbitinghail/sqlsync SQLSync is a collaborative offline-first wrapper around SQLite. It is designed to synchronize web application state between users, devices, and the edge.

Example use cases

  • A web app with a structured file oriented data model like Figma. Each file could be a SQLSync database, enabling real-time local first collaboration and presence
  • Running SQLSync on the edge with high tolerance for unreliable network conditions
  • Enabling optimistic mutations on SQLite read replicas

Soul

soul | 🕉 A SQLite REST and realtime server, written in node.js; Run soul -d sqlite.db -p 8000 and it’ll start a REST API on http://localhost:8000 and a Websocket server on ws://localhost:8000


See also: duckdb, til/sqlite-writable_schema, code/sqlite-csv-loading-using-virtual-table-extension

notes#database#sqlite