The Curious Engineer

All blogs / Databases

phiresky's blog

phiresky.github.io/blog

Code, Craft, and Creativity

DatabasesPerformance / optimizationPythonSoftware / engineering practice

’10’15’20’25
Posts
15 from 16 Jul 2006 to 31 Jan 2025
Posting
now and then
Kind
personal blog
Feed
https://phiresky.github.io/blog/atom.xml

2025 2

  1. Visualizing all books of the world in ISBN-Space
  2. Click here to view the visualization in full screen (esp. on mobile)

2024 1

  1. Using PostgreSQL production query planner statistics to fill a mock database

2023 1

  1. Improving Lemmy (PostgreSQL) Performance

2022 1

  1. sqlite-zstd: Transparent dictionary-based row-level compression for SQLite

2021 4

  1. Knowledge dump about LED Strips for indoor lighting
  2. Data Export Day
  3. Hosting SQLite databases on Github Pages
  4. 10 underused features of modern Python [incomplete]

2020 2

  1. An overview of typed SQL libraries for TypeScript
  2. SQLite performance tuning

2019 3

  1. Automatic citation extraction from URLs
  2. rga: ripgrep, but also search in PDFs, E-Books, Office documents, zip, tar.gz, etc.
  3. Creating a blog

2006 1

  1. Pandoc Test Suite