Implement Optimistic Concurrency in NHibernate 5.x with a Version Column
Map a version column, carry it across web requests, handle StaleObjectStateException with a bounded retry, and verify the UPDATE’s WHERE clause enforces the check.
Loading…
ReadMeFeed / Community knowledge
#orm
Real questions. Useful conversations. Find the people who know your stack.
dotnet
nhibernateStop the N+1 Nightmare: Mastering Django’s select_related and prefetch_related
Learn how Django’s select_related and prefetch_related solve the N+1 query problem. A step‑by‑step example with Book, Author, and Tag models shows query counts before and after optimization, plus trade‑offs to watch out for.
djangoServer-Side Pagination in CakePHP 4.x with Query::paginate() and Scoped Finders
Paginate finder-scoped queries in CakePHP 4.x using ORM Query::paginate(), clamp the limit parameter, and verify LIMIT/OFFSET in the generated SQL.
cakephpMoving to SQLAlchemy 2.0: Replacing session.query() with select()
Stop using session.query(). Learn how SQLAlchemy 2.0's unified select() API decouples query construction from execution for better typing and composability.
python
sqlalchemyEliminating N+1 Queries in Django with select_related and prefetch_related
Learn how Django's select_related and prefetch_related turn N+1 query patterns into a constant number of efficient queries, with a concrete Book‑Author‑Genre example and verification steps.
Efficient Large‑Dataset Pagination with Hibernate ORM
Learn how to replace slow OFFSET pagination with cursor‑based keyset pagination in Hibernate, tune fetch size, and stream results with ScrollableResultSet for constant‑memory large‑dataset access.
hibernate
javaSequelize Pagination With findAndCountAll: Count Handling, Association Quirks, and When to Switch to Keyset
A practical guide to Sequelize pagination using findAndCountAll, handling count queries with includes, avoiding OFFSET pitfalls at scale, and switching to keyset patterns when needed.
Cutting Repeat Database Trips with NHibernate's Second-Level Cache and SysCache2
Repeatedly loading the same reference data on every request wastes database round-trips. Here's how NHibernate's second-level cache with the SysCache2 provider fixes that — and where it falls down.
Eager Loading with CakePHP’s contain(): One Call, Zero Per‑Row Queries
Eager loading with CakePHP’s contain() lets you fetch related data in a fixed number of queries. Learn how to use contain() for Articles, Authors and Comments, avoid common pitfalls, and verify the SQL output with DebugKit.