41554 blogs · [ { "id": "01a087c2-61ea-7373-9e16-3badeb159798", "title": "Visualizing all books of the world in ISBN-Space", "url": "https://phiresky.github.io/blog/2025/visualizing-all-books-in-isbn-space", "published_at": "2025-01-31T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3badea856209", "title": "Using PostgreSQL production query planner statistics to fill a mock database", "url": "https://phiresky.github.io/blog/2024/mock-data-from-postgres-stats", "published_at": "2024-11-03T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3badea7fd06f", "title": "Improving Lemmy (PostgreSQL) Performance", "url": "https://phiresky.github.io/blog/2023/improving-lemmy-performance", "published_at": "2023-08-27T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade80c0f37", "title": "sqlite-zstd: Transparent dictionary-based row-level compression for SQLite", "url": "https://phiresky.github.io/blog/2022/sqlite-zstd", "published_at": "2022-07-31T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3badeb95443e", "title": "Knowledge dump about LED Strips for indoor lighting", "url": "https://phiresky.github.io/blog/2021/led-strips-for-indoor-lighting", "published_at": "2021-10-14T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3badec46669f", "title": "Data Export Day", "url": "https://phiresky.github.io/blog/2021/data-export-day", "published_at": "2021-10-05T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3baded21c425", "title": "Hosting SQLite databases on Github Pages", "url": "https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages", "published_at": "2021-04-17T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3badeb726022", "title": "10 underused features of modern Python [incomplete]", "url": "https://phiresky.github.io/blog/2021/python-features", "published_at": "2021-02-15T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade75dbb74", "title": "An overview of typed SQL libraries for TypeScript", "url": "https://phiresky.github.io/blog/2020/sql-libs-for-typescript", "published_at": "2020-06-27T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade72405b3", "title": "SQLite performance tuning", "url": "https://phiresky.github.io/blog/2020/sqlite-performance-tuning", "published_at": "2020-06-26T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade9cf6d55", "title": "Automatic citation extraction from URLs", "url": "https://phiresky.github.io/blog/2019/pandoc-url2cite", "published_at": "2019-12-13T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade9ba6e83", "title": "rga: ripgrep, but also search in PDFs, E-Books, Office documents, zip, tar.gz, etc.", "url": "https://phiresky.github.io/blog/2019/rga--ripgrep-for-zip-targz-docx-odt-epub-jpg", "published_at": "2019-06-16T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade8b9423b", "title": "Creating a blog", "url": "https://phiresky.github.io/blog/2019/about", "published_at": "2019-06-14T00:00:00+00:00" }, { "id": "01a087c2-61ea-7373-9e16-3bade972710e", "title": "Pandoc Test Suite", "url": "https://phiresky.github.io/blog/2019/writer", "published_at": "2006-07-16T22:00:00+00:00" } ] posts Claim your blog

Back to phiresky.github.io

Blog · corpus.blog/blogs/phiresky.github.io/posts

phiresky.github.io

phiresky.github.io

2025

Visualizing all books of the world in ISBN-Space original ↗

31 Jan 2025

2024

Using PostgreSQL production query planner statistics to fill a mock database original ↗

3 Nov 2024

2023

Improving Lemmy (PostgreSQL) Performance original ↗

27 Aug 2023

2022

sqlite-zstd: Transparent dictionary-based row-level compression for SQLite original ↗

31 Jul 2022

2021

Knowledge dump about LED Strips for indoor lighting original ↗

14 Oct 2021

Data Export Day original ↗

5 Oct 2021

Hosting SQLite databases on Github Pages original ↗

17 Apr 2021

10 underused features of modern Python [incomplete]original ↗

15 Feb 2021

2020

An overview of typed SQL libraries for TypeScript original ↗

27 Jun 2020

SQLite performance tuning original ↗

26 Jun 2020

2019

Automatic citation extraction from URLs original ↗

13 Dec 2019

rga: ripgrep, but also search in PDFs, E-Books, Office documents, zip, tar.gz, etc.original ↗

16 Jun 2019

Creating a blog original ↗

14 Jun 2019

2006

Pandoc Test Suite original ↗

16 Jul 2006