News for hackers. Stuff that matters.
Re:Modern SQL in PostgreSQL by juliangregorian on Monday February 09, 2015 @04:00AM (#9020264)
I often find myself wishing that SQL had a more uniform syntax. So much of it resembles COBOL to me, with all the capital letters and "english-like" arbitrary word order. At the same time, relational algebra exists and is very elegant, in an APL-like way. Would be very interested if there was a project to expose such an api to SQL databases.
Re:Modern SQL in PostgreSQL by ris on Monday February 09, 2015 @07:56PM (#9024775)
SQLAlchemy (for python) tries to sanitize the syntax away from SQL with some level of success.
Re:Modern SQL in PostgreSQL by collyw on Monday February 09, 2015 @04:29AM (#9020321)
SQL is case insensitive. It is a bit quirky though.
Re:Modern SQL in PostgreSQL by domoarevil on Monday February 09, 2015 @08:28AM (#9021013)
Indeed, something people forget sometimes leading to collation problems in the (odd) instance when CS is set.
Re:Modern SQL in PostgreSQL by juliangregorian on Monday February 09, 2015 @04:45AM (#9020376)
True, but very few people write it as anything but.