Zalgorithm

Posts

Obsidian to Hugo Script

Copy a markdown file from Obsidian to Hugo.

Create and populate an SQLite database with Python

Create an SQLite database, and populate it from a JSON file.

Combining full text and semantic search

Possible ways of combining full text and semantic search.

Create a persistent Chroma collection

Embed the descriptions of tmux keybindings into a Chroma collection.

Create and populate a persistent FTS5 table

SQLite virtual tables aren’t necessarily temporary.

Database indexes at a high level

A database index is like a book’s index.

Fts5 indexes

An FTS5 index is a database structure that maps tokens produced from the indexed columns of an FTS5 virtual table to their occurrences in that table.

FTS5 search with English stemming and and matching

A demonstration of the use of the SQLite porter tokenizer in conjunction with the full-text-search AND operator.

Query a Chroma collection

Try getting tmux key bindings with semantic search.

Searching a Database With Fts5 Queries and English Stemming

Search with FTS5 query syntax.

The Porter Stemming Algorithm

The Porter stemming algorithm is a process for removing the commoner morphological and inflexional endings from words in English. Its main use is a part of a term normalization process that is usually done when setting up Informational Retrieval systems.

Hello Fennel!

First steps with Fennel.

Create Fts5 Virtual Table in the Sqlite Cli

FTS5 is an SQLite virtual table module that provides full-text search functionality to database applications.

Searching a database with SQL LIKE queries

Confirming I know how to query an SQLite database with Python.

SQLite FTS tokenizers

Testing tokenizers in the SQLite CLI.

SQLite virtual tables

(Briefly) what is an SQLite virtual table?

The Obsidian to Hugo Script Now Transfers Tags and Created_at Frontmatter

Small wins.

What Deserves a Note?

It’s goingg to be hit or miss for a while.

Hello World

This is a test, this is only a test…

View Unstaged and Staged Git Modifications

Git diff to the rescue!

Print a Mandelbrot set to the console

A function to generate a Mandelbrot set and print it to the console.