SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 JavaScript Postgresql Projects
-
Knex
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
-
-
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.
-
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)
-
-
-
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.
-
react-firebase-starter
Boilerplate (seed) project for creating web apps with React.js, GraphQL.js and Relay
-
-
-
Chartbrew
Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
-
thin-backend
🔥 Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps
-
-
rdb
Javascript and Typescript ORM with full intellisense, no-code generations. Works over http as well.
-
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
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09Knex.js
> I'm a big fan of https://nodebb.org/
TIL to what shit Netgate moved pfSense forums to. I'm glad you are fine with it, but not only my FullHD monitor is not a smartphone, so I don't need 400% fonts on everything (and post dates on the faaaaar right clearly shows nobody ever even used the forum) and most importantly - search doesn't work. It's not like the previous forum had a good search, but at least it worked.
Bonus point: try to Ctrl+mousewheel on any NodeBB (including the official one).
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15pg doesn't do too well with serverless, dead connections are left in the pool (or something)
https://github.com/brianc/node-postgres/issues/2112
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15I want to use this as a chance to bring attention to a GitHub issue that I think would help reduce friction for Neon:
https://github.com/neondatabase/neon/issues/4989
If the Neon driver were to allow us to easily pass in a localhost connection, the development and test experience would be easier. Perhaps Neon could swap to something like this internally: https://github.com/porsager/postgres.
Having run a local dev environment connected to Neon and tests connected to Neon got in our way of adoption. We'd prefer to develop and run tests against a regular Postgres localhost database.
To the PMs of Neon, put yourself in the shoes of a new developer thinking of giving Neon a try. What changes will I have to make to my code and my development workflow?
Bookshelf.js is an uncomplicated and lightweight ORM designed for Node.js, constructed atop the Knex.js query builder. Its primary aim is to support SQL databases, such as PostgreSQL, MySQL, and SQLite. Bookshelf.js focuses on simplicity and user-friendliness, offering a direct method for defining models and relationships through JavaScript classes and prototypal inheritance.
Regarding visualization tools, sqliteviz has proven to be the best I've found so far. Their web app runs locally but has some trackers, so I run it locally via a simple, static HTTP server. Falcon and Redash seem like overkill for my needs.
Personally with more time I would also use JavaScript so I can improve it. Last time I wrote something with Express and a database connection is a long time ago and not for work, only for my personal testing. But for JavaScript database connection to PostgreSQL I recommend pg-promise. That works like a charm.
Project mention: Show HN: An Shopify Alternative on Node and Postgres | news.ycombinator.com | 2024-05-10
Project mention: Show HN: Released Chartbrew v3.0 an open source client reporting platform | news.ycombinator.com | 2024-02-22
These tasks are managed by pg-boss behind the scenes (which is based on PostgreSQL) and, oh look, that seamlessly connects to...
Project mention: I created two courses on how to build SaaS web apps with React and Django | /r/SaaS | 2023-06-22You can read more about course at https://saasitive.com/
Project mention: Flyweight: A Node.js ORM Specifically for SQLite | news.ycombinator.com | 2024-04-07You should try https://github.com/alfateam/rdb
It is database agnostic. It works with sqlite, mssql, mysql, postgres, oracle, and sapase.
It gives you full intellisense without code generation - even when running pure javascript.
You can run it from the browser in a secure manner, as you can host it in express js via adapter.
I am the author.
Project mention: Show HN: Synmetrix – Open-Source Platform for Data and Metrics Management | news.ycombinator.com | 2024-02-28
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).
JavaScript Postgresql related posts
-
Psql-describe: \d ported to JavaScript
-
Neon Is Generally Available: Serverless Postgres
-
Flyweight: A Node.js ORM Specifically for SQLite
-
RDS Database Migration Series - A horror story of using AWS DMS with a happy ending
-
Show HN: Synmetrix – Open-Source Platform for Data and Metrics Management
-
Show HN: Synmetrix – Open Semantic Layer
-
NodeJS Security Best Practices
-
A note from our sponsor - SaaSHub
www.saashub.com | 10 May 2024
Index
What are some of the best open-source Postgresql projects in JavaScript? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Knex | 18,789 |
| 2 | nodeBB | 13,924 |
| 3 | PostgreSQL | 11,937 |
| 4 | drawdb | 9,812 |
| 5 | postgres | 6,750 |
| 6 | Bookshelf | 6,337 |
| 7 | falcon | 5,132 |
| 8 | react-firebase-starter | 4,497 |
| 9 | franchise | 3,988 |
| 10 | pg-promise | 3,418 |
| 11 | evershop | 3,313 |
| 12 | orm2 | 3,074 |
| 13 | rate-limiter-flexible | 2,899 |
| 14 | Chartbrew | 2,288 |
| 15 | pg-boss | 1,666 |
| 16 | ElectroCRUD | 1,530 |
| 17 | postbird | 1,496 |
| 18 | thin-backend | 1,227 |
| 19 | django-react-boilerplate | 588 |
| 20 | rdb | 570 |
| 21 | MiAOU | 538 |
| 22 | tasking-manager | 491 |
| 23 | mlcraft | 470 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com