VirtualTam's bookmarks

1. dqlite - Distributed SQLite - Embeddable and replicated SQL database engine with high availability and automatic failover

   2025-06-20
   database/sqlite distributed-system programming/c programming/sql

   Permalink
2. Why would I use DuckDB for that?

   2025-06-15
   database/duckdb database/postgresql programming/python programming/sql

   Permalink
   • Analyzing open data with DuckDB
3. Time to Better Know The Time in PostgreSQL

   2025-05-16
   database/postgresql programming/sql time

   Permalink
4. Time Series Benchmark Suite - A tool for comparing and evaluating databases for time series data

   2025-03-30
   database database/postgresql observability/time-series observability/time-series/influxdb performance/benchmark programming/go programming/sql

   Permalink
   • TSBS Documentation
5. sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code

   2024-11-24
   database/mysql database/postgresql database/sqlite programming/python programming/sql static-analysis/lint

   Permalink
   • Configuration
   • Rules Reference
6. sqruff - Fast SQL formatter/linter

   2024-11-24
   programming/rust programming/sql static-analysis/lint

   Permalink
   • Translating sqlfluff to Rust
7. pg_duckdb - A Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features

   2024-11-20
   database/duckdb database/postgresql programming/apache-parquet programming/c++ programming/json programming/python programming/sql

   Permalink
   • DuckDB - PostgreSQL Extension
   • Querying Postgres Tables Directly from DuckDB
8. What I Wish Someone Told Me About Postgres

   2024-11-19
   command-line database/postgresql programming/csv programming/json programming/sql

   Permalink
9. Is pg_dump a Backup Tool?

   2024-11-03
   backup database/postgresql programming/sql

   Permalink
   • Why pg_dump Is Amazing
   • EnterpriseDB/barman - Backup and Recovery Manager for PostgreSQL
   • pgbackrest/pgbackrest - Reliable PostgreSQL Backup & Restore
10. Supercharge the One Person Framework with SQLite: Rails World 2024

    2024-10-18
    database/sqlite framework/ruby-on-rails programming/ruby programming/sql

    Permalink
    • How (and why) to run SQLite in production: RubyConf Taiwan 2023
    • Litestream - Streaming SQLite Replication
11. Ibis - The portable Python dataframe library

    2024-08-29
    data database programming/python programming/sql

    Permalink
    • ibis-project
12. GPT From Scratch - GPT in 60 Lines of NumPy

    2024-02-28
    neural-network neural-network/large-language-model programming/python programming/python/numpy programming/sql text

    Permalink
    • Happy New Year: GPT in 500 lines of SQL
13. What is the "N+1 selects problem" in ORM (Object-Relational Mapping)?

    2024-02-12
    database performance programming/sql

    Permalink
14. postgres_lsp - Language Server for PostgreSQL

    2023-12-08
    database/postgresql programming-language programming/sql

    Permalink
    • Postgres Language Server: implementing the Parser
    • Hacker News announcement thread
15. Create an advanced search engine with PostgreSQL

    2023-07-14
    database/postgresql programming/sql search-engine text

    Permalink
    • Postgres Full Text Search vs the rest (MeiliSearch, OpenSearch/Elasticsearch, SQlite FTS, Typesense)
    • Optimizing Full Text Search with Postgres tsvector Columns and Triggers
    • Word separators for Postgres full text search with Rails
    • Using PostgreSQL Full Text Search With Golang
    • PostgreSQL: Full Text Search
    • PostgreSQL: Preferred Index Types for Text Search
16. Herding elephants: Lessons learned from sharding Postgres at Notion

    2022-08-28
    database/postgresql distributed-system performance programming/sql shard

    Permalink
17. PostgresSQL ltree module - a data type for representing labels of data stored in a hierarchical tree-like structure

    2022-04-07
    data-structure/tree database/postgresql graphviz programming/go

    Permalink
    • https://coderwall.com/p/whf3-a/hierarchical-data-in-postgres
    • https://stackoverflow.com/questions/tagged/ltree
    • https://github.com/jinagamvasubabu/ltreevisualizer
    • https://patshaughnessy.net/2017/12/11/trying-to-represent-a-tree-structure-using-postgres
    • https://patshaughnessy.net/2017/12/12/installing-the-postgres-ltree-extension
    • https://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree
    • https://patshaughnessy.net/2017/12/14/manipulating-trees-using-sql-and-the-postgres-ltree-extension
18. Lessons Learned From 5 Years of Scaling PostgreSQL

    2022-02-16
    database/postgresql performance programming/sql

    Permalink
19. Writing a SQL database from scratch in Go: 1. SELECT, INSERT, CREATE and a REPL | notes.eatonphil.com

    2021-08-22
    database programming/go programming/library programming/sql

    Permalink
    1. SELECT, INSERT, CREATE and a REPL
    2. Binary expressions and WHERE filters
    3. Indexes
    4. A database/sql driver
    5. LIMIT and OFFSET
20. golang-migrate/migrate: Database migrations. CLI and Golang library.

    2021-05-11
    command-line database database/migration programming/go programming/sql

    Permalink