Top 10 Java Sqlserver Projects
Free universal database tool and SQL clientProject mention: SQLite is not a toy database | /r/programming | 2023-04-28
dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.
Flyway by Redgate • Database Migrations Made Easy.Project mention: Strategy to run database scripts on Kubernetes | /r/kubernetes | 2023-06-05
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.
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.
jOOQ is the best way to write SQL in JavaProject 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 parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor PatternProject mention: Semantic Diff for SQL | news.ycombinator.com | 2022-07-29
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 and it does produce an AST which can be parsed using the visitor-pattern 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.
Main Liquibase SourceProject 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.
Database Subsetting and Relational Data Browsing Tool.Project mention: Database subsetting and relational data browsing tool. | /r/linux | 2023-06-07
Jailer Database Tools.
Official GeoTools repositoryProject mention: Vulnerability in GeoTools with CVSS score of 9.8 | /r/gis | 2023-02-22
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.
Ebean ORMProject mention: loom and database drivers | /r/java | 2023-02-18
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.Project mention: Seamless integration of Databases | /r/PostgreSQL | 2023-02-17
There are several CDC (change data capture) solutions on the market. I've used https://www.symmetricds.org quite successfully in the past.
A Simple tool that generates Micronaut Components
What are some of the best open-source Sqlserver projects in Java? This list will help you: