DEV Community

#mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
The Report That Was Off by Three Hours: Timezone Rules for Laravel Business Apps

The Report That Was Off by Three Hours: Timezone Rules for Laravel Business Apps

Comments 2
6 min read
Database Concurrency 101: Optimistic vs. Pessimistic Locking

Database Concurrency 101: Optimistic vs. Pessimistic Locking

Comments
3 min read
How I Structured a Java Library Management System with DAO and Service Layers

How I Structured a Java Library Management System with DAO and Service Layers

Comments
8 min read
How I Built a Java Hotel Reservation System with JDBC and MySQL

How I Built a Java Hotel Reservation System with JDBC and MySQL

Comments
9 min read
MySQL UNSIGNED Primary Keys: Signed or Unsigned, and How to Fix Error 3780 When They Mix

MySQL UNSIGNED Primary Keys: Signed or Unsigned, and How to Fix Error 3780 When They Mix

Comments 2
12 min read
Specialization and Generalization in DBMS: Explained with Simple Examples

Specialization and Generalization in DBMS: Explained with Simple Examples

Comments
4 min read
Moving off EventON: its timestamps aren't what they look like

Moving off EventON: its timestamps aren't what they look like

1
Comments 1
4 min read
Moving off WP Event Manager: what's in your database and what breaks

Moving off WP Event Manager: what's in your database and what breaks

Comments 1
3 min read
Moving off Modern Events Calendar: what's in your database and what breaks

Moving off Modern Events Calendar: what's in your database and what breaks

Comments 1
4 min read
SQL vs MySQL: What Is the Difference?

SQL vs MySQL: What Is the Difference?

Comments
6 min read
MySQL Server Has Gone Away (2006) in Laravel & XAMPP: Fix

MySQL Server Has Gone Away (2006) in Laravel & XAMPP: Fix

Comments
16 min read
MySQL Explained: The Database Behind Much of the Web

MySQL Explained: The Database Behind Much of the Web

Comments
2 min read
Decommissioning a Laravel SaaS Without Losing the Ability to Restore It

Decommissioning a Laravel SaaS Without Losing the Ability to Restore It

1
Comments 2
10 min read
Fix mysql_fetch_array() Expects Parameter 1 to Be Resource

Fix mysql_fetch_array() Expects Parameter 1 to Be Resource

1
Comments
7 min read
Stop Killing Your Database: The Power of Connection Pooling

Stop Killing Your Database: The Power of Connection Pooling

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.