There are also some limitations if using something like rails / activerecord which doesn't support composite primary keys natively
HN user
tappleby
Are there any strategies for migrating from a separate db per tenant to shared db with scoped tenant_id? In this case each tenant would have overlapping primary keys.
+1 for postmark. Had deliverability issues with mailgun which were resolved once switching.
We have been using jsonnet for Amazon ECS service and task definitions, works quite well.
Works well, only issue I ran into is that multidimensional arrays must all have the same number of elements. Had missed this originally when reading the documentation https://www.postgresql.org/docs/10/static/arrays.html#ARRAYS...
I use Postico almost every day, great tool.
We have a similar setup for extending our app with custom fields / forms using ruby-json-schema and react-jsonschema-form [1].
ruby-json-schema has worked out quite well, we added a custom schema reader so that we could generate enums dynamically based on records in the database via custom refs eg. app://schemas/organizations?type_eq=education&tags=one, any of these internal refs are inlined at the API layer.
One issue we did run into with ruby-json-schema, is the schema caching is not thread safe. We opted to clear the cache after each validation, this ended up causing race-condition issues. In the end we had to use a mutex on write and cache the validation result (not ideal, but our app isn't that write heavy).
[1] https://github.com/mozilla-services/react-jsonschema-form