frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Brute Force Colors (2022)

https://arnaud-carre.github.io/2022-12-30-amiga-ham/
1•erickhill•2m ago•0 comments

Google Translate apparently vulnerable to prompt injection

https://www.lesswrong.com/posts/tAh2keDNEEHMXvLvz/prompt-injection-in-google-translate-reveals-ba...
1•julkali•2m ago•0 comments

(Bsky thread) "This turns the maintainer into an unwitting vibe coder"

https://bsky.app/profile/fullmoon.id/post/3meadfaulhk2s
1•todsacerdoti•3m ago•0 comments

Software development is undergoing a Renaissance in front of our eyes

https://twitter.com/gdb/status/2019566641491963946
1•tosh•3m ago•0 comments

Can you beat ensloppification? I made a quiz for Wikipedia's Signs of AI Writing

https://tryward.app/aiquiz
1•bennydog224•5m ago•1 comments

Spec-Driven Design with Kiro: Lessons from Seddle

https://medium.com/@dustin_44710/spec-driven-design-with-kiro-lessons-from-seddle-9320ef18a61f
1•nslog•5m ago•0 comments

Agents need good developer experience too

https://modal.com/blog/agents-devex
1•birdculture•6m ago•0 comments

The Dark Factory

https://twitter.com/i/status/2020161285376082326
1•Ozzie_osman•6m ago•0 comments

Free data transfer out to internet when moving out of AWS (2024)

https://aws.amazon.com/blogs/aws/free-data-transfer-out-to-internet-when-moving-out-of-aws/
1•tosh•7m ago•0 comments

Interop 2025: A Year of Convergence

https://webkit.org/blog/17808/interop-2025-review/
1•alwillis•8m ago•0 comments

Prejudice Against Leprosy

https://text.npr.org/g-s1-108321
1•hi41•9m ago•0 comments

Slint: Cross Platform UI Library

https://slint.dev/
1•Palmik•13m ago•0 comments

AI and Education: Generative AI and the Future of Critical Thinking

https://www.youtube.com/watch?v=k7PvscqGD24
1•nyc111•13m ago•0 comments

Maple Mono: Smooth your coding flow

https://font.subf.dev/en/
1•signa11•14m ago•0 comments

Moltbook isn't real but it can still hurt you

https://12gramsofcarbon.com/p/tech-things-moltbook-isnt-real-but
1•theahura•18m ago•0 comments

Take Back the Em Dash–and Your Voice

https://spin.atomicobject.com/take-back-em-dash/
1•ingve•18m ago•0 comments

Show HN: 289x speedup over MLP using Spectral Graphs

https://zenodo.org/login/?next=%2Fme%2Fuploads%3Fq%3D%26f%3Dshared_with_me%25253Afalse%26l%3Dlist...
1•andrespi•19m ago•0 comments

Teaching Mathematics

https://www.karlin.mff.cuni.cz/~spurny/doc/articles/arnold.htm
2•samuel246•22m ago•0 comments

3D Printed Microfluidic Multiplexing [video]

https://www.youtube.com/watch?v=VZ2ZcOzLnGg
2•downboots•22m ago•0 comments

Abstractions Are in the Eye of the Beholder

https://software.rajivprab.com/2019/08/29/abstractions-are-in-the-eye-of-the-beholder/
2•whack•23m ago•0 comments

Show HN: Routed Attention – 75-99% savings by routing between O(N) and O(N²)

https://zenodo.org/records/18518956
1•MikeBee•23m ago•0 comments

We didn't ask for this internet – Ezra Klein show [video]

https://www.youtube.com/shorts/ve02F0gyfjY
1•softwaredoug•24m ago•0 comments

The Real AI Talent War Is for Plumbers and Electricians

https://www.wired.com/story/why-there-arent-enough-electricians-and-plumbers-to-build-ai-data-cen...
2•geox•26m ago•0 comments

Show HN: MimiClaw, OpenClaw(Clawdbot)on $5 Chips

https://github.com/memovai/mimiclaw
1•ssslvky1•26m ago•0 comments

I Maintain My Blog in the Age of Agents

https://www.jerpint.io/blog/2026-02-07-how-i-maintain-my-blog-in-the-age-of-agents/
3•jerpint•27m ago•0 comments

The Fall of the Nerds

