MySQL tips that still default
Indexes and InnoDB notes for the database everyone has.
Naive Bayes Classifier in php and mysql
Anant Gupta
·
1 response
·
php, mysql, machine learning, naive bayes classifier
MySQL calculate distance between two latitude/longitude coordinates
Martin Auswöger
·
1 response
·
mysql, latitude, longitude, coordinates
Ubuntu 12.04: Installing Apache2 + PHP5 + MySQL + phpMyAdmin
Sebastian Muszyński
·
2 responses
·
mysql, apache2, ubuntu, phpmyadmin
Setting up Unicode defaults for MariaDB (or MySQL)
Mark Vasilkov
·
0 responses
·
mysql, unicode, utf8, utf8mb4
Library Not Loaded issue for mysql client on Mac OS
Leon Guan
·
4 responses
·
ruby, mysql, gem, mac os x
Nested PDO transactions
Samuel Merlet
·
0 responses
·
php, mysql, postgres, database
MySQL output as CSV, on command line
Michael Jemmeson
·
1 response
·
mysql, csv, bash
Build a web development OS in VirtualBox
Nek
·
2 responses
·
php, mysql, linux, apache
Always include a WHERE clause in conditional UPDATE statements
Justin
·
0 responses
·
mysql, sql, update statements, safe updates
Setting up Recurring Events in MySQL
Tom Krush
·
2 responses
·
mysql, recurring events
Running out of Memory with PDO/PHP?
Erik Wurzer
·
0 responses
·
php, mysql, pdo
Calculating distance between two points (Latitude, Longitude)
St0iK
·
1 response
·
mysql, sql, location, distance calculation
ubuntu / Installing MySQL 5.6.x from source
Chungsub Kim
·
0 responses
·
mysql, source, install, ubuntu
Calculate distance between two coordinates in PHP, JavaScript and MySQL
Alvaro Flores
·
0 responses
·
php, mysql, geolocation, latitude
Simple MySQL wrapper using mysqli_*
Jonathan Tavares
·
6 responses
·
php, mysql, dba, php class
Using rollup tables to aggregate data in large datasets
Matthias Mullie
·
1 response
·
mysql, big data, rollup tables
Use a Remote Mysql Database With Heroku
Larry Scott
·
0 responses
·
mysql, heroku
MySQL 5.6 doesn't accept empty strings on numerical fields
Nuno Costa
·
3 responses
·
ruby, mysql, rails
Geographic searches within a certain distance
Matthias Mullie
·
1 response
·
php, mysql, geography, distance
mysql extension not showing on phpinfo [fixed]
Pramendra Gupta
·
0 responses
·
mysql, nginx, php-fpm
Mysql - Load data infile ignore blank lines
JD
·
0 responses
·
mysql, data, load
MySQL Composite Index
aleemb
·
0 responses
·
mysql, index
Why not to use NOW() in MySQL
Scott Horsley
·
7 responses
·
php, mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#
Coderwall Dev Community
Explore the all-time favorite tutorials, design patterns and engineering guides that thousands of readers keep sharing and coming back to, year after year.
These proven techniques, reusable code samples, programming tips and vibe coding habits earned their place through steady views and member likes.
Each entry here is still useful today, covering programming languages, frameworks and workflows that stay relevant long after they were first published.
Whether you're new to a tech stack or an experienced engineer refreshing your skills, start with the most useful tips our dev community members recommend and build on solid, well-tested coding knowledge.