SQL tips that query better
Joins, indexes, and query notes that make the database work for you.
SQLite - get first weekday of current week
Noval Agung Prayogo
·
0 responses
·
sqlite, sql
Stored Procedures and ActiveRecord
Yannick Schutz
·
2 responses
·
rails, activerecord, sql
Always include a WHERE clause in conditional UPDATE statements
Justin
·
0 responses
·
mysql, sql, update statements, safe updates
Select a range from SQL table using DB2
Thom
·
0 responses
·
sql, select, range, db2
Calculating distance between two points (Latitude, Longitude)
St0iK
·
1 response
·
mysql, sql, location, distance calculation
Using retry to rescue ActiveRecord::RecordNotUnique
Gabriel Cebrian
·
0 responses
·
ruby, rails, sql, rescue
Select all fields from a model without strings
Adan Alvarado
·
0 responses
·
rails, activerecord, sql, arel
Count by group in BookshelfJS for SQL
Yacobus Reinhart
·
0 responses
·
sql, orm, nodejs, bookshelfjs
Exporting Postgres queries as JSON
Stuart Corbishley
·
0 responses
·
sql, json, postgres, psql
create triggers on Amazon RDS like a boss
Daniel Tralamazza
·
0 responses
·
mysql, sql, aws, rds
Adding time interval to timestamp column
Bashir Eghbali
·
0 responses
·
sql, postgres, rails
Creating your own django lookup function
Hatem Nassrat
·
0 responses
·
django, python, sql, query
sql query to delete orphaned post meta in your WordPress database
Thibault Milan
·
0 responses
·
mysql, sql, wordpress
Great Objective-C SQLite Wrapper
Cole Hecht
·
0 responses
·
cocoa, ios, sqlite, sql
Better Diffs with SQL Files
Chris Missal
·
2 responses
·
diff, sql, binary, encoding
Mysql: set the LAST_INSERT_ID
Hannes Georg
·
0 responses
·
mysql, sql
Size in Kb of BLOB fields
Andréia Bohner
·
0 responses
·
sql, oracle, pl
Run VBS from SQL
John Bevan
·
0 responses
·
sql, vbscript, tsql, vbs
Profiling queries in Zend Framework
Eric Valera Miller
·
0 responses
·
php, log, sql, zf
Using Postgres Functions in a Rails Model Scope
Brad Fults
·
0 responses
·
rails, activerecord, sql, postgres
A simple PEG.js grammar to validate SQL selects
Haskell Camargo
·
0 responses
·
sql, compiler, grammar, peg
SQL Queries with Sublime Text and Ruby
Chris Kentfield
·
0 responses
·
ruby, sql, sublime-text-2
SQL Optimisation :: Convert Primary Keys to Clustered Indexes
John Bevan
·
2 responses
·
sql, performance, index, tsql
SQL to Generate Random IP Address
Anders Brownworth
·
0 responses
·
sql, postgresql
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.