Server side paging using Common Table Expressions: If you're not into under-the-hood technobabble: do yourself a big favor and skip this post. Yesterday I've rewritten the query for fetching blog posts from the back-end database. Not only I wanted it to be cleaner written and faster, but my pal and I were also in desperate need of 'Previous entries' - 'Next entries' buttons at the bottom of the page (this is called paging). The addition of this tiny feature would allow us to reduce the number of posts shown on ...