Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Saturday, November 16, 2013

Mandelbrot set in SQL

Betcha didn't see that coming.

Saturday, November 2, 2013

How Craig Kerstiens writes SQL

I guess I was on a modeling tear in May (I can hardly even remember May at this point; it's been a busy year).  Anyway, this is a nice little guide about how one PostgreSQL expert thinks about carefully constructed SQL.

Sunday, December 16, 2012

Holy schemoley, SQL::Translator exists!

Now I don't have to write it!  Manual here!  Holy Toledo, what a fantastic thing this is!

Friday, December 7, 2012

SQL injection for fun and profit

An absolutely fantastic article about SQL injection.  Don't treat SQL like a string! You will come to regret it.

Sunday, November 6, 2011

Underrated Features of PostgreSQL

Another good survey.

Clojure DML for SQL

Interesting - this is the conceptual-level kind of thing that fascinates me.

Tuesday, August 30, 2011

ORMs don't kill databases - people do

A cogent article about how wrapping your SQL in an ORM can get you quick returns - until it does something boneheaded. Better to isolate your SQL in a transparent manner like I'm planning, right? Right.

Sunday, February 13, 2011

MySQL explicit query strategy

I'm not sure how best to go about codifying this sort of knowledge, but ... it's an interesting short read.

Saturday, February 5, 2011

Wrestling with SQL for real

I'm down to the wire on table definitions and trying to come up with a good way to combine quick-and-dirty things with more careful solutions. I think the current implementation of the table tag is going to do the trick.

Here's a bit of a link dump.
I guess I only had one link up about tables. Weird; I could have sworn there were two or three.