frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Show HN: AI Dating photos – can you tell they're AI?

https://datingprofile.app
1•markx997•5m ago•0 comments

Show HN: We submitted 105 AI-built contact forms – 27 said "sent", sent nothing

https://github.com/formgong/dead-forms-study
1•Formgong•5m ago•0 comments

AI Killed the MVP – Long Live the IUP

https://steveblank.com/2026/09/25/ai-killed-the-mvp-long-live-the-iup/
1•pella•6m ago•0 comments

Uber says hackers stole information on close to 150k DLs during data breach

https://techcrunch.com/2026/11/16/uber-confirms-hackers-stole-thousands-of-drivers-license-inform...
4•dvaplima•9m ago•0 comments

Trump DOJ Folds, Agrees to Permanent Ban on Censoring ICE Tracking Group and App

https://www.techdirt.com/2026/11/16/trump-doj-folds-agrees-to-permanent-ban-on-censoring-ice-trac...
2•cdrnsf•10m ago•0 comments

California Sues OpenAI over A.I. Safety Issues

https://www.nytimes.com/2026/11/16/technology/california-openai-ai-safety.html
3•ot•11m ago•0 comments

New CSIRO technique confirms iconic black hole image

https://www.csiro.au/en/news/All/News/2026/November/confirm-black-hole
1•atombender•11m ago•0 comments

The optogenetic tool ASAP acutely inhibits autophagy

https://www.nature.com/articles/s41556-026-02124-2
1•bookofjoe•11m ago•0 comments

Corma raises $125M at $1B valuation three months out of stealth

https://www.businesswire.com/news/home/20261116743982/en/Corma-Raises-%24125M-Series-A-at-%241B-V...
1•dvaplima•13m ago•0 comments

Cyber giant Infoblox confirms security incident

https://techcrunch.com/2026/11/16/cyber-giant-infoblox-confirms-security-incident-after-hackers-a...
2•cdrnsf•13m ago•0 comments

The New York Times on the Web: AOL Keywords

https://archive.nytimes.com/www.nytimes.com/info/help/aol-keywords.html
1•mmoogle•13m ago•0 comments

BIS Issues Rule Addressing Remote Access to American AI

https://www.bis.gov/press-release/bis-issues-rule-addressing-remote-access-american-super-intelli...
2•fosco•15m ago•0 comments

Show HN: NOS x86-64 hypervisor, written in Rust

https://nos-os.tech/en/demo
1•irqlevel•16m ago•0 comments

Claude vs. Dino [video]

https://www.youtube.com/watch?v=iUqU4Xe2D4E
1•mughu12345•16m ago•0 comments

Jensen Huang Passed Billions in Nvidia Stock to His Heirs Months Before Downfall

https://www.barrons.com/articles/jensen-huang-nvidia-stock-trust-grat-estate-tax-357c1fd3
2•madihaa•18m ago•0 comments

United Halts Flights as It Addresses 'Widespread System Outage'

https://www.nytimes.com/2026/11/16/business/united-airlines-outage-flights.html
3•jbredeche•18m ago•1 comments

FBI warns ARTEX AI hacking tool is powering global cyberattacks

https://www.bleepingcomputer.com/news/security/fbi-warns-artex-ai-hacking-tool-is-powering-global...
2•fosco•20m ago•0 comments

Improving the Wii U's Wii Mode

https://garyodernichts.blogspot.com/2026/11/improving-wii-us-wii-mode.html
1•GaryOderNichts•21m ago•0 comments

All code is slop (except mine) [video]

https://www.youtube.com/watch?v=O_zcc6Xl12g
1•jebarker•22m ago•0 comments

Show HN: Brewlet – Patch golden images across Kubernetes without rebuilding apps

https://brewlet.sh/
1•brunoborges•22m ago•0 comments

Disaster recovery efforts temporarily boosted health for some men

https://news.northwestern.edu/stories/2026/10/disaster-recovery-efforts-temporarily-boosted-healt...
1•sieste•26m ago•0 comments

[SPLASH'26] Mojo: Towards One Systems Language for All Hardware [video]

https://www.youtube.com/watch?v=9-97SB5XJh4
1•melodyogonna•26m ago•0 comments

Suitcase does more than one job

https://usefulls.com/
1•channusingh1424•27m ago•1 comments

United Airlines has a widespread system outage

https://apnews.com/article/united-airlines-outage-5a5e5f75bb07f11ffb8750901f0076ff
32•tedd4u•31m ago•5 comments

United Airlines experiencing 'widespread system outage'

https://www.nbcchicago.com/news/local/united-airlines-experiencing-widespread-system-outage/4017556/
4•scapecast•31m ago•0 comments

Marlow – an AI app builder that deploys to your own server

https://marlow.app
3•morzanius•31m ago•0 comments

Xcode now includes skills for performance profiling

https://developer.apple.com/documentation/xcode-release-notes/xcode-27_3-release-notes
1•Austin_Conlon•32m ago•0 comments

A Collage Showing 49 Drill Holes Made by NASA's Curiosity Mars Rover

https://science.nasa.gov/photojournal/a-collage-showing-49-drill-holes-made-by-nasas-curiosity-ma...
1•wawayanda•33m ago•0 comments

How to Break into Security, Ptacek Edition

https://krebsonsecurity.com/2012/06/how-to-break-into-security-ptacek-edition/
35•ronfriedhaber•34m ago•6 comments

US datacenters emit as much CO2 as Denmark

https://www.nature.com/articles/s41893-026-01985-7
6•28304283409234•34m ago•2 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