These things are good. I do wish SQL had a different syntax, though. After learning XPath, it struck me that SQL really is an inheritor to COBOL's English-like syntax, which hampers its composability. For instance, WHERE and HAVING do the same thing, just before and after aggregation. This could be done with parentheses! Instead of SELECT FROM , how about a column-filtering operator? e.g. (*) That sort of thing.
You may or may not like SQLite3. I was pleasantly reintroduced to it when I had to extract data from sqlite3 databases on some bank CDs. I hadn't realized how well featured it had become.
The way SQLite3 works, it can be more of a drop-in replacement for legacy Excel and Access garbage. In cases where it doesn't make sense to set up a full blown SQL server (MS SQL Server or otherwise), that is.
Michael Prescott I mean, yes. The combination of where and having is totally a thing I'd like to see. Alas. Still, when compared to trying to do it in Excel? fuuuuuuck
Isaac Kuo That's need, but we've got sql servers to spare.
These things are good. I do wish SQL had a different syntax, though. After learning XPath, it struck me that SQL really is an inheritor to COBOL's English-like syntax, which hampers its composability. For instance, WHERE and HAVING do the same thing, just before and after aggregation. This could be done with parentheses! Instead of SELECT FROM , how about a column-filtering operator? e.g. (*) That sort of thing.
ReplyDeleteYou may or may not like SQLite3. I was pleasantly reintroduced to it when I had to extract data from sqlite3 databases on some bank CDs. I hadn't realized how well featured it had become.
ReplyDeleteThe way SQLite3 works, it can be more of a drop-in replacement for legacy Excel and Access garbage. In cases where it doesn't make sense to set up a full blown SQL server (MS SQL Server or otherwise), that is.
Michael Prescott I mean, yes. The combination of where and having is totally a thing I'd like to see. Alas. Still, when compared to trying to do it in Excel? fuuuuuuck
ReplyDeleteIsaac Kuo That's need, but we've got sql servers to spare.