PostgresApp
bazel-postgres-sketch | PostgresApp | |
---|---|---|
2 | 58 | |
3 | 7,118 | |
- | 0.4% | |
0.0 | 9.2 | |
over 2 years ago | about 2 months ago | |
Shell | 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.
bazel-postgres-sketch
-
We Went All in on Sqlc/Pgx for Postgres and Go
I uploaded most of our Workspace setup here: https://github.com/jschaf/bazel-postgres-sketch. The tooling is a bunch of Go to manage the Postgres process. Basically, give it schema files and receive a running database with a tear down command.
We make temp instances of Postgres quickly by:
- avoiding Docker, especially on Mac
- keeping the data dir on tmpfs
- Disable initdb cleanup
- Disable fsync and other data integrity flags
- Use unlogged tables.
- Use sockets instead of TCP localhost.
For a test suite, it was 12x faster to call createdb with the same Postgres cluster for each test than than to create a whole new db cluster. The trick was to create a template database after loading the schema and use that for each createdb call.
-
In Praise of PostgreSQL
Sure, here's sketch of how it works: https://github.com/jschaf/bazel-postgres-sketch
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?
goyesql - Parse SQL files with multiple named queries and automatically prepare and scan them into structs.
DBngin - DB Engine
pike - Generate CRUD gRPC backends from single YAML description.
wsl-vpnkit - Provides network connectivity to WSL 2 when blocked by VPN
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
docker-openldap - OpenLDAP container image 🐳🌴
proteus - A simple tool for generating an application's data access layer.
xclip - Command line interface to the X11 clipboard
SQLBoiler - Generate a Go ORM tailored to your database schema.
arkade - Open Source Marketplace For Developer Tools
pronto - Protobuf ORM
prisma-examples - 🚀 Ready-to-run Prisma example projects