By using this website you agree to our Privacy Policy.

Skip to content
Kevin Dees
  • About
  • Dare To Code
Search Say Thanks
Kevin Dees
Close menu
  • About
  • Dare To Code
Kevin Dees
Search Toggle menu

Category: SQL

brown wooden bench in field
April 24, 2020April 24, 2020Fix, SQL, Tips, Web

How to Reset the Primary Key Sequence ID in PostgreSQL

I run into an issue today with PostgreSQL. I had manually entered a row into a table and it caused the primary […]

2kh
February 19, 2020April 4, 2020Fix, SQL, Web

Fixing MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

To fix, “MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf. Once you have opened […]

qh7v 7 bqzi
October 3, 2019December 6, 2021Web, Performance, SQL, WordPress

How to Display and Debug All Database Queries Made by WordPress

When working with WordPress you will eventually have the question, “How do I display all database queries made by WordPress?” In your […]

December 18, 2018April 4, 2020Fix, Laravel, Servers, SQL, Web

Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead

If you are using MySQL 8 or 5.7, on Laravel Forge, for example, use the command sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf. The options file […]

kgopcmppt7c
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 […]

p3pj7joyvnm
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 […]

2ts5hna67k8
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. […]

knv mjdgwzu
April 11, 2015April 8, 2020Performance, SQL, Web

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 […]

  • About
  • Dare To Code
  • Say Thanks
  • Privacy Policy

Dare To Code

Get the tips, links, and tricks on full-stack PHP development in your inbox with monthly emails from Kevin Dees.
Name(Required)
This field is for validation purposes and should be left unchanged.

© 2010 - 2023 Kevin Dees, all right reserved.