<img width="550" alt="jasync-sql" src="resources/jas.png" style="max-width:100%;">

[](https://gitter.im//jasync-sql/support) [](https://search.maven.org/search?q=g:%22com.github.jasync-sql%22%20AND%20a:%22jasync-common%22)  [](https://github.com/jasync-sql/jasync-sql/blob/master/LICENSE) [](https://codecov.io/gh/jasync-sql/jasync-sql) [](https://github.com/KotlinBy/awesome-kotlin#libraries-frameworks-database)

[jasync-sql](https://github.com/jasync-sql/jasync-sql) is a Simple, Netty based, asynchronous, performant and reliable database drivers for

PostgreSQL and MySQL written in Kotlin.

[Show your ❤ with a ★](https://github.com/jasync-sql/jasync-sql/stargazers)

Connection connection = MySQLConnectionBuilder.createConnectionPool(

"jdbc:mysql://$host:$port/$database?user=$username&password=$password");

Connection connection = PostgreSQLConnectionBuilder.createConnectionPool(

"jdbc:postgresql://$host:$port/$database?user=$username&password=$password");

CompletableFuture<QueryResult> future = connection.sendPreparedStatement("select * from table");

connection.disconnect().get()

See a full example at [jasync-mysql-example](https://github.com/jasync-sql/jasync-mysql-example) and [jasync-postgresql-example](https://github.com/jasync-sql/jasync-postgresql-example).

More samples on the [samples dir](https://github.com/jasync-sql/jasync-sql/tree/master/samples).

For docs and info see the [wiki](https://github.com/jasync-sql/jasync-sql/wiki).

<dependency>

<groupId>com.github.jasync-sql</groupId>

<artifactId>jasync-mysql</artifactId>

<version>2.0.3</version>

</dependency>

<dependency>

<groupId>com.github.jasync-sql</groupId>

<artifactId>jasync-postgresql</artifactId>

<version>2.0.3</version>

</dependency>

This project is a port of [mauricio/postgresql-async](https://github.com/mauricio/postgresql-async) to Kotlin.

Why? Because the original lib is not maintained anymore, We use it in [ob1k](https://github.com/outbrain/ob1k), and would like to remove the Scala dependency in ob1k.

If you want information specific to the drivers, check the [PostgreSQL README](postgresql-async/README.md) and the

[MySQL README](mysql-async/README.md).

You can view the project's change log [here](CHANGELOG.md).

**Follow us on twitter: [@jasyncs](https://twitter.com/Jasyncs).**

Version 1.x always returns [JodaTime](http://joda-time.sourceforge.net/) when dealing with date types and not the

`java.util.Date` class nor jdk-8 dates.

Version 2.x works with java 8 DateTime objects (`java.time.LocalDateTime` and such).

This [post](https://blog.joda.org/2014/11/converting-from-joda-time-to-javatime.html) can help with migration.

* [R2DBC](https://r2dbc.io/)

* [Spring Data R2DBC](https://spring.io/projects/spring-data-r2dbc)

* [Vert.x](https://github.com/vert-x3/vertx-mysql-postgresql-client)

* [micronaut](https://github.com/micronaut-projects/micronaut-sql)

* [Outbrain/ob1k-db](https://github.com/outbrain/ob1k/)

* https://github.com/humb1t/jpom

* [Zeko Data Mapper](https://github.com/darkredz/Zeko-Data-Mapper) and [Zeko SQL Builder](https://github.com/darkredz/Zeko-SQL-Builder)

* [vertx-jooq async module](https://github.com/jklingsporn/vertx-jooq)

* [ScalikeJDBC Async](https://github.com/scalikejdbc/scalikejdbc-async)

* [Quill](https://getquill.io/)

* [Jasync SQL Extensions](https://github.com/28Smiles/jasync-sql-extensions)

Add your name here!

Is it used in production on large scale?

<img width="550" alt="jasync-sql-production" src="resources/production.png" style="max-width:100%;">

The graph above is from only couple of services using it. Y-Axis is # of queries per minute.

There is also a [TechEmpower test](https://github.com/TechEmpower/FrameworkBenchmarks/pull/4247) using `ktor` and `jasync-sql`.

[Zeko SQL Builder](https://github.com/darkredz/Zeko-SQL-Builder#performance) compared jasync to hikary and vertex:

<img width="550" alt="jasync-sql-zeko" src="https://github.com/darkredz/Zeko-SQL-Builder/blob/master/zeko-sql-builder-benchmark.jpeg" style="max-width:100%;">

* Check [FAQ](https://github.com/jasync-sql/jasync-sql/wiki/FAQ) or [Known Issues](https://github.com/jasync-sql/jasync-sql/wiki/Known-Issues) or [google](https://www.google.com/search?q=jasync-sql).

* Open an issue here: https://github.com/jasync-sql/jasync-sql/issues

* Chat on gitter: https://gitter.im/jasync-sql/support

* Ask a question in StackOverflow with [jasync-sql](https://stackoverflow.com/questions/tagged/jasync-sql) tag.

* [How we cloned the original lib](https://hackernoon.com/how-i-ported-10k-lines-of-scala-to-kotlin-in-one-week-c645732d3c1).

* https://github.com/mauricio/postgresql-async - The original (deprecated) lib.

* [Async database access with MySQL, Kotlin and jasync-sql](https://medium.com/@OhadShai/async-database-access-with-mysql-kotlin-and-jasync-sql-dbfdb8e7fd04).

* [Issue with NUMERIC](https://medium.com/@OhadShai/sometimes-a-small-bug-fix-can-lead-to-an-avalanche-f6ded2ecf53d).

* [jasync-sql + javalin example](https://medium.com/@OhadShai/reactive-java-all-the-way-to-the-database-with-jasync-sql-and-javalin-c982365d7dd2).

* [jasync-sql + ktor + coroutines example](https://medium.com/@OhadShai/async-with-style-kotlin-web-backend-with-ktor-coroutines-and-jasync-mysql-b34e8c83e4bd).

* [jasync-sql + spring + kotlin example](https://github.com/godpan/spring-kotlin-jasync-sql).

* [How to implement an Object Pool with an Actor in Kotlin](https://medium.freecodecamp.org/how-to-implement-an-object-pool-with-an-actor-in-kotlin-ed06d3ba6257).

* [Coroutines usage](https://medium.com/@OhadShai/just-a-small-example-of-how-kotlin-coroutines-are-great-c9774fe8434).

* [Spring Data R2DBC video](https://www.youtube.com/watch?v=DvO4zLVDkMs).

* [JDBC for Spring WebFlux: Spring Data R2DBC](https://medium.com/w-logs/jdbc-for-spring-webflux-spring-data-r2dbc-99690208cfeb).

* [Spring WebFlux는 어떻게 적은 리소스로 많은 트래픽을 감당할까?](https://alwayspr.tistory.com/44).

Pull requests are welcome!

See [CONTRIBUTING](CONTRIBUTING.md).