VirtualTam's bookmarks

1. PostgreSQL at Scale: Database Schema Changes Without Downtime

   2025-06-12
   database/migration database/postgresql database/schema

   Permalink
   • Safe Operations For High Volume PostgreSQL (Archived 2020-04-14)
2. 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
3. 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
4. Horrible edge cases to consider when dealing with music

   2023-11-15
   music text text/unicode

   Permalink
   • MusicBrainz Database / Schema
5. pgloader - load data from various sources into PostgreSQL

   2022-04-17
   command-line database/mysql database/postgresql database/sqlite linux programming/csv programming/lisp

   Permalink
   • dimitri/pgloader
   • MySQL to PostgreSQL
   • pgloader#645 - How to import into public schema
6. gqlgen: go generate based graphql server library

   2019-03-04
   database graph programming/api/graphql programming/go

   Permalink
   • https://graphql.org/learn/schema/
   • https://99designs.com.au/blog/engineering/gqlgen-a-graphql-server-generator-for-go/
   • https://medium.freecodecamp.org/deep-dive-into-graphql-with-golang-d3e02a429ac3
7. Distributed environments and database migrations

   2017-11-29
   database/migration database/schema distributed-system framework/django linux/container/docker

   Permalink

   Actors:

   • database server / cluster
   • load-balanced application servers relying on a database schema with migrations
   • reverse proxy

   Issue:

   • managing database schema migrations

   Possible sequence:

   • create the database
   • run a service that executes database schema migrations
   • start application servers
   • start the load-balancer / reverse-proxy

   Resources:

   • https://www.reddit.com/r/docker/comments/2t2pnf/what_are_best_strategies_to_migrate_relational/
   • https://softwareengineering.stackexchange.com/questions/357929/db-migration-strategy-for-docker-containers-in-aws-ecs
   • https://stackoverflow.com/questions/41592091/run-a-database-migration-command-when-deploying-a-docker-container-to-aws
   • https://ltd-keeper.lsst.io/gke-migrations.html
   • https://stackoverflow.com/questions/31715239/docker-compose-database-migrations-and-other-pre-post-scripts
   • https://stackoverflow.com/questions/38089999/docker-compose-rails-best-practice-to-migrate
   • https://stackoverflow.com/questions/37058812/how-best-to-run-one-off-migration-tasks-in-a-kubernetes-cluster
8. PostgreSQL: Documentation: 9.6: Schemas

   2017-08-20
   database/postgresql database/schema framework/flask programming/python programming/sql sqlalchemy

   Permalink
   • https://wiki.postgresql.org/wiki/Database_Schema_Recommendations_for_an_Application
   • https://stackoverflow.com/questions/9298296/sqlalchemy-support-of-postgres-schemas
   • https://github.com/bernardopires/django-tenant-schemas
9. joncrlsn/pgdiff: Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database.

   2016-12-12
   database/postgresql database/schema programming/sql text/diff

   Permalink