frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

France's homegrown open source online office suite

https://github.com/suitenumerique
379•nar001•3h ago•185 comments

British drivers over 70 to face eye tests every three years

https://www.bbc.com/news/articles/c205nxy0p31o
111•bookofjoe•1h ago•88 comments

Start all of your commands with a comma (2009)

https://rhodesmill.org/brandon/2009/commands-with-comma/
421•theblazehen•2d ago•152 comments

Hoot: Scheme on WebAssembly

https://www.spritely.institute/hoot/
81•AlexeyBrin•5h ago•15 comments

Stories from 25 Years of Software Development

https://susam.net/twenty-five-years-of-computing.html
29•vinhnx•2h ago•4 comments

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

https://openciv3.org/
774•klaussilveira•19h ago•240 comments

Leisure Suit Larry's Al Lowe on model trains, funny deaths and Disney

https://spillhistorie.no/2026/02/06/interview-with-sierra-veteran-al-lowe/
14•thelok•1h ago•0 comments

First Proof

https://arxiv.org/abs/2602.05192
34•samasblack•1h ago•19 comments

Reinforcement Learning from Human Feedback

https://arxiv.org/abs/2504.12501
50•onurkanbkrc•4h ago•3 comments

The Waymo World Model

https://waymo.com/blog/2026/02/the-waymo-world-model-a-new-frontier-for-autonomous-driving-simula...
1021•xnx•1d ago•581 comments

Coding agents have replaced every framework I used

https://blog.alaindichiappari.dev/p/software-engineering-is-back
159•alainrk•4h ago•206 comments

Vocal Guide – belt sing without killing yourself

https://jesperordrup.github.io/vocal-guide/
160•jesperordrup•9h ago•60 comments

Software Factories and the Agentic Moment

https://factory.strongdm.ai/
11•mellosouls•2h ago•11 comments

72M Points of Interest

https://tech.marksblogg.com/overture-places-pois.html
10•marklit•5d ago•0 comments

Unseen Footage of Atari Battlezone Arcade Cabinet Production

https://arcadeblogger.com/2026/02/02/unseen-footage-of-atari-battlezone-cabinet-production/
103•videotopia•4d ago•26 comments

A Fresh Look at IBM 3270 Information Display System

https://www.rs-online.com/designspark/a-fresh-look-at-ibm-3270-information-display-system
17•rbanffy•4d ago•0 comments

StrongDM's AI team build serious software without even looking at the code

https://simonwillison.net/2026/Feb/7/software-factory/
9•simonw•1h ago•3 comments

Ga68, a GNU Algol 68 Compiler

https://fosdem.org/2026/schedule/event/PEXRTN-ga68-intro/
35•matt_d•4d ago•9 comments

Making geo joins faster with H3 indexes

https://floedb.ai/blog/how-we-made-geo-joins-400-faster-with-h3-indexes
152•matheusalmeida•2d ago•42 comments

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

https://github.com/valdanylchuk/breezydemo
261•isitcontent•19h ago•33 comments

Monty: A minimal, secure Python interpreter written in Rust for use by AI

https://github.com/pydantic/monty
275•dmpetrov•20h ago•145 comments

Show HN: Kappal – CLI to Run Docker Compose YML on Kubernetes for Local Dev

https://github.com/sandys/kappal
15•sandGorgon•2d ago•3 comments

Hackers (1995) Animated Experience

https://hackers-1995.vercel.app/
545•todsacerdoti•1d ago•263 comments

Sheldon Brown's Bicycle Technical Info

https://www.sheldonbrown.com/
417•ostacke•1d ago•108 comments

Show HN: I spent 4 years building a UI design tool with only the features I use

https://vecti.com
361•vecti•21h ago•161 comments

What Is Ruliology?

https://writings.stephenwolfram.com/2026/01/what-is-ruliology/
61•helloplanets•4d ago•65 comments

Show HN: If you lose your memory, how to regain access to your computer?

https://eljojo.github.io/rememory/
334•eljojo•22h ago•206 comments

An Update on Heroku

https://www.heroku.com/blog/an-update-on-heroku/
456•lstoll•1d ago•298 comments

Microsoft open-sources LiteBox, a security-focused library OS

https://github.com/microsoft/litebox
371•aktau•1d ago•195 comments

Google staff call for firm to cut ties with ICE

https://www.bbc.com/news/articles/cvgjg98vmzjo
108•tartoran•2h ago•30 comments
Open in hackernews

Postgres extension complements pgvector for performance and scale

https://github.com/timescale/pgvectorscale
143•flyaway123•1mo ago

Comments

ricw•1mo ago
I’ve been using this since early this year and it’s been great. It was what convinced me to just stick to Postgres rather than using a dedicated vector db.

Only working with 100m or so vectors, but for that it does the job.

