Java Sqlserver

Open-source Java projects categorized as Sqlserver

Top 10 Java Sqlserver Projects

  • dbeaver

    Free universal database tool and SQL client

    Project 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

    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.

  • 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.

  • jOOQ

    jOOQ is the best way to write SQL in Java

    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

    Project 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[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.

    [0]: https://github.com/JSQLParser/JSqlParser

    [1]: https://en.wikipedia.org/wiki/Visitor_pattern

  • liquibase

    Main Liquibase Source

    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 Subsetting and Relational Data Browsing Tool.

    Project mention: Database subsetting and relational data browsing tool. | /r/linux | 2023-06-07

    Jailer Database Tools.

  • GeoTools

    Official GeoTools repository

    Project mention: Vulnerability in GeoTools with CVSS score of 9.8 | /r/gis | 2023-02-22
  • 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.

  • Ebean ORM

    Ebean ORM

    Project mention: loom and database drivers | /r/java | 2023-02-18
  • 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.

    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.

  • MicrostarterCli

    A Simple tool that generates Micronaut Components

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-06-07.

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
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com