node-pg-migrate
flan
Our great sponsors
| node-pg-migrate | flan | |
|---|---|---|
| 4 | 10 | |
| 1,215 | 181 | |
| 0.6% | 0.6% | |
| 8.9 | 0.0 | |
| 4 days ago | over 2 years ago | |
| TypeScript | TypeScript | |
| MIT License | MIT License |
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:
Go - https://github.com/golang-migrate/migrate
Node - https://github.com/salsita/node-pg-migrate
flan
- Flan – A tasty tool that lets you save, load and share Postgres dumps with ease
- Flan, a tool to save and share Postgres across your team
- Flan, a tool to quickly take snapshots of Postgres databases and share them with your team
- Flan: easily save/load postgres snapshots and share them across your team via git
- Flan: a cli tool to help your team save and share postgres snapshots
- Flan, a tool that makes sharing Postgres dumps across your team easy
What are some alternatives?
sql-lint - An SQL linter
mergestat-lite - Query git repositories with SQL. Generate reports, perform status checks, analyze codebases. 🔍 📊
graphjin - GraphJin - Build NodeJS / GO APIs in 5 minutes not weeks
vscode-sqltools - Database management for VSCode
logpaste - A simple web service for storing text log files
vinit - Vinit is a command-line tool to generate V projects and run scripts written in V
prawn-stack - A pageview counter using the AWS free tier, Postgres, Node and React
mergestat - MergeStat enables anyone to ask questions about the history and contents of source code.
migrate - Database migrations. CLI and Golang library.
postgres-meta - A RESTful API for managing your Postgres. Fetch tables, add roles, and run queries
kubernetes-the-hard-way - Bootstrap Kubernetes the hard way. No scripts.
diagrams - :art: Diagram as Code for prototyping cloud system architectures