frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

SQLite JSON at Full Index Speed Using Generated Columns

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing
177•upmostly•4h ago•60 comments

Async DNS

https://flak.tedunangst.com/post/async-dns
18•todsacerdoti•1h ago•1 comments

4 billion if statements (2023)

https://andreasjhkarlsson.github.io//jekyll/update/2023/12/27/4-billion-if-statements.html
403•damethos•6d ago•121 comments

Fedora: Open-source repository for long-term digital preservation

https://fedorarepository.org/
62•cernocky•4h ago•35 comments

Microservices Should Form a Polytree

https://bytesauna.com/post/microservices
48•mapehe•4d ago•42 comments

Epic celebrates "the end of the Apple Tax" after court win in iOS payments case

https://arstechnica.com/tech-policy/2025/12/epic-celebrates-the-end-of-the-apple-tax-after-appeal...
88•nobody9999•1h ago•47 comments

Framework Raises DDR5 Memory Prices by 50% for DIY Laptops

https://www.phoronix.com/news/Framework-50p-DDR5-Memory
75•mikece•1h ago•46 comments

From text to token: How tokenization pipelines work

https://www.paradedb.com/blog/when-tokenization-becomes-token
79•philippemnoel•1d ago•8 comments

Show HN: tomcp.org – Turn any URL into an MCP server

https://github.com/Ami3466/tomcp
8•ami3466•46m ago•2 comments

CM0 – a new Raspberry Pi you can't buy

https://www.jeffgeerling.com/blog/2025/cm0-new-raspberry-pi-you-cant-buy
28•speckx•2h ago•1 comments

Secondary school maths showing that AI systems don't think

https://www.raspberrypi.org/blog/secondary-school-maths-showing-that-ai-systems-dont-think/
8•zdw•1h ago•3 comments

BpfJailer: eBPF Mandatory Access Control [pdf]

https://lpc.events/event/19/contributions/2159/attachments/1833/3929/BpfJailer%20LPC%202025.pdf
34•voxadam•3h ago•4 comments

Oracle made a $300B bet on OpenAI. It's paying the price

https://finance.yahoo.com/news/oracle-made-a-300-billion-bet-on-openai-its-paying-the-price-20544...
32•pera•55m ago•14 comments

The tiniest yet real telescope I've built

https://lucassifoni.info/blog/miniscope-tiny-telescope/
208•chantepierre•10h ago•55 comments

Show HN: Tripwire: A new anti evil maid defense

https://github.com/fr33-sh/Tripwire
54•DoctorFreeman•1d ago•31 comments

Koralm Railway

https://infrastruktur.oebb.at/en/projects-for-austria/railway-lines/southern-line-vienna-villach/...
273•fzeindl•7h ago•154 comments

Nokia N900 Necromancy

https://yaky.dev/2025-12-11-nokia-n900-necromancy/
429•yaky•17h ago•168 comments

Google de-indexed Bear Blog and I don't know why

https://journal.james-zhan.com/google-de-indexed-my-entire-bear-blog-and-i-dont-know-why/
343•nafnlj•16h ago•142 comments

Berlin Approves New Expansion of Police Surveillance Powers

https://reclaimthenet.org/berlin-approves-new-expansion-of-police-surveillance-powers
80•robtherobber•2h ago•39 comments

The Tor Project is switching to Rust

https://itsfoss.com/news/tor-rust-rewrite-progress/
256•giuliomagnifico•5h ago•174 comments

Senator endorses discredited book that claims chemical treats autism, cancer

https://www.propublica.org/article/ron-johnson-wisconsin-chlorine-dioxide-pierre-kory-endorsement
39•duxup•1h ago•6 comments

Guarding My Git Forge Against AI Scrapers

https://vulpinecitrus.info/blog/guarding-git-forge-ai-scrapers/
115•todsacerdoti•10h ago•75 comments

Octo: A Chip8 IDE

https://github.com/JohnEarnest/Octo
57•tosh•6d ago•9 comments

Japan law opening phone app stores to go into effect dec.18th

https://www3.nhk.or.jp/nhkworld/en/news/20251210_B1/
17•shlip•57m ago•2 comments

CRISPR fungus: Protein-packed, sustainable, and tastes like meat

https://www.isaaa.org/kc/cropbiotechupdate/article/default.asp?ID=21607
261•rguiscard•16h ago•188 comments

Training LLMs for Honesty via Confessions

https://arxiv.org/abs/2512.08093
39•arabello•7h ago•27 comments

He set out to walk around the world. After 27 years, his quest is nearly over

https://www.washingtonpost.com/lifestyle/2025/12/05/karl-bushby-walk-around-world/
199•wallflower•5d ago•162 comments

How to Articulate Yourself Intelligently

https://letters.thedankoe.com/p/how-to-articulate-yourself-intelligently
3•BerislavLopac•4d ago•1 comments

Rivian Unveils Custom Silicon, R2 Lidar Roadmap, and Universal Hands Free

https://riviantrackr.com/news/rivian-unveils-custom-silicon-r2-lidar-roadmap-universal-hands-free...
365•doctoboggan•23h ago•526 comments

Denial of service and source code exposure in React Server Components

https://react.dev/blog/2025/12/11/denial-of-service-and-source-code-exposure-in-react-server-comp...
324•sangeeth96•21h ago•205 comments
Open in hackernews

Vircadia, a Bun and PostgreSQL-powered reactivity layer for games

