node-pg-migrate
PostgresApp
Our great sponsors
node-pg-migrate | PostgresApp | |
---|---|---|
4 | 58 | |
1,215 | 7,108 | |
0.4% | 0.9% | |
8.9 | 9.2 | |
about 21 hours ago | about 1 month ago | |
TypeScript | Makefile | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
node-pg-migrate
-
Fully featured Repository Pattern with Typescript and native PostgreSQL driver
Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.
-
New to PostgreSQL - Best way to use it?
b) How you will manage schema migrations: every time you change tables, columns, foreign keys, every time you create or modify stored procedures, and so on, you need to do this through a migration. Here I'm at loss to recommend anything specific, but if you went with Prisma, I would read their docs and use whatever they are recommending you (if they actually recommend something). If you want something more neutral but still in the node ecosystem, node-pg-migrate might be the winner here? I'm not sure.
-
Postgres: What is the development process?
You’ll probably want something like this too: https://github.com/salsita/node-pg-migrate
-
The Architecture of a One-Man SaaS
You can use any normal DB migration tool. For k8s, I put the app's readiness probe to false, run the migrations and then toggle the probe back to true.
Here are some migration libraries:
PostgresApp
-
Test Driving a Rails API - Part One
A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:
-
Full Stack Chat App with Socket.io
I was using Postgres.app, but of course, you can download it in any way as long as it works.
-
Building Secure Neon-Infused Web Apps with Auth0, Express, and EJS
There are two ways to connect with the Postgres database which can be in the terminal or using a Postgres GUI client app like DBeaver. But first, download the PostgreSQL installer for macOS or Windows, depending on your OS. The setup and installation come with the psql command, a tool shipped with Postgres that allows you to communicate with Postgres through the command line.
- How do I get sql exactly?
-
Postgres: Opinionated Rules-of-Thumb and Gotchas
6a. Even stricter option is an "append-only" aka "timeseries" schema, which I highly recommend. Can't remember the last time I didn't use one.
7. If you happen to be testing on a Mac, https://postgresapp.com/ is easier than the MacPorts or Homebrew packages.
- Postgres.app – the easiest way to get started with PostgreSQL on the Mac
-
SQLite-based databases on the Postgres protocol? Yes we can
And if you're on a Mac, Postgres.app makes it even easier: https://postgresapp.com/
- Postgres Devs: What platform are you using to build postgres?
- Mac - zsh: command not found: psql
-
Creating a Telegram Desktop App with PostgreSQL and Next.js 🪄
A great app for managing PostgreSQL databases is Postgres.app.
What are some alternatives?
sql-lint - An SQL linter
DBngin - DB Engine
graphjin - GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks
wsl-vpnkit - Provides network connectivity to WSL 2 when blocked by VPN
logpaste - A simple web service for storing text log files
docker-openldap - OpenLDAP container image 🐳🌴
prawn-stack - A pageview counter using the AWS free tier, Postgres, Node and React
xclip - Command line interface to the X11 clipboard
flan - A tasty tool that lets you save, load and share postgres snapshots with ease
prisma-examples - 🚀 Ready-to-run Prisma example projects
migrate - Database migrations. CLI and Golang library.
arkade - Open Source Marketplace For Developer Tools