# I built a self hosted memory engine using SQLite instead of heavy vector databases — retained record

> Retained reddit record from reddit:selfhosted.

Canonical: https://highsignal.app/data/records/a0dce5279eec5e0e

[← sources](https://highsignal.app/data)


source: [reddit](https://highsignal.app/data/reddit) (reddit:selfhosted)  published 2026-10-07 16:06 ingested 2026-10-08 02:38

[original source ↗](https://www.reddit.com/r/selfhosted/comments/1x00i8j/i_built_a_self_hosted_memory_engine_using_sqlite/)

## retained text



```
Disclosure: I am the creator of this open source project.

If you run local AI on a home server, mini PC, or low power node, standard RAG setups are usually a complete non starter. Spinning up Milvus, Qdrant, or Chroma alongside an 8B model just to chunk and parse text eats up several gigabytes of memory before your actual inference model even loads. On top of that, cloud phone home APIs defeat the whole purpose of self hosting your data privately.

I built Hillock to solve this for self hosters. It is an open source, 100 percent local memory engine under AGPL-3.0 that replaces vector databases with an SQLite Knowledge Graph and hyperdimensional vector math. Ingestion runs without an LLM in about five seconds using tiny specialized models under 300MB, storing facts as relational triples with write ahead logging.

When you query it, a 10,000 dimensional hypervector gate runs on the CPU in under 0.01 milliseconds using bit packed SIMD math. If the stored data does not contain the answer, it blocks the prompt before the model can hallucinate. Total footprint stays under 1.2 GB of VRAM or runs on pure CPU. It includes an OpenAI compatible API server on port 8000, so you can point self hosted frontends like Open WebUI or AnythingLLM directly at it.

Code is on GitHub at [https://github.com/roandejager/Hillock](https://github.com/roandejager/Hillock)  
Interactive docs are at [https://hillock.mintlify.site/](https://hillock.mintlify.site/) and we have a Discord at [https://discord.com/invite/BGUPNBcVdp](https://discord.com/invite/BGUPNBcVdp)
```



document fetched 2026-10-08 00:31 · canonical https://reddit.com/r/selfhosted/comments/1x00i8j/i_built_a_self_hosted_memory_engine_using_sqlite