https://vircadia.com/
12•kaliqt•7mo ago

Comments

kaliqt•7mo ago
We gave Vircadia a full Gen 2 overhaul (big thanks to our sponsors such as Linux Professional Institute, Deutsche Telekom, etc. for enabling this), aiming to cut down on code bloat and boost performance. The main shift is swapping out our custom backend infrastructure for a battle-tested, high-performance system like PostgreSQL with Bun wrapping and managing every end of it.

It's kind of unheard of to do this for things like game dev (preferring custom solutions), but it works and makes things way easier to manage. The shape of the data in a database affects how well it works for a use case, and that model scales well for virtually every kind of software ever, the same should apply here!

Feel free to prototype some game ideas you might have been tossing around, our priority is DX for the project as a whole to enable more developers with less resources to build bigger worlds, so please do share feedback here and/or in GH issues!

Our roadmap is for more SDKs, and cutting down on bloat where possible, with the express goal of giving devs more cycles in the day to focus on the actual gameplay instead of tooling.

porridgeraisin•7mo ago
Interested to know why Deutsche telekom sponsored this
nand_gate•7mo ago
My guess is money laundering, given that the product is pretty vapourware-y (as a game dev in a past life: Vircadia looks more like 'how a web dev thinks multiplayer games work' aka basically unusable in a serious title).
kaliqt•7mo ago
I think you fundamentally misunderstand the stack. Their main usage of the platform has to do with a E2E solution with avatars, audio, etc. all synced without issue. These features ship with the client and other private repositories wrapping the core.

However, for usage to HN users they would be (likely) more interested in the SDK, the core, the underlying system, and how it can fit their use cases.

If you want to understand a small part of the scale of this project, you are welcome to check out:

https://github.com/vircadia/vircadia-web https://github.com/vircadia/vircadia-web-sdk https://github.com/vircadia/vircadia-native-core

kaliqt•7mo ago
For an E2E worlds solution, so this https://github.com/vircadia/vircadia-web and this https://github.com/vircadia/vircadia-native-core except heavily condensed so it's easier to modify/upgrade for each new bespoke use case.

Our old system, being very monolithic, while extremely performant and capable, was nearly impossible to adapt and change. So what we have now is much more dynamic but also still a work in progress, a more complete example will be published in the coming weeks.

ricardobeat•7mo ago
The example shows using it to update player positions. Doesn’t Postgres add significant latency considering a 16-33ms budget for state updates? How well does this scale?
andyferris•7mo ago
Generally client games optimistically carry on a few frames (and sometimes much more!) ahead of the what the server has responded with as accepted.

This is because gamers require low latency to effectively play, but things can be slightly out of sync and logic can be complex, and anti cheat can be hard to implement server side only (which is why eg fortnite and valarant install fancy client side anti cheat software too).

For a friendly game of stardew valley or turn based strategy you can afford to wait for transactions to complete and causality to be enforced.

kaliqt•7mo ago
We CAN submit the change to the DB and not listen to the message on if it succeeded or not! The message will arrive eventually, it's just not necessary to await it, so you have options.
jasonjmcghee•7mo ago
I had a similar reaction / question. Why not use KV store and get sub millisecond latency?
kaliqt•7mo ago
So it's a bit of tradeoffs, we may add a second DB to the compose by the time we reach v1.0, but, if we had to pick the convergence of simplicity and flexibility to start, PostgreSQL is it.

We prototyped SQLite as well. It just wasn't working in the stack like we had needed.

The idea is simple: use as few components as possible to achieve the outcome. Better to have less than more initially, because we can simply add the more and extend the API, but ripping everything out and trying to trim it down is damn near impossible, especially when the platform garners widespread usage.

The decision to do the less then more instead of more then less approach was spurred by us (the wider project) always having way too much bulk and then finding it impossible to turn the ship when we needed to (https://github.com/vircadia/vircadia-native-core).

We need to be agile to reach the milestones we have set out, hence the differed approach using off the shelf parts and only adding what we need, when we need it.

kaliqt•7mo ago
Postgres finishes its updates sub-ms in a reasonably sized DB if optimized correctly. In terms of upper-scale (>1000 players in a somewhat real-world scenario), we're working out benchmarks to test that.

Postgres is not slow by any stretch of the imagination, but it depends on how the schema is setup and what layers you have between the user and the DB, naturally any game developer will want to tweak the client+schema before going live. The layers between we manage to make it as minimal as possible, so that shouldn't be touched, if it's too slow for a reasonable use case, it means we have more optimization to do!

koakuma-chan•7mo ago
I love that you use Bun.
kaliqt•7mo ago
We have to cut bloat where we can if this is to work for higher up revision games, so Bun is the only answer that balances speed and simplicity (TypeScript native).
Drakim•7mo ago
How does the system separate between state changes that must be confirmed by backed compared to state changes that can be updated locally (by prediction) to give the user more snappy experience?
reedf1•7mo ago
I would love to get into some game design - and something like this seems intuitive enough from my perspective as a software engineer. Forgive me if this is a naive question, but is the use case for this single-player games or multiplayer games?
kaliqt•7mo ago
Definitely multiplayer games, you wouldn't really need a syncing networking layer if you're doing single player as you can store state in any method you desire, something as simple as serializing JSON to the disk for example, or up to your server. But even then, a traditional setup like Supabase might be simpler to wrap your head around if you're just handing "user" data and not "player" data in a shared world.