Java Postgresql

Open-source Java projects categorized as Postgresql

Top 23 Java Postgresql Projects

  • dbeaver

    Free universal database tool and SQL client

  • Project mention: DBeaver – open-source Database client | | 2024-03-10

    Yes but not in the community version:

  • shardingsphere

    Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.

  • Project mention: Managing Data Residency - the demo | | 2023-05-25

    Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.

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

    InfluxDB logo

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

  • mybatis-plus

    An powerful enhanced toolkit of MyBatis for simplify development

  • QuestDB

    An open source time-series database for fast ingest and SQL queries

  • Project mention: How to Forecast Air Temperatures with AI + IoT Sensor Data | | 2024-03-24

    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.

  • Chat2DB

    🔥 🔥 🔥 An intelligent and versatile general-purpose SQL client and reporting tool for databases which integrates ChatGPT capabilities.

  • Project mention: Show HN: AI-driven data development and analysis platform | | 2024-04-08
  • ali-dbhub


  • Project mention: FLaNK Stack Weekly for 20 June 2023 | | 2023-06-20

    ChatGPT Mac/Windows App for SQL

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

    WorkOS logo
  • Flyway

    Flyway by Redgate • Database Migrations Made Easy.

  • Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | | 2024-04-14

    Also RedGate, but Flyway has some reasons to recommend it over RedGate Deploy depending on your DBAs/workflows:

    (Though I don't think it is "complete" or "perfect", either.)

    EF Migrations are in a really good place now if you like/don't mind C# as a language (and you can easily embed SQL inside the C#, too, but there are benefits to being able to also run high level C# code). With today's tooling you can package your migration "runner application" as a single deployable executable for most platforms. You can build the executable once and run it in all your environments. (The same tool that updates your QA and Staging updates your Prod, testably running the same migrations.) Given the single executable deployable I might even consider using it for projects not themselves written in C#.

  • jOOQ

    jOOQ is the best way to write SQL in Java

  • Project mention: ORMs are nice but they are the wrong abstraction | | 2024-02-01
  • 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.

  • Project mention: FLaNK AI - 01 April 2024 | | 2024-04-01
  • Jailer

    Database Subsetting and Relational Data Browsing Tool.

  • Project mention: Show HN: Jailer is a unique open-source database client tool | | 2024-03-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.

  • metasfresh

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

  • pgjdbc

    Postgresql JDBC Driver

  • Project mention: Password may not contain: select, insert, update, delete, drop | | 2024-01-21

    The method doAppendEscapeLiteral (Line 66) is a good example;

    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

  • sqlancer

    Automated testing to find logic and performance bugs in database systems

  • Project mention: Solving duplicate data with performant deduplication | | 2023-11-22
  • r2dbc-postgresql

    Postgresql R2DBC Driver

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

  • Project mention: Hitchhiker's Guide to Moving from Relational Data to Events | | 2023-12-16

    This is an extremely well documented postgresql event sourcing reference implementation:

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

  • Project mention: FLaNK Stack Weekly for 14 Aug 2023 | | 2023-08-14
  • 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

  • Project mention: Micronaut multi project build | /r/micronaut | 2023-06-06

    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:

  • incubator-baremaps

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

  • Project mention: FLaNK Stack Weekly 29 may 2023 | | 2023-05-30
  • 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). The latest post mention was on 2024-04-14.

Java Postgresql related posts


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

Project Stars
1 dbeaver 37,266
2 shardingsphere 19,406
3 APIJSON 16,614
4 mybatis-plus 15,770
5 QuestDB 13,448
6 Chat2DB 12,461
7 ali-dbhub 8,459
8 Flyway 7,754
9 jOOQ 5,874
10 JSqlParser 4,938
11 Crate 3,955
12 Jailer 2,675
13 LakeSoul 2,294
14 metasfresh 1,629
15 pgjdbc 1,414
16 sqlancer 1,405
17 r2dbc-postgresql 984
18 postgresql-event-sourcing 950
19 Nakadi 948
20 symmetric-ds 691
21 pgjdbc-ng 590
22 micronaut-microservices-poc 486
23 incubator-baremaps 475

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