Simple fix for Bluetooth audio not working on Android 10 13 October 2019 Posted in: Software About: After upgrading my phone to Android 10, my Bluetooth speakers and earphones stopped working. Luckily the fix is very simple.
Tutorial: UNIQUE constraint on NULL values in PostgreSQL 21 March 2017 Posted in: Database About: Distinguishing between NULL values is impossible, as per SQL standard. These are my favorite workarounds for one and multiple columns.
Tutorial: sizes of tables and databases in PostgreSQL 19 March 2017 Posted in: Database About: How big are PostgreSQL tables in terms of rows and disk space? Here are some queries to get their sizes.
Tutorial: read-only PostgreSQL user 21 February 2017 Posted in: Database About: PostgreSQL is installed, the tables are planned or already created. Now how do I create a read-only user that can access one/some/all tables in a schema but not UPDATE, INSERT or DELETE anything?