Kenneth Kreindler

Posted a solution that worked for me in #91

Having the same problem.

The solution in #77 did not work for me. I found a workaround that did work in my case. ### My case When using the back button from the stack...

If you are using a newer DB like Mysql 8.0 OFFSET AND t1.userCommentNum < LIMIT ``` [https://docs.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver15](https://docs.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver15 ) Pretty simple and if you use a query builder like typeORM you...

> My brain storming here. > > How about `UNION ALL` and `limit`, mixing solutions from @onderonur @klausXR ? > > I didn't test huge data performance, but it looks...

> @KDKHD > Thanks for pointing out. I don't have performance benchmarks yet, but this project actually uses `UNION` to paginate related tables. > > https://lighthouse-php.com/ > > Yeah ORM...

I've been checking out [postgraphile](https://github.com/graphile/postgraphile) which builds pretty compact queries. This is my gql query: ``` { galleries { nodes { galleryItems(offset: 2, first: 3) { nodes { mediaId }...

> If you are using a newer DB like Mysql 8.0 > ``` > SELECT * FROM > (SELECT > ROW_NUMBER() OVER(PARTITION BY userId ORDER BY commentId ASC) > AS...

I get `Property 'plugin' does not exist on type 'typeof Decoration'.`

Using a ref to store the "isDragged" state works well for me. ```tsx const Parent: React.FC = () => { const draggedRef = useRef(false) return ( { draggedRef.current = true...