Category
SQL
10 posts tagged #SQL
- · 3 min read
Link Share: Issue #5
I have quite a build-up of links to share. It's been a while, so some may be old news, but it's still worth posting. Grab a coffee and enjoy!
- · 2 min read
Laravel 11 Migrations: Best Practices for Stability and Scalability
Learn the top best practices for writing Laravel 11 migrations, including avoiding dynamic table names, separating schema from data migrations, and blocking down method rollbacks in production. Build resilient and maintainable database migrations for your application.
- · 1 min read
How to Reset the Primary Key Sequence ID in PostgreSQL
Reset PostgreSQL primary key sequences that fall out of sync using setval and pg_get_serial_sequence.
- · 1 min read
Fixing MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes
Resolve MySQL error 1153 by increasing the max_allowed_packet setting in the MySQL configuration file.
- · 1 min read
How to Display and Debug All Database Queries Made by WordPress
Debug WordPress database queries using SAVEQUERIES constant and helper functions for optimization.
- · 1 min read
Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead
Disable MySQL strict mode and NO_ZERO_DATE errors in Laravel Homestead by configuring sql_mode.
- · 2 min read
Import and Export MySQL and PostgreSQL
Import and export databases for MySQL and PostgreSQL using command line tools and troubleshooting.
- · 2 min read
Raw PHP and MySQL Eager Loading
Implement eager loading in PHP with PDO to reduce database queries and improve performance.
- · 1 min read
Character Encoding UTF-8: PHP, HTML,and MySQL
Understand how to properly configure UTF-8 character encoding in PHP, HTML, and MySQL.
- · 2 min read
Enabling Performance Monitoring for MariaDB and MySQL
Enable performance schema monitoring in MariaDB and MySQL to track query performance and optimization.
