Postgresql

Open-source projects categorized as Postgresql
Edit details
Language: + TypeScript + Java + Ruby + C + Go + Clojure + Python + Haskell + JavaScript + Elixir + Rust
Topics: Database MySQL SQL Postgres Docker
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
surveyjs.io
featured

Top 23 Postgresql Open-Source Projects

  • Netdata

    The open-source observability platform everyone needs

    • Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05

    netdata.cloud โ€” Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!

  • supabase

    The open source Firebase alternative.

    • Project mention: How I migrated from Firebase to Supabase | dev.to | 2024-04-30

    I didn't really give much thought as to which backend I would use. I already had 2 projects in Supabase (BOXCUT & MineWork), but also a few projects in Firebase too. I was more concerned at the time at actually building the product.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo

  • Gogs

    Gogs is a painless self-hosted Git service

    • Project mention: Forgejo forks its own path forward | news.ycombinator.com | 2024-02-16

    > Gitea but the other one

    Wouldn't that also be Gogs? https://gogs.io/

    I remember when that one was what a lot of people were looking into, before the Gitea fork happened. It's odd to see how this has happened yet again, but I guess is a good thing that it's even possible in the first place, if there are indeed differing values and goals?

  • nocodb

    ๐Ÿ”ฅ ๐Ÿ”ฅ ๐Ÿ”ฅ Open Source Airtable Alternative

    • Project mention: Open-Source Alternative to Airtable | news.ycombinator.com | 2024-05-01

  • Discourse

    A platform for community discussion. Free, open, simple.

    • Project mention: Discord to Start Showing Ads for Gamers to Boost Revenue | news.ycombinator.com | 2024-04-01

    > Tell me another platform that is free, has realtime chat, voice and video, has stable service, allows sharing images and other media, with good ownership management... and is open source.

    Mattermost: https://mattermost.com/

    Rocket.Chat: https://www.rocket.chat/

    Nextcloud Talk: https://nextcloud.com/talk/

    Self hosting and some assembly required. I've run all of them on cheap VPSes to explore a Slack/Discord replacement, neither was mindblowing but all of them seemed okay (Nextcloud's offering was rather barebones, though).

    Audio and video support varies because getting those right is challenging, at best you'd just integrate with something like Jitsi, that one's actually pretty good for meetings and such: https://jitsi.org/ and has a cloud version too: https://meet.jit.si/ (yet people still go for Zoom and it's odd UI/UX choices)

    I actually rather liked forums back in the day, but I guess nobody will be setting up that many phpBB instances in the current year, though projects like Discourse also seem promising: https://www.discourse.org/

    I don't think many people at all will be leaving Discord, due to how entrenched the platform is (network effect): if you want people to help you with what you're working on, you go where they are, not vice versa.

  • dbeaver

    Free universal database tool and SQL client

    • Project mention: DBeaver โ€“ open-source Database client | news.ycombinator.com | 2024-03-10

    Yes but not in the community version:

    https://github.com/dbeaver/dbeaver/wiki/Schema-compare

  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    • Project mention: A Software Engineer's Tips and Tricks #1: Drizzle | dev.to | 2024-04-29

    In the world of software development, there are two kinds of developers: those who have never had to complain about ORMs and those who have actually used them. Whether itโ€™s Django ORM for Python, Active Record for Ruby, GORM for Golang, Doctrine for PHP, or Prisma for TypeScript, a common issue persists: writing simple queries is straightforward, but constructing complex or optimized queries can take hours, if not days.

  • 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

  • Metabase

    The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

    • Project mention: HackTheBox - Writeup Analytics | dev.to | 2024-03-30

    Remote Code Execution via H2

  • TypeORM

    ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    • Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

    If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.

  • Sequelize

    Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

    • Project mention: Full Stack Web Development Concept map | dev.to | 2024-03-23

    Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs

  • cal.com

    Scheduling infrastructure for absolutely everyone.

    • Project mention: Start your own (side) business with open-source in mind | dev.to | 2024-02-29

    Cal.com is an open-source event-juggling scheduler for everyone, and is free for individuals.

  • maybe

    The OS for your personal finances

    • Project mention: ๐Ÿ› ๏ธNon-AI Open Source Projects that are ๐Ÿ”ฅ | dev.to | 2024-04-04

    Maybe is the story of a comeback. It was shut down in July, 2023. Not wanting to waste the $1,000,000 from investors, Maybe was open-sourced this past January as a fully transparent, open-source, community-backed personal finance app. It was hard to miss because it was trending on GitHub for the entire week.

  • Directus

    The Modern Data Stack ๐Ÿฐ โ€” Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    • Project mention: How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb | dev.to | 2024-04-25

    Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.

  • Redash

    Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.

    • Project mention: Redash: Connect to data source, easily visualize, dashboard and share your data | news.ycombinator.com | 2024-03-20

  • plane

    ๐Ÿ”ฅ ๐Ÿ”ฅ ๐Ÿ”ฅ Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.

    • Project mention: Projectmanagement | /r/selfhosted | 2023-12-08

  • full-stack-fastapi-template

    Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.

    • Project mention: Building a Secure API with FastAPI, PostgreSQL, and Hanko Authentication | dev.to | 2023-10-30

    This project is a modification of the authentication flow of the awesome repository made by tiangolo at full-stack-fastapi-postgresql

  • postgrest

    REST API for any Postgres database

    • Project mention: Supabase โ€“ General Availability Week | news.ycombinator.com | 2024-04-15

    hey hn, supabase ceo her

    we just announced GA, after ~4 years of beta. for those who don't know: supabase is a postgres hosting company. we also host other open source "backend" tools that make it easy to get started with postgres (tools like PostgREST for auto-generate APIs [0])

    we owe a lot to the HN community. you launched us 4 years ago [1], when we were just a few developers. since then HN has been a staple in our journey, one of the best sources of product feedback [2]

    the GA badge is mostly to signify organizational readiness. we're at a stage where we can take any profile of customer. we have a support team that works 24/7, and a success team that will help customers improve their postgres usage. we released our Index Advisor [3] yesterday, and we'll be releasing a few more products this week that helps customer with performance and security.

    on a personal note: i read HN most days, and love going through the ShowHN's to see what devs are building. thanks for being an awesome community and my favorite place to lurk on the internet. i'll stick around to answer any questions

    [0] PostgREST: https://postgrest.org

    [1] Launch: https://news.ycombinator.com/item?id=23319901

    [2] HN journey: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

    [3] Index Advisor: https://news.ycombinator.com/item?id=40028111

  • drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too ๐Ÿ˜…

    • Project mention: A Software Engineer's Tips and Tricks #1: Drizzle | dev.to | 2024-04-29

    Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL โ€” you know Drizzle.

  • shardingsphere

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

    • Project mention: Managing Data Residency - the demo | dev.to | 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.

  • Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

    • Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09

    Knex.js

  • Plausible Analytics

    Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.

    • Project mention: Any Google Analytics Alternatives? | news.ycombinator.com | 2024-05-01

    I think a single Google Analytics alternative is pretty hard to pick considering that GA can be used to very much varying extents.

    For simple and "detailed enough" insights, I enjoyed using Plausible (https://plausible.io/) in the past.

    For more in depth analytics that give you a detailed view into your own product, PostHog.com seems to be by far the best and most popular option out there.

  • cube.js

    ๐Ÿ“Š Cube โ€” The Semantic Layer for Building Data Applications

    • Project mention: MQL โ€“ Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07

    I should have clarified. There's a large number of apps that are:

    1. taking info strictly from SQL (e.g. information_schema, query history)

    2. taking a user input / question

    3. writing SQL to answer that question

    An app like this is what I call "text-to-sql". Totally agree a better system would pull in additional documentation (which is what we're doing), but I'd no longer consider it "text-to-sql". In our case, we're not even directly writing SQL, but rather generating semantic layer queries (i.e. https://cube.dev/).

  • APIJSON

    ๐Ÿ† ้›ถไปฃ็ ใ€ๅ…จๅŠŸ่ƒฝใ€ๅผบๅฎ‰ๅ…จ ORM ๅบ“ ๐Ÿš€ ๅŽ็ซฏๆŽฅๅฃๅ’Œๆ–‡ๆกฃ้›ถไปฃ็ ๏ผŒๅ‰็ซฏ(ๅฎขๆˆท็ซฏ) ๅฎšๅˆถ่ฟ”ๅ›ž JSON ็š„ๆ•ฐๆฎๅ’Œ็ป“ๆž„ใ€‚ ๐Ÿ† A JSON Transmission Protocol and an ORM Library ๐Ÿš€ provides APIs and Docs without writing any code.

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

Postgresql related posts

Index

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

Project Stars
1 Netdata 68,252
2 supabase 66,167
3 Gogs 44,167
4 nocodb 42,586
5 Discourse 40,538
6 dbeaver 37,481
7 Prisma 37,241
8 Metabase 36,592
9 TypeORM 33,307
10 Sequelize 29,055
11 cal.com 28,745
12 maybe 26,739
13 Directus 25,417
14 Redash 24,994
15 plane 24,085
16 full-stack-fastapi-template 23,069
17 postgrest 22,342
18 drizzle-orm 19,921
19 shardingsphere 19,442
20 Knex 18,758
21 Plausible Analytics 18,415
22 cube.js 17,174
23 APIJSON 16,659

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