Top 10 Java Sqlserver Projects
-
dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.
-
This is a 4th option, which should play nice with ArgoCD. The following example runs flyway as a k8s job. The desired migration changes are recorded as files within the chart. This helm chart can be integrated with your application (Using hooks to determine when the migration job is run) or run manually.
-
Sonar
Write Clean Java Code. Always.. Sonar helps you commit clean code every time. With over 600 unique rules to find Java bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
Project mention: Looking4Library: A GraphQL client that has query methods on the generated types | /r/typescript | 2023-06-04
You may have the fortune of being familiar with the jOOQ library for Java/JVM apps, that can generate domain models based on your database schema, as well as methods on these classes to perform queries. In case you're not, here an example Postgres schema:
-
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
I wonder if this is a topical thread to check if anyone is aware of a Java based solution to parse a CREATE VIEW statement to get a mapping between the view columns and the corresponding source table columns. I checked out jsqlparser[0] and it does produce an AST which can be parsed using the visitor-pattern[1] but was wondering if there is a more "out-of-the-box" solution. Due to various reasons, querying the database information schema is not an option I can pursue.
-
Project mention: Better alternatives to schemachange for Snowflake Database Object Deployment | /r/snowflake | 2023-05-20
I haven't used it for a number of years but it sounds like something like liquibase (https://www.liquibase.org/) might be what you're looking for.
-
Jailer Database Tools.
-
-
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
-
-
symmetric-ds
SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.
There are several CDC (change data capture) solutions on the market. I've used https://www.symmetricds.org quite successfully in the past.
-
Index
What are some of the best open-source Sqlserver projects in Java? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | dbeaver | 32,212 |
| 2 | Flyway | 7,200 |
| 3 | jOOQ | 5,450 |
| 4 | JSqlParser | 4,398 |
| 5 | liquibase | 3,892 |
| 6 | Jailer | 1,635 |
| 7 | GeoTools | 1,474 |
| 8 | Ebean ORM | 1,386 |
| 9 | symmetric-ds | 583 |
| 10 | MicrostarterCli | 13 |
