VirtualTam's bookmarks

1. Is pg_dump a Backup Tool? 2024-11-03

   tags: 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
2. Supercharge the One Person Framework with SQLite: Rails World 2024 2024-10-18

   tags: 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
3. Ibis - The portable Python dataframe library 2024-08-29

   tags: data, database, programming/python, programming/sql

   [ permalink ]

   • ibis-project
4. GPT From Scratch - GPT in 60 Lines of NumPy 2024-02-28

   tags: 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
5. What is the "N+1 selects problem" in ORM (Object-Relational Mapping)? 2024-02-12

   tags: database, performance, programming/sql

   [ permalink ]
6. postgres_lsp - Language Server for PostgreSQL 2023-12-08

   tags: database/postgresql, programming-language, programming/sql

   [ permalink ]

   • Postgres Language Server: implementing the Parser
   • Hacker News announcement thread
7. Create an advanced search engine with PostgreSQL 2023-07-14

   tags: 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
8. Herding elephants: Lessons learned from sharding Postgres at Notion 2022-08-28

   tags: database/postgresql, distributed-system, performance, programming/sql, shard

   [ permalink ]
9. PostgresSQL ltree module - a data type for representing labels of data stored in a hierarchical tree-like structure 2022-04-07

   tags: 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
10. Lessons Learned From 5 Years of Scaling PostgreSQL 2022-02-16

    tags: database/postgresql, performance, programming/sql

    [ permalink ]
11. Writing a SQL database from scratch in Go: 1. SELECT, INSERT, CREATE and a REPL | notes.eatonphil.com 2021-08-22

    tags: 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
12. golang-migrate/migrate: Database migrations. CLI and Golang library. 2021-05-11

    tags: command-line, database, database/migration, programming/go, programming/sql

    [ permalink ]
13. Presto | Distributed SQL Query Engine for Big Data 2021-01-07

    tags: business-intelligence, database, programming/api, programming/sql, statistics

    [ permalink ]

    • https://github.com/prestodb/presto
14. Percona Toolkit Documentation 2020-01-21

    tags: database, database/mysql, observability/logging, performance, programming/sql, query

    [ permalink ]

    • https://www.percona.com/blog/2018/09/13/analyzing-amazon-aurora-slow-logs-pt-query-digest/
    • https://www.jeffgeerling.com/blog/2018/analyzing-mysql-slow-query-log-pt-query-digest
15. How Postgres Makes Transactions Atomic — Brandur Leach 2019-10-18

    tags: database, database/postgresql, programming/sql

    [ permalink ]
16. The Schemaverse, a space-based strategy game implemented entirely within a PostgreSQL database 2019-10-18

    tags: astrology, database, database/postgresql, game, programming/sql, web

    [ permalink ]
17. Building and Testing a REST API in GoLang using Gorilla Mux and MySQL 2019-04-01

    tags: database, database/mysql, database/postgresql, network/http, programming/go, programming/sql, programming/testing

    [ permalink ]

    • https://github.com/kaihendry/GoApiTutorial
    • https://semaphoreci.com/community/tutorials/building-and-testing-a-rest-api-in-go-with-gorilla-mux-and-postgresql
    • https://www.youtube.com/watch?v=ynUUGWvqA4c
18. Sqitch - a database change management application 2019-03-13

    tags: database, database/migration, programming/perl, programming/sql

    [ permalink ]

    • https://github.com/sqitchers/sqitch
19. sql - Efficiently mapping one-to-many many-to-many database to struct in Golang - Stack Overflow 2019-02-13

    tags: database, programming/go, programming/sql

    [ permalink ]
20. python - Does SQLAlchemy have an equivalent of Django's get_or_create? - Stack Overflow 2019-01-20

    tags: database, programming/python, programming/sql

    [ permalink ]