Popular Sql Programming Tips
SQLite - get first weekday of current week
Noval Agung Prayogo
·
0 responses
·
sqlite, sql
Always include a WHERE clause in conditional UPDATE statements
Justin
·
0 responses
·
mysql, sql, update statements, safe updates
Stored Procedures and ActiveRecord
Yannick Schutz
·
2 responses
·
rails, activerecord, sql
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
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
Select all fields from a model without strings
Adan Alvarado
·
0 responses
·
rails, activerecord, sql, arel
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
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
sql query to delete orphaned post meta in your WordPress database
Thibault Milan
·
0 responses
·
mysql, sql, wordpress
Creating your own django lookup function
Hatem Nassrat
·
0 responses
·
django, python, sql, query
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
SQL Queries with Sublime Text and Ruby
Chris Kentfield
·
0 responses
·
ruby, sql, sublime-text-2
A simple PEG.js grammar to validate SQL selects
Haskell Camargo
·
0 responses
·
sql, compiler, grammar, peg
Using Postgres Functions in a Rails Model Scope
Brad Fults
·
0 responses
·
rails, activerecord, sql, postgres
SQL Optimisation :: Convert Primary Keys to Clustered Indexes
John Bevan
·
2 responses
·
sql, performance, index, tsql
Profiling queries in Zend Framework
Eric Valera Miller
·
0 responses
·
php, log, sql, zf
Find all tables without primary key in MySQL
Igor Moiseev
·
0 responses
·
mysql, sql, primary key