Welcome to Squeryl

squeryl

A Scala ORM and DSL for talking with Databases with minimum verbosity and maximum type safety

Get Started

Write compiler validated statements

Squeryl statements that pass compilation won’t fail at runtime. Refactor your schema as often as is required, the Scala compiler and your IDE will tell you exactly which lines of code are affected.

Write declaratively

Write as declaratively as SQL, only with less boilerplate. SQL’s declarativeness is preserved, not encapsulated in a lower level API that requires imperative and procedural code to get things done.

Never repeat yourself

The Composability of Squeryl statements allows you to define them once and reuse them as sub queries within other statements.

We use Squeryl to enable better QA testing with less development effort and to enhance integrity of our database-driven applications.

Andy Katz, PhD
Chief Operating Officer, Genome DX

The best thing about Squeryl is its simplicity. It never tries to hide the database from you, or pretend that it's something that it's not.

Joe Zulli
Favado and Savings.com

Squeryl allows Broad Institute's Genomics Platform to manage a database backing our workflow manager, which orchestrates the analysis of petabytes of genomic data on a compute farm with thousands of cores.

Alec Wysoker
Broad Institute

Yubixi uses Squeryl for all of our server-side queries. Squeryl allows us to quickly design queries with type checking and syntax validation at compile time, ensuring that we catch most bugs before the code is even deployed.

Alan Honeycutt
CTO, Yubixi