Another Linux lie: we have a DB engine

Truth is, you kind of do but not really.

Enter MySQL, the supposedly top DB. Its SQL syntax has LIMIT and OFFSET keywords, but their arguments are constants. I grant you that constant LIMIT is quite acceptable, but only a terminal genius could have decided that a constant OFFSET is acceptable.

Dudes, offset is for paging, and when you flip the 1st page, your zero offset should become whatever the size of your page is, in records, i.e. 50 for example. Next, it should become 100. How on Earth are we supposed to page our result sets, if OFFSET is a constant? By using nothing but dynamic SQL? Yuck!

Bottom line is, a DB engine cannot be considered top, not even production-ready, if it has such an absurd, idiotic limitation.

Genius is as genius does: always as a degenerate.

Posted by: LinuxLies at 10:54 AM | No Comments | Add Comment
Post contains 155 words, total size 1 kb.