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!

UK conducting offensive cyber ops against Russia, China, Iran and North Korea

https://news.sky.com/story/uk-conducting-offensive-cyber-ops-against-russia-china-iran-and-north-...
1•DeepLogin•2m ago•0 comments

Wikipedia Rewrote Zionism

https://quillette.com/2026/10/30/how-wikipedia-rewrote-zionism/
2•baud147258•5m ago•0 comments

The Last Acceptable Prejudice

https://quillette.com/2026/11/17/the-last-acceptable-prejudice-lookism/
1•baud147258•5m ago•0 comments

My friend's group chat just got roasted

https://github.com/defAaron/gc-wrapped
1•aaron_dutta•7m ago•1 comments

Another company I've never heard of lost my Data

https://idiallo.com/byte-size/another-company-lost-my-data-and-free-credit-monitoring
1•foxfired•8m ago•0 comments

Donald Trump vows to tax US companies building data centres overseas

https://www.abc.net.au/news/2026-11-21/trump-vows-tax-companies-building-data-centres-overseas/10...
2•ggm•16m ago•1 comments

Reviving the Donkey Car with Erlang

https://underjord.io/reviving-the-donkey-car-with-erlang.html
1•lawik•18m ago•0 comments

Cursor tells Congress it's considering phasing out foreign open-weight AI models

https://www.cnbc.com/2026/11/20/cursor-chinese-ai-models-geopolitical-risk.html
1•CGMthrowaway•19m ago•0 comments

AI may have solved the most important problem in mathematics

https://www.economist.com/science-and-technology/2026/11/20/ai-may-have-solved-the-most-important...
2•vinni2•27m ago•0 comments

Real-Time Messaging (2023)

https://slack.engineering/real-time-messaging/
1•thunderbong•27m ago•0 comments

Per-task file scopes enforced by a PreToolUse hook for subagents [video]

https://www.youtube.com/watch?v=-_t_ZsufwvU
1•agentshipped•29m ago•0 comments

Libreboot Abandons Anti-AI Policy After One Month

https://www.phoronix.com/news/Libreboot-Drops-AI-Policy
3•Novosell•32m ago•0 comments

Written Agent Authorizations: 25 Instruments, Dissected for AI-Agent Design

https://github.com/dazzaji/agent4whom/blob/main/25-legal-instruments.md
1•mooreds•32m ago•0 comments

Is this the kind of book Hacker News likes?

https://davidngo1562.substack.com/p/its-not-about-the-money-until-it
1•illidan1000•32m ago•1 comments

Antseed – brings people's computers together to serve AI

https://antseed.com/
1•bilsbie•34m ago•0 comments

Metro UI: How a Bold Design Language Changed Everything [video]

https://www.youtube.com/watch?v=MYyyhAhHgT8
1•MaximilianEmel•41m ago•0 comments

Ask HN: Should Uber Ratings Decay over Time?

2•AB3TZ•41m ago•0 comments

Mailchimp employees asked to care for each other post Bending Spoons acquisition

https://www.businessinsider.com/mailchimp-intuit-plans-bending-spoons-sale-memo-2026-11
3•cebert•41m ago•1 comments

Pac-Hunt – You're the Ghost

https://garritfra.github.io/pac-hunt/
1•bookofjoe•42m ago•0 comments

NINLIVE: The Nine Inch Nails live archive

https://ninlive.com/
15•CharlesW•43m ago•1 comments

Nasdaq erases all 2026 gains

https://www.cnbc.com/2026/11/19/stock-market-today-live-updates.html
12•mv4•45m ago•0 comments

This Industrial Revolution Belongs to the Builders

1•pacificmaelstrm•45m ago•0 comments

Bernhard Riemann

https://en.wikipedia.org/wiki/Bernhard_Riemann
1•simonebrunozzi•46m ago•0 comments

The blue sucker discovered to live well over 100 years

https://d.umn.edu/news/research-brief-fish-old-montana-blue-sucker-discovered-live-well-over-100-...
1•geox•46m ago•0 comments

Let's Talk About Why All This OT Stuff Is Connected

https://tisiphone.net/2026/11/08/lets-talk-about-why-all-this-ot-stuff-is-connected/
2•birdculture•47m ago•0 comments

The Rot of Youth Sports Is Spreading

https://www.nytimes.com/2026/11/18/opinion/greed-youth-sports.html
2•mooreds•48m ago•0 comments

Seaman Inspired Virtual Pet in Browser

https://mattcool.tech/posts/creature/
1•mbcool•48m ago•0 comments

N-Able Breach (Cloud Cybersecurity Management System)

https://www.bleepingcomputer.com/news/microsoft/n-able-says-recent-security-breach-led-to-major-s...
2•l0c0b0x•48m ago•0 comments

Give Me Back My Monolith (2019)

https://www.craigkerstiens.com/2019/03/13/give-me-back-my-monolith/
1•sammatilda•49m ago•0 comments

Grand Theft Auto VI Earns $3.79B on First Day

https://www.take2games.com/ir/news/grand-theft-auto-vi-shatters-entertainment-box-office-records
7•HelloUsername•50m ago•0 comments