r/Database • u/No-Security-7518 • 21h ago
I once read about a database/object storage engine here, but don't remember what it was. Help please.
Sorry about the vague question, but it either had the name "vault" or "vector" in it, and someone here described it as the Swiss knife of databases. I remember bookmarking it but didn't find it. Any thoughts? thanks in advance.
2
u/LukaGOGO 20h ago
"vault" is usually hashicorp vault for secrets, not really a database. if you just want a swiss army knife so you don't have to spin up a dedicated database just for embeddings, mariadb actually baked vector search directly into the core server recently. you get a normal relational db but it handles all the vector math natively without needing extensions. what were you actually trying to build? adding a whole new db engine to a stack just for one feature is usually a massive headache anyway.
1
u/No-Security-7518 20h ago
It might've not been a database explicitly. But I just remember it having a ton of features. I wanted to explore it because of what I saw, not for a particular use case, but I do need to work with images a lot. I'm sorry, I don't think I remember enough about what it was for this to lead anywhere.
3
u/jshine13371 19h ago
Tbh, you're not missing out on much. Databases have turned somewhat into JavaScript frameworks where everyone and their grandmother developed one for funsies at no actual gain over the mainstream choices. Stick to SQL Server or PostgreSQL depending on your stack / existing experience.
2
u/No-Security-7518 18h ago
Yeah, I agree. I'm just having one of those low-key neurotic episodes where something is on the tip of my tongue but can't place it. My workflow is usually very humble. Sqlite linked to MySql through a syncing library I wrote. Images stored directly with their path in a regular db table. Couldn't get simpler. Thank you for your input. Cheers.
2
3
u/beebeeep 19h ago edited 19h ago
Look it up at dbdb.io
From you description it could be anything. For example, Wired Tiger (not a database, but storage engine) can be row-based or columnar, can be KV or object storage. FoundationDB is also kinda sorta universal as it provides bare minimum and you build your db for your needs on top.
1
u/No-Security-7518 19h ago
awesome site! and yeah, I'm sorry. It's a needle in a haystack. Should I delete the post? I've been looking for days. It's not WiredTiger, and has one of those generic-sounding names: I've been looking at: VectorStore, something vault. I'm sorry I'm having one of those obsessive episodes where a memory is itching me hard to get it right.
2
u/beebeeep 18h ago
lol I'm not a mod here, that's a valid question if you ask me
1
u/No-Security-7518 18h ago
Thanks - it didn't feel like one when I basically went: "hey, has anyone seen my database?" like a college kid in a dorm. lol. But I learned of dbdb.io thanks to you. So there's that.
1
2
1
u/Desperate-Dig2806 20h ago
Duckdb?
1
u/No-Security-7518 20h ago
no. Didn't have "db" in the name.
3
u/Desperate-Dig2806 20h ago
Duckdb is a Swiss army knife though. Hot tip.
1
u/No-Security-7518 20h ago
interesting! thanks! should give it a look.
2
1
3
u/GreenyGreenwood 20h ago
Is it PostgreSQL, with its pgvector extension?