pagination

[tyfncn]

Thanks for a good database adapter for peewee. Just starting to like this, then I find out paging is still in your TODO list. Are you planning to add it sometime soon?

[ribx]

The code says:

    # TODO: implement limit and offset properly, we can use:
    # SELECT *
    # FROM (SELECT ROW_NUMBER() OVER(ORDER BY id) RowNr, id FROM tbl) t
    # WHERE RowNr BETWEEN 10 AND 20

I never used MsSQL, but how about this:
https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx

[ribx]

looks like it took Microsoft until SQL Server 2012 to fix this:

https://dba.stackexchange.com/questions/136259/offset-fetch-in-sql-server-2008

That's quite frustrating.

[COUR4G3]

I only ever used this with older version of MSSQL (2005 and 2008) and the pagination looked very frustrating to implement. It looks simple enough to implement in 2012+ but I don't use MSSQL anymore so hard to find time to code it.

[COUR4G3]

Will probably start looking at this issue again in the next month, since I will be probably end up working with MSSQL again - both 2005/2008 and 2016.

[stefanjcollier]

Not so much an issue, more an FYI. There is another chap attempting (or at least got further with) pagination:

https://github.com/brake/peewee_mssql