/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

rocketee.rs
| | jchri.st

Here's a fun little tool that Debian ships in the postgresql-common package. Chances are you haven't heard of it, so let's dive into some fun usecases for it!
3.1 parsecs

Travel
| |
| | jinyuz.dev

So, I was trying to reproduce some issues and bugs that only happened in production. I needed an exact copy of the production database and run it locally. Here's how I did it using pg_dump and pg_restore. $ pg_dump -U postgres -Fc -Z 9 -j 8 production.dump -d postgres Here's the breakdown for the arguments: U means username. It's used to connect to your postgres database. In this case, my username is postgres.
5.5 parsecs

Travel
| |
| | www.shayon.dev

Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective
5.5 parsecs

Travel
| |
| | simonwillison.net

sqlite-utils is a combination Python library and command-line tool I've been building over the past six months which aims to make creating new SQLite databases as quick and easy as ...
22.5 parsecs

Travel
|