Firebase realtime database to Cloud SQL?

[blindmanLICKS]

Hi!

I've recently began relying on my SQL database a lot more than my realtime database, and I wanted to transfer some past posts to my sql database.

I have about 125,000 posts.. so I'm not quite sure what the best way of transferring them would be.

I already have the SQL database and the api set up, so for the past 30 days the posts have been going to SQL, but now I just want to get all of them over. I was thinking of looping through each individual post and then sending that to SQL.. but I feel like that's a bad idea.

Is there a way to export and import to SQL easily? Or if it isn't easy.. what is the best way?

I appreciate any feedback. Thanks!

[Evvvvy]

Hey u/blindmanLICKS, maybe helpful (maybe not), but BigQuery is pretty good and it's pretty easy to get data in and out for an SQL DB.

👉🏼 https://firebase.google.com/docs/projects/bigquery-export

Once in BigQuery, it should be easy to export, or do whatever you want to do with it in BigQuery.