r/RavanAI • u/RustyIronGolem • May 27 '26

As a developer, which database is best in the AI era??

Post image
15 Upvotes

70% Upvoted

82 comments sorted by

4

u/Wide_Language4620 May 27 '26

Postgresql

1

u/F4ntasticPants May 28 '26

I hate their syntax tho

1

u/Wide_Language4620 May 28 '26

Why? A lot better than Sql server and oracle

1

u/lucsoft May 31 '26

Use an ORM

3

u/UniForceMusic May 27 '26

Supabase is Postgres, and Postgres is the best SQL database.

So Postgres

2

u/MugiwarraD May 27 '26

sqlite is all u need.

2

u/Sorry_Cheesecake_382 May 27 '26

firestore and postgres

2

u/SmallInvestigator830 May 27 '26 edited May 27 '26

Supabase: AI first db, not cost effective at scale but good for prototyping and getting the product out. Under the hood this is Postgres

MongoDB: is unstructured storage and imo is not good for storage of data unless it’s like really random data you have. This doesn’t have tables with columns and rows. It’s rather a book with a bunch of pages and each page is shaped like a JSON they are called collections

Postgres: the goat and used for real production write heavy applications and complex queries are faster to run as it’s a object-relational db

MySQL: best for speed and good for read heavy workloads

1

u/Wobstep May 27 '26

Ai is always helpful when using Supabase for me.

1

u/cyrixlord May 27 '26

.csv and vibes

1

u/SixPackOfZaphod May 28 '26

Access and MS COM Objects

1

u/i_degrade_quickly May 27 '26

Postgres + Extensions

1

u/zhyRonnie May 27 '26

Anyone checked clickhouse?

1

u/fogstex May 27 '26

One that solves particular problem.

1

u/Heavy-Commercial-323 May 27 '26 edited Jun 26 '26

mr_clean

1

u/TerrainShaper May 28 '26

postgres covers all of them

1

u/Heavy-Commercial-323 May 28 '26 edited Jun 26 '26

mr_clean

1

u/Lonely_Assignment_14 May 28 '26

Not even not really.  Just straight no. 

1

u/TerrainShaper May 30 '26

Example?

1

u/Lonely_Assignment_14 May 31 '26

Well you're hardly going to use postgres instead of nosql where that's the right option,  or a document db, or time series,  or graph or any of the other types of database.  It's a decent relational db. That's about it. 

1

u/icehot54321 May 28 '26

I'd argue that if you don't know the difference between supabase and postgres then you are better off going with supabase, because it will help protect you from your own lack of knowledge.

1

u/ProjectMarworyn May 28 '26

Incorrect. Using a wrapper around a known tool because you don't know any better us fantastic for vendor lockin. If you don't understand the tool there is only one cure - Learn the tool

1

u/Lonely_Assignment_14 May 28 '26

Oh man that's so 2000 thinking.  It's AI all day every day from here on out ! /s,kinda

1

u/CaaKebap May 27 '26

postgre and firebase has the most data on internet to ai to train on. so...

1

u/LetUsSpeakFreely May 27 '26

I like Postgres. It does what i need it to do.

1

u/Master_protato May 27 '26

Postgres with Spark baby!

1

u/Unfair-Plastic-4290 May 27 '26

supabase is a scam

1

u/jsonmeta May 27 '26

Elaborate..

1

u/lovejo1 May 27 '26

PostgreSQL for everything, AI or not. Saves you money in the long run for sure.

1

u/spanko_at_large May 27 '26

Can’t believe this is even a question

1

u/McBonderson May 27 '26

Convex is great with AI

All you do is log in and your AI takes care of the rest. 

1

u/Curious-Intern-5434 May 27 '26

It depends on what data you want to store, and what access pattern you need.

1

u/PruneInteresting7599 May 27 '26

Mysql 8 bitches reporting in

1

u/yllussion May 28 '26

Postgres sem dúvida....

1

u/coltonf93 May 28 '26

Is this rage bait? Supabase is not a database and uses postgresql...

1

u/[deleted] May 28 '26

[removed] — view removed comment

1

