frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

WorldClaw Agentic 3D open-world generation at scale

https://tencent-hunyuan.github.io/Hunyuan3D-WorldClaw/
87•EwanG•2h ago•30 comments

Nvidia Nemotron 3.5 Lightning and NeMo Switchyard

https://blogs.nvidia.com/blog/nemotron-lightning-switchyard-rtx-dgx/
165•droidjj•4h ago•84 comments

Compression is prediction

https://ngrok.com/blog/compression-is-prediction
214•nikolay•4h ago•92 comments

Mojo 1.0

https://www.modular.com/blog/modular-26-5-mojo-1-0-is-here
269•dayanruben•7h ago•120 comments

Ethical Cold Outreach

https://blog.val.town/ethical-cold-outreach
29•stevekrouse•6h ago•23 comments

Go is an ideal language for AI-assisted software engineering

https://developers.googleblog.com/why-go-is-an-ideal-language-for-ai-assisted-software-engineering/
233•0xedb•7h ago•283 comments

Stealing Reasoning Traces from Proprietary LLM APIs

https://stolen-thoughts.com/
473•quantumgarbage•11h ago•201 comments

Making holograms with a pen plotter

https://blog.jordan.matelsky.com/Penplotter-holography/
105•DemiGuru•5h ago•11 comments

OpenAI’s head of ethics leaves less than a year after joining

https://www.ft.com/content/e49dfb75-f841-4466-a577-f7aaff8779a0
260•ilamont•12h ago•333 comments

Show HN: iPhone app takes simultaneous images from 2 lenses, fuses into 1 photo

https://photosynthesis.camera
192•sajomes•3d ago•194 comments

pg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries

https://clickhouse.com/blog/pg_clickhouse-whats-new-july-2026
31•saisrirampur•2h ago•2 comments

Grok Bot

https://x.ai/bot
109•rvz•7h ago•107 comments

Show HN: Tamron Lens Utility Alternative on Linux

https://github.com/yikerman/tamron-lens-control
13•xiaoyu2006•4d ago•0 comments

US hires over 2k video gamers as air traffic controllers

https://www.cbsnews.com/news/video-gamer-air-traffic-controllers-faa-recruitment-sean-duffy/
31•shagie•1h ago•16 comments

England set to be one of the first countries to eliminate hepatitis C

https://www.bbc.com/news/articles/c75gk620r22o
483•stevekemp•11h ago•347 comments

How we used to get jobs: A newspaper classifieds story

https://ironicsans.ghost.io/how-we-used-to-get-jobs/
100•speckx•6h ago•84 comments

Jolt: Clojure compiler implemented with Chez Scheme

https://jolt-lang.github.io
141•mark_l_watson•3d ago•51 comments

Suzanne: AI tool for designing and manufacturing physical products

https://www.suzanne3d.com/
28•Samanthajeanneb•3h ago•20 comments

Manus will return to operating as an independent company

https://manus.im/blog/a-note-to-our-users
129•thm•10h ago•68 comments

RSI Simulator

https://www.paradigm.xyz/writing/rsi-simulator
27•ckraeuter•7h ago•11 comments

Nvidia's Risky Business

https://stratechery.com/2026/nvidias-risky-business/
286•jonbaer•14h ago•134 comments

Show HN: Git-knife – edit commit messages, authors, and dates like a spreadsheet

https://github.com/TheRealYT/git-knife
124•YonathanTesfaye•9h ago•85 comments

Emergent Introspective Awareness in Large Language Models

https://arxiv.org/abs/2601.01828
19•doener•3h ago•8 comments

Show HN: Line9 - a Mermaid rendering engine with its own layout

https://line9.ai/diagram
4•jumpalongjim•5d ago•0 comments

London Underground begins scanning passengers' faces

https://www.btp.police.uk/news/btp/news/england/btp-expands-live-facial-recognition-lfr-trial-int...
207•BlueBerry2001•14h ago•245 comments

OpenSSH 10.5/10.5p1

https://www.openssh.org/releasenotes.html#10.5
92•voxadam•6h ago•30 comments

The Hat and the Spectre – Recent Groundbreaking Discoveries in Mathematics

https://momath.org/the-hat/
11•vismit2000•3d ago•1 comments

CSS properties you should know for better text designs

https://master.dev/blog/typographic-css-tricks/
66•ibobev•7h ago•6 comments

Apple Silicon and macOS VMs: Faster LLM Inference with llama.cpp

https://github.com/trycua/cua/blob/main/blog/gpu-passthrough-macos-vms.md
279•frabonacci•9h ago•43 comments

What I learned by putting GitHub Copilot behind a MitM proxy

https://www.lighthousenewsletter.com/p/i-put-github-copilot-behind-a-mitm
153•j0selit0•13h ago•24 comments
Open in hackernews

QueryLeaf: SQL for Mongo

https://github.com/beekeeper-studio/queryleaf
23•tilt•1y ago

Comments

ttfkam•1y ago
Would much rather have "Mongo" for SQL like this:

https://github.com/microsoft/documentdb

I am skeptical that SQL with Mongo backing it would be at all performant except in the most trivial cases. On the flip side, Postgres's jsonb indexing makes the inverse very doable.

Zambyte•1y ago
https://www.ferretdb.com/
VWWHFSfQ•1y ago
We're seeing a convergence of document DBs adding relational features, and relational DBs adding document features. At this point I find the best of both worlds to simply be PG with JSONB.

    create table document (
      id uuid primary key default gen_random_uuid(),
      doc jsonb
    );
This alone will give you a huge number of the features that Mongo provides, but also the full power of Postgres for everything else.
victor106•1y ago
this makes so much sense.

I also wonder if there are some specific capabilities of MongoDB that this pattern does not support?

etse•1y ago
Maybe not capabilities, but I'm wondering if Postgres has gotten any easier to scale horizontally. The administrative overhead of scaling and maintenance with MongoDB seemed lower to Postgres to me.

Would love to hear from others with more Postgres than I.

ttfkam•1y ago
Excluding conversations about MongoDB compatibility, PG16 added bidirectional replication for multiple writers and there are Postgres-compatible options out there for a distributed database including Citus, EDB Postgres Distributed, Yugabyte, CockroachDB, Aurora Limitless, etc.

The choices require some nuance to figure out a best fit, but then again so does any MongoDB installation (despite the marketing hype to the contrary as there are no free lunches).

You might be surprised how far most folks can typically scale with just read replica(s) on a reasonably sized writer. Add in bidirectional replication for multiple writers, and you can go even further. Beyond that, even vanilla Postgres can do it, but you'll need to do some combinations of partitioning and foreign tables.

zareith•1y ago
Curious if there is something similar that works with sqlite.
maxbond•1y ago
As of 3.38 (or 3.45 if you meant a binary JSON structure specifically) https://sqlite.org/json1.html
zareith•1y ago
We can use json type, but the dx around directly using that is not comparable to mongodb. Which is why I was looking for a similar abstraction.
aleksi•1y ago
There is FerretDB v1, which provides MongoDB protocol for SQLite. See https://github.com/FerretDB/FerretDB/tree/main-v1
zareith•1y ago
They seemed to have moved away from that.

From https://docs.ferretdb.io/migration/migrating-from-v1

> Unlike v1.x that provides options for PostgreSQL and SQLite as backend, FerretDB v2.x requires a PostgreSQL with DocumentDB extension as the backend

aleksi•1y ago
FerretDB v2 is built on top of this extension. See https://github.com/FerretDB/FerretDB
gavinray•1y ago
It's somewhat of a secret, but AWS's JDBC driver for DocumentDB supports Mongo as well

Let's you interact with Mongo as if it were a regular SQL JDBC database

https://github.com/aws/amazon-documentdb-jdbc-driver

bdcravens•1y ago
That driver is read-only
gitroom•1y ago
Honestly, putting Mongo and SQL together always confuses me a bit. I'm way more comfy with Postgres and jsonb. Anyone else feel like scaling Postgres is still kinda a pain?
sparky_•1y ago
I can appreciate the technical aspect of a translation layer, but I struggle to understand the use case for a tool like this. If your data is inherently relational, then you should be using a relational store anyway. And if it isn't, trying to hammer it on-demand into something that looks relational is going to eat you with performance implications. Unless I'm missing something.