All Projects → jasync-sql → Jasync Sql

jasync-sql / Jasync Sql

Licence: apache-2.0
Java & Kotlin Async DataBase Driver for MySQL and PostgreSQL written in Kotlin

Programming Languages

kotlin
9241 projects

Projects that are alternatives of or similar to Jasync Sql

Porsas
Experimental stuff for going fast with Clojure + JDBC & Async SQL
Stars: ✭ 78 (-92.86%)
Mutual labels:  reactive, sql, jdbc
Micronaut Data
Ahead of Time Data Repositories
Stars: ✭ 352 (-67.77%)
Mutual labels:  sql, jdbc
Vertx Jooq
A jOOQ-CodeGenerator to create vertx-ified DAOs and POJOs.
Stars: ✭ 299 (-72.62%)
Mutual labels:  reactive, jdbc
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+329.95%)
Mutual labels:  sql, jdbc
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
Stars: ✭ 4,581 (+319.51%)
Mutual labels:  sql, jdbc
Clojureql
ClojureQL is superior SQL integration for Clojure
Stars: ✭ 281 (-74.27%)
Mutual labels:  sql, jdbc
Kyuubi
Kyuubi is a unified multi-tenant JDBC interface for large-scale data processing and analytics, built on top of Apache Spark
Stars: ✭ 363 (-66.76%)
Mutual labels:  sql, jdbc
Grdbcombine
GRDB ❤️ Combine
Stars: ✭ 220 (-79.85%)
Mutual labels:  reactive, sql
Jailer
Database Subsetting and Relational Data Browsing Tool.
Stars: ✭ 576 (-47.25%)
Mutual labels:  sql, jdbc
Hibernate Springboot
Collection of best practices for Java persistence performance in Spring Boot applications
Stars: ✭ 589 (-46.06%)
Mutual labels:  sql, jdbc
Mycat2
MySQL Proxy using Java NIO based on Sharding SQL,Calcite ,simple and fast
Stars: ✭ 750 (-31.32%)
Mutual labels:  sql, jdbc
Doma
DAO oriented database mapping framework for Java 8+
Stars: ✭ 257 (-76.47%)
Mutual labels:  sql, jdbc
H2database
H2 is an embeddable RDBMS written in Java.
Stars: ✭ 3,078 (+181.87%)
Mutual labels:  sql, jdbc
Requery
requery - modern SQL based query & persistence for Java / Kotlin / Android
Stars: ✭ 3,071 (+181.23%)
Mutual labels:  sql, jdbc
delta
DDD-centric event-sourcing library for the JVM
Stars: ✭ 15 (-98.63%)
Mutual labels:  reactive, jdbc
Rxjava2 Jdbc
RxJava2 integration with JDBC including Non-blocking Connection Pools
Stars: ✭ 360 (-67.03%)
Mutual labels:  reactive, jdbc
Examples
Demo applications and code examples for Confluent Platform and Apache Kafka
Stars: ✭ 571 (-47.71%)
Mutual labels:  sql, jdbc
Lychee
The most complete and powerful data-binding library and persistence infra for Kotlin 1.3, Android & Splitties Views DSL, JavaFX & TornadoFX, JSON, JDBC & SQLite, SharedPreferences.
Stars: ✭ 102 (-90.66%)
Mutual labels:  reactive, jdbc
Ragtime
Database-independent migration library
Stars: ✭ 519 (-52.47%)
Mutual labels:  sql, jdbc
Spark
Apache Spark - A unified analytics engine for large-scale data processing
Stars: ✭ 31,618 (+2795.42%)
Mutual labels:  sql, jdbc
jasync-sql

Chat at https://gitter.im/jasync-sql/support Download Maven Central Build Status Apache License V.2 codecov Awesome Kotlin Badge

jasync-sql is a Simple, Netty based, asynchronous, performant and reliable database drivers for PostgreSQL and MySQL written in Kotlin.

Show your ❤ with a ★

Getting started

// Connection to MySQL DB
Connection connection = MySQLConnectionBuilder.createConnectionPool(
               "jdbc:mysql://$host:$port/$database?user=$username&password=$password");
     
// Connection to PostgreSQL DB    
Connection connection = PostgreSQLConnectionBuilder.createConnectionPool(
               "jdbc:postgresql://$host:$port/$database?user=$username&password=$password");

// Execute query
CompletableFuture<QueryResult> future = connection.sendPreparedStatement("select * from table");
// work with result ...
// Close the connection pool
connection.disconnect().get()

See a full example at jasync-mysql-example and jasync-postgresql-example.
More samples on the samples dir.

For docs and info see the wiki.

Download

Maven

<!-- mysql -->
<dependency>
  <groupId>com.github.jasync-sql</groupId>
  <artifactId>jasync-mysql</artifactId>
  <version>1.1.6</version>
</dependency>
<!-- postgresql -->
<dependency>
  <groupId>com.github.jasync-sql</groupId>
  <artifactId>jasync-postgresql</artifactId>
  <version>1.1.6</version>
</dependency>

Gradle

dependencies {
  // mysql
  compile 'com.github.jasync-sql:jasync-mysql:1.1.6'
  // postgresql
  compile 'com.github.jasync-sql:jasync-postgresql:1.1.6'
}

Overview

This project is a port of mauricio/postgresql-async to Kotlin.
Why? Because the original lib is not maintained anymore, We use it in ob1k, and would like to remove the Scala dependency in ob1k.

This project always returns JodaTime when dealing with date types and not the java.util.Date class. (We plan to move to jdk-8 dates).

If you want information specific to the drivers, check the PostgreSQL README and the MySQL README.

You can view the project's change log here.

Follow us on twitter: @jasyncs.

Who is using it

Add your name here!

Is it used in production on large scale?

jasync-sql-production

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

There is also a TechEmpower test using ktor and jasync-sql.

Zeko SQL Builder compared jasync to hikary and vertex:
jasync-sql-zeko

Support

More links

Contributing

Pull requests are welcome!
See CONTRIBUTING.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].