finds.dev

balderdashy/waterline

An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more

View on GitHubHomepage ↗

★ 5,391JavaScriptMITupdated Dec 2022

// the take

Waterline is the ORM bundled with Sails.js, offering a single query API across MySQL, Postgres, MongoDB, and a handful of other datastores via a pluggable adapter layer. It works standalone but is clearly designed to live inside Sails. If you're not using Sails, there are better-maintained options.

The adapter model is genuinely well-thought-out — the query normalization layer (forge-stage-two-query, forge-stage-three-query) does real work translating a unified criteria object into whatever the underlying adapter needs. Async/await support landed in v0.13 and the API is clean for basic CRUD. The test suite covers edge cases in type casting, association types, and lifecycle callbacks in reasonable depth. The ontology utilities (get-model, get-attribute) that resolve cross-datastore associations at query time are a clever piece of work.

Last commit was December 2022 — this project is effectively unmaintained. The documentation lives entirely on the Sails website, which makes standalone usage a guessing game from source code and StackOverflow. Cross-adapter queries with complex joins are limited or unsupported depending on the adapter, which is a sharp edge you'll hit in any real schema. No TypeScript types, no support for modern Node.js features like ESM, and the adapter ecosystem outside of the four core databases has been rotting for years.

We read the README, the directory tree and a key source file in July 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
5,391
Forks
595
Language
JavaScript
License
MIT
Last commit
11 Dec 2022

// nearby

If waterline isn't quite it.

All repos →