VirtualTam's bookmarks

21. Self-hosted online collaborative drawing platform Excalidraw

    2024-11-25
    database/mongodb database/sqlite diagram image/png image/svg network/websocket programming/json programming/node.js programming/typescript schema self-hosting software-engineering/uml

    Permalink
    • Self-hosted online collaborative drawing platform Excalidraw (alternate version on Medium)
      • alswl/excalidraw-collaboration - Excalidraw with collaboration feature, self-hosting, and only one-click deploy
      • alswl/excalidraw-storage-backend - Storage for scenes, images and collaboration rooms
      • alswl/excalidraw.alswl.com - Custom static version featuring a Chinese font with handwriting style
      • Someone0nEarth/excalidraw-self-hosted - A docker-compose configuration for a fully self-hosted excalidraw stack, a collaborative whiteboard solution
    • r/selfhosted - Excalidraw
      • excalidraw/excalidraw-room - Example collaboration server
      • Comment on excalidraw/excalidraw/issues/4993 - Building your own Docker images
      • excalidraw/excalidraw/issues/6506 - Tutorial for Træfik
    • PatWie/excalidraw-complete - Self-host Excalidraw with a single Go binary - Supports multiple storage options and real-time collaboration
22. 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
23. 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
24. 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
25. What I Wish Someone Told Me About Postgres

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

    Permalink
26. 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
27. 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
28. 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
29. Ibis - The portable Python dataframe library

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

    Permalink
    • ibis-project
30. 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
31. Litestream - Streaming SQLite Replication

    2024-06-20
    backup database/sqlite

    Permalink
    • benbjohnson/litestream
32. 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
33. 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
34. Cloud Study Network - Free Certifications

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

    Permalink
35. 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
36. 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
37. 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
38. 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
39. 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
40. data load tool (dlt) -

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

    Permalink
    • dlt-hub/dlt
    • dlt documentation