SQL tips that query better
Joins, indexes, and query notes that make the database work for you.
Find all tables without primary key in MySQL
Igor Moiseev
·
0 responses
·
mysql, sql, primary key
MySQL Query Optimization
Richard Clifford
·
3 responses
·
php, mysql, sql, database
Splitting up your GeographyCollection's into seperate Polygons in Sql Server 2012 [Part 2 of 2]
Pure Krome
·
0 responses
·
sql, sql-server, geography, sql-server-2012
Construct Hibernate Criteria Query with OR clause
Rajesh
·
0 responses
·
sql, hibernate
Numbered Paging in SimpleDB Queries
Justin Poliey
·
0 responses
·
sql, aws, simpledb, sdb
Learn programing languages by example
Mariz Melo
·
2 responses
·
ruby, php, python, sql
PHP: Easy SQL date time formatting
Rogério Alencar Lino Filho
·
1 response
·
php, sql, format, date
Boostrapping H2 database with schema / data from SQL script
Kim A. Betti
·
0 responses
·
sql, testing, jdbc, java
Determining the 'closest' centre point for a shape in Sql Server 2012
Pure Krome
·
0 responses
·
sql, sql-server, shapefiles, geography
Solving TFS 2010 Build Stuck as Infinitely Queued
Glauco Vinicius
·
0 responses
·
sql, tfs, team foundation server, build server
Delete duplicate FAL entries and references after TYPO3 6.2 upgrade
Michael Stucki
·
3 responses
·
sql, typo3, duplicate, fal
Convert SQL `LIKE` wildcards to Ruby RegExp
Emmanuel Bourgerie
·
3 responses
·
ruby, sql, regexp, wildcard
Removing duplicates rows in MySQL
Morteza Nourelahi Alamdari
·
0 responses
·
mysql, sql, select, duplicate
Best practices for writing procedural SQL queries
Jon Peck
·
0 responses
·
php, mysql, sql, queries
SQL Pagination Without OFFSET
Stephan Sokolow
·
0 responses
·
sql, reference
Calculating Median in Sap Hana
Gefei
·
0 responses
·
sql, median, saphana
use sed -i to replace in place on a string in a file
Jupiter St John
·
0 responses
·
perl, shell, terminal, sed
Need to Create A New API Key For An App?
ErikJacobsen
·
0 responses
·
php, dreamfactory, api, api keys
Quick Ranking by attribute Rails/Heroku
Randy Morgan
·
0 responses
·
rails, heroku, sql, performance
Find similar functions between different programing languages
Mariz Melo
·
0 responses
·
ruby, php, python, perl
Django order_by random in Postgres
Nam Ngo
·
0 responses
·
python, sql, django, postgres
Postgres contains in array function
Daniel Alejandro Gaytán Valencia
·
0 responses
·
sql, postgresql
Use SQL WITH clause as a filter
Brian Jesse
·
0 responses
·
sql, oracle, with
SQL92 LIKE expression escaping in Arel's matches(_all) method
Kazuya Numata
·
0 responses
·
rails, activerecord, sql, like
Change the collation for all columns
Russell England
·
0 responses
·
mysql, sql, utf8
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.