Top 23 JavaScript Postgresql Projects
-
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server & DB2
Lucid is AdonisJS Built-In ORM. It's extremely powerful and works much like Laravel's Eloquent ORM. While Lucid is built in, you can optionally use Sequelize or Prisma with AdonisJS as well.
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
a) How will you do your queries from node. There's two, actually three approaches. First, writing SQL directly in your code (which I think is the one you should take), and in this case you would use node-postgres. The great thing about this is that you can try out some query in DBeaver or in psql (the command line) or some other tool and when it's right, just copy to your node.js code. Or conversely, if a query in your program isn't right, you can debug it in psql / DBeaver with some test inputs. Anyway another approach would be to use an ORM, and for this one I think the most popular in node land is Prisma (but I may be wrong). And then there's a middle ground which is like just writing queries, but instead of using sql syntax, you write it with JS methods and get them converted to SQL using a query builder. A nice query builder would be knexjs, and actually it's the kind of thing I would use myself (but I don't program in node). (Prisma itself has a comparison on those 3 approaches (actually, the whole Prisma documentation is pretty good))
-
OPS
OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
-
Project mention: NodeBB - Node.js based forum software built for the modern web | reddit.com/r/CKsTechNews | 2021-12-25
-
a) How will you do your queries from node. There's two, actually three approaches. First, writing SQL directly in your code (which I think is the one you should take), and in this case you would use node-postgres. The great thing about this is that you can try out some query in DBeaver or in psql (the command line) or some other tool and when it's right, just copy to your node.js code. Or conversely, if a query in your program isn't right, you can debug it in psql / DBeaver with some test inputs. Anyway another approach would be to use an ORM, and for this one I think the most popular in node land is Prisma (but I may be wrong). And then there's a middle ground which is like just writing queries, but instead of using sql syntax, you write it with JS methods and get them converted to SQL using a query builder. A nice query builder would be knexjs, and actually it's the kind of thing I would use myself (but I don't program in node). (Prisma itself has a comparison on those 3 approaches (actually, the whole Prisma documentation is pretty good))
-
Project mention: Recovering XAMPP developer looking to make a Node CRUD app. What Node database tools are easy to learn? | reddit.com/r/node | 2021-12-30
I made the transition from LAMP to Node-based stacks 6 or 7 years ago and started out using BookshelfJS. Node is a different world though, one that lends itself to distributed services and server-less infrastructure, and it's changed how I interact with DBs.
-
Or maybe Falcon as a desktop tool.
-
react-firebase-starter
Boilerplate (seed) project for creating web apps with React.js, GraphQL.js and Relay
GitHub
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise
-
-
-
I've been trying out Beekeeper Studio [https://www.beekeeperstudio.io/] recently, and like that it supports both MySQL and PostgreSQL (and others I don't use). The interface takes a little bit to get used to, but it's been pretty powerful for me.
Before that, or when I'm in a rush to just get something done as I adjust to Beekeeper, I use Postbird (an Electron app) [https://github.com/Paxa/postbird]
-
If anyone is looking to use postgres as a job server with node.js clients, I can highly recommend the pg-boss library (https://github.com/timgit/pg-boss). Looks like it just added pub/sub too (yesterday), so I guess you could use it for that too.
-
Chartbrew
Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
Project mention: Ask HN: Tool for dashboards / alerting on operational health metrics? | news.ycombinator.com | 2021-12-19There's an indie-hacker I follow building this: https://chartbrew.com/
From what I understand, it's more like an easier-to-use grafana, where you can build charts/graphs from different data sources.
-
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
Project mention: Some?ready?made.solution() for private users messaging ? (not for testing) | reddit.com/r/node | 2021-11-17 -
-
Project mention: Ask HN: Best (Low-/No-Code) Solution for Simple Web-Based Database Front Ends | news.ycombinator.com | 2021-04-01
-
-
Project mention: Do you ever avoid submitting something on HN so devs don't ruin it? | news.ycombinator.com | 2021-12-08
I would certainly hate for devs to hate on this top-secret pure orm project [0].
-
Project mention: Stuck On Node database management. Should I use a different ORM? Should I use raw SQL? | reddit.com/r/node | 2021-07-03
You can use something like sqliterally to compose your SQL, and maybe make it a bit cleaner.
-
Project mention: giraffeQL - Relational Database Visualiser and Schema Exporter for GraphQL APIs | reddit.com/r/coolgithubprojects | 2021-02-27
-
Project mention: LCBO.com adds the ability to download the store availability as an excel file (bottom of page) | reddit.com/r/torontocraftbeer | 2021-03-19
-
Project mention: Implicit In-order Forests: Zooming a billion trace events at 60fps | news.ycombinator.com | 2021-04-30
We built a general 2D zooming visualization system which supports data in PostgreSQL: https://github.com/tracyhenry/kyrix. Under the hood, it uses PostgreSQL quad tree index to fetch data on demand.
We have also tested with Citus, which helped us scaled to billions of objects. Demo: https://youtu.be/ccES97ni_vI
-
Project mention: Ask HN: What are some tools / libraries you built yourself? | news.ycombinator.com | 2021-05-16
JavaScript Postgresql related posts
- New to PostgreSQL - Best way to use it?
- Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
- Node.js with Postgresql Bad Practice
- Help an old desktop dev learn a new trick?
- Study: Developers spend almost 2 days a week just waiting for other developers to review their code
- Solution to weird error when trying to use pg with SvelteKit in Vercel
- Vortex - Create customizable, beautiful and modern blogs in a minute
Index
What are some of the best open-source Postgresql projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Sequelize | 25,575 |
| 2 | Knex | 15,244 |
| 3 | nodeBB | 12,403 |
| 4 | PostgreSQL | 10,145 |
| 5 | Bookshelf | 6,260 |
| 6 | falcon | 4,870 |
| 7 | react-firebase-starter | 4,374 |
| 8 | pg-promise | 3,071 |
| 9 | orm2 | 3,065 |
| 10 | postgres | 2,215 |
| 11 | postbird | 1,216 |
| 12 | pg-boss | 728 |
| 13 | Chartbrew | 614 |
| 14 | MiAOU | 505 |
| 15 | django-react-boilerplate | 477 |
| 16 | PostGUI | 331 |
| 17 | mlcraft | 309 |
| 18 | pure-orm | 297 |
| 19 | sqliterally | 251 |
| 20 | giraffeQL | 149 |
| 21 | lcbo-api | 127 |
| 22 | Kyrix | 125 |
| 23 | pgcmd | 116 |
Are you hiring? Post a new remote job listing for free.
