Java Postgresql

Open-source Java projects categorized as Postgresql

Top 23 Java Postgresql Projects

  1. dbeaver

    Free universal database tool and SQL client

    Project mention: DBeaver – AI Smart Assistance | news.ycombinator.com | 2025-02-04
  2. Nutrient

    Nutrient - The #1 PDF SDK Library. Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.

    Nutrient logo
  3. shardingsphere

    Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.

  4. Chat2DB

    🔥🔥🔥AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.

    Project mention: SQLite Tutorial: Installation, Usage, and Best Practices | dev.to | 2025-02-06

    Download Chat2DB: https://chat2db.ai

  5. APIJSON

    🏆 实时 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码,前端(客户端) 定制返回 JSON 的数据和结构 🏆 Real-Time coding-free, powerful and secure ORM 🚀 providing APIs and Docs without coding by Backend, and the returned JSON of API can be customized by Frontend(Client) users

    Project mention: Top 15 Open-Source Low-Code Projects with the Most GitHub Stars | dev.to | 2024-07-18

    GitHub https://github.com/Tencent/APIJSON GitHub Stars 16.9k Most Recent Update on GitHub 2 days ago Open Source License Apache 2.0 Number of Active Contributors This Year 6 Acceptance of External PRs Yes Official Website http://apijson.cn/ Documentation https://apijsondocs.readthedocs.io/en/latest/

  6. mybatis-plus

    An powerful enhanced toolkit of MyBatis for simplify development

  7. QuestDB

    QuestDB is a high performance, open-source, time-series database

    Project mention: QuestDB is an open source time-series database for fast ingest and SQL queries | news.ycombinator.com | 2024-08-31
  8. Flyway

    Flyway by Redgate • Database Migrations Made Easy.

    Project mention: Ne jouez plus tout l'historique de vos migrations Flyway grâce au baseline ! | dev.to | 2025-01-09
  9. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  10. jOOQ

    jOOQ is the best way to write SQL in Java

    Project mention: Systems ideas that sound good but almost never work | news.ycombinator.com | 2024-12-31

    (1) DSLs work great sometimes. See https://www.jooq.org/

    (2) Elastic Load Balancer is a control loop responsive to workloads, that kind of thing is a commodity

    (3) Under-provisioning is rampant in most industries; see https://erikbern.com/2018/03/27/waiting-time-load-factor-and... and https://www.amazon.com/Goal-Process-Ongoing-Improvement/dp/0...

    (4) Anomaly detection is not inherently a problem of distributed systems like the others, but someone facing the problems they've been burned with might think they need it. Intellectually it's tough. The first algorithm I saw that felt halfway smart was https://scikit-learn.org/1.5/modules/outlier_detection.html#... which is sometimes a miracle and I had good luck using it on text with the CNN-based embeddings we had in 2018 but none at all w/ SBERT.

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

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

    Project mention: OpenAI Acquires Rockset | news.ycombinator.com | 2024-06-21

    Great initiative making a list of possible Rockset replacements. Would it be possible to open the Notion page for guest contributions?

    I would like to add CrateDB (I work there) to the list. CrateDB is a distributed SQL database purposely built for real-time analytics across large datasets of structured and semi-structured data. Similarly to Rockset, it indexes all data in real-time (text, vector, geospatial, time-series, and JSON) for the most efficient search and fast ad hoc query execution at any scale. It is built on top of Apache Lucene and unlike Rockset is open-source (https://github.com/crate/crate).

    Rocket frequently comes up among other solutions our users were looking at before choosing CrateDB. For example https://cratedb.com/customers/govspend.

  13. Jailer

    Database Subsetting and Relational Data Browsing Tool.

    Project mention: Show HN: Outerbase Studio – Open-Source Database GUI | news.ycombinator.com | 2024-12-04
  14. 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.

  15. metasfresh

    We do Open Source ERP - Fast, Flexible & Free Software to scale your Business.

  16. pgjdbc

    Postgresql JDBC Driver

  17. sqlancer

    Automated testing to find logic and performance bugs in database systems

    Project mention: You can use C-Reduce for any language | news.ycombinator.com | 2024-11-27

    Works well for SQL too, I‘ve been using it at my day job, found out via https://github.com/sqlancer/sqlancer?tab=readme-ov-file#redu...

  18. mybatis-plus-join

    支持连表查询的mybatis-plus,mybatis-plus风格的连表操作提供wrapper.leftJoin(),wrapper.rightJoin()等操作

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

  20. r2dbc-postgresql

    Postgresql R2DBC Driver

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

  22. qstudio

    qStudio - Free SQL Analysis Tool

    Project mention: Show HN: Outerbase Studio – Open-Source Database GUI | news.ycombinator.com | 2024-12-04

    QStudio. Editor and notebook in one, works on all os with 30+ databases and is Free: https://www.timestored.com/qstudio/ disclaimer: I'm the author

  23. pgjdbc-ng

    A new JDBC driver for PostgreSQL aimed at supporting the advanced features of JDBC and Postgres

  24. incubator-baremaps

    Create custom vector tiles from OpenStreetMap and other data sources with Postgis and Java.

    Project mention: Show HN: OpenFreeMap – Open-Source Map Hosting | news.ycombinator.com | 2024-09-24

    I am currently exploring the open source mapping world and trying to get a better grasp of what's available.

    How does this project compare to Apache Baremaps (incubating)?

    https://baremaps.apache.org/

  25. micronaut-microservices-poc

    Very simplified insurance sales system made in a microservices architecture using Micronaut

  26. SaaSHub

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

    SaaSHub logo
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 discussion

Log in or Post with

Java Postgresql related posts

  • A Major Postgres Upgrade with Zero Downtime

    4 projects | news.ycombinator.com | 29 Jan 2025
  • Database Stress Testing: Why It Matters and How to Get Started

    5 projects | dev.to | 9 Jan 2025
  • Configuring a Connection Pool

    3 projects | dev.to | 18 Sep 2024
  • The Great Database Migration

    3 projects | news.ycombinator.com | 30 Jun 2024
  • DBeaver – open-source Database client

    10 projects | news.ycombinator.com | 10 Mar 2024
  • Password may not contain: select, insert, update, delete, drop

    1 project | news.ycombinator.com | 21 Jan 2024
  • Show HN: Light implementation of Event Sourcing using PostgreSQL as event store

    1 project | /r/hackernews | 2 Nov 2023
  • A note from our sponsor - CodeRabbit
    coderabbit.ai | 16 Feb 2025
    Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. Learn more →

Index

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

# Project Stars
1 dbeaver 41,714
2 shardingsphere 20,034
3 Chat2DB 18,637
4 APIJSON 17,430
5 mybatis-plus 16,641
6 QuestDB 14,896
7 Flyway 8,472
8 jOOQ 6,283
9 JSqlParser 5,539
10 Crate 4,186
11 Jailer 2,923
12 LakeSoul 2,485
13 metasfresh 1,863
14 pgjdbc 1,541
15 sqlancer 1,540
16 mybatis-plus-join 1,236
17 postgresql-event-sourcing 1,146
18 r2dbc-postgresql 1,025
19 symmetric-ds 772
20 qstudio 643
21 pgjdbc-ng 604
22 incubator-baremaps 526
23 micronaut-microservices-poc 489

Sponsored
Nutrient - The #1 PDF SDK Library
Bad PDFs = bad UX. Slow load times, broken annotations, clunky UX frustrates users. Nutrient’s PDF SDKs gives seamless document experiences, fast rendering, annotations, real-time collaboration, 100+ features. Used by 10K+ devs, serving ~half a billion users worldwide. Explore the SDK for free.
nutrient.io