VirtualTam's bookmarks

1. 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
2. Horrible edge cases to consider when dealing with music 2023-11-15

   tags: music, text, text/unicode

   [ permalink ]

   • MusicBrainz Database / Schema
3. Schema.org - Schemas for structured data on the Internet, Web pages, email messages 2022-07-04

   tags: 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
4. pgloader - load data from various sources into PostgreSQL 2022-04-17

   tags: 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
5. 389ds in containers 2021-01-20

   tags: 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
6. The Hitchhiker's Guide to PlantUML 2020-12-01

   tags: diagram, model, plantuml, schema, software, software-engineering/uml

   [ permalink ]
7. gqlgen: go generate based graphql server library 2019-03-04

   tags: 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
8. drawio: Source to www.draw.io 2018-06-07

   tags: 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
9. Distributed environments and database migrations 2017-11-29

   tags: data, database, database/migration, distributed, 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
10. phpLDAPadmin | Templates 2017-08-28

    tags: group, network/ldap, programming/php, schema, security/authentication, tree, user

    [ permalink ]

    • https://forums.zarafa.com/showthread.php?609-Phpldapadmin-templates
11. PostgreSQL: Documentation: 9.6: Schemas 2017-08-20

    tags: database, database/postgresql, framework/flask, programming/python, programming/sql, schema, 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
12. 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

    tags: database, database/postgresql, diff, programming/sql, schema

    [ permalink ]