Software Development

CSS Viewport Units: What They Mean (vh, dvh, svh etc.)

By Callum May 17, 2023Software DevelopmentNo Comments

The table below can be used as a reference to check the meaning of the unit. E.g. height: 20dvh is 20% of "current viewport height, excluding user agent's interface..." UnitDescriptionsvhSmallest…

Quick MongoDB Naming Conventions

By Callum June 30, 2020Software DevelopmentNo Comments

I have written this post to serve as some quick guidelines for how databases and collections should be named in MongoDB to keep my projects consistent. Partially derived from this…

Different MySQL Results but Same Query & Data

By Callum May 18, 2020Software DevelopmentNo Comments

I was recently asked to look at an issue causing results on two MySQL servers (hosted on different machines: local environment and production environment) to be inconsistent with one another…

Exporting MySQL Results to CSV

By Callum May 16, 2020Software DevelopmentNo Comments

Before exporting the query results to a CSV file, you must firstly determine if the secure_file_priv option is set by running the following SQL query: SHOW VARIABLES LIKE 'secure_file_priv'; If…