Managing Large Datasets in AdonisJS with Lucid Pagination
Stop loading entire tables into memory. Learn how to use AdonisJS Lucid's .paginate() method to implement efficient, database-level data slicing and prevent server crashes.
Loading…
ReadMeFeed / Community knowledge
#lucid-orm
Real questions. Useful conversations. Find the people who know your stack.
adonisjsStopping the N+1 Leak: Mastering Eager Loading in AdonisJS Lucid
Stop database CPU spikes by eliminating N+1 queries in AdonisJS. Learn how to use Lucid's preload method for eager loading, nested relationships, and constrained data retrieval.
nodejsDeciding How to Paginate List Endpoints in AdonisJS 6 with Lucid
Lucid's paginate() handles most AdonisJS list endpoints out of the box. The real decisions are capping client-supplied page sizes in one place and knowing when offset pagination stops scaling.
AdonisJS Lucid and PostgreSQL JSONB object serialization at the model boundary
The goal is to read a PostgreSQL JSONB column through an AdonisJS Lucid model as a plain JavaScript object after fetch, and to write a plain object back on save without manual stringification in application code. Lucid does not document guaranteed automatic JSONB casting, and behavior may differ between AdonisJS 5 and Lucid in AdonisJS 6. The node-pg type pa
Does AdonisJS provide built-in idempotency-key handling for transaction retries?
When a client retries a write request after a network timeout, the server may have already committed the transaction before the response was lost. Lucid transactions roll back only when the callback throws, so a client-side timeout does not guarantee the work was aborted. Without a deduplication mechanism, the retry can create a duplicate record even though
Missing $fillable declaration permits unintended field mass-assignment in AdonisJS Lucid APIs
AdonisJS Lucid models declare mass-assignable fields through an explicit $fillable array; when this property is absent, all public attributes are writable via API payloads. This default, shifted to opt-in status in AdonisJS 5.x, means that models without a defined $fillable expose every column to potential modification through resourceful routes. When route