I typically spend my weekends shooting landscape photography or hacking away my newest side project. Trying to start the new year off by killing two birds with one stone, I embarked to build a lightweight lightbox component into my fresh hugo blog.

I want a reusable component, that once complete will allow me to …

TL;DR

A sql query to list the size of database tables on a mysql server.

1SELECT concat( table_schema, '.', table_name ) table_name,
2       concat( round( data_length / ( 1024 *1024 ) , 2 ) , 'M' ) data_length,
3       concat( round( index_length / ( 1024 *1024 ) , 2 ) , 'M' ) index_length,
4 …