Top 13 Java Sqlserver Projects

dbeaver

27 37,679 9.9 Java

Free universal database tool and SQL client

Project mention: DBeaver – open-source Database client | news.ycombinator.com | 2024-03-10

Yes but not in the community version:
https://github.com/dbeaver/dbeaver/wiki/Schema-compare

APIJSON

0 16,691 8.3 Java

🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.
InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Chat2DB

5 13,752 9.9 Java

🔥🔥🔥AI-driven data management platform Over 1 million developers are using Chat2DB

Project mention: LLMs and SQL | news.ycombinator.com | 2024-04-29

Flyway

81 7,801 7.2 Java

Flyway by Redgate • Database Migrations Made Easy.

Project mention: Let's write a simple microservice in Clojure | dev.to | 2024-04-26

The session logs show that the application loads configurations and establishes a connection with a PostgreSQL database. This involves initializing a HikariCP connection pool and Flyway for database migrations. The logs confirm that the database schema validation and migration checks were successful. The startup of the Jetty HTTP server follows, and the server becomes operational and ready to accept requests on the specified port.

jOOQ

94 5,905 9.8 Java

jOOQ is the best way to write SQL in Java

Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

> 2. ORMs do not hide SQL nastiness.
This is certainly true!
I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".
I think the are of ORMs is over. It simply did not deliver.
If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.
I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.
There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)
https://www.jooq.org/
https://hasura.io/

JSqlParser

4 4,984 9.4 Java

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
liquibase

54 4,416 9.9 Java

Main Liquibase Source

Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12

While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase

SaaSHub

www.saashub.com featured

SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Jailer

218 2,715 9.6 Java

Database Subsetting and Relational Data Browsing Tool.

Project mention: Jailer – open-source database client | news.ycombinator.com | 2024-04-30

GeoTools

1 1,638 9.4 Java

Official GeoTools repository
Ebean ORM

7 1,430 9.5 Java

Ebean ORM
symmetric-ds

12 696 9.5 Java

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: FLaNK Stack Weekly for 14 Aug 2023 | dev.to | 2023-08-14

MicrostarterCli

8 16 5.2 Java

A Simple tool that generates Micronaut Components
JSqlServerBulkInsert

1 12 5.3 Java

A library for bulk inserts to SQL Server Databases using Java

Project mention: Azure SQL how to use BULK Insert via JAVA JDBC | /r/AZURE | 2023-05-20

There's also a JSqlServerBulkInsert library that looks like a wrapper around SQLServerBulkCopy for working with lists of entities. This might work with your JdbcDetail type.

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

Java Sqlserver related posts

DBeaver – open-source Database client

10 projects | news.ycombinator.com | 10 Mar 2024

Index

What are some of the best open-source Sqlserver projects in Java? This list will help you:

	Project	Stars
1	dbeaver	37,679
2	APIJSON	16,691
3	Chat2DB	13,752
4	Flyway	7,801
5	jOOQ	5,905
6	JSqlParser	4,984
7	liquibase	4,416
8	Jailer	2,715
9	GeoTools	1,638
10	Ebean ORM	1,430
11	symmetric-ds	696
12	MicrostarterCli	16
13	JSqlServerBulkInsert	12