The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 Java MySQL Projects
-
InfluxDB
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.
-
shardingsphere
Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
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
-
Leetcode
Solutions to LeetCode problems; updated daily. Subscribe to my YouTube channel for more. (by fishercoder1534)
-
SuperMarket
设计精良的网上商城系统,包括前端、后端、数据库、负载均衡、数据库缓存、分库分表、读写分离、全文检索、消息队列等,使用SpringCloud框架,基于Java开发。该项目可部署到服务器上,不断完善中……
-
mycollab
An open source, free, high performance, stable and secure Java Application Business Platform of Project Management and Document
-
mybatis-plus-join
支持连表查询的mybatis-plus,mybatis-plus风格的连表操作提供wrapper.leftJoin(),wrapper.rightJoin()等操作
-
Plan
Player Analytics plugin for Minecraft Server platforms - View player activity of your server with ease. :calendar: (by plan-player-analytics)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Yes but not in the community version:
https://github.com/dbeaver/dbeaver/wiki/Schema-compare
Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.
Project mention: Show HN: AI-driven data development and analysis platform | news.ycombinator.com | 2024-04-08
ChatGPT Mac/Windows App for SQL https://github.com/alibaba/Chat2DB
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.
> 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/
Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase
Project mention: Show HN: Jailer is a unique open-source database client tool | news.ycombinator.com | 2024-03-14
Project mention: Solving duplicate data with performant deduplication | news.ycombinator.com | 2023-11-22
I haven't used either of these two suggestions, but with some quick searching, I found MyCollab or Fractale which look like they might be pretty good. MyCollab looks better of the two of those to me, but Fractale could surprise me.
Plan (short for PLayer ANalytics, it gathers information about player activity and makes it easy for everyone to check their own statistics in a nice web UI. i found that long-term players like to have an idea of how much time and work they put into the server since they joined. you as the admin get access to everyone else's statistics, plus some helpful server stats)
Java MySQL related posts
- Serious flaws in SQL – Edgar F. Codd (1990)
- DBeaver – open-source Database client
- Ask HN: Is there still ORM hate these days?
- I'm open sourcing a Saas I built
- I'm open sourcing a Saas I built
- Why people care about PostGIS and Postgres
- Effortless Containerization: Deploying Spring Boot and MySQL with Docker and Docker Compose
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Index
What are some of the best open-source MySQL projects in Java? This list will help you:
Project | Stars | |
---|---|---|
1 | JavaGuide | 142,999 |
2 | dbeaver | 37,391 |
3 | shardingsphere | 19,425 |
4 | mybatis-plus | 15,770 |
5 | Chat2DB | 12,566 |
6 | ali-dbhub | 8,454 |
7 | Flyway | 7,763 |
8 | jOOQ | 5,882 |
9 | JSqlParser | 4,956 |
10 | liquibase | 4,394 |
11 | Leetcode | 3,691 |
12 | requery | 3,132 |
13 | Jailer | 2,705 |
14 | SuperMarket | 1,933 |
15 | sqli | 1,905 |
16 | GeoTools | 1,634 |
17 | mybatis-flex | 1,631 |
18 | Ebean ORM | 1,429 |
19 | sqlancer | 1,406 |
20 | mycollab | 1,226 |
21 | mybatis-plus-join | 948 |
22 | MariaDB4j | 805 |
23 | Plan | 800 |
Sponsored