Category: Web

  • Import and Export MySQL and PostgreSQL

    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

    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

    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

    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.…

  • Installing Xdebug for PHP7

    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 need to do so manually. Ubuntu 15 and lower will not come with a package for PHP7 or its xDebug counterpart. First, be…

  • Enabling Performance Monitoring for MariaDB and MySQL

    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 you want to do essential performance monitoring overall. In the past, you could use general_log, log_slow_queries and SHOW PROFILES. Since MySQL 5.5…

  • Podcasts 101: Learn How to Do Your First Podcast

    Podcasts 101: Learn How to Do Your First Podcast

    The session itself will be on Podcasting. Luckily I have no shortage of stories when it come to the topic. I have had the honer of podcasting for a little over two years now. The first podcast I have been involved with is called “The Web Weekly” and the second is the “SitePoint Podcast”. From…

  • Optimizing large font files for @font-face

    Optimizing large font files for @font-face

    @font-face font optimization has been to my mind recently. Due to the CSS Off that Unmatched Style is hosting if I’m forced to be honest. Now you may be wondering what I mean by font optimization for @font-face. In this I mean the reduction of the font file size. For example. Let’s say you have…

  • IE seeping content link overlap CSS fix

    IE seeping content link overlap CSS fix

    Totally fired up about this one. I have not seen this Internet Explorer bug in a while so it was fun to fix. This absolute positioning error affects IE7 and IE8 for sure, and my guess is that it affects IE6 as well; and, we can and should all pray IE9 fixed this. Basically the…