pkgx VS Jailer

I’m liking pkgx over asdf as it can activate project tooling upon cd’ing into a project folder.

https://pkgx.sh

I saw some alternatives being suggested and wanted to do the same (Also, so that I can look back at this item, through my comments :) ). Started using https://pkgx.sh/ lately. I know it has some baggage with tea.xyz and crypto, but it is also easy to get started with.

Secondly, our development environments must not drift, because then code may behave differently and a change could pass on our machine but fail in production. There are many tools for locking down environments, e.g nix, pkgx, asdf, containers, etc., and they all share the common goal of being able to lock down dependencies for an environment accurately and deterministically. And that needs to be enforced in our local workflow so we don't have to rely on CI environments for correctness. All developers must have environments that are effectively identical to what runs in CI (which itself should be representative of the production environment).

There are many ways this can be done (e.g nix, pkgx, asdf, containers, etc.), and we won’t get into which specific tools to use, because we'll instead cover the essential essence of preventing environment drift:

1. pkgx

Before diving in, it's a good idea to have a package manager handy, like tea. It'll handle your development environment and simplify your life!

Direct fast-track link to repo

checkout https://github.com/teaxyz/cli and https://github.com/teaxyz/pantry

Install is tea: sh <(curl https://tea.xyz) and

Some other tools I have also enjoyed:

DBVisualizer: https://www.dbvis.com/ (for exploring the schema)

Jailer: https://wisser.github.io/Jailer/ (for data browsing)

Aside from that, it's usually just been a mix of using specialized tools like MySQL Workbench, SQL Developer, pgAdmin and others, or something that tries to do it all like DataGrip.

Didn't actually find anything particularly amazing about DataGrip, but if I'm paying for the JetBrains Ultimate subscription, might as well use it because it's pretty okay.

I also found DBeaver to be a huge improvement over tools I used earlier.

Recently I discovered Jailer which makes it very easy to navigate complex relational structures: https://github.com/Wisser/Jailer