pqdbr•1mo ago
Are you using a dedicated pg instance for vector or you keep all your data in a single pg instance (vector and non-vector)?
ComputerGuru•1mo ago
The biggest selling point to using Postgres over qdrant or whatever is that you can put all the data in the same db and use joins and ctes, foreign keys and other constraints, lower latency, get rid of effectively n+1 cases, and ensure data integrity.
dalberto•1mo ago
I generally agree that one database instance is ideal, but there are other reasons why Postgres everywhere is advantageous, even across multiple instances:

- Expertise: it's just SQL for the most part - Ecosystem: same ORM, same connection pooler - Portability: all major clouds have managed Postgres

I'd gladly take multiple Postgres instances even if I lose cross-database joins.

throwaway7783•1mo ago
Yep. If performance becomes a concern, but we still want to exploit joins etc, it's easy to set up replicas and "shard" read only use cases across replicas.
nicholasjarnold•1mo ago
Postgres supports the Foreign Data Wrapper concept from SQL/MED. If you configure this you can do joins across instances, even!

https://www.postgresql.org/docs/current/postgres-fdw.html

ricw•1mo ago
All in one of course. That’s the biggest advantage. And why postgres is great - it covers virtually all standard use cases.
esafak•1mo ago
What kind of performance do you observe with what setup?
ricw•1mo ago
Depends on the query and I don’t have exact numbers of the top of my head, but we’re talking low 100ms range for something pgvector itself wasn’t able to handle in a reasonable amount of time.
isoprophlex•1mo ago
The linked blogpost is an interesting read, too, comparing well-tuned pgvector to pinecone:

https://www.tigerdata.com/blog/pgvector-vs-pinecone

aunty_helen•1mo ago
Related discussion for pgvector perf: https://news.ycombinator.com/item?id=45798479
tacoooooooo•1mo ago
the main issue with pgvectorscale is that it's not available in RDS :(
omg2864•1mo ago
Yes, RDS seems to really hold PG back on AWS, with all the interesting pg extensions getting released now (pg_lake). It is a share I can't move to other PG vendors because it is a pain in the ass to get all privacy, legal docs in order.
calderwoodra•1mo ago
Yes, the InfoSec advantages of using RDS are very real, especially in B2B Enterprise SaaS.
coredog64•1mo ago
Technically, is there a reason AWS can't support allowing sophisticated users to run arbitrary extensions in RDS? The control-plane/data-plane boundaries should be robust enough that it's not going to allow an RDS extension to "hack AWS". Worst case is that AWS would have to account for the possibility of a crash backoff loop in RDS.

I understand that practically you can b0rk an install with a bunch of poorly configured extensions, and you can easily install something that hoovers up all your data and sends it to North Korea. But if I understand those risks and can mitigate them, why not allow RDS to load up extension binaries from an S3 bucket and call it a day?

If AWS wanted to broaden the available market, this would be an opportunity to leverage partners and the AWS marketplace mechanisms: Instead of AWS vouching for the extensions, allow partners to sell support in a marketplace. AWS has clean hands for the "My RDS instance crashed and wiped out my market cap" risk, but they can still wet their beak on the money flowing through to vendors. Meanwhile, vendors don't have to take full responsibility for the entire stack and mess with PrivateLink etc. Top tier vendors would also perform all the SOC attestation so that RDS doesn't lose out.

P.S. Andy, if you're reading this you should call me.

mrinterweb•1mo ago
I'm considering hosting a separate pg db just to be able to access certain extensions. I am interested in this extension as well as https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc... (also not available on RDS). Then use logical replication for specific data source tables (guess it would need to be DMS).
mmmeff•1mo ago
This is still unsupported in RDS, right?
tacoooooooo•1mo ago
correct afaik :(

https://github.com/timescale/pgvectorscale/issues/113

jascha_eng•1mo ago
We have a lot of happy customers that moved from rds to tiger cloud if you think pgvectorscale is interesting to you and you don't want to self host pg.

But yes big cloud providers move slow in adopting extensions.

mmmeff•1mo ago
No
jascha_eng•1mo ago
Combined with our other search extension for full text search these two extensions make postgres a really capable hybrid search engine: https://github.com/timescale/pg_textsearch
ldng•1mo ago
I'm not how you'd combine the two; care to give us a quick outline ?
jascha_eng•1mo ago
We have docs on how to do hybrid search here: https://www.tigerdata.com/docs/use-timescale/latest/extensio...

Essentially you combine the pgvector score and the bm25 score to hopefully get better results.

dmarwicke•1mo ago
does this actually fix metadata filtering during vector search? that's the thing that kills performance in pgvector. weaviate had the same problem, ended up using qdrant instead
whakim•1mo ago
Worth noting that the filtering implementation is quite restrictive if you want to avoid post-filtering: filters must be expressible as discrete smallints (ruling out continuous variables like timestamps or high cardinality filters like ids); filters must always be denormalized onto the table you're indexing (no filtering on attributes of parent documents, for example); and filters must be declared at index creation time (lots of time spent on expensive index builds if you want to add filters). Personally I would consider these caveats pretty big deal-breakers if the intent is scale and you do a lot of filtering.