Sqlite support #197

New Issue

2026-02-23T17:20:43-05:00

yindo commented

2026-02-23 17:20:43 -05:00

Originally created by @netandreus on GitHub (Oct 26, 2023).

Do you plan support sqlite instead of postgresql?
I think it will be comfortable for small instalaltions.

Originally created by @netandreus on GitHub (Oct 26, 2023). Do you plan support sqlite instead of postgresql? I think it will be comfortable for small instalaltions.

yindo closed this issue

2026-02-23 17:20:43 -05:00

yindo commented

2026-02-23 17:20:44 -05:00

@timothycarambat commented on GitHub (Oct 26, 2023):

We actually used to use SQLite! But we had a ton of concurrency issues and massive performance problems when dealing with really large vector databases + background jobs. It was causing a bunch of issues so we moved away from it.

Limitations for SQLite + Primsa like deleteMany not being available was also very frustrating so we had to move to something less lightweight, but more robust.

I like SQLite! We use it for AnythingLLM!

@timothycarambat commented on GitHub (Oct 26, 2023): We actually used to use SQLite! But we had a ton of concurrency issues and massive performance problems when dealing with really large vector databases + background jobs. It was causing a bunch of issues so we moved away from it. Limitations for SQLite + Primsa like deleteMany not being available was also very frustrating so we had to move to something less lightweight, but more robust. I like SQLite! We use it for [AnythingLLM](https://github.com/Mintplex-Labs/anything-llm)!

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: Mintplex-Labs/vector-admin#197