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 Postgresql Projects
-
-
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.
-
APIJSON
🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.
-
-
-
-
-
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.
-
-
-
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
-
Crate
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
-
LakeSoul
LakeSoul is an end-to-end, realtime and cloud native Lakehouse framework with fast data ingestion, concurrent update and incremental data analytics on cloud storages for both BI and AI applications.
-
-
-
-
-
postgresql-event-sourcing
A reference implementation of an event-sourced system that uses PostgreSQL as an event store built with Spring Boot. Fork the repository and use it as a template for your projects. Or clone the repository and run end-to-end tests to see how everything works together.
-
Nakadi
A distributed event bus that implements a RESTful API abstraction on top of Kafka-like queues
-
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.
-
pgjdbc-ng
A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres
-
micronaut-microservices-poc
Very simplified insurance sales system made in a microservices architecture using Micronaut
-
incubator-baremaps
Create custom vector tiles from OpenStreetMap and other data sources with Postgis and Java.
-
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.
If your data lacks uniform time intervals between consecutive entries, QuestDB offers a solution by allowing you to sample your data. After that, MindsDB facilitates creating, training, and deploying your time-series models.
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: Show HN: Jailer is a unique open-source database client tool | news.ycombinator.com | 2024-03-14
Project mention: Password may not contain: select, insert, update, delete, drop | news.ycombinator.com | 2024-01-21The method doAppendEscapeLiteral (Line 66) is a good example; https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main...
I didn’t take notes all the way down, but at the end of the day this method is invoked when a prepared statements’ parameters are being bound
Project mention: Solving duplicate data with performant deduplication | news.ycombinator.com | 2023-11-22
Project mention: Hitchhiker's Guide to Moving from Relational Data to Events | news.ycombinator.com | 2023-12-16This is an extremely well documented postgresql event sourcing reference implementation: https://github.com/eugene-khyst/postgresql-event-sourcing
This project seems to do exactly what I'm trying to accomplish but can't seem to replicate it. Every time I try to import a full "application" into another and build the project I end up with the following exception:
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 Postgresql related posts
- DBeaver – open-source Database client
- Password may not contain: select, insert, update, delete, drop
- Show HN: Light implementation of Event Sourcing using PostgreSQL as event store
- I'm open sourcing a Saas I built
- I'm open sourcing a Saas I built
- Why people care about PostGIS and Postgres
- Everything People Don't Get About CVEs
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Index
What are some of the best open-source Postgresql projects in Java? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | dbeaver | 37,391 |
| 2 | shardingsphere | 19,425 |
| 3 | APIJSON | 16,643 |
| 4 | mybatis-plus | 15,770 |
| 5 | QuestDB | 13,448 |
| 6 | Chat2DB | 12,566 |
| 7 | ali-dbhub | 8,454 |
| 8 | Flyway | 7,763 |
| 9 | jOOQ | 5,882 |
| 10 | JSqlParser | 4,956 |
| 11 | Crate | 3,957 |
| 12 | Jailer | 2,705 |
| 13 | LakeSoul | 2,301 |
| 14 | metasfresh | 1,632 |
| 15 | pgjdbc | 1,416 |
| 16 | sqlancer | 1,406 |
| 17 | r2dbc-postgresql | 986 |
| 18 | postgresql-event-sourcing | 954 |
| 19 | Nakadi | 948 |
| 20 | symmetric-ds | 691 |
| 21 | pgjdbc-ng | 592 |
| 22 | micronaut-microservices-poc | 486 |
| 23 | incubator-baremaps | 475 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com