frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Italian court places Revolut under supervision over money laundering

https://www.fstech.co.uk/fst/Italian_Court_Places_Revolut_Under_Supervision_Over_Money_Laundering...
1•marcyb5st•31s ago•0 comments

Microsoft discovers AI can't keep the email going

https://www.channelnewsasia.com/commentary/commentary-microsoft-discovers-ai-cant-keep-email-goin...
1•Markoff•2m ago•0 comments

Show HN: Fifty Shades of Claude (Book as a Skill)

https://github.com/adi-devv/fifty-shades-of-claude
1•sharkyy•2m ago•0 comments

Revolut - October Outage: Technical Overview

https://www.revolut.com/blog/post/20octoutagetechnicaloverview/
2•_sJiff•3m ago•0 comments

Muru: Scaling from What the Workers Report

https://grahamdumpleton.me/posts/2026/11/muru-scaling-from-what-the-workers-report/
1•lumpa•3m ago•0 comments

Floem: Cross-platform GUI framework for Rust

https://github.com/lapce/floem
1•modinfo•3m ago•0 comments

Pip-Tools: From Jazzband to PyPA

https://webknjaz.me/prose/pip-tools-moves-to-pypa/
1•lumpa•4m ago•0 comments

Pip-Tools v7.7.0

https://sirosen.net/2026/11/15/pip-tools-770.html
1•lumpa•4m ago•0 comments

Hackers Thawed Europe's Supermarket Freezers

https://medium.com/data-science-collective/open-sesame-said-the-freezer-3d6ba294a587
1•cadeos•5m ago•0 comments

Show HN: IronSurf – Browser in full Rust with cookie containers and userscripts

https://github.com/h4sh5/ironsurf
1•h4sh•5m ago•0 comments

Nationwide Ground Stop: Questions and Answers

https://www.faa.gov/newsroom/nationwide-ground-stop-questions-and-answers
1•KoftaBob•5m ago•0 comments

Never use a URL shortening service – even if you own it (2023)

https://shkspr.mobi/blog/2023/02/never-use-a-url-shortening-service-even-if-you-own-it/
3•jamietanna•7m ago•0 comments

Loadsketch: A system design simulator. Every request runs for real

https://loadsketch.mclee.dev/
1•alxtztw•10m ago•0 comments

Personal Agent Protocol

https://personalagentprotocol.org
1•janpio•15m ago•0 comments

Huang's affair with suspected spy is Silicon Valley's worst nightmare come true

https://www.theguardian.com/technology/2026/nov/14/jensen-huang-affair-nvidia-nightmare
2•nephihaha•15m ago•0 comments

Generative Artificial Intelligence and the Limits of the Corpus

https://medium.com/@smoking2man/generative-artificial-intelligence-and-the-limits-of-the-corpus-w...
1•Aldus551•16m ago•0 comments

Ask HN: Woz wrote BASIC before the Apple II. What would Emacs-only hardware be?

1•oliverchan2024•18m ago•0 comments

Stackboard – a Chrome new tab that's just your bookmarks, in columns

https://chromewebstore.google.com/detail/stackboard-new-tab-bookma/bgcedhchngcopaefchpkbhioagknnpma
2•intensityflow•24m ago•0 comments

Running untrusted CMS plugins in WebAssembly

https://hatamoto.dev/post/running-untrusted-cms-plugins-in-webassembly
6•sammatilda•26m ago•0 comments

Six hours and a stack of .md files

https://security.is.fucked.blog/six-hours-and-a-stack-of-md-files
1•micr0byte•26m ago•0 comments

LinkedIn Pinpoint Answer Today

https://wordanswer.today
2•dolaiart2026a•27m ago•0 comments

Why Every Startup Needs an Origin Myth

https://www.joanwestenberg.com/p/why-every-startup-needs-an-origin
1•flail•28m ago•0 comments

We found 1,698 Internet-visible AI offensive-security endpoints

https://gcore.com/blog/ai-offensive-security-endpoints-artex-pentagi-cairn
2•XaviorE•34m ago•0 comments

Mitchell Hashimoto's TUI – public beta waitlist

https://www.superlogical.com/updates/public-testing-beginning
2•michael-sumner•35m ago•1 comments

David Sacks Is Fucked Too

https://daringfireball.net/linked/2026/11/13/sacks
11•JumpCrisscross•41m ago•2 comments

It's always DNS, so why are we running our own?

https://s2.dev/blog/dns-server
2•misker1•42m ago•1 comments

Show HN: Unlimited-OCR-2 on Dual-Panel Lab Tables: What Works, What Breaks, How

https://zlu.me/2026/11/16/unlimited-ocr-2-dual-panel-lab-tables.html
2•zlu•42m ago•0 comments

Overpass API Performance Issues

https://community.openstreetmap.org/t/overpass-api-performance-issues/140598?page=10
4•altilunium•42m ago•0 comments

Show HN: VennDB: append-only in-memory Rust DB for rows queried using bit flags

https://github.com/plabayo/venndb
1•gdcbe•44m ago•0 comments

The Invisible Shape

https://sorenblank.com/craft/the-invisible-shape
2•matthberg•45m 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