October 7, 2016August 31, 2020Laravel, Servers, SQL, Web 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 […]
September 21, 2016April 8, 2020Performance, PHP, SQL, Web 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 […]
June 11, 2016April 3, 2020Apps, HTML, SQL, Web 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. […]
May 29, 2016May 4, 2022Servers, Web 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 […]
January 21, 2016December 6, 2021Web, PHP, Servers 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(). […]