sql2o
Querydsl
| sql2o | Querydsl | |
|---|---|---|
| 1 | 6 | |
| 1,132 | 4,566 | |
| - | 0.5% | |
| 7.9 | 4.4 | |
| 17 days ago | 9 days ago | |
| Java | Java | |
| MIT License | Apache License 2.0 |
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.
Querydsl
-
PostgreSQL Is Enough
There is a bit of tooling needed but is already around. For Java for example I had very good experience with a combination of flyway [1] for migrations, testcontainers [2] for making integration tests as easy as unit tests and querydsl [3] for a query and mapping layer.
[1] https://github.com/flyway/flyway
[2] https://java.testcontainers.org/modules/databases/postgres/
[3] https://github.com/querydsl/querydsl
-
Apache Empire-Db: Full SQL Freedom for Java
http://querydsl.com/ also seems similar
-
Useful & Unknown Java Libraries - Piotr's TechBlog
As for JPA: I cannot miss the QueryDSL library for building typesafe queries. Another interesting alternative is Jinq, that provides a java stream api to query entities.
-
You might not need an ORM
> all I really want is a nice API for building queries (that actually supports all underlying database features) and automatic mapping of the results to whatever objects/structs and primitives the language supports.
For Java based solutions, check out https://www.jooq.org/ or http://querydsl.com/
-
How do access sql through java in the real world?
QueryDsl -- http://querydsl.com
- How to build SQL query strings?
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.
jOOQ - jOOQ is the best way to write SQL in Java
HikariCP - 光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Jinq - LINQ-style queries for Java 8
H2 - H2 is an embeddable RDBMS written in Java.
Apache Hive - Apache Hive
Presto - The official home of the Presto distributed SQL query engine for big data
Spring Data JPA - Simplifies the development of creating a JPA-based data access layer.
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.