postgresql-database

Open-source projects categorized as postgresql-database
Edit details
Language: + Python + Java + TypeScript + Perl + Ruby + Shell + Go + JavaScript + HTML + Haskell
Topics: Postgresql Postgres Database Docker SQL
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
Sponsored

Top 23 postgresql-database Open-Source Projects

  • APIJSON

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

  • postgresqltuner

    Simple script to analyse your PostgreSQL database configuration, and give tuning advice

  • 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

  • pgadmin4

    pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

    • Project mention: Using migrations with Golang | dev.to | 2024-04-17

    If we access a client like PgAdmin or Beekeeper, or accessing its container via bash and checking via CLI, we can see that the table was created successfully:

  • Udacity-Data-Engineering-Projects

    Few projects related to Data Engineering including Data Modeling, Infrastructure setup on cloud, Data Warehousing and Data Lake development.

    • Project mention: Pitanje za data engineering? | /r/programiranje | 2023-06-30

  • zapatos

    Zero-abstraction Postgres for TypeScript: a non-ORM database library

    • Project mention: Zapatos: Zero-Abstraction Postgres for TypeScript | news.ycombinator.com | 2023-10-14

  • netdisco

    A web-based network management tool.

    • Project mention: Script for network that generates diagrams | /r/networking | 2023-06-29

  • pg-osc

    Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

    • Project mention: Pgroll: zero-downtime, undoable, schema migrations for Postgres | news.ycombinator.com | 2023-10-03

    Great to see more innovation in this space! How does this compare to?

    https://github.com/shayonj/pg-osc

  • 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

  • docker-pgautoupgrade

    A PostgreSQL Docker container that automatically upgrades your database

    • Project mention: Why Postgres Extensions should be packaged and distributed as OCI images | news.ycombinator.com | 2024-04-05

    > ... PostgreSQL package.

    Is it able to automatically upgrade people from older PG versions?

    If not, the MIT licensed code from here might be worth looking through and grabbing ideas from? :)

    https://github.com/pgautoupgrade/docker-pgautoupgrade

    Specifically the scripting here is the bulk of it, the majority of the other stuff is just the existing docker entrypoint code from the official Docker PG container:

    https://github.com/pgautoupgrade/docker-pgautoupgrade/blob/0...

  • pgdiff

    Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match.

    • Project mention: Any free SchemaDiff tools out there? pgAdmin Schema Diff created a script but it fails (order is wrong, etc) | /r/PostgreSQL | 2023-06-26

  • postgresql-portable

    Portable version of the PostgreSQL Database Server, for Windows.

    • Project mention: Portable Setup for PostgreSQL on Windows | news.ycombinator.com | 2023-09-14

    An unofficial alternative: https://github.com/garethflowers/postgresql-portable

  • serverless

    Connect to Neon PostgreSQL from serverless/worker/edge functions (by neondatabase)

    • Project mention: HTTP vs. WebSockets: Which one is the fastest for Postgres queries at the Edg | news.ycombinator.com | 2023-07-11

    Here is the actual package used [1]. I thought it would have been similar to serverless-pg[2] with initiation outside the handler as with the node implementation. Any insights into how they achieve connection caching (similar to pooling?) on the edge?

    [1]: https://github.com/neondatabase/serverless

  • FastAPIQuickCRUD

    Generate CRUD methods in FastApi from an SQLAlchemy schema

  • kanban-board

    Single-click full-stack application (Postgres, Spring Boot & Angular) using Docker Compose

  • ephemeralpg

    Quickly spin up a temporary PostgreSQL test databases

  • embedded-postgres-binaries

    Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.

    • Project mention: Testcontainers | news.ycombinator.com | 2024-02-27

  • DB2Rest

    Instant low-code REST DATA API platform for databases.Combine your data with language models(LM/LLMS) to rapidly deliver context-aware, intelligent applications.

    • Project mention: Expose your database as a REST API safely and without code | dev.to | 2024-04-11

    DB2Rest is open source middleware that offers a no-code way to safely expose data from your database for your applications to consume. It's runs as a service that you can host locally or in the cloud. It even has an easy to use Docker deployment.

  • ArtemisQL

    ArtemisQL is a GraphQL migration tool and database visualizer that empowers developers to build and implement GraphQL with ease.

  • lexiQL

    lexiQL is a GraphQL prototyping tool and SQL database visualizer built for developers looking to optimize their queries and transition away from RESTful APIs

  • SQL-NoSQL-Guide

    SQL/NoSQL DB Guide. Learn about SQL/NoSQL databases & Distributed Systems.

  • FastAPI-PostgreSQL-Docker

    FastAPI using PostgreSQL DB

  • mySequelWeb

    MySequel Web is an open source web based GUI tool to access your MySql database. It is similar to PHP My Admin of WAMP. Here you can access any MySQL database with proper connection strings. We do not save or store any of your connection strings or data. Every thing related to your connection strings are volatile. You can host this as a simple nodeJs application on any server or you can simply run this in your local.

  • pg-counter-metrics

    PG Counter Metrics ( PGCM ) is a tool for publishing PostgreSQL performance data to CloudWatch. By publishing to CloudWatch, dashboards and alarming can be used on the collected data.

    • Project mention: Monitoring a pgsql database running on EC2. | /r/aws | 2023-05-21

  • postgresql-resilient

    Automatic re-connection support for PostgreSQL.

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

postgresql-database related posts

Index

What are some of the best open-source postgresql-database projects? This list will help you:

Project Stars
1 APIJSON 16,614
2 postgresqltuner 2,550
3 pgadmin4 2,056
4 Udacity-Data-Engineering-Projects 1,295
5 zapatos 1,217
6 netdisco 599
7 pg-osc 475
8 docker-pgautoupgrade 434
9 pgdiff 419
10 postgresql-portable 290
11 serverless 265
12 FastAPIQuickCRUD 248
13 kanban-board 176
14 ephemeralpg 173
15 embedded-postgres-binaries 123
16 DB2Rest 121
17 ArtemisQL 108
18 lexiQL 80
19 SQL-NoSQL-Guide 57
20 FastAPI-PostgreSQL-Docker 46
21 mySequelWeb 27
22 pg-counter-metrics 22
23 postgresql-resilient 16

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com