Guide to disabling MySQL strict mode on Laravel Forge/Ubuntu servers to fix application compatibility issues.
A technical guide on recovering a MySQL InnoDB database after a catastrophic DROP TABLES command, using tools from Twindb.
Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
A guide on setting up and connecting a Laravel application to a MySQL database using the ClearDB add-on on the Heroku platform.
Explains why MySQL's -p password parameter cannot have a space, detailing the command-line parsing logic behind this design choice.
An overview of daloRADIUS, an advanced open-source RADIUS web management platform for hotspots and ISPs, featuring user management and reporting.
A tutorial on setting up and securing a new Ubuntu server on Linode, covering initial provisioning, SSH connection, and essential software installation.
A technical tutorial explaining how to use AJAX with jQuery to query a MySQL database and display the results in a tooltip on a webpage.
Explains why MySQL's 'utf8' charset is incomplete and how to use 'utf8mb4' for full Unicode support, including emojis.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
A tutorial on building a Java EE 6 web application with MySQL, JPA 2.0, and Servlet 3.0 using the GlassFish Tools Bundle for Eclipse.
A developer compares MySQL and MS SQL Server, listing syntax and usability advantages of MySQL based on personal experience.
Announcing a new database backup feature for daloRADIUS, focusing on portable INSERT-based backups for compatibility across database types.
A technical guide showing how to get the UNIX timestamp for New Year's Day in MySQL, Excel, and Visual BASIC.
A practical guide to setting up MySQL replication, covering master-slave configuration, log files, and initial data synchronization.
