frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

C64 ultimate firmware 1.2.1 released

https://downloads.commodore-international.com/documentation/changelog-1.2.1.txt
1•mikerg87•33s ago•0 comments

"A government that 'gets it'": Canada recommits to federal funding for news

https://www.niemanlab.org/2026/11/a-government-that-gets-it-canada-recommits-to-federal-funding-f...
1•DeepLogin•40s ago•0 comments

A Rust simulation engine for discrete-time controllers

https://www.modeloop.app/blog/porting-the-simulation-engine-into-rust
1•lucamark•44s ago•0 comments

The Birds of GTA 6: A Field Guide to Vice City and Leonida's Wildlife

https://www.audubon.org/magazine/birds-of-gta-6-field-guide-vice-city-wildlife
1•gaws•44s ago•0 comments

Detecting Bugs at the Interfaces of OpenBSD Privilege-Separated Programs [pdf]

https://mpi-sp-deos.github.io/assets/pdf/openbsd-civs-ccs26.pdf
1•beachhead•2m ago•1 comments

An A.I. Editor's Essential Tool: The Typewriter

https://www.nytimes.com/2026/11/22/insider/typewriter-artificial-intelligence.html
1•gaws•4m ago•0 comments

Show HN: A one-time $5 API pass for text,image,and audio models

https://ai.fissionagents.com/#models
1•12ziyad•5m ago•0 comments

Companies Suck at Internal Tooling

https://nonstationary.substack.com/p/companies-suck-at-internal-tooling
1•helicalmix•6m ago•0 comments

OpenRun 1.0 release – zero-config declarative deployments

https://openrun.dev/blog/openrun-1.0/
1•ajayvk•6m ago•1 comments

Mexico's President Flew 21 Hours to China in Economy (In a Middle Seat)

https://onemileatatime.com/news/mexico-president-flew-china-economy-middle-seat/
3•prmph•8m ago•0 comments

The first Britons were not 'black'

https://www.spiked-online.com/2024/02/07/no-the-first-britons-were-not-black/
2•jamesgill•11m ago•0 comments

Ask HN: Are startups today worth it even in a best case scenario?

3•enigmous_hippo•13m ago•0 comments

Meridian: Web-browser built on GPUI and Servo

https://op.tngl.io/meridian/
2•nerdypepper•14m ago•0 comments

Make your own Meta Muse / AI charm keychain

https://github.com/devniz/znp-re
2•nzr_ldn•15m ago•0 comments

Proposed proof of Riemann Hypothesis looks promising

https://www.scientificamerican.com/article/anthropic-mathematician-claims-to-prove-riemann-hypoth...
2•larryfreeman•16m ago•0 comments

Bell Canada says 'agentic' hacker stole enterprise customer data

https://www.bleepingcomputer.com/news/security/bell-canada-says-agentic-hacker-stole-enterprise-c...
3•ersinesen•18m ago•0 comments

Show HN: I made a manifestation film tool in 5 days

https://www.visionflick.com/
1•bjoern_live•18m ago•0 comments

The Shepard-tone theory of Capital

https://monofrogue.substack.com/p/the-shepard-tone-theory-of-capital
1•paulpauper•20m ago•0 comments

EAX x86 Register Meaning and History

https://keleshev.com/eax-x86-register-meaning-and-history/
5•ibobev•20m ago•0 comments

Dirac's Theorem at a Dinner Party

https://prideout.net/blog/dirac-dinner-party/
2•prideout•20m ago•0 comments

The Story of Ministry's Jesus Built My Hotrod

https://www.loudersound.com/features/the-story-of-ministrys-jesus-built-my-hotrod-gibby-threw-up-...
2•jruohonen•21m ago•0 comments

"Breathe"

https://mondmondmondmon.substack.com/p/breathe
1•paulpauper•22m ago•0 comments

The Short Age of Dragon Riders

https://atilloy.com/2026/11/16/the-short-age-of-dragon-riders/
1•libraryofbabel•23m ago•0 comments

AI and hiring: bad for employees, bad for employers

https://johnhempton.substack.com/p/ai-and-hiring-bad-for-employees-bad
2•rwmj•25m ago•2 comments

Boeing leaves open possibility of more layoffs amid stalled production plans

https://www.reuters.com/legal/litigation/boeing-leaves-open-possibility-more-layoffs-amid-stalled...
4•frank_clover•25m ago•0 comments

More load is faster: Tuning Postgres read replicas

https://clickhouse.com/blog/tuning-postgres-read-replicas
1•tudorg•26m ago•0 comments

Sub-30s LLM Pretraining on 8×H100? Modded-NanoGPT World Record Attempt (29.90 S)

https://amund.blog/modded-nanogpt-sub-30s-record-attempt/
1•amund•26m ago•0 comments

Voluntary attention regulates acute immune responses in humans

https://www.nature.com/articles/s41562-026-02541-1
2•rkp8000•26m ago•0 comments

TypeScript to C++ Compiler

https://github.com/geastack/compiler
1•arbayi•27m ago•0 comments

Models Can Communicate via Inference Servers Despite Being Sandboxed

https://www.lesswrong.com/posts/7wzWuLP3HhyBLmKfo/models-can-communicate-via-inference-servers-de...
1•ryankung•27m ago•0 comments
Open in hackernews

Ask HN: Any good tools to pgdump multi tenant database?

3•polishdude20•1y ago
Just joined a new company and they run a multi tenant database in postgres where each tenant is distinguished by their account ID. I'd like to be able to dump the data of a single account to my local instance to assist in debugging.

Problem is, many of the entities do not include an account ID. For example, a user can have an account ID but a user post will not but it will be tied to a user ID.

Also foreign keys aren't really implemented fully.

Are there any tools or techniques that could help make this process easier to do?

Comments

tudorg•1y ago
You can try with data subsetting tools, a few that I know are: greenmask, jailer, tonic condenser, and I think there are more. They are not exactly for your use case, but might help you a bit. The problem is most of these tools can walk foreign keys, but only in one directions.

Also, since you said FK are not fully implemented, then there just won't be enough information for them to work with. So you can either work on fixing the foreign keys or have more complex scripts.

polishdude20•1y ago
Thanks for the suggestions!

Yeah due to the unavailability of FK's, I'd have to somehow map certain ID columns to the tables they're for, accounting for slight naming convention differences.

woyten•1y ago
In case you don’t have FKs you could specify virtual foreign keys in Greenmask.

Check out docs for details

https://docs.greenmask.io/latest/database_subset/#virtual-re...

abhisek•1y ago
This is poor design. Multi-tenant data model design must have a tenant or segment ID for every tenant segmented tables. While it may not be a problem initially but as the business grows, you may need to move tenant data to separate DBs or even different regions based on compliance requirements. IMHO it is a good idea to run DB migrations and have a tenant ID populated in all tenant segmented tables
polishdude20•1y ago
Oh yes I agree with you. It may become a big push to convince my org to do that