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. xml2rfc - Generate RFCs and IETF drafts from document source in XML according to the IETF xml2rfc v2 and v3 vocabularies

   2025-02-16
   ietf/rfc internet programming/html programming/python programming/xml

   Permalink
   • ietf-tools/xml2rfc
   • Xml2rfc Vocabulary Version 3 Schema
3. drf-spectacular - Sane and flexible OpenAPI 3 schema generation for Django REST framework

   2024-11-28
   framework/django network/http/openapi programming/api/rest programming/python type-hint

   Permalink
4. 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
5. 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
6. Horrible edge cases to consider when dealing with music

   2023-11-15
   music text text/unicode

   Permalink
   • MusicBrainz Database / Schema
7. Schema.org - Schemas for structured data on the Internet, Web pages, email messages

   2022-07-04
   email google google/mail programming/html programming/json programming/xml web

   Permalink
   • https://schema.org/docs/schemas.html
   • https://stackoverflow.com/questions/57371445/schema-org-markup-in-emails
   • https://softwareengineering.stackexchange.com/questions/328567/how-does-microdata-rdfa-compare-to-json-ld/328711#328711
   • https://json-ld.org/
   • https://developer.mozilla.org/en-US/docs/Web/HTML/Microdata
   • https://developers.google.com/gmail/markup/overview
   • https://developers.google.com/gmail/markup/reference/formats/json-ld
   • https://developers.google.com/gmail/markup/reference/formats/microdata
   • https://docs.microsoft.com/en-gb/outlook/actionable-messages/adaptive-card
8. 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
9. 389ds in containers

   2021-01-20
   linux/container/docker network/ldap security/authentication security/authorization

   Permalink
   • https://fy.blackhats.net.au/blog/html/pages/ldap_guide_part_1_foundations.html
   • https://fy.blackhats.net.au/blog/html/pages/ldap_guide_part_2_searching.html
   • https://fy.blackhats.net.au/blog/html/pages/ldap_guide_part_3_filters.html
   • https://fy.blackhats.net.au/blog/html/pages/ldap_guide_part_4_schema_and_objects.html
   • https://github.com/389ds/389-ds-base/blob/master/docker/389-ds-fedora/Dockerfile
10. The Hitchhiker's Guide to PlantUML

    2020-12-01
    diagram model plantuml schema software software-engineering/uml

    Permalink
11. 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
12. drawio: Source to www.draw.io

    2018-06-07
    chart diagram graph image/svg schema web

    Permalink
    • https://github.com/jgraph/mxgraph
    • https://github.com/jgraph/mxgraph/tree/master/javascript/examples/grapheditor

    Docker image:

    • https://hub.docker.com/r/fjudith/draw.io/
    • https://github.com/fjudith/docker-draw.io
13. 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
14. phpLDAPadmin | Templates

    2017-08-28
    group network/ldap programming/php schema security/authentication tree user

    Permalink
    • https://forums.zarafa.com/showthread.php?609-Phpldapadmin-templates
15. 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
16. 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