frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

What every developer needs to know about in-process databases

https://www.graphgeeks.org/blog/what-every-developer-needs-to-know-about-in-process-dbmss
12•semihs•1y ago

Comments

semihs•1y ago
In-process (aka embedded/embeddable) databases are not new. In fact SQLite is the most widely deployed database in the world. However, starting with DuckDB, there is a new set of in-process database systems, such as Kuzu and Lance. As a co-developer of Kuzu, I hear several frequently asked questions (some of which are misconceptions) about in-process databases.

- What are their advantages/disadvantages compared to client-server databases? - Does in-process mean databases are in-memory/ephemeral? (NO!) - Can in-process databases handle only small amounts of data? (NO!) - What are some common use cases of in-process databases? - What if my application needs a server?

I tried to answer some of these questions in a blog post with pointers to several other resources that articulate several of these points in more detail than I get into.

I hope it's helpful to clarify some of these questions and help developers position in-process DBMSs against client-server ones.

emmanueloga_•1y ago
The article suggests running Kuzu in a FastAPI frontend for network access. A caveat: production Python servers like Uvicorn [1] typically spawn multiple worker processes.

A simple workaround is serving HTTP through a single process language like Go or JavaScript, since Kuzu has bindings for both. Other processes could access the database directly in read-only mode for analysis [2].

For better DX, the ideal would be Kuzu implementing the Bolt protocol of Neo4J directly in the binary, handling single-writer and multi-reader coordination internally. Simpler alternative: port the code from [3] to C++ and add a `kuzu --server` option.

--

1: https://fastapi.tiangolo.com/deployment/server-workers/#mult...

2: https://docs.kuzudb.com/concurrency/#scenario-2-multiple-pro...

3: https://github.com/kuzudb/explorer/tree/master/src/server

semihs•1y ago
Yes this makes sense and we plan to eventually do something along what you are suggesting. We also have a plan to have a built-in server/GUI, where users can directly launch a web-based explorer through our CLI by typing "kuzudb -ui".
emmanueloga_•1y ago
That sounds great!

Slate Screenless GPS

https://www.slate.auto/en/store/AXM0059
1•nticompass•13s ago•1 comments

Waves as High as 50 Feet Pummel the California Coast [video]

https://www.youtube.com/watch?v=8MntJrFZANs
1•shinryudbz•1m ago•0 comments

Show HN: A Linter and GitHub Action for Claude.md, Agents.md and Skill.md

https://github.com/Katta041/asitis-agent-tools
1•Katta041•2m ago•0 comments

Purism prepares to release Librem 5 v2

https://www.phoronix.com/news/Librem-5-v2-Announced
1•nalekberov•3m ago•0 comments

Trystero – Serverless peer-to-peer multiplayer for the web

https://trystero.dev/
1•eustoria•3m ago•0 comments

3D Sword Coast Map with weather and day/night cycle (Rust to WebGL)

https://swordcoastmap.com/
1•elliotbnvl•4m ago•1 comments

Prefer synthetic traffic over LLM as a judge

https://softwaredoug.com/blog/2026/11/12/agent-search-traffic
1•softwaredoug•4m ago•0 comments

Some Linux maintainers are quitting under AI bugs, but there are signs of hope

https://www.zdnet.com/innovation/ai-bug-reports-linux-windows/
2•CrankyBear•4m ago•0 comments

Erasing 20 Years of Digital Identity

https://vanilla.sh/blog/identity-v1/
1•speckx•5m ago•0 comments

iPhone Duo for Creative Pros

https://www.austinmann.com/trek/iphone-duo
1•eustoria•7m ago•0 comments

A5 Pyramids

https://a5-pyramids.belian.earth/
1•pheelicks•7m ago•0 comments

The Economics of Intelligence

https://www.convex.io/thoughts/the-economics-of-intelligence/
2•jflatow•8m ago•0 comments

AI Guardrails Explained

https://blog.kjamistan.com/ai-guardrails-explained.html
1•eustoria•8m ago•0 comments

Rust Nightly to Begin Enabling Parallel Front End by Default

https://www.phoronix.com/news/Rust-Nightly-Parallel-Frontend
3•Bender•8m ago•0 comments

Show HN: Liar's Ledger – Werewolf deduction for one player, solved by reasoning

https://theliarsledger.com/play/
1•enoch_hou•8m ago•0 comments

Friselle: The ingenious Italian bread that can last for a year

https://www.bbc.com/travel/article/20261112-friselle-the-ingenious-italian-bread-that-can-last-fo...
1•tosh•9m ago•0 comments

Marvell and Penguin Solutions aim to end the RAMpocalypse with photonic fabric

https://www.theregister.com/systems/2026/11/16/marvell-and-penguin-solutions-aim-to-end-the-rampo...
1•Bender•10m ago•0 comments

University of Toronto's database of academic discipline decisions

https://governingcouncil.utoronto.ca/adfg/page/case-summaries-reasons/university_tribunal_decisio...
1•sbdaman•10m ago•1 comments

James Webb Telescope finds ice older than the star it orbits

https://arstechnica.com/science/2026/11/james-webb-telescope-finds-ice-older-than-the-star-it-orb...
2•Bender•10m ago•0 comments

SwiftWin – build and run SwiftUI iPhone apps from Windows, no Mac

https://github.com/Dadon-11/SwiftWin-Studio
1•Dadon11•11m ago•0 comments

Learning to Code in 2026: The Data

https://www.boot.dev/blog/jobs/job-data-on-learning-to-code-2026
8•theobeers•11m ago•2 comments

Project Gutenberg temporarily down for maintenance

2•robin_reala•12m ago•0 comments

Show HN: Paisty, a Mac app that reads the front window and pastes a reply draft

https://www.paisty.com/
1•hailports•12m ago•0 comments

Show HN: DockShip42, small browser game to land Starship

https://www.dockship42.com
1•ml_comms_eng•12m ago•0 comments

Show HN: Meridian, a network engineer's Swiss army knife

https://github.com/hriday/meridian
1•hridaybala•13m ago•0 comments

Who paid right-wing influencers to promote Nvidia chip sales to China?

https://twitter.com/TheMidasProj/status/2122347141050028302
1•pretext•14m ago•1 comments

Show HN: Torsher – a Jellyfin and *ARR alternative in one Docker container

https://torsher.app/demo/tv/
1•antonreshetov•14m ago•0 comments

Frame – 31.5" color ePaper display

https://trmnl.com/blog/introducing-frame
2•geerlingguy•15m ago•2 comments

Android Time Machine

https://android.levente.net
2•srhngpr•15m ago•1 comments

US allies deepen deal to guard AI supply chains against 'hostile actors' (China)

https://www.theregister.com/systems/2026/11/16/us-allies-deepen-deal-to-guard-ai-supply-chains-ag...
4•beardyw•15m ago•0 comments