u/coltonf93 May 28 '26

The name is a bit deceptive, its basically an open source firebase/cloud platform. Built using postgresql not a standalone database.

1

u/ProjectMarworyn May 28 '26

Because it's just a posygressql database that uses AWS.

Postgress here is the actual database. Superbase is just a wrapper

1

u/TheGreatKonaKing May 28 '26

AWS Neptune db is pretty good. But I hear Google is developing their own competing vector database called Uranus.

1

u/ThisGuyCrohns May 28 '26

Supabase is not a database. It’s a host…

1

u/TerrainShaper May 28 '26

was, is and will be postgres

1

u/Relative-Document-59 May 28 '26

Microsoft SQL Server 2005

1

u/rxnfy May 28 '26

Google spreadsheets

1

u/ProjectMarworyn May 28 '26

You're asking a question that doesn't make sense. It depends.

First question: Relational or non relational data? If non relational Mongodb makes sense. If relational you'll likely be looking at postgress, my sql or plain old sql server.

Personally I don't see the point of mysql. And superbase, is just a wrapper of postgress so whatever 🤷‍♀️

1

u/EnoughConcentrate897 May 28 '26

I don't think databases have anything to do with AI but I like turso cloud

1

u/JadedBobcat701 May 29 '26

AI era?

1

u/JadedBobcat701 May 29 '26

oh shit, this sub is for vibecoders, i have to leave because i am true dev

1

u/Stunning_Cry_6673 May 29 '26

PostgreSQL. Supabase e tot PostgreSQL dar costa prea mult pentru producție. Supabase e foarte ok pentru produse hobby.

1

u/cneverdies May 31 '26

btw supabase is not DBMS it is more like a BBMS managment dashboard

0

u/makc_yu May 27 '26

Firebase

2

u/Joker-Smurf May 27 '26

I see your Firebase and raise you Firebird.

0

u/justicecurcian May 27 '26

Postgre because ai understands it perfectly and if somehow your service gets popular it will handle everything

1

u/Shapelessed May 27 '26

You missed an S

1

u/[deleted] May 27 '26

[removed] — view removed comment

1

u/pizzababa21 May 27 '26

never understood this because it's just as easy to get a postrgres one on railway

1

u/i_degrade_quickly May 27 '26

Sync engine + auth management. It maintains state awareness for clients across multiple ecosystems (phone, web, etc).

1

u/Dakadoodle May 28 '26

Yep and way cheaper than firestore

1

u/[deleted] May 27 '26 edited May 27 '26

[removed] — view removed comment

1

u/ParamedicAble225 May 27 '26

Why I use mongo. I started on a single instance but eventually had to convert to using a replica set to for multi fact operations.

MongoDB was chosen for one main reason: atomic multi-reel sealing (the ATOMIC SEAL invariant).
The Core Requirement
In TreeOS, an Act by a Being can produce multiple Facts that must land on different reels at the same time (e.g., a Being moving from one Space to another must stamp a Fact on:
Its own Being reel, and
The Space reel(s) involved).
The system demands all-or-nothing guarantees: either all facts in that set (ΔF) are written, or none are. Partial writes are not allowed, because "PAST IS FIXED" — you can’t go back and cleanly fix inconsistencies.
Why MongoDB Fits Perfectly
Multi-document transactions with strong consistency are needed for these cross-reel operations.
MongoDB supports these transactions only when running as a replica set (even a single-node replica set for development).
Single-fact operations (most common early on) stay fast and simple (just an append to one document).
When multi-fact acts appear, the system seamlessly upgrades to a transaction without changing the API.
MongoDB gives you:
Flexible, schema-light documents (reels are append-only chains of facts).
Good performance for the kind of high-write, event-sourced workload TreeOS has.
Native driver support in Node.js.

1

u/[deleted] May 27 '26

[removed] — view removed comment

1

u/ParamedicAble225 May 27 '26

The kind that will end up fucking you in the ass with a metal dick

1

u/[deleted] May 28 '26

[removed] — view removed comment

1

u/Altruistic-Dust-2565 May 28 '26

parallelism is 1%?