Top 23 Java SQL Projects
-
install DBeaver because it's better anyway DBeaver fails to download plugins from server because of outdated SSL certificates "fixed in early access version" install early access version realize it's the same version that was already published not fixed
-
Project mention: Avro SpecificRecord File Sink using apache flink is not compiling due to error incompatible types: FileSink<?> cannot be converted to SinkFunction<?> | reddit.com/r/apacheflink | 2021-09-14
[1]: https://mvnrepository.com/artifact/org.apache.avro/avro-maven-plugin/1.8.2 [2]: https://github.com/apache/flink/blob/master/flink-connectors/flink-connector-files/src/main/java/org/apache/flink/connector/file/sink/FileSink.java [3]: https://ci.apache.org/projects/flink/flink-docs-master/docs/connectors/datastream/file_sink/ [4]: https://github.com/apache/flink/blob/c81b831d5fe08d328251d91f4f255b1508a9feb4/flink-end-to-end-tests/flink-file-sink-test/src/main/java/FileSinkProgram.java [5]: https://github.com/rajcspsg/streaming-file-sink-demo
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
How about batch insert, updates, and deletes? I had to fix a broken MyBatis project recently and was surprised that this feature doesn't even seem to be implemented, at least according to this GitHub issue.
-
Project mention: Learn how to use ShardingSphere version 5.0 in a practical scenario case integrating data sharding, read/write splitting, and data encryption & decryption. Details below, no paywall: | reddit.com/r/programming | 2021-12-23
-
Project mention: Let's write a compiler, part 5: A code generator | news.ycombinator.com | 2021-08-19
-
-
Project mention: Misunderstandings about deploying, docker, and databases | reddit.com/r/learnprogramming | 2021-12-21
I use a schema versioning tool in the application repo. The one I use is called Flyway and is often used for JVM based applications.
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
Project mention: Jinja2 not formatting my text correctly. Any advice? | reddit.com/r/learnpython | 2021-12-10
ListItem(name='Apache Beam', website='https://beam.apache.org/', category='Batch Processing', short_description='Apache Beam is an open source unified programming model to define and execute data processing pipelines, including ETL, batch and stream processing'),
-
Trino
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
-
Project mention: How does jooq do Prepared statements for DDL in Postgres | reddit.com/r/jOOQ | 2022-01-19
Then test that against your pgjdbc driver version and server version, to remove jOOQ from the equation. Pretty sure, this issue has nothing to do with jOOQ directly, although I think we could add some convenience in the future to work around having to specify the Settings.statementType for DDL statements manually in case a static statement is preferred: https://github.com/jOOQ/jOOQ/issues/12901
-
OrientDB
OrientDB is the most versatile DBMS supporting Graph, Document, Reactive, Full-Text and Geospatial models in one Multi-Model product. OrientDB can run distributed (Multi-Master), supports SQL, ACID Transactions, Full-Text indexing and Reactive Queries.
I think the best multi-modal with a high focus on their graph-side outside of Neo4j for the last few years has been OrientDB.
-
-
Project mention: Which library/project do you wish was ported to golang? | reddit.com/r/golang | 2022-01-09
Apache Ignite https://ignite.apache.org/
-
JSqlParser
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.
-
Crate
CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.
Project mention: Parser generators vs. handwritten parsers: surveying major languages in 2021 | news.ycombinator.com | 2021-08-21 -
-
-
Project mention: SQL - Moving from concatenated queries to parameterized queries | reddit.com/r/learnprogramming | 2022-01-05
However, if you’re concerned if these queries will continue to work as before, I would recommend investing in creating tests for these. Using an in-memory database such as H2 or using Testcontainers, perhaps mixed with Liquibase to automate database updates, would allow you to create a stable database on which you can perform and test your queries.
-
Project mention: Anyone know of any software that can help in designing then outputting to various database | reddit.com/r/DatabaseHelp | 2021-11-21
Abstraction Layer - You can use something like Calcite to abstract out your data storage. https://calcite.apache.org/
-
I use Spotless and it works quite well, but there are many other options. Also good IDEs can reformat your code.
-
Project mention: Apache Drill: the reports of my death have been greatly exaggerated | news.ycombinator.com | 2021-11-01
>We’ve started talking about speeding up our release cadence to better reflect our recent activity.
There's been only one release per year in the past so you can't fault anyone to think the project is dead.
-
JDBI
jdbi is designed to provide convenient tabular data access in Java; including templated SQL, parameterized and strongly typed queries, and Streams integration
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.
-
There is https://ebean.io/ and looks like it a community driven alternative to jOOQ.
Java SQL related posts
- How does jooq do Prepared statements for DDL in Postgres
- Which O/S libraries does your Java code *interact* with the most?
- questdb: NEW Data - star count:7726.0
- questdb: NEW Data - star count:7726.0
- questdb: NEW Data - star count:7726.0
- questdb: NEW Data - star count:7726.0
- questdb: NEW Data - star count:7726.0
Index
What are some of the best open-source SQL projects in Java? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | dbeaver | 24,162 |
| 2 | Apache Flink | 18,010 |
| 3 | MyBatis | 16,715 |
| 4 | shardingsphere | 15,116 |
| 5 | Presto | 13,043 |
| 6 | QuestDB | 7,781 |
| 7 | Flyway | 6,326 |
| 8 | beam | 5,218 |
| 9 | Trino | 4,745 |
| 10 | jOOQ | 4,725 |
| 11 | OrientDB | 4,401 |
| 12 | Apache Hive | 4,083 |
| 13 | Apache Ignite | 4,050 |
| 14 | JSqlParser | 3,455 |
| 15 | Crate | 3,270 |
| 16 | H2 | 3,126 |
| 17 | requery | 3,073 |
| 18 | liquibase | 2,933 |
| 19 | Apache Calcite | 2,864 |
| 20 | spotless | 2,324 |
| 21 | Apache Drill | 1,624 |
| 22 | JDBI | 1,593 |
| 23 | Ebean ORM | 1,270 |
Are you hiring? Post a new remote job listing for free.
