JavaScript Postgresql

Open-source JavaScript projects categorized as Postgresql | Edit details

Top 23 JavaScript Postgresql Projects

  • GitHub repo Sequelize

    An easy-to-use multi SQL dialect ORM tool for Node.js

    Project mention: Confused about connecting SQL database to frontend | reddit.com/r/learnprogramming | 2021-09-04

    You could add an ORM to your express app, I've never used IT, but there's sequelize for example.

  • GitHub repo Knex

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

    Project mention: I used Typeorm in one of our projects and I have nothing but regrets | reddit.com/r/node | 2021-10-02

    Knex is an amazing library. If you need raw SQL, you can use knex.raw:

  • Syncfusion

    Syncfusion - See why our products are consistently getting 4.6 out of 5 stars by your peers.. Syncfusion Essential Studio for JavaScript is a modern UI control library built from the ground up to be lightweight, responsive, modular, and touch-friendly.

  • GitHub repo PostgreSQL

    PostgreSQL client for node.js.

    Project mention: Use custom type/domain in store procedure call. | reddit.com/r/PostgreSQL | 2021-10-08

    I want to know how can I pass custom type in store proc arguments in PG. I am calling my store proc for node PG module (https://node-postgres.com/). This documentation link doesn't have info about calling store proc.

  • GitHub repo Bookshelf

    A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

    Project mention: Autogenerate GraphQL API documentation with SpectaQL | dev.to | 2021-04-25

    A few of the most important characteristics of the solution we wanted was that any documentation-related work had to be easy for developers, and it would ideally be located in proximity to the actual implementing code. Anvil's web application is written in Node, and we chose Apollo as our GraphQL framework and use a modified version of Bookshelf as our ORM.

  • GitHub repo falcon

    Free, open-source SQL client for Windows and Mac 🦅 (by plotly)

    Project mention: best free sql query assistance tool | reddit.com/r/SQL | 2021-08-30

    Or maybe Falcon as a desktop tool.

  • GitHub repo react-firebase-starter

    Boilerplate (seed) project for creating web apps with React.js, GraphQL.js and Relay

    Project mention: 12+ React Boilerplates & Starter Kits For Developers In 2021 | dev.to | 2021-05-11

    GitHub

  • GitHub repo orm2

    Object Relational Mapping

  • Nanos

    Run Linux Software Faster and Safer than Linux with Unikernels.

  • GitHub repo pg-promise

    PostgreSQL interface for Node.js

    Project mention: Help seeding a database with PG | reddit.com/r/learnjavascript | 2021-08-17

    Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise

  • GitHub repo postgres

    Postgres.js - The Fastest full featured PostgreSQL client for Node.js (by porsager)

    Project mention: DenoDB | news.ycombinator.com | 2021-06-17

    I prefer the postgres module. 0 dependencies. Easy to use API. Wicked fast. Also really hard to fall victim to SQL injection attacks unless you actually put some extra effort into doing something foolish.

    https://github.com/porsager/postgres#readme

  • GitHub repo postbird

    Open source PostgreSQL GUI client for macOS, Linux and Windows

    Project mention: PostgreSQL 14 Released | news.ycombinator.com | 2021-09-30

    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]

  • GitHub repo pg-boss

    Queueing jobs in Node.js using PostgreSQL like a boss

    Project mention: Do you need Redis? how to get away with just Postgres | news.ycombinator.com | 2021-06-12

    We’ve seen success in our current node.js application using pgboss [1] for job queueing. Since the primary database is Postgres, it’s nice to not introduce another dependency into the system, and take advantage of the infrastructure that we already have. The library supports most of what you’d expect from a job queue, and is crucially well maintained!

    That being said, I agree with other comments that this is somewhat swimming against the tide. Redis is much more commonly used, and so if you don’t mind adding another service into the mix, I’d probably recommend going with Redis instead.

    [1] https://github.com/timgit/pg-boss

  • GitHub repo Chartbrew

    Open-source web platform for creating charts out of different data sources (databases and APIs) 📈📊

    Project mention: Show HN: Open-Source multi-dashboarding platform for teams and client reporting | news.ycombinator.com | 2021-09-01

    One use-case that the platform is being used for is for B2B SaaS businesses to offer their analytics through Chartbrew. So it is possible and there are people already using it like this.

    Or if you're wondering if you can offer the analytics platform by itself as a SaaS, I built a SaaS layer on top of it here: https://chartbrew.com

  • GitHub repo 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

  • GitHub repo django-react-boilerplate

    DIY Django + React Boilerplate for starting your SaaS

    Project mention: Show HN: Django and React SaaS boilerplate tutorial | news.ycombinator.com | 2020-12-23

    As someone who works in Django a lot, their non-standard approach to defining models is wild.

    ie.

    Their approach in accounts models.py:

    https://github.com/saasitive/django-react-boilerplate/blob/m...

    Over the standard approach in their notes models.py:

    https://github.com/saasitive/django-react-boilerplate/blob/m...

  • GitHub repo PostGUI

    A React web application to query and share any PostgreSQL database.

    Project mention: Ask HN: Best (Low-/No-Code) Solution for Simple Web-Based Database Front Ends | news.ycombinator.com | 2021-04-01
  • GitHub repo pure-orm

    A Node.js SQL toolkit for writing native SQL queries yielding pure business objects

    Project mention: An ORM that is only an ORM | reddit.com/r/node | 2021-09-10
  • GitHub repo mlcraft

    Low-code metrics store, modern open-source alternative to Looker

    Project mention: Ыelf-hosted alternative to Looker | reddit.com/r/selfhosted | 2021-09-27
  • GitHub repo sqliterally

    Lightweight SQL query builder

    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.

  • GitHub repo giraffeQL

    🦒 Developer tool to visualize relational databases and export schemas for GraphQL API's.

    Project mention: giraffeQL - Relational Database Visualiser and Schema Exporter for GraphQL APIs | reddit.com/r/coolgithubprojects | 2021-02-27
  • GitHub repo lcbo-api

    A crawler and API server for Liquor Control Board of Ontario retail data

    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
  • GitHub repo Kyrix

    Interactive details-on-demand data visualizations at scale

    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

  • GitHub repo pgcmd

    Non-interactive PostgreSQL query tool.

    Project mention: Ask HN: What are some tools / libraries you built yourself? | news.ycombinator.com | 2021-05-16
  • GitHub repo ship-hold

    data access framework for Postgresql on nodejs

    Project mention: Which ORM/Query builder do you prefer using? | reddit.com/r/node | 2021-03-09

    Ship-Hold https://github.com/zorro-del-caribe/ship-hold

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 2021-10-08.

Index

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

Project Stars
1 Sequelize 25,120
2 Knex 14,818
3 PostgreSQL 9,950
4 Bookshelf 6,227
5 falcon 4,820
6 react-firebase-starter 4,350
7 orm2 3,062
8 pg-promise 3,024
9 postgres 2,153
10 postbird 1,176
11 pg-boss 689
12 Chartbrew 574
13 MiAOU 499
14 django-react-boilerplate 442
15 PostGUI 316
16 pure-orm 292
17 mlcraft 278
18 sqliterally 248
19 giraffeQL 147
20 lcbo-api 125
21 Kyrix 121
22 pgcmd 116
23 ship-hold 112
Find remote Postgresql jobs at our new job board 99remotejobs.com. There are 6 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
Scout APM: A developer's best friend. Try free for 14-days
Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
scoutapm.com