JDBI Alternatives
Similar projects and alternatives to JDBI
-
-
Spring Data JPA
Simplifies the development of creating a JPA-based data access layer.
-
Mergify
Automate your Pull Request with Mergify. Mergify is the most powerful merge queue tool that offers speculative checks, batch merges, and multiple queueing options. Coordinated with any CI and fully integrated to GitHub. Get started or request a demo!
-
-
sql2o
sql2o is a small library, which makes it easy to convert the result of your sql-statements into objects. No resultset hacking required. Kind of like an orm, but without the sql-generation capabilities. Supports named parameters.
-
-
-
-
SonarLint
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
-
-
-
TypeORM
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB (Preview)
-
-
-
-
-
-
FrameworkBenchmarks
Source for the TechEmpower Framework Benchmarks project
-
-
-
JDBI reviews and mentions
-
What is a simple way to read from a Oracle DataBase and write to a text file, not using Spring Batch (but using Java)? Too complicated for Spring Batch.
Another option is JDBI, that helps you with mappings too while having less features than JPA: https://jdbi.org/
-
Struggling to understand how to set up Micronaut for an SQL app that uses repositories for inserts and SQL queries for queries.
Hi! I’m not familiar with this particular exception in combination with Micronaut, because my team has chosen to use JDBI rather than Hibernate.
-
Spring Data — Power of Domain Events
By the way, you probably don't need Spring Data and Hibernate, if you apply the Transaction Script pattern. Since all business rules are bound to services, Hibernate will bring overhead and not so many benefits. Instead, you could try to use JDBI, JOOQ or even plain JDBC.
-
ResultSet mapping library
I really like Jdbi which I feel has a very similar goal than your library.
-
Shenandoah in OpenJDK 17: Sub-millisecond GC pauses
There are plenty of alternatives to ORMs. We use JDBI (https://jdbi.org) which is dead simple and a happy medium between pure JDBC and a full blown ORM.
Even using the built-in JDBC support is an option with modern Java, PreparedStatement and ResultSet implement AutoClosable, which means you can write code like this:
try ( -
Stuck On Node database management. Should I use a different ORM? Should I use raw SQL?
Ideally I'd like to use something like https://jdbi.org/ - ORM which only does conversion from rows to objects, no other magic. But I don't think it exists for node.
-
DenoDB
* ...
At least for Java and Kotlin the awesome library jdbi ( https://jdbi.org/ ) implements a very useful hybrid approach.
One creates DAOs and Repositories to abstract away the DB and map results and arguments to/from objects on the fly. All while retaining full control over the SQL and all mapping aspects.
This way SQL and mapping can be optimized to leverage the features of each database (ie. PostgreSQL's array, UUID, hash and JSON types) or be handled generically.
The SQL loading can also be customized to read SQL from pure ".sql" files in resources/files or from inline specification via annotations.
The jdbi developers have in the past reacted very fast and competent to issue reports or PRs.
If find applications built using this library more easy to understand and also better performing than ones using a full-blown ORM.
-
Two lines change turned a 6 sec request to 300ms
I used to be in the camp of "ORM's are bad just write your own queries" but once the application grows to some extent and you are interacting with several rows of data across many different tables often you'll wish you had an ORM (or at the very least a SQL builder or even something ORM like but hand-written like https://jdbi.org/#_createsqlobject ).
-
C# - string vs. String is not a style debate
No dice. From the docs (https://jdbi.org/#_primitive_mapping):
- List.of is terrible
-
Ask HN: What stack would you use to build a CRUD web app on the JVM today?
I highly recommend the following stack:
JVM Language: Java 11+
Webserver: https://javalin.io/
Templating: https://j2html.com/
Enhanced html attributes: https://htmx.org/
Database helper: http://jdbi.org/
Sqlite or Postgres depending on the expected scale.
The startup time is very fast. I usually see times under a second, which makes iterative changes significantly less painful than something like Spring.
Also setup is ridiculously simple, just throw those libraries in a pom file and use a CDN for htmx. No front end build tools needed since htmx removes the need for most if not all of your javascript.
The whole setup feels kind of old school, but man it makes developing CRUD apps dead simple again.
Lastly, project onboarding is as simple as having someone download intelij and pulling the project. The built in maven and jdk to intelij is all they need. That is as long as you don't need them to run their own Dev database instance, but that's not the end of the world if you utilize docker.
Even if you decide on something else take a look at the above libraries, they're all pretty fantastic.
-
What would you use to start a new HTTP + SSR project with Java today?
https://jdbi.org fits that description pretty well
Stats
jdbi/jdbi is an open source project licensed under Apache 2.0 license which is not an OSI approved license.
Popular Comparisons
Are you hiring? Post a new remote job listing for free.