sql2o
OBridge
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sql2o
-
Are there recommended approach working with Database except Panache/Hibernate ?
Mostly i think because in our Kubernetes - the max resources allocated for single service instance - 2gb ram + 4vcore (2vcore, for 4 there is special agreement process). Under load i often see high memory pressure (gc count, high pauses, etc.). But handling http requests and dealing with CRUD is not a big problem. The huge difference appears during data batch upload into big-data system. The only service which was able to upload it's database faster than 300k record/s+ (peak ingestion) is using https://github.com/aaberg/sql2o + https://vertx.io/docs/vertx-pg-client/java/ . I don't remember numbers for services which use hibernate, but they mostly are very low.
OBridge
We haven't tracked posts mentioning OBridge yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
JDBI - The Jdbi library provides convenient, idiomatic access to relational databases in Java and other JVM technologies such as Kotlin, Clojure or Scala.
JetBrains Xodus - Transactional schema-less embedded database used by JetBrains YouTrack and JetBrains Hub.
jOOQ - jOOQ is the best way to write SQL in Java
Apache Phoenix - Apache Phoenix
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
H2 - H2 is an embeddable RDBMS written in Java.
EVCache - A distributed in-memory data store for the cloud
Presto - The official home of the Presto distributed SQL query engine for big data
Crate - CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.