VirtualTam's bookmarks

21. 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
22. Ibis - The portable Python dataframe library 2024-08-29

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

    [ permalink ]

    • ibis-project
23. Webamp - Winamp 2 in your browser 2024-07-29

    tags: audio, database/sqlite, programming/javascript

    [ permalink ]

    • captbaritone/webamp
    • Winamp Skins Museum
    • The Winamp Skin Museum is powered by an sqlite3 database
24. Litestream - Streaming SQLite Replication 2024-06-20

    tags: backup, database/sqlite

    [ permalink ]

    • benbjohnson/litestream
25. 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
26. 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
27. Cloud Study Network - Free Certifications 2024-04-03

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

    [ permalink ]
28. 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
29. 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
30. 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 ]
31. 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
32. 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
33. data load tool (dlt) - 2024-02-26

    tags: data-mining, database, programming/python

    [ permalink ]

    • dlt-hub/dlt
    • dlt documentation
34. 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
35. What is the "N+1 selects problem" in ORM (Object-Relational Mapping)? 2024-02-12

    tags: database, performance, programming/sql

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

    tags: programming/go, security, static-analysis

    [ permalink ]

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

    tags: music, text, text/unicode

    [ permalink ]

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

    tags: database/sqlite, image/exif

    [ permalink ]

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

    tags: database, database/sharding, game/mmo

    [ permalink ]

    • Startup Lessons Learned: Sharding for Startups