frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Decision model for robot status 90% less time and money

https://www.rightnowai.co/rightnow
3•OsamaJaber•3m ago•0 comments

If tiny 'primordial' black holes exist

https://phys.org/news/2026-11-tiny-primordial-black-holes.html
1•wglb•5m ago•0 comments

Work Network added new lucky draw feature in the app

https://work-networks.com/lucky-draws.html
1•onlineiqbal•11m ago•0 comments

Long DNA strands turn chaotic fluid motion into a steady rhythm

https://phys.org/news/2026-11-dna-strands-chaotic-fluid-motion.html
1•wglb•14m ago•1 comments

Mapping every neuron in Qwen3-8B

https://www.fermionresearch.com/research/mapping-every-neuron-in-qwen3-8b/
2•sheepscreek•16m ago•0 comments

Astronomers discover remarkable 3-star system just 28 light-years from Earth

https://phys.org/news/2026-11-astronomers-remarkable-triple-star-years.html
1•wglb•17m ago•1 comments

The race to understand why young people are dying from colon cancer

https://www.scientificamerican.com/article/colon-cancer-in-young-people-might-have-a-distinct-and...
2•ValentineC•21m ago•1 comments

You can't spell ennui without AI

https://12gramsofcarbon.com/p/you-cant-spell-ennui-without-ai
1•theahura•22m ago•0 comments

Can We Refreeze the Arctic?

https://www.scientificamerican.com/article/can-we-refreeze-the-arctics-ice-scientists-test-new-ge...
3•yoloswagins•24m ago•0 comments

Show HN: Fire Circle – 15-minute 1-on-1 virtual breaks based on shared interests

https://play.google.com/store/apps/details?id=com.app.firecircle&hl=en_US
3•ahmay02•26m ago•0 comments

PyCon US 2026 Recap

https://mariatta.ca/posts/pycon-us-2026-recap/
1•lumpa•27m ago•0 comments

Stanford AI100 – One Hundred Year Study on Artificial Intelligence – 2026 Report

https://ai100.stanford.edu/reports/2026-report
2•lmc•31m ago•0 comments

Amazon serves political ads in-app pop-up

https://arstechnica.com/tech-policy/2026/11/amazon-takes-its-fight-against-nyc-delivery-bill-to-s...
4•worik•32m ago•1 comments

Show HN: I made the ultimate resource for learning about space

https://farbound.fyi/
1•sak5sk•38m ago•0 comments

Show HN: Google Workspace / Microsoft 365 alternative

https://cloud.mailflare.co
1•hieunc229•43m ago•0 comments

I built a solution and can't find the problem

https://chromewebstore.google.com/detail/shoppilot/jaookbeghccminjahkpgfgpdjblabhia
1•MichalKrk•43m ago•1 comments

Launch-at-Login for Windows | Firefox Help

https://support.mozilla.org/en-US/kb/launch-login-firefox
1•josephcsible•44m ago•0 comments

Trump ousts cyber director after tech outages spark criticism

https://www.reuters.com/world/us/white-house-national-cyber-director-cairncross-leaving-his-post-...
2•wslh•47m ago•2 comments

Mutex poisoning is not for everyone

https://bertptrs.nl/2026/11/16/mutex-poisoning-is-not-for-everyone.html
1•smarx•48m ago•0 comments

The Healthcare System, or whatever you call it

https://davebarry.substack.com/p/the-healthcare-system
1•brandonb•49m ago•0 comments

Show HN: Ufatfs: Unix overlay file system for VFAT/exFAT

https://fossil.chungy.name/ufatfs/doc/trunk/README.md
1•chungy•51m ago•0 comments

Metaphors Referring to Dairy Products

https://en.wikipedia.org/wiki/Category:Metaphors_referring_to_dairy_products
1•jacques_chester•53m ago•0 comments

In Defense of Astrophysics

https://gregdurrett.github.io/blog/2026-11-19-astrophysics/index.html
1•Anon84•55m ago•0 comments

PwC Is Teaching Critical Thinking to 85,000 Employees

https://www.inc.com/minda-zetlin/pwc-is-teaching-critical-thinking-to-85000-employees-we-all-need...
2•ChrisArchitect•58m ago•0 comments

What Comes After AGI?

https://institute.deepmind.com/essays/what-comes-after-agi/
5•jdkee•58m ago•0 comments

Postgres 19 Repack: Faster, Built-In Table Bloat Cleanup

https://www.snowflake.com/en/blog/engineering/postgres-19-repack-table-bloat/
3•craigkerstiens•59m ago•0 comments

Michael Tomasello: What a Squirrel Knows That Language Model Skips [video]

https://www.youtube.com/watch?v=io7qhEjJoik
1•eph0m0ral•1h ago•0 comments

LittleBit: Ultra Low-Bit Quantization via Latent Factorization

https://arxiv.org/abs/2506.13771
2•kakadu•1h ago•1 comments

Amazon Ring's New Indoor Surveillance Drone Is Not Compatible with Privacy

https://www.eff.org/deeplinks/2026/11/amazon-rings-new-indoor-surveillance-drone-not-compatible-p...
2•gslin•1h ago•0 comments

Nobody is talking seriously about AI demand

https://twitter.com/giovannicatt3/status/2094815425972539565
3•gmays•1h 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