From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
dbadrivers5d ago • 4 min read
AI DBA on Bare Metal: Slow Log In, Diagnosis + Fix SQL Out (Data Never Leaves Your Network)
This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle ...
#ai#devchallenge#hf26challenge#mysql
0 0
anders lee2d ago • 4 min read
Three Docker Compose health checks that say "healthy" too early (tested on Docker 29)
mysqladmin ping, pg_isready and redis-cli ping all pass before the service is really usable. Here is...
#docker#devops#mysql#postgres
0 1
Kartik Butani2d ago • 2 min read
Amigose Overseas Education CRM & Student Portal — Architectural Case Study
A student admissions CRM and mobile app for overseas study consultants. Amigose Overseas...
#flutter#dart#php#mysql
0 0
Son Tran1d ago • 10 min read
How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM
MySQL ON UPDATE, a trigger or the ORM for updated_at: Schemity compares them, the migrations that si...
#mysql#postgres#database#sql
0 0
Son Tran4d ago • 12 min read
MySQL UNSIGNED Primary Keys: Signed or Unsigned, and How to Fix Error 3780 When They Mix
Schemity tested signed vs UNSIGNED keys on MySQL 8.4: same storage, but a mismatched foreign key fai...
#mysql#database#laravel#sql
0 2
Ze Horta4d ago • 6 min read
Full-text search in Laravel on both SQLite and MySQL: FTS5, FULLTEXT and one interface
How I added search inside files to a self-hosted Laravel app without a search server, on SQLite (FTS...
#laravel#php#sqlite#mysql
0 0
Son Tran3d ago • 15 min read
Round-Tripping Invoice Ninja and Sylius Through a Database Diagram: What MySQL Lost and What We Fixed
Schemity rebuilt Invoice Ninja's and Sylius's MySQL schemas from its own SQL. Before the fixes MySQL...
#mysql#database#laravel#symfony
0 0
Faizan6d ago • 12 min read
What Is the Host Parameter in mysqli_connect()?
Learn which host value to use in mysqli_connect(), how localhost differs from 127.0.0.1, and how to ...
#mysql#database#tutorial
0 0
Faizan6d ago • 11 min read
How to select multiple columns based on a condition in SQL?
Learn how to select multiple MySQL columns using WHERE, CASE, conditional aggregation, and dynamic S...
#mysql#database#tutorial
0 0
Faizan5d ago • 8 min read
Find the Query from query_id in MySQL (InnoDB)
Learn how to identify SQL queries from MySQL InnoDB query IDs using process lists, Performance Schem...
#mysql#database#tutorial
0 0
Faizan5d ago • 11 min read
BeanCreationException: Database Type NONE MySQL Fix
Fix Spring Boot's database type NONE error with working MySQL JDBC settings, driver dependencies, pr...
#mysql#database#tutorial
0 0
Ali Raza2d ago • 3 min read
My PHP + MySQL Stack for Small Business Software in 2026
Everyone asks why I still build with PHP and MySQL in 2026. The answer is simple: my clients are...
#php#webdev#beginners#mysql
0 0
Qasim Parray1d ago • 7 min read
Laravel DB::olap() on PlanetScale: When I'd Still Chunk
Laravel 13.36 adds DB::olap() to lift PlanetScale's 100,000-row query limit. Here is the lazy cursor...
#laravel#planetscale#mysql#vitess
0 0
Faizan4d ago • 6 min read
Add a JOIN to an Existing CodeIgniter Query Builder Select
Learn how to add a JOIN to an existing CodeIgniter SELECT query, with working CodeIgniter 3 and 4 ex...
#mysql#database#tutorial
0 0
Abdullah Web Dev4d ago • 2 min read
wp_postmeta Has No Index on meta_value — And That Missing Index Is Why Your WooCommerce Store Crawls
Every product lookup on a WooCommerce store reads the wp_postmeta table. And one missing index in...
#wordpress#woocommerce#mysql#php
0 0
Ashish sinha4d ago • 2 min read
schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL
BIRD Mini-Dev is 500 text-to-SQL questions over 11 real databases, in three dialects. It is scored b...
#claude#database#mysql#sql
0 0
Faizan4d ago • 6 min read
AWS RDS MySQL kill transaction by ID (without thread_id)
Map an InnoDB trx_id to its connection on AWS RDS MySQL, kill it with mysql.rds_kill, and handle XA ...
#mysql#database#tutorial
0 0
Faizan3d ago • 11 min read
load data infile optionally enclosed by not working as expected
Fix MySQL LOAD DATA INFILE splitting quoted CSV fields. Learn how to correct delimiters, PHP escapin...
#mysql#database#tutorial
0 0
Faizan5d ago • 6 min read
Unknown character set index for field received from server
Why MySQL 8 triggers 'Unknown character set index for field 255' in older JDBC and PHP clients, and ...
#mysql#database#tutorial
0 0
devTalkOct 16, 2026 • 7 min read
Laravel Stream Backup: Database Backups Without Temp Files
Most Laravel backup setups share a quiet assumption: the server has enough free disk to hold the...
#laravel#backup#mysql#s3
1 1
devTalk4d ago • 7 min read
Laravel Query Optimization: 4 Simple Fixes for Faster Apps
When a Laravel page or job feels slow, the database is the first suspect, and usually the right one....
#laravel#eloquent#mysql#performance
0 1
Kartik Butani2d ago • 1 min read
GEAMS (Genesys Employee Appraisal Management System) — Architectural Case Study
Digitizing employee performance reviews and goal tracking. GEAMS gives management a...
#mysql#webapi#php#webdev
0 0
Nishant Gaurav Oct 16, 2026 • 4 min read
Where Clause In PostgreSQL
WHERE is one of the first things you learn in SQL, and it's also one of the things people stop payin...
#postgressql#sql#database#mysql
0 0
Abd Alrhman Alloush4d ago • 4 min read
On-Premise Database Inventory: Bringing MySQL and PostgreSQL Into One Multi-Cloud View
Most multi-cloud database discussions start and end with AWS, GCP, and maybe MongoDB Atlas....
#database#devops#postgres#mysql
0 0