PostgreSQL: How to Disable or Enable Foreign Key Constraint of a Table

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;

UUID Primary Keys in PostgreSQL

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_%’; ...

Java 9 + DBeaver 4.2.2 fails at start with NoClassDefFoundError / IllegalStateException

https://github.com/serge-rider/dbeaver/issues/2247 https://wiki.eclipse.org/Configure_Eclipse_for_Java_9 Workaround: add –add-modules=ALL-SYSTEM in dbeaver.ini after -vmargs

Await and Async Explained with Diagrams and Examples

http://nikgrozev.com/2017/10/01/async-await/

HTML Cheat Sheet – Fully Interactive [Inc HTML5]

HTML cheat sheet

Semantic version calculator

https://semver.npmjs.com/

Who is listening on a given TCP port on Mac OS X?

lsof -n -i:$PORT

Joel on Software

Partyzancki poradnik rekrutacji Test Joela: 12 kroków ku lepszym programom

Introduction to ES6 Promises – The Four Functions You Need To Avoid Callback Hell

http://jamesknelson.com/grokking-es6-promises-the-four-functions-you-need-to-avoid-callback-hell/

The Twelve-Factor App

A methodology for building modern, scalable, maintainable software-as-a-service apps. https://www.12factor.net/