JavaScript Don’t mistake the service worker as a small thing Service workers let you decide what a user experiences on your website when there is, is not or is limited network connectivity. The service worker is a game changer. It is no small
My Programming Naming Philosophy 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
JavaScript 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.
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
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
Character Encoding: UTF-8, PHP, MySQL and Sequel Pro I love Sequel Pro. However, the default encoding is latin1 and you should be using a form of Unicode like utf8mb4. The next time you add a database with Sequel Pro be sure
Servers 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,
Installing xDebug for PHP7 Xdebug deepens debugging PHP apps and websites to a level you can't receive from the manual process of using code level var_dump(). Setup To install Xdebug for PHP7 on Ubuntu you will
WordPress Making an API endpoint in WordPress using add_rewrite_rule There are many ways to build an API in WordPress. I personally like to build them against the base URL. If I was building one for this site it might be http://php-built.
Database Enabling Performance Monitoring for MariaDB and MySQL Enabling performance monitoring for MariaDB and MySQL works the same way. Performance monitoring for databases is beneficial when you have records in the hundreds of thousands using complex joins. It also helps when
