I would like to know if it is possible to use Firebase as a SQL database. I have trouble with relations in NoSQL.
For example: a user belongs to a team, and a team has users.
One of the most popular traditional databases/RDBMS is SQL Server. SQL Server is owned by Microsoft whose fundamental aim is to provide a platform to create, manage and manipulate databases. Firebase SQL Server Integration is a process that helps you quickly transfer data between Firebase and SQL Server.
The Firebase Realtime Database is a cloud-hosted NoSQL database that lets you store and sync data between your users in realtime.
Data HandlingFirebase effectively handles large sets of data. It uses wide-column, key-value, document stores, or graphs and has dynamic schemas to facilitate unstructured data. MySQL is table-based and has predefined schemas. It is a preferred choice for handling complex data.
Firestore is a NoSQL, document-oriented database. Unlike a SQL database, there are no tables or rows. Instead, you store data in documents, which are organized into collections.
It is not possible to use Firebase in this way. Firebase is a real-time object store. It is not a SQL database and is not intended to be a replacement for one. It completely lacks mechanisms such as JOINs, WHERE query filters, foreign keys, and other tools relational databases all provide. That doesn't mean it isn't a valuable tool. But any attempt to treat it "like" a SQL replacement is going to fail. That's not its purpose.
I think what you need is supabase.
It uses an Open Source Postgres Database and they're trying to be a firebase alternative.
It's backed by YCombinator but is still in beta as of Feb, 2021.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With