frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Cybersecurity Survival Notes – Open-Source Project

https://github.com/Radz-04/Cybersecurity-survival-notes
1•anonimo_•26s ago•0 comments

What makes a dog or cat live longer?

https://fluffmobile.com/research/what-makes-pets-live-longer/
1•titusblair•2m ago•0 comments

Microsoft's ONNX Runtime has disappeared from GitHub

https://github.com/microsoft/onnxruntime
2•nvader•9m ago•2 comments

Nvidia closes lower ahead of earnings as company reels from Huang resignation

https://www.cnbc.com/2026/11/17/nvidia-stock-earnings-jensen-huang-resignation.html
1•aghuang•9m ago•0 comments

Fucked Company

https://en.wikipedia.org/wiki/Fucked_Company
1•UmYeahNo•9m ago•0 comments

Netmap caching: keeping Tailscale up on iffy connections

https://tailscale.com/blog/netmap-caching
1•mfrw•10m ago•0 comments

Everything we got before Grand Theft Auto 6

https://www.polygon.com/what-we-got-before-grand-theft-auto-6/
1•abdullahalharir•17m ago•0 comments

The Validation Gap

https://cwodtke.com/the-validation-gap/
1•mooreds•17m ago•0 comments

Instrumental Convergence

https://en.wikipedia.org/wiki/Instrumental_convergence
1•jonbaer•17m ago•0 comments

Show HN: A non-brainrot, education Roblox game for your kids

https://www.roblox.com/games/129981060143619/Roxy-Island-Math-Reading
2•velex•19m ago•0 comments

Personhood: The Killer Credential?

https://www.vennfactory.com/blog-post/personhood-the-killer-credential
1•mooreds•20m ago•0 comments

OODA Loop

https://en.wikipedia.org/wiki/OODA_loop
1•mooreds•20m ago•0 comments

Making Art with QR Codes, and the Fine Line Between Inspiration and Idea Theft

https://www.gorillasun.de/blog/making-art-with-qr-codes-and-the-fine-line-between-inspiration-and...
1•shminge•23m ago•0 comments

Salesforce and Microsoft Announce Copilotforce

https://www.salesforce.com/news/stories/copilotforce-announcement/?bc=HL
2•qainsights•25m ago•0 comments

I hate GPT-6.2 Astra

https://twitter.com/i/status/2122760447103484410
5•Michelangelo11•30m ago•1 comments

StubHub International Announces Data Breach

https://news.pollstar.com/2026/11/17/stubhub-international-announces-data-breach/
1•zgeor•31m ago•0 comments

How to Tell If It's a Cyberattack or Just an Outage

https://www.wired.com/story/how-to-tell-if-its-a-cyberattack-or-just-an-outage/
1•emot•32m ago•0 comments

Revisiting my Master's thesis with AI – Understanding the Riemann Hypothesis

https://riemannhypothesis.blog/2026/11/revisiting-my-masters-thesis-with-ai/
2•kurinikku•35m ago•0 comments

Nvidia Beats Estimates, Raises Guidance After Huang's Ouster

https://www.wsj.com/tech/ai/nvidia-nvda-3q-2027-earnings-report-stock-6e642303
3•karimf•35m ago•0 comments

Ask HN: I read Blake Masters' notes for Zero to One went viral on HN

2•illidan1000•36m ago•1 comments

Show HN: Vyro Clipping Calculator – what your views actually pay

https://vyroclipping.org/
1•fireflywedding•37m ago•0 comments

Nvidia says it does not intend to reinstate Jensen Huang as CEO

https://www.theverge.com/report/1035465/nvidia-says-it-will-not-reinstate-jensen-huang-as-ceo
7•granto•37m ago•0 comments

Ageing could be switched off by a new gene

1•denisreshetov•37m ago•0 comments

The Accelerator Gap in Cancer Therapy

https://cerncourier.com/the-accelerator-gap-in-cancer-therapy/
1•EA-3167•38m ago•0 comments

ReactiveScript: A language for describing reactive UI

https://reactivescript.dev/
1•thomastill•43m ago•0 comments

Elderly people are buying Teslas for the 'full self-driving.' This is a problem

https://www.fastcompany.com/91641371/elderly-people-are-buying-tesla-for-full-self-driving-this-i...
2•danso•43m ago•0 comments

TDD with AI Agents: Design the Tests First, Let the Agent Implement

https://realpython.com/tdd-ai-agents/
1•rbanffy•46m ago•0 comments

StubHub Data Breach Exposes Customer Details

https://cypro.co.uk/insights/cyber-bulletins/stubhub-data-breach-exposes-customer-details/
1•zgeor•47m ago•0 comments

GPT-6.2 Astra and GPT-6.2 Sol

https://simonwillison.net/2026/Nov/17/gpt62-astra-and-sol/
2•acossta•47m ago•0 comments

Migrating to Python 3.15 – Mathspp

https://mathspp.com/blog/migrating-to-python-315
2•rbanffy•48m 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