logoalt Hacker News

jdthedisciplelast Friday at 7:33 PM2 repliesview on HN

But SQLite is notoriously 35% faster than the filesystem [0], so why not use that?

[0] https://news.ycombinator.com/item?id=14550060


Replies

bob1029last Friday at 11:15 PM

SQLite + GPT5.4 works very well for me.

My biggest success is a Roslyn method that takes a .NET solution and converts it into a SQLite database with Files, Lines, Symbols, and References tables. I've found this approach to perform substantially better than a flat, file-based setup (i.e., like what Copilot provides in Visual Studio). Especially, for very large projects. 100+ megs of source is no problem. The relational model enables some really elegant [non]queries that would otherwise require bespoke reflection tooling or a lot more tokens consumed.

show 3 replies
tomComblast Friday at 8:17 PM

And Turso has built a Virtual Filesystem on top of their SQLite.

AgentFS https://agentfs.ai/ https://github.com/tursodatabase/agentfs

Which sounds like a great idea, except that is uses NFS instead of FUSE (note that macFUSE now has a FSKit backend so FUSE seems like the best solution for both Mac and Linux).