PostgresApp VS DBngin

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:

I was using Postgres.app, but of course, you can download it in any way as long as it works.

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.

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.

And if you're on a Mac, Postgres.app makes it even easier: https://postgresapp.com/

A great app for managing PostgreSQL databases is Postgres.app.

Check out DBngin or StackBricks.

Home page: https://dbngin.com/

My option of choice is DBngin. It is a simple tool which lets you add databases quickly for whatever you need including MySQL, Postgres, and even Redis.

Laravel Valet + PHP Monitor + DBngin

DBngin provides a free, all-in-one database management tool that includes MySQL, PostgreSQL, and Redis. After DBngin has been installed, you can connect to your database at 127.0.0.1 using the root username and an empty string for the password.

DBNgin is a great tool for spinning up a DB (MySQL/Postgres/Redis)

Ok I see what you mean, yeah that's a pain. You could turn off MySQL in MAMP and run a separate DB app such as DBngin (https://dbngin.com/), which makes it easier to start/stop different DB's but only offers different versions of MySQL, not MariaDB.

Download here

Laravel has a built in server which leverages local PHP. I use that combined with https://dbngin.com/ for MySQL + Redis. Then frontend is ran with local node (via https://volta.sh/, also very quick)