Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Saturday, November 16, 2013
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
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.
- A useful comparison of popular field types in several different databases.
- Um...
I guess I only had one link up about tables. Weird; I could have sworn there were two or three.
Subscribe to:
Posts (Atom)