https://www.noahpinion.blog/p/the-fall-of-the-nerds
1•otoolep•29m ago•0 comments

Show HN: I'm 15 and built a free tool for reading ancient texts.

https://the-lexicon-project.netlify.app/
5•breadwithjam•31m ago•2 comments

How close is AI to taking my job?

https://epoch.ai/gradient-updates/how-close-is-ai-to-taking-my-job
1•cjbarber•32m ago•0 comments

You are the reason I am not reviewing this PR

https://github.com/NixOS/nixpkgs/pull/479442
2•midzer•33m ago•1 comments

Show HN: FamilyMemories.video – Turn static old photos into 5s AI videos

https://familymemories.video
1•tareq_•35m ago•0 comments
Open in hackernews

Ask HN: I'm a New PostgreSQL Hacker – What Problems Do You Face with Postgres?

7•DumBthInker007•9mo ago
Hi HN,

I'm a developer diving deep into PostgreSQL internals, aiming to contribute meaningfully to the project. I have a strong grasp of core components like the internal architecture, physical replication, WAL (Write-Ahead Logging), and buffer management. I'm now expanding into areas like logical replication, asynchronous I/O (AIO), the optimizer, and beyond.

To learn and grow as a Postgres hacker, I want to hear directly from you—PostgreSQL users—about the problems you face, big or small. These could be operational challenges, performance bottlenecks, confusing behaviors, missing features, or friction points in your workflows.

For me, it's a win-win: you get a contributor trying to tackle real problems, and I get to deepen my understanding by working on issues that matter in the real world. If a problem resonates with me, I’ll do my best to investigate, learn, and potentially create a patch to address it.

Thanks—and I look forward to hearing from you!

Comments

znpy•9mo ago
I'd like to see something like MySQL's Group Replication in PostgreSQL.

HA is still a wheel you have to re-invent yourself every time with PostgreSQL.

References for what i'm talking about:

- Group Replication: https://dev.mysql.com/doc/refman/8.4/en/group-replication.ht...

DumBthInker007•9mo ago
thanks for the quick reply, will surely look into it.
znpy•9mo ago
You're welcome. The bigger picture is probably this: https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster...
DumBthInker007•9mo ago
thanks for sharing.
WilcoKruijer•9mo ago
I’d like to see a true monotonic counter in Postgres. Serials can increment out of order when multiple transactions are active. We can obtain the WAL LSN, but it’s not related to the currently active transaction. I really like FoundationDB’s versionstamp, would be great to have that in Postgres.
DumBthInker007•9mo ago
Thanks for the reply,will surely look into it.
dapperdrake•9mo ago
How is a "true monotonic counter" supposed to interact with atomicity and isolation of transactions? Sounds like a global bottleneck.

Is uniqueness sufficient or is it really required to step through all integers without missing any?

EDIT: Missing primary keys in-between also bothers me, however, never found a decent solution for this at scale.

hyperman1•9mo ago
Parallell insert. I can easily saturate a CPU with insert statements, with io very low.
DumBthInker007•9mo ago
Hi thanks for the reply ,i guess there was some ongoing work for this and for some reason it didn't continued this is the thread https://www.postgresql.org/message-id/flat/CAJcOf-cXnB5cnMKq... if you are interested in, but for sure i will look into this(added to my list:).
hyperman1•9mo ago
What can I say, except thank you very much.
dapperdrake•9mo ago
That seems like an unintuitive consequence. Saturating disk would have been obvious. But CPU?

Does anything about the INSERT pattern seem "special"? Or does it happen for many different "kinds of INSERT statements"?

I_am_tiberius•9mo ago
1. I'd like a native way to scale horizontally based on tenant ids without using citus. 2. array constraints (foreign keys) -> meaning that each item in the array references an id in another table.
cssanchez•9mo ago
My experience with PG ended a few years ago. The thing that killed PG for me is the lack of collation for searches. I haven't tested since the last updates that mentioned something along these lines, so this may have improved.

PG for years relied on unaccent which is not a true solution as it requires manually storing two versions of a text (the original and the un-accented one) and handle indexes + searches manually for each field... Not to mention unaccent itself is an extension you have to install. Whereas collation is built-in and it just works by handling it all under the hood in SQL Server. This feature alone is worth switching databases for my use cases.

That and the updates being a royal pain.

DumBthInker007•9mo ago
Thanks for sharing.