VirtualTam's bookmarks

21. PostgreSQL Anonymizer 2024-05-23

    tags: database/postgresql, privacy/gdpr, programming/rust, security/anonymization

    [ permalink ]

    • dalibo/postgresql_anonymizer
    • Introducing PostgreSQL Anonymizer
    • 8 Anonymization Strategies with PostgreSQL
    • Data anonymization with Postgres
22. All you need is Wide Events, not "Metrics, Logs and Traces" 2024-04-19

    tags: database, distributed-system, observability, observability/logging, observability/metrics, observability/tracing

    [ permalink ]

    • Scuba: Diving into Data at Facebook - International Conference on Very Large Data Bases (VLDB) (PDF, Talk)
    • HN discussion
    • Axiom - Stop sampling, observe every event
      • Adaptive _time compression — A database hacker story
    • Eventrelay - An event streaming/storage system for the rest of us
    • Honeycomb - Identify Outliers
    • Rill - Fast operational dashboards that your team will actually use
    • Strangeloop 17 - Why We Built Our Own Distributed Column Store by Sam Stokes
23. Cloud Study Network - Free Certifications 2024-04-03

    tags: cloud-computing, course, database, knowledge, learn, network

    [ permalink ]
24. How to use PostgreSQL for (military) geoanalytics tasks 2024-03-31

    tags: country/russia, country/ukraine, database/postgresql, geography/gis, map, nasa/earthdata, war

    [ permalink ]

    • From Map to Reality: Using PostGIS in Warfare (PDF)
    • NASA Earthdata - Full and open access to NASA’s collection of Earth science data for understanding and protecting our home planet
    • Visible Infrared Imaging Radiometer Suite (VIIRS) Active Fire detection
    • PostgreSQL - GiST - Generalized Search Tree
    • PostgreSQL - SP-GiST - Space-partitioned GiST
    • H3 - Hexagonal hierarchical geospatial indexing system
    • zachasme/h3-pg - PostgreSQL bindings for H3
25. Fly.io - JIT Wireguard 2024-03-31

    tags: database/sqlite, network/http, network/udp, network/vpn/wireguard, programming/go

    [ permalink ]

    What if, instead of pushing [user] configs to gateways, we had the gateways pull them from our API on demand?

    • Linux Kernel - Introduction to Netlink
    • tqbf/wg_init.go - Wireguard initiator-responder identity example
26. dev-sec/ansible-collection-hardening - Hardening for Linux, SSH, Apache HTTPD, Nginx, MySQL 2024-03-31

    tags: configuration-management/ansible, database/mysql, linux, network/http-server/apache-httpd, network/http-server/nginx, network/ssh

    [ permalink ]
27. LWN - The race to replace Redis 2024-03-30

    tags: database/nosql, database/redis, open-source/fork, programming/c, programming/c#

    [ permalink ]

    • Redis Adopts Dual Source-Available Licensing
    • valkey-io/valkey
    • redict/redict
    • microsoft/garnet
28. Atlas - Manage your database schema as code 2024-03-07

    tags: configuration-management/hcl, continuous-integration, database, database/migration, programming/go

    [ permalink ]

    • ariga/atlas
    • Getting Started
    • HCL Schema
    • GitHub Actions
29. data load tool (dlt) - 2024-02-26

    tags: data-mining, database, programming/python

    [ permalink ]

    • dlt-hub/dlt
    • dlt documentation
30. The One Billion Row Challenge 2024-02-22

    tags: concurrency, database, jvm, performance/benchmark, performance/profiling, programming/java

    [ permalink ]

    • gunnarmorling/1brc
    • The Billion Row Challenge (1BRC) - Step-by-step from 71s to 1.7s
    • The One Billion Row Challenge in Go: from 1m45s to 4s in nine solutions
    • One Billion Rows Challenge in Golang
31. What is the "N+1 selects problem" in ORM (Object-Relational Mapping)? 2024-02-12

    tags: database, performance, programming/sql

    [ permalink ]
32. Vulnerability Management for Go 2024-01-15

    tags: programming/go, security, static-analysis

    [ permalink ]

    • Go Vulnerability Database (Go Blog)
    • Go Vulnerability Database
    • govulncheck command
33. 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
34. Horrible edge cases to consider when dealing with music 2023-11-15

    tags: music, text, text/unicode

    [ permalink ]

    • MusicBrainz Database / Schema
35. Exploring EXIF 2023-09-08

    tags: database/sqlite, image/exif

    [ permalink ]

    • mattiasw/ExifReader
    • ExifTool
36. Database “sharding” came from Ultima Online? 2023-07-22

    tags: database, database/sharding, game/mmo

    [ permalink ]

    • Startup Lessons Learned: Sharding for Startups
37. Fly.io - Reliability: It’s Not Great 2023-07-22

    tags: database/postgresql, distributed-system, hashicorp/consul, hashicorp/nomad, hashicorp/vault, linux/container/docker

    [ permalink ]
38. 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
39. jackc/pgx - PostgreSQL Driver and Toolkit 2023-07-04

    tags: concurrency, database/postgresql, programming/go

    [ permalink ]

    • Getting started with pgx
    • https://donchev.is/post/working-with-postgresql-in-go-using-pgx/
    • jackc/pgx/v5/pgtype - Map between all common base types directly between Go and PostgreSQL
    • jackc/pgx/v5/pgxpool - Concurrency-safe connection pool for pgx
    • scany/v2/pgxscan - Scan data into Go structs and other composite types
    • Bulk INSERT in Postgres in GO using pgx
    • Postgres table batch updates using golang pgxpool not reflected in database
    • pgx.Conn can see uncommitted changes made from a pgx.Tx - TL;DR use pgxpool for concurrency-safe transactions
    • Not clear if caller is required to close in case of QueryRow or if QueryRow properly closes in case of error
40. Grafana SQLite Migration to PostgreSQL 2023-06-25

    tags: database/migration, database/postgresql, database/sqlite, observability/grafana

    [ permalink ]

    • Migrating Grafana’s database from sqlite to postgres
    • pgloader
    • Configure Grafana - Database