Offset vs Cursor Based Pagination
5 min
Understand SQL pagination with practical examples, comparing offset and cursor methods to manage datasets efficiently.
Read post ›
How to reset the primary key sequence in Postgres
1 min
How can we fix the "duplicate key value violates unique constraint" error because the primary key sequence is out of sync from the records in the table
Read post ›
Dapper and NPGSql : Write a query with the IN operator
1 min
In this post, I look at what changes need to be made to write a query with the IN operator in a WHERE clause using Dapper and NPGSql
Read post ›