Some thoughts I have on the naming of functions, variables, classes, files, and folder. These thoughts do not have anything to do with project/code structure or architecture. I apply these thoughts to almost every language I program in, but a language can impact what ideas I implement. Patterns Name things using a consistent pattern this […]
Web
The JavaScript Event Loop
I received that feeling of excitement, the unlocking of the mind, watching Philip Roberts unpack the JavaScript event loop at JSConf EU 2014. I’d like to share that moment and hopefully the feeling. Who knew setTimeout(function(){ do_stuff(); }, 0); would be so helpful.
Import and Export MySQL and PostgreSQL
There are many ways to export and import data from a database. You can use a Mac client like Sequal Pro for MySQL, for example. You can do the same for PostgreSQL, though I have not settled on a Mac client for PostgreSQL. Mac clients aside, you need can import and export your database SQL […]
Raw PHP and MySQL Eager Loading
Working with complicated and joined data sets can be tricky for MySQL database performance. For example, What if you need to load multiple authors and their books from a database. How would you work around the N+1 problem and avoid unnecessary queries to the database without an expensive join statement? The answer is quite simple. […]
Character Encoding UTF-8: PHP, HTML,and MySQL
Note: Sequel Pro has not had a stable update in some time and I no longer use it. I love Sequel Pro. However, the default encoding is latin1 and you should be using a form of Unicode like utf8mb4 and utf8mb4_unicode_ci. The next time you add a database with Sequel Pro, or any other client, […]
Server Level CRON Backups
Backing up files and storing them in a remote location should be done on a regular basis. Backups are vital. They ensure your code and assets are available if your server is hacked, destroyed and when your data is lost or corrupted. In WordPress, you could use a plugin like BackupBuddy to manage your backups. […]
