Resources

This is a miscellaneous set of reading and resources that may or may not be relevant to Mathesar. Feel free to add more!

APIs

• Best practices for REST API design - Stack Overflow Blog

Deployment

• Best Practices Around Production Ready Web Apps with Docker Compose

Licensing

• Maintaining Permissive-Licensed Files in a GPL-Licensed Project: Guidelines for Developers

Postgres

Information on Postgres related projects and tools.

Articles

• Migration Opinions opinions on writing database migrations in Postgres. Invaluable for long-running production production projects with breaking schema changes.
• Evaluating PostGraphile For Your Project: The section on “Schema Driven APIs” here has some great insights.
• Advice on Indexes in Postgres
• 10 Things I Hate About PostgreSQL

Primary Keys

• UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
• Sequential UUID Generators

Projects

• The graphile organization on GitHub is full of postgres-related projects written in TypeScript. Clean, straightforward codebases with very good documentation.

Introspection + API Generation

• PostgREST - Introspects, generates, and serves OpenAPI-complaint REST apis from Postgres databases.
• Postgraphile The same thing, but for GraphQL and written in TypeScript. They have really rich documentation that gets into a lot of interesting Postgres best practices and architectural patterns.
  • A package for realtime communication with Postgres LISTEN / NOTIFY https://github.com/graphile/graphile-engine/tree/v4/packages/pg-pubsub