POSTGRES APP CREATE DATABASE INSTALL
POSTGRES APP CREATE DATABASE UPDATE

still requires all the code to be “source compatible”, as it’s all still being loaded into a single interpreter, and 2. Slightly more savvy package managers, like Rubygems, allow version constraints, but only globally there can only be one resolved version of each package (this is a fundamental limitation - loading multiple versions of the same library into a single Ruby runtime would generate namespace collisions), so Rubygems emits “constraint resolution failures” when different deps want incompatible versions of something.Īnd then there’s the Node.js approach, where everything can specify its own version constraints, and gets those specified versions installed recursively into its own nested node_modules dir.

POSTGRES APP CREATE DATABASE UPDATE

This creates long-standing update PRs in the homebrew-core repo, as the same PR that introduces an update, is expected to also then fix all the problems that introducing that update created for the rest of the ecosystem.) If a lib updates, and breaks its dependents? Too bad, the Brew maintainers need to go update all the dependents. (And Brew is very “naive” in this regard, as formulae can’t even specify a version constraint for their formula dependencies. Which is better than nothing, but it still means that different programs can’t be fixed to rely on different locked+resolved commits of the same symbolic-named ref of a dependent formula. Nix is more sort of a… content-addressable executable environment manager.īrew has a single shared “brew env” that it executes all its installs in the context of. Of course this is different from the isolation Docker provides, but I find that for development it is the perfect middle-ground between 'everything is installed globally and conflicts with each other' and 'everything is so perfectly isolated I can't get anything done'. If in project B I use Node.js v14, all I have to do is declare in its `default.nix` file that it uses `nodejs-14_x` and there will be no conflicts whatsoever. Once I exit it, `nodejs-12_x` is no longer available. When I run `cd /project/root & nix-shell` I'm dropped into a shell that has `nodejs-12_x` along with the rest of my 'normal' shell. The project root contains a `default.nix` file that says it needs the package `nodejs-12_x`.

A tool I use extensively when developing is a 'nix shell', which is a shell that's configured with a `default.nix` file.įor example, in project A I use Node.js v12.

POSTGRES APP CREATE DATABASE INSTALL

Nix is primarily a package management tool, yes, but it provides isolation in the sense that you don't have to globally install anything (except for Nix, of course).

Postgres app create database