SQL tips that query better
Joins, indexes, and query notes that make the database work for you.
Related articles using Jaccard index
Oto Brglez
·
0 responses
·
ruby, sql, postgresql
How to Find and Delete Orphaned Records with Ruby on Rails
Anton Zolotov
·
0 responses
·
ruby, rails, activerecord, sql
Try your SQL queries online
Mariz Melo
·
0 responses
·
mysql, sqlite, sql, postgres
Translate SQL to MongoDB MapReduce
Bob Williams
·
0 responses
·
sql, mongodb, mapreduce, mongo
Stop writing Wordpress themes like its 1998
Ryan Berry
·
0 responses
·
coffeescript, rails, haml, sql
Make optimised and quick SQL queries
Sergey Romanov
·
1 response
·
sql, mysql-optimisation, query-optimisation, sql-optimisation
Use this plugin to have a heroku SQL console
Javier Toledo
·
0 responses
·
heroku, sql
PostgreSQL multiple column UNIQUE constraints with NULLs are not UNIQUE
S. Brent Faulkner
·
0 responses
·
sql, unique, constraint, postgresql
MySQL: Select all indexes from all tables in a given MySQL databbase
Stilliard
·
0 responses
·
mysql, sql, statistics, database
how to disable RavenDB's caching
19nine78
·
0 responses
·
sql, nosql, ravendb
Creating a (lot of) DBLink in Oracle
Bruno "Clef"
·
0 responses
·
sql, oracle, db link, script
Delete duplicate rows
Russell England
·
1 response
·
mysql, sql, duplicates, postgresql
Parsing delimited/serialized fields in SQL Server
Lyndsy Simon
·
0 responses
·
sql, sql-server
Lottery Drawing SQL, Rails scope :)
George
·
0 responses
·
activerecord, sql, schema, db
Multiple SQL column delete and create using Regex
Macs Dickinson
·
0 responses
·
sql, regex, productivity
Splitting up your GeographyCollection's into seperate Polygons in Sql Server 2012 [Part 1 of 2]
Pure Krome
·
0 responses
·
sql, geography, sqlserver, spatial
Wish to execute SQL in Command Prompt?
Karthik Sirasanagandla
·
0 responses
·
shell, sql, unix, database
Postgresql Unique K-ordered 64-bit Integer Generator
Anton Sekatski
·
2 responses
·
sql, database, postgresql, plpgsql
Rails : model and migrate
Mariz Melo
·
0 responses
·
ruby, mvc, rails, sql
PostgreSQL for WordPress
Simon Koch
·
0 responses
·
sql, plugin, database, postgresql
Postgres: Add Sequential PKEY
Cathy Wise
·
0 responses
·
sql, postgresql, databases, quickfix
Get latest friends' FB status updates
Filippo Valsorda
·
0 responses
·
sql, facebook, api
Find SQL Server tables containing a given column name
Sharon Cichelli
·
0 responses
·
sql, schema, sql server
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.