Slick - Scala Language Integrated Connection Kit

API Documentation (scaladoc)

• Slick
• Slick TestKit
• Slick Code Generator
• Slick Extensions

User Manual

• Introduction
  • What is Slick?
  • Features
  • Supported database systems
  • License
  • Compatibility Policy
  • Query APIs
  • Lifted Embedding
• Getting Started
• Adding Slick to Your Project
• Quick Introduction
  • Database Connection
  • Schema
  • Populating the Database
  • Querying
• Migration Guide from Slick 1.0 to 2.0
  • Code Generation
  • Table Descriptions
  • Mapped Tables
  • Profile Hierarchy
  • Inserting
  • Pre-compiled Updates
  • Database and Session Handling
  • Dynamically and Statically Scoped Sessions
  • Mapped Column Types
• Coming from SQL to Slick
  • Schema
  • Queries in comparison
    • JDBC Query
    • Slick Plain SQL queries
    • Slick type-safe, composable queries
  • Main obstacle: Semantic API differences
  • Scala-to-SQL compilation during runtime
  • Limitations
    • Missing query operators
    • Unsupported JDBC features
    • Non-optimal SQL code
  • SQL vs. Slick examples
    • select *
    • select
    • where
    • order by
    • Aggregations (max, etc.)
    • group by
    • having
    • Implicit join
    • Explicit join
    • left/right/outer join
    • Subquery
    • Scalar value subquery / custom function
    • insert
    • update
    • delete
• Connections / Transactions
  • Database connection
    • Using a JDBC URL
    • Using a DataSource
    • Using a JNDI Name
  • Session handling
    • Automatically closing Session scope
    • Implicit Session
    • Transactions
    • Manual Session handling
    • Passing sessions around
    • Dynamically scoped sessions
  • Connection Pools
  • JDBC interoperability
• Schema code generation
  • Overview
  • Standalone use
  • Integrated into sbt
  • Generated Code
  • Warning
  • Customization
• Schemas
  • Table Rows
  • Table Query
  • Mapped Tables
  • Constraints
  • Data Definition Language
• Queries
  • Expressions
  • Sorting and Filtering
  • Joining and Zipping
  • Unions
  • Aggregation
  • Querying
  • Deleting
  • Inserting
  • Updating
  • Compiled Queries
• User-Defined Features
  • Scalar Database Functions
  • Other Database Functions And Stored Procedures
  • Using Custom Scalar Types in Queries
  • Using Custom Record Types in Queries
    • Polymorphic Types (e.g. Custom Tuple Types or HLists)
    • Monomorphic Case Classes
    • Combining Mapped Types
• Plain SQL Queries
  • Scaffolding
  • DDL/DML Statements
  • Query Statements
  • String Interpolation
  • Other JDBC features
• Slick Extensions
• Direct Embedding (Experimental Feature)
  • Dependencies
  • Imports
  • Row class and schema
  • Query
  • Execution
  • Alternative direct embedding bound to a driver and session
  • Features
• Slick TestKit
  • Scaffolding
  • Driver
  • Test Harness
  • Database Configuration
  • Testing