Welcome to the jasync-sql wiki!

jasync-sql is simple, async, Netty-based, performant and reliable database driver written in Kotlin. This is not supposed to be a JDBC replacement, these drivers aim to cover the common process of send a statement, get a response that you usually see in applications out there.

Supported databases:

• MySQL
• MariaDB - Not tested but should be compatible with MySQL.
• MemSQL - via the MySQL Driver.
• PostgreSQL
• CockroachDB - Using PostgreSQL driver (Not tested).

Content:

• Overview (This page)
• Getting started
• Configuring and Managing Connections
• Executing Statements
• Examples
• API Overview
• Type Safety
• Kotlin Specific API
• Native Transport & Unix Domain Socket
• Interceptors
• Migrating from Mauricio Driver
• Using the Object Pool
• FAQ
• Known Issues
• Links
• Internals
  • Connection Pool
  • Netty
  • Query Timeout
  • Supported Data Types
    • MySQL Types
    • PostgreSQL Types
  • MySQL Supported Protocol Encoding

Usually, querying a database include 3 layers: Driver API, Connection Pool, and ORM or another way to get type safety. This library has all those:

• A driver.
• A connection pool.
• a-la-JDBC type safety.

It is possible to use the driver separately and to write your own lib to provide other parts. scalike-jdbc-async did something similar to the original lib.