Why I chose AWS over Digital Ocean

So Digital Ocean is awesome.   They bring a lot to the table that Amazon does not.   For example, with a Digital Droplet, you have option of choosing Fedora, CentOS, Ubuntu, and more.  For RPM distros, AWS only has Amazon AMI (not my favorite) and Redhat which is incredibly expensive.   With Digital Ocean, you also have […]

How a typo can break Laravel, and how bash can fix it

First off, thank you Nathan Long at StackExchange for saving my app.  Here’s the link to his sage answer: https://superuser.com/questions/428493/how-can-i-do-a-recursive-find-and-replace-from-the-command-line This is the typo that broke my code: php artisan app:name foo.bar Here foo.bar is just pseudocode for a very specific label that I was applying to the app namespace.  However, I carelessly added the […]

get table size in megabytes, MySQL

Here’s an awesome snippet of code that I got from Thomas Eisenbarth at https://makandracards.com/makandra/39413-mysql-mariadb-show-disk-usage-of-tables-and-columns SELECT table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` FROM information_schema.TABLES WHERE table_schema = “$your_database”; Basically, it will display all the tables in a database with disk usage in the next column. All you to do […]

an old JSON typeahead project

https://blog.luauapps.com/cdc/index.php It is my belief that database nuts should get familiar with noSQL.  We live in a world where noSQL has become very prominent.  Get familiar with JSON.  Get familiar with Mongo and Cassandra.  These tools are very useful in some ways, and you CAN do things with them that you cannot do with SQL. […]

Raw PHP vs. frameworks

Everything PHP is object-oriented these days, and thank goodness for that. Who could imagine life without Laravel? However, the question should be asked, is Web development in raw PHP still relevant? If so, what is raw PHP good for, compared to frameworks such as Symfony or Laravel? Consider the following link: https://www.techempower.com/benchmarks/#section=data-r17&hw=ph&test=fortune This is a […]