frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Pill to treat pancreatic cancer hailed as 'biggest breakthrough in decades'

https://www.theguardian.com/society/2026/nov/20/pill-pancreatic-cancer-breakthrough-daraxonrasib
365•rafaelc•1d ago•108 comments

Inkling-2-Mini in 5.4 GB Memory

https://github.com/ShinMegamiBoson/lookatmyquant
296•k__•4h ago•71 comments

Lean verification of the Riemann Hypothesis

https://leanprover-community.github.io/blog/posts/riemann-hypothesis/
720•g-b-r•8h ago•575 comments

Detonating a pile of lead azide

https://www.science.org/content/blog-post/detonating-huge-pile-lead-azide-really
471•beginning_end•9h ago•307 comments

Getting the mind to steer the body to steer you

https://notnottalmud.substack.com/p/getting-the-mind-to-steer-the-body
90•jger15•1d ago•34 comments

Brazil's tax authority open-sources its tax calculator on GitHub under MIT

https://www.gov.br/receitafederal/pt-br/assuntos/noticias/2026/novembro/receita-federal-publica-p...
670•dvaplima•4d ago•215 comments

PcapAnalyzer – self-hosted pcap analyzer with 27 problem detectors

https://github.com/sebaandrada-cell/PcapAnalyzer
7•sebaandrada•44m ago•1 comments

PostgreSQL Extensions in Go

https://jespino.github.io/gopgext/
103•valyala•5h ago•14 comments

Tasklet (YC P26) Is Hiring Product and Agent Infra Engineers

https://tasklet.ai/careers
1•mayop100•1h ago

Hurried Announcement: Alessandro Masullo GRH

https://math216.wordpress.com/2026/11/20/hurried-announcement-alessandro-masullo-grh/
2375•jasondavies•1d ago•1150 comments

My monitor was cutting my download speed by 75%

https://blog.tymscar.com/posts/studiodisplayethernet/
422•soheilpro•12h ago•213 comments

The Emergence of Inequality in the Czech Corded Ware Culture

https://www.jna.uni-kiel.de/index.php/jna/article/view/1560/1746
11•marojejian•1h ago•3 comments

Windows has two settings that bring work back after restart, both off by default

https://www.makeuseof.com/windows-can-bring-your-work-back-after-restart/
11•surprisetalk•2d ago•4 comments

Tropical Rainforests Species may be surprisingly young

https://phys.org/news/2026-11-species-tropical-rainforests-young-emergence.html
33•PaulHoule•4d ago•13 comments

Upload2Shell (CVE-2026-125396)

https://pwn.ai/upload2shell
59•f311a•4h ago•15 comments

Exponential Behavior in Magic: The Gathering

https://levineuwirth.org/essays/exponential-magic/
80•neuwirth•3d ago•58 comments

Show HN: Zero C# – C# without a runtime or GC

https://onurgumus.github.io/zero-csharp/index.html
112•reverseblade2•7h ago•86 comments

Verification files for the Lean proof of the Riemann Hypothesis

https://math.mit.edu/~drew/grh/
75•Bluestein•6h ago•26 comments

Inkling 2 Mini

https://thinkingmachines.ai/news/inkling-2-mini/
1348•jasondavies•1d ago•276 comments

Advice for the next 100 Rust GUIs

https://linebender.org/blog/next-100-guis/
8•raphlinus•1h ago•0 comments

Bolt's Scooters Are Becoming Accessibility Sensors

https://geoawesome.com/bolt-scooters-accessibility-mapping-wheels4wheels/
15•chippy•4d ago•15 comments

I'm quite pleased by the tech architecture of my art website

https://klauria.tech/klauria-art/
131•evakhoury•1d ago•31 comments

RCE in Gnupg

https://lists.gnupg.org/pipermail/gnupg-announce/2026q4/000517.html
218•gdgghhhhh•14h ago•86 comments

Why there are still no non-WebKit browsers on iOS

https://blog.mozilla.org/en/mozilla/internet-policy/apple-ios-browser-engine-rules/
444•lapcat•1d ago•245 comments

Context-Generic Programming v0.8.0 – Pluggable trait implementations for Rust

https://contextgeneric.dev/blog/v0.8.0-release/
10•maybevoid•3d ago•0 comments

Ask HN: I have been unemployed for 2y. 15 years of experience, US. What to do?

580•LetThingsBeDiff•23h ago•635 comments

LLMs can read and write executables byte by byte from a hex dump

https://sgiannopoulos.github.io/blog/machine-code-programming/
166•fortran77•3d ago•112 comments

We promoted developers into architects without informing them

https://manidoraisamy.com/developer-to-architect.html
571•QueensGambit•1d ago•306 comments

How I made a custom game engine for Satelital

https://spectralorbit.com/blog/satelital_game_engine
28•todsacerdoti•3d ago•3 comments

Show HN: An ASCII cell aquarium for your terminal

https://github.com/kborer/cells/
42•kborer•3d ago•16 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.