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?
French playing cards for Poker in PostgreSQL, MySQL and SQLite 14 April 2016, edited 08 July 2016 Posted in: Software About: Implementing a deck of Poker cards in a SQL database: my solution for it is just a simple table of cards with a lot of columns in it.