infovore + sql   11

UNION with Active Record - The Pug Automatic
Turns out I really shouldn't have been messing with ARel: this seems more sane.
union  postgresql  sql  activerecord  ruby  rubyonrails 
february 2016 by infovore
Useful temporal functions & queries | code.openark.org
"Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations. There are many ways to solve such problems. I’ll present my favorites." These are, indeed, useful, and I've been using a few of them recently.
mysql  tips  programming  databases  sql 
december 2009 by infovore
SQL pie chart | code.openark.org
"My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people." Generating ASCII pie charts with a single SQL query. It's a very, very big query. It's a bit crazy.
sql  mysql  ascii  graphics  programming  visualization  sick 
august 2009 by infovore
qwantz: "select" is a workhorse, "update" is as routine as a pair of pants. "coalesce" is something special
Ryan North makes a little poem dedicated to the COALESCE function in MySQL. He's right: it's super useful.
databases  mysql  poem  ryannorth  poetry  programming  sql  coalesce 
june 2009 by infovore
Coding Horror: A Visual Explanation of SQL Joins
An even better explanation of SQL joins via Venn Diagrams. Already saved some bacon today, I can tell you.
sql  diagrams  illustration  join  syntax 
october 2007 by infovore
Pivotal Blabs : HasFinder -- It's Now Easier than ever to create complex, re-usable SQL queries
"HasFinder is an extension to ActiveRecord that makes it easier than ever to create custom find and count queries." Looks excellent. Might well be making use of this.
rails  activerecord  sql  plugin  finders 
september 2007 by infovore
RubyForge: Sequel: Project Info
Nice database front-end that's not a full ORM, but useful for boring db maintenance, that's for sure.
ruby  sql  database 
july 2007 by infovore
How to find the max row per group in SQL without subqueries - Xaprb
As with so many other SQL challenges, if you re-phrase the question, it’s easy to select the maximum or minimum row per group without subqueries. The key is to understand what you want, and to be able to word the problem in a way that translates from En
sql  mysql  database  programming  performance  howto 
may 2007 by infovore
A Gentle Introduction to SQL
Really, really good online tutorial of SQL queries. Need to go over this again
SQL  query  tutorial  online 
january 2005 by infovore

Copy this bookmark:



description:


tags: