VirtualTam's bookmarks

21. 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
22. 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
23. psqlrc - PostgreSQL command-line client configuration

    2024-11-19
    command-line/pager database/postgresql

    Permalink
    • How To Customize the PostgreSQL Prompt with psqlrc on Ubuntu 14.04
    • datachomp//dotfiles - psqlrc
    • okbob/pspg - Pager specialized for tabular data
24. What I Wish Someone Told Me About Postgres

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

    Permalink
25. The Ultimate Guide to Django Performance: Best Practices for Scaling and Optimization - LoadForge Guides

    2024-11-18
    database framework/django network/http performance programming/python storage/cache

    Permalink
    • Django - Performance and optimization
    • Django - Database access optimization
    • Better living through optimized Django
26. 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
27. 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
28. Ibis - The portable Python dataframe library

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

    Permalink
    • ibis-project
29. Webamp - Winamp 2 in your browser

    2024-07-29
    audio database/sqlite programming/javascript

    Permalink
    • captbaritone/webamp
    • Winamp Skins Museum
    • The Winamp Skin Museum is powered by an sqlite3 database
30. Litestream - Streaming SQLite Replication

    2024-06-20
    backup database/sqlite

    Permalink
    • benbjohnson/litestream
31. PostgreSQL Anonymizer

    2024-05-23
    database/postgresql privacy/gdpr programming/rust security/anonymization

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

    2024-04-19
    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
33. Cloud Study Network - Free Certifications

    2024-04-03
    cloud-computing course database knowledge learn network

    Permalink
34. How to use PostgreSQL for (military) geoanalytics tasks

    2024-03-31
    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
35. Fly.io - JIT Wireguard

    2024-03-31
    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
36. dev-sec/ansible-collection-hardening - Hardening for Linux, SSH, Apache HTTPD, Nginx, MySQL

    2024-03-31
    configuration-management/ansible database/mysql linux network/http-server/apache-httpd network/http-server/nginx network/ssh

    Permalink
37. LWN - The race to replace Redis

    2024-03-30
    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
38. Atlas - Manage your database schema as code

    2024-03-07
    configuration-management/hcl continuous-integration database database/migration programming/go

    Permalink
    • ariga/atlas
    • Getting Started
    • HCL Schema
    • GitHub Actions
39. data load tool (dlt) -

    2024-02-26
    data-mining database programming/python

    Permalink
    • dlt-hub/dlt
    • dlt documentation
40. The One Billion Row Challenge

    2024-02-22
    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