Meteo and Postgre

[yvancoyaud]

Hello everyone
Probably a question asked many times, but I can’t find a satisfactory solution on the net: How to migrate a Meteor application from MongoDB to PostGre.
Or a link to a tutorial, or a small application written with Meteor and PosGre.

Thank you for your help.
YC

[peterfkruger]

Are you sure it’s not the other way around that you want? Like from whatever RDBMS to MongoDB?

[yvancoyaud]

no, I would like my meteor application to use PostGre instead of mongodb

[raragao]

You can try to use Apollo Graphql to access your PostgreSQL instead Mongodb. Or some component to connect to it.

But, personally, I think that Mongodb has enough conditions to be used by any project. Let me know if you need some help with Mongodb.

[storyteller]

https://atmospherejs.com/meteorsteam/meteor-postgres

Reactive queries for PostgreSQL

Over the new year’s break I implemented one idea I had for reactive queries for PostgreSQL. You can take an arbitrary SELECT query, using multiple joins, data transformations, and even custom functions, and besides the initial set of results also get real-time updates about any changes to those results. Using PostgreSQL’s to_json and jsonb data type and you can literally simulate MongoDB now with all extra features of transactions and joins. And with this package you can now easily make a Meteor…

And there is much more. Search the forums.

[yvancoyaud]

Thank you all for your answers,
but I found a hosting solution at a very good price for MONGODB. In fact that was my cause for my desire to migrate from MongoDB to postGres.
So I keep my MongoDB database and I’m very happy with it.
Thank you all and my apologies for the noise.

YC

[umbralimi]

Which MongoDB host did you go with?

[yvancoyaud]

I had the choice between “hosteur.com” and “hidora.com”
Finally I chose “hidora.com” with which I had better contact.
It will only cost between 10 and 20 Swiss francs.
It’s a lot more than Heroku, but I can take it.