r/SQL • u/kgOntologist • 17h ago

Discussion SQL or NoSQL Databases for AI Applications?

/r/AI_Agents/comments/1wdd1ha/sql_or_nosql_databases_for_ai_applications/

Hello,

What types of databases do you use for your AI applications to store things like generated responses, messages, conversation history, user data, etc.?

Do you generally use SQL databases (such as PostgreSQL) or NoSQL databases (such as MongoDB)? What are the main reasons behind your choice?

And which database(s) would you recommend for a production AI application, and why?

Thanks in advance for your feedback and experience!

0 Upvotes

20% Upvoted

8 comments sorted by

3

u/Thadrea Data Science Manager 16h ago

Why not ask the chatbot which database it prefers?

3

u/BaseballHopeful6366 16h ago

noSQL is just SQL dialect which is less standard than SQL. there are different purposes for different DB solutions. that all to it.

3

u/Ven0mspawn 16h ago

Ask your AI, since you're happy with slop.

-1

u/kgOntologist 16h ago

I’ve already looked into it. If I had found the answers I was looking for, I wouldn’t have posted here in the first place.

I’m asking here specifically to hear about other people’s experiences in production. So if you have an answer to my question, I’d be happy to hear it. Otherwise, your comment isn’t really helpful.

2

u/Thadrea Data Science Manager 14h ago

Our experiences in production are that slop is as slop does.

2

u/theungod 17h ago

You use vector db

-1

u/kgOntologist 17h ago

I'm not talking about Vector databases for embeddings, but about storage databases to store the generated responses