frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

AI doesn't replace jobs: it removes the constraint that created them

https://briefings.canaryiq.com/p/the-invisible-governor
1•mintone•28s ago•0 comments

Linker Script Generation for Firmware Projects: A Primer

https://dnedic.github.io/blog/firmware-linker-script-generation/
1•dnedic•36s ago•0 comments

Show HN: Pluto – open-source Experiment Tracker for Neptune users

https://github.com/Trainy-ai/pluto
1•roanakb•39s ago•0 comments

Alphabet (Googl) Plans Tech's First 100-Year Bond Since Dot-Com Era

https://www.bloomberg.com/news/articles/2026-02-09/alphabet-mandates-banks-for-rare-100-year-ster...
1•corvad•54s ago•0 comments

I woke up to 77 pull requests

https://zachwills.net/building-at-the-speed-of-thought/
1•deveng24•2m ago•0 comments

Ring Doorbell's 'dystopian' Super Bowl ad is sparking privacy concerns

https://www.tyla.com/news/super-bowl-ring-doorbell-ad-privacy-concerns-099156-20260209
1•randycupertino•3m ago•0 comments

Understanding Green Day's "Holiday" [video]

https://www.youtube.com/watch?v=163MUrEoj5Y
1•cameron_b•3m ago•0 comments

ClawTime – An engaging 1-on-1 private chat interface for you and your AI agent

https://github.com/youngkent/clawtime
1•tongkeyun•4m ago•0 comments

Show HN: SDF Protocol – Pre-compiled semantic JSON for AI agent web consumption

https://sdfprotocol.org/
1•spranab•6m ago•1 comments

Show HN: LLM-use – orchestrate LLMs for AI agents like OpenClaw, cut costs

1•justvugg•7m ago•0 comments

Why cars in the next lane seem to go faster

https://www.nature.com/articles/43360
1•mhb•8m ago•0 comments

A method and calculator for building foamcore drawer organisers

https://capnfabs.net/posts/foamcore-would-be-a-sick-name-for-a-music-genre/
2•evakhoury•8m ago•1 comments

An articulated archer automaton [video]

https://www.youtube.com/watch?v=Bc0bIpDVEa8
2•Teever•9m ago•0 comments

Fat Agent(s) vs. Solver Market(s)

https://moldandyeast.substack.com/p/fat-agents-vs-solver-markets
1•rmrmrm•10m ago•1 comments

Ask HN: How do you test payment webhook edge cases?

1•jalalmanafi•11m ago•3 comments

Using an Engineering Notebook

https://ntietz.com/blog/using-an-engineering-notebook/
1•evakhoury•11m ago•0 comments

Show HN: Hyperstar – LiveView/Datastar for TypeScript and JSX

https://github.com/StreamUI/hyperstar
1•Jonovono•12m ago•0 comments

LocalGPT: A local AI assistant with persistent memory in a single binary

https://localgpt.app/
1•gaws•12m ago•0 comments

Know: Compiling LLM reasoning into a shared, open knowledge network

https://github.com/JoostdeJonge/Know
1•joostdejonge•12m ago•1 comments

How AI trained on birds is surfacing underwater mysteries

https://research.google/blog/how-ai-trained-on-birds-is-surfacing-underwater-mysteries/
2•salkahfi•13m ago•0 comments

DirectStorage LLM Weight Streaming: 4x faster loading, MoE expert streaming

https://github.com/kibbyd/llm_upper/blob/main/PROJECT_RECORD.md
1•kibbyd1985•14m ago•1 comments

Exploring D&D 5th Edition Monster Features Using Julia

https://cmu-lib.github.io/2026LoveDataWeek_DnDnDMonsterManagement/
1•mirawelner•15m ago•0 comments

Toyota Developing a Console-Grade, Open-Source Game Engine – Flutter and Dart

https://www.phoronix.com/news/Fluorite-Toyota-Game-Engine
2•mosura•15m ago•0 comments

GPT-5.3-Codex review after 4 days of use

1•agentifysh•15m ago•0 comments

Alphabet lines up 100-year sterling bond sale

https://www.ft.com/content/3260bc45-e09e-45a7-ae30-e55effbaf29b
1•hnburnsy•17m ago•0 comments

AI Took over the Super Bowl, Accounting for 23% of Ads

https://www.adweek.com/brand-marketing/super-bowl-revealed-ai-messaging-crisis/
1•firasd•19m ago•2 comments

Discord Is Not an Acceptable Choice for Free Software Projects (2020)

https://sneak.berlin/20200220/discord-is-not-an-acceptable-choice-for-free-software-projects/
2•sneak•20m ago•0 comments

Show HN: Brood– an image-first design tool for iterating on visual ideas

https://github.com/kevinshowkat/brood
2•kshowkat•21m ago•0 comments

Daily YouTube Digest for Your AI Agents

https://github.com/therohitdas/awesome-openclaw-usecases/blob/add-daily-youtube-digest/usecases/d...
1•nikhonit•21m ago•1 comments

Luce: First Electric Ferrari. Designed by LoveFrom

https://www.ferrari.com/en-US/auto/ferrari-luce
7•kaizenb•22m ago•3 comments
Open in hackernews

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

3•polishdude20•8mo 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•8mo 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•8mo 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•8mo 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•8mo 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•8mo ago
Oh yes I agree with you. It may become a big push to convince my org to do that