SQL tips that query better
Joins, indexes, and query notes that make the database work for you.
Splitting Strings with MySQL
Franklin Strube
·
0 responses
·
mysql, sql
The //* /*/ //*/ comment toggle trick
Alexander Brevig
·
27 responses
·
arduino, sql, comments, wiring
How to convert string to integer (PHP & MySQL)
Nicolas KEMPF
·
2 responses
·
php, mysql, sql, type conversion
Postgres GROUP_CONCAT
Greg Roodt
·
0 responses
·
mysql, sql, postgres
Using Group By LINQ C#
Samuel Diogo
·
2 responses
·
sql, linq, c#
Closure Tables for Browsing Trees in SQL
Shaun McCormick
·
6 responses
·
sql, database, architecture, data structures
OR queries with arrays as arguments in Rails 4
Rafał Cieślak
·
9 responses
·
rails, activerecord, sql, arel
Delete All Existing WordPress Transients in MySQL Database
Pothi Kalimuthu
·
0 responses
·
mysql, sql, cache, transients
sqlite substring from right
Miles Matthias
·
0 responses
·
sqlite, sql, substr
Nested Set Model: the best approach to deal with hierarchical data
Álvaro
·
2 responses
·
ruby, mysql, rails, sql
How to remove diacritics in SQL Server
Dominic Goulet
·
0 responses
·
sql, sqlserver
Complex database migrations with PHP/MySQL using Phinx
Adrian Imfeld
·
2 responses
·
php, mysql, sql, migration
.....
Jacob Vidal
·
2 responses
·
sql, databases
Quickly setup SQL query logging - django
Jakh Daven
·
0 responses
·
logging, sql, django
SQL to Change WordPress Domain URL
Matthew Hauth
·
2 responses
·
sql, domain, phpmyadmin, wordpress
Deletion in the Django ORM
Zachary Voase
·
0 responses
·
sql, django
Calculating Median in PostgreSQL
Gefei
·
0 responses
·
sql, aggregation, postgresql, median
SQLZOO - Learn and practice SQL
Filly
·
0 responses
·
mysql, sql, oracle, databases
SELECT * FROM DUAL MySQL Equivalent
Julian Lannigan
·
0 responses
·
mysql, oracle, sql, select
Consider subqueries instead of joins
Hannes Georg
·
1 response
·
mysql, sql, postgresql
Nested SQL Injections
Nemo
·
1 response
·
sql, security, sqli, injection
Preloading scoped has_many :through associations
Alex Popov
·
0 responses
·
rails, activerecord, sql, eager loading
Change owner of multiple tables of a PostgreSQL database
Lars Behnke
·
0 responses
·
sql, postgresql
Moving schema from an Oracle database to another
Paolo
·
0 responses
·
sql, oracle
SQLAlchemy model to dictionary
lukas
·
0 responses
·
python, sql, json, flask
186
Tips
0
Followers
Related Tags
sql
Recent Activity
Laravel Eloquent: mysql-or-pgsql case-insensitive string matching 'search' for models
matt j. sorenson
·
laravel, eloquent, sql, mysql
Sql Server Datetime Tips and Tricks
Rick Pearson
·
sql, mssql, datetime
Replace emails for test env
Luciano Sousa
·
sql, query, data, anonymize
Need to Create A New API Key For An App?
Newest
SQL
protips
ErikJacobsen
·
php, dreamfactory, api, api keys
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.