sah
Joined 18 years ago
Joined 18 years ago
I've spent many years using schemas, and I know well how they work and what they achieve. I'm saying they're a lousy tradeoff.
My primary point was just that SQL is old, and I think the reason it is the way it is has more to do with history and compatibility than what we'd want it to look like if we started from scratch today.
SQL is still around because it was successful. And there are reasons to value compatibility, and to avoid changing things for no reason. But my personal experience using a database without using SQL was pleasant, and I'm anxious to see the world move on to something new and improved.
My point is, people still do this. You never hear about REST-injection or memcached-injection attacks, even though those are possible in principle, because those protocols don't encourage this mistake the way using SQL as a database API does.
One thing I would say about postgres is that it has a lot of features. As a new user, it's hard to know which ones to use in which ways, and what the downsides might be.
YouTube videos: https://www.youtube.com/user/hackerdashery
My twitter feed: http://twitter.com/sahazel
My website: http://awesame.org/
Side projects: http://codepad.org/ http://omgaudio.com/incoherence/