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. Learn more โ
Top 23 Postgresql Open-Source Projects
-
-
-
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.
-
-
-
-
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
-
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.
-
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
-
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.
-
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.
-
-
-
Directus
The Modern Data Stack ๐ฐ โ Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
-
plane
๐ฅ ๐ฅ ๐ฅ Open Source JIRA, Linear and Asana Alternative. Plane helps you track your issues, epics, and product roadmaps in the simplest way possible.
-
full-stack-fastapi-template
Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.
-
-
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 ๐
-
shardingsphere
Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
-
Plausible Analytics
Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
-
-
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.
Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05netdata.cloud โ Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!
Project mention: Creating a Pokรฉmon guessing game using Supabase, Drizzle, and Next.js in just 2 hours! | dev.to | 2024-04-23Setting up Supabase Create a new Supabase project, and get the connection string for the database from settings > database.
> 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?
Project mention: Show HN: Teable โ Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11
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.
Yes but not in the community version:
https://github.com/dbeaver/dbeaver/wiki/Schema-compare
Project mention: Deploy Full-Stack Next.js T3App with Cognito and Prisma using AWS Lambda | dev.to | 2024-04-15generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema
Remote Code Execution via H2
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 - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs
Cal.com is an open-source event-juggling scheduler for everyone, and is free for individuals.
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.
As of April 2024, Directus' GitHub repository has accumulated 25.2k stars and 3.5k forks, showcasing its active community. The project has secured $8+ million in funding, further fueling its growth and development.
Project mention: Redash: Connect to data source, easily visualize, dashboard and share your data | news.ycombinator.com | 2024-03-20
Project mention: Building a Secure API with FastAPI, PostgreSQL, and Hanko Authentication | dev.to | 2023-10-30This project is a modification of the authentication flow of the awesome repository made by tiangolo at full-stack-fastapi-postgresql
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 is a very popular TypeScript ORM that provides type safe access to your database, automated migrations, and a custom data model definition.
Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.
Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09Knex.js
I could do the same exercise with Google Analytics and Google Tag Manager, but luckily I don't need to, since Plausible already did. A piece of advice, rip out Google Analytics and use Plausible instead. It first of all doesn't destroy your website, and secondly it doesn't violate the GDPR - So you can embed it on your site without having to warn your visitors about that they're being spied on by Google.
Project mention: MQL โ Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07I 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/).
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
- IHP โ The Haskell Framework for Non-Haskellers
- Ask HN: How Can I Make My Front End React to Database Changes in Real-Time?
- Get started with Drizzle ORM and Xata's Postgres service
- Neon Is Generally Available: Serverless Postgres
- Supabase Acquires OrioleDB
- Ask HN: What tool(s) do you use to code review and deploy SQL scripts?
- Show HN: PostgreSQL Index Advisor
-
A note from our sponsor - SurveyJS
surveyjs.io | 24 Apr 2024
Index
What are some of the best open-source Postgresql projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Netdata | 68,064 |
| 2 | supabase | 65,456 |
| 3 | Gogs | 44,097 |
| 4 | nocodb | 42,199 |
| 5 | Discourse | 40,422 |
| 6 | dbeaver | 37,266 |
| 7 | Prisma | 37,151 |
| 8 | Metabase | 36,417 |
| 9 | TypeORM | 33,253 |
| 10 | Sequelize | 29,026 |
| 11 | cal.com | 28,546 |
| 12 | maybe | 26,466 |
| 13 | Directus | 25,357 |
| 14 | Redash | 24,917 |
| 15 | plane | 23,846 |
| 16 | full-stack-fastapi-template | 22,914 |
| 17 | postgrest | 22,103 |
| 18 | drizzle-orm | 19,510 |
| 19 | shardingsphere | 19,425 |
| 20 | Knex | 18,720 |
| 21 | Plausible Analytics | 18,213 |
| 22 | cube.js | 17,120 |
| 23 | APIJSON | 16,614 |
Sponsored
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.
www.influxdata.com