Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work. Learn more →
Top 23 JavaScript Postgresql Projects
-
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: Using a MySQL database to serve multiple guilds | reddit.com/r/Discord_Bots | 2023-01-21If you like the OOP paradigm and you don't know a lot of the SQL syntax i also suggest looking for an ORM, which abstracts query language the language you're using like https://sequelize.org/
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
How does HN receive SQL builders in general? I feel like most of us agree ORMs are typically a bad idea. I feel like that almost instantly leaves the need for "something" to take its place. In my experience, it's typically been a query builder like this.
I've also tried:
https://www.npmjs.com/package/sql-template-strings ("out of date" since like 2016? https://www.npmjs.com/package/sql-template-tag might be better)
Are query builders an anti pattern? People who are doing serious/logic heavy stuff with SQL, how do you avoid a query builder (if at all?)
-
Appwrite
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
-
Project mention: The over-reliance on Discord is doing more harm than good. | reddit.com/r/truegaming | 2022-11-23
If you want to make your own app out of custom code that you will actively develop new features for, I think your points are true. But if you just wanted a modern version of the old phpBB forums, there are plenty of almost-turnkey projects/templates you can use. Check out NodeBB for instance. Maybe the barrier for entry is higher in a way, given increased complexity, but you also get more and nicer features "for free". I think it's a wash.
-
node-postgres (raw sql, without ORM)
-
Project mention: Is there a 'batteries included' backend framework like Django, but written in JS? | reddit.com/r/learnjavascript | 2022-03-06
If you're set on JS (using only one language on a team/project can be very nice) common choices for backend often involve using Express or hapi with some ORM (like Prisma or Bookshelf).
-
Project mention: Connect SQL Client to PostgreSQL in Docker Compose | reddit.com/r/docker | 2022-07-27
As you can see, I have Postgres db running in my container, I also have a client I want to use to access this database (falcon-client), however, it cannot connect to the db, I'm assuming it's because my port at 5432 is not allowing access to the database (as suggested here)
-
react-firebase-starter
Boilerplate (seed) project for creating web apps with React.js, GraphQL.js and Relay
Let's look at React Starter Kit, which bills itself as an isomorphic web project boilerplate. Additionally, the React Starter Kit is described as, “very opinionated” on the webpage. This implies that it has already chosen our tech stack for us, which consists of Node.js, Express and GraphQL.
-
Sonar
Write Clean JavaScript Code. Always.. Sonar helps you commit clean code every time. With over 300 unique rules to find JavaScript bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno (by porsager)
Project mention: Well, shit. Objection.js has been sunset, which ORM/querybuilder did you move to? | reddit.com/r/node | 2022-12-03About a year ago I moved to raw SQL using Postgres.js. Honestly I thought it would be traumatic but it's been great so far.
-
Project mention: What is the best web-based PostgreSQL for Workshop | reddit.com/r/PostgreSQL | 2022-10-05
Would https://franchise.cloud be any use?
-
Project mention: Ask HN: Why are so many PHP projects moving to Node? | news.ycombinator.com | 2023-01-26
I've always loved this project / product:
https://github.com/outline/outline
I think the guy who built it posts here. There's also pg-promise, a "Postgres interface for Node.js":
-
-
-
thin-backend
🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps
Project mention: Ask HN: How would you refactor a big project in 2023? | news.ycombinator.com | 2023-01-13A tool like https://thin.dev/ might be good for you. You can port and serve functionality a little bit at a time into thin and use their managed postgres db and the schema editor to handle the new fields in the backend.
-
-
Chartbrew
Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
Project mention: Those making $500/month on side projects in 2023 – Show and tell | news.ycombinator.com | 2023-01-22I'm working part-time on my project https://chartbrew.com
It's an open-source data visualization and reporting platform that I started in 2018, I abandoned in 2019, then resumed working on it more seriously in 2020.
Currently, the platform is doing $1,138 in MRR from then managed hosting service and has made over $11k in revenue so far. It's been growing steadily in the last few months but going through a rough Dec-Jan period at the moment. You can see the open page at https://chartbrew.com/open
Onwards and great job everyone at working to make side projects work for you!
-
You cac check SaaSitive React and Django tutorial. It has lesson about registration and more. It is paid tutorial.
-
MiAOU
A chat server with OAuth2 authentication, persistent and searchable history, video and audio, markdown formatting, private and public rooms, stars, votes, embedded games, and many other features
-
Help mapping (all in a browser) https://tasks.hotosm.org/explore?campaign=T%C3%BCrkiye%20Ear...
The tech for the task manager is at https://github.com/hotosm/tasking-manager/issues
-
-
-
-
-
Netflix-Clone
Netflix like full-stack application with SPA client and backend implemented in service oriented architecture (by yuchiu)
Netflix Clone - https://github.com/yuchiu/Netflix-Clone
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
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 2023-02-07.
JavaScript Postgresql related posts
- How/do you handle queue type workflows?
- Which tool/library well adopted to use Postgres as a message broker?
- Which ORM do you prefer with nodejs/Typescript project and why ?
- Promises, Thenables, & Lazy-evaluation: What, Why, How
- Ask HN: How would you refactor a big project in 2023?
- What is your development stack for 2023?
- Help with my small Edtech startup.
-
A note from our sponsor - Sonar
www.sonarsource.com | 8 Feb 2023
Index
What are some of the best open-source Postgresql projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Sequelize | 27,388 |
| 2 | Knex | 17,078 |
| 3 | nodeBB | 13,170 |
| 4 | PostgreSQL | 10,957 |
| 5 | Bookshelf | 6,309 |
| 6 | falcon | 5,052 |
| 7 | react-firebase-starter | 4,450 |
| 8 | postgres | 4,367 |
| 9 | franchise | 3,942 |
| 10 | pg-promise | 3,276 |
| 11 | orm2 | 3,076 |
| 12 | postbird | 1,360 |
| 13 | thin-backend | 1,105 |
| 14 | pg-boss | 1,068 |
| 15 | Chartbrew | 976 |
| 16 | django-react-boilerplate | 544 |
| 17 | MiAOU | 515 |
| 18 | tasking-manager | 419 |
| 19 | PostGUI | 370 |
| 20 | mlcraft | 363 |
| 21 | rdb | 291 |
| 22 | sqliterally | 256 |
| 23 | Netflix-Clone | 252 |
Build time-series-based applications quickly and at scale.
InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
www.influxdata.com