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

Parkinson’s Law of Triviality

Law of triviality Parkinson’s law bikeshedding   “Work expands so as to fill the time available for its completion” “Praca rozszerza się tak, aby wypełnić czas dostępny na jej ukończenie”

Europe’s Greatest Driving Roads

Trasa #1: Rumunia – Trasa Transfogarska Trasa #2: Wielka Brytania – „Blakey Ridge”, Północ Yorkshire Trasa #3: Hiszpania – C462, Katalonia Trasa #4: Francja – D526 i D926, Alpy Trasa #5: Niemcy – B500, Schwarzwald Trasa #6: Majorka – MA10 Ford GT przejeżdża kultową Drogę Atlantycką w Norwegii (i mierzy się z Torem Arctic Circle)

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/

These diagrams show how people negotiate around the world – Norwegians fall somewhere between Swedes and Finns

National communication patterns