Small example how to print out a SQLAlchemy query with parameters being expanded.

When displaying items based on a database search, one sometimes wants to display a specific set of items at the top or bottom of the result set. Applying the custom order inside of the database query allows to still use LIMIT and OFFSET in a natural way.

Two approaches to quickly compare two similar tables and get an idea of how many records differ based on an example with geo data.

Small SQL snippet to quickly get an overview of the row count in a PostgreSQL database.