Checklist of the most important security countermeasures when designing, testing, and releasing your API
This is a collection of useful resources for building RESTful HTTP+JSON APIs. There are a lot of good tools and entire ecosystems out there! It can be overwhelming not knowing what options are available, so you can use this as a reference starting point.
https://www.dbrnd.com/2017/02/postgresql-how-to-disable-or-enable-foreign-key-constraint-of-a-table-data-migration-bulk-operation/ ALTER TABLE table_name DISABLE TRIGGER ALL; INSERT INTO table_name VALUES (1,6,50,60,90); ALTER TABLE table_name ENABLE TRIGGER ALL;
http://www.starkandwayne.com/blog/uuid-primary-keys-in-postgresql/ https://dba.stackexchange.com/questions/146135/psql-9-5-gen-random-uuid-not-working psql 9.5: gen_random_uuid() not working? SELECT gen_random_uuid() produces output: ERROR: function gen_random_uuid() does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. you can check if the functions are defined using: select * from pg_proc where proname like ‘gen_random_%’; ...