3 ms·
> If you have a MySQL or PostgreSQL system that's bursting at the seams Postgresql ? How does this work for people migrating from traditional SQL databases - t
by sandGorgon 10y ago
> If you have a MySQL or PostgreSQL system that's bursting at the seams
Postgresql ? How does this work for people migrating from traditional SQL databases - typically people use ORM. How would this fit in with, say , Rails or SqlAlchemy ?
- boulos 10y agoThere is JDBC support, so if you're willing and able to connect that way, you could hope for an easier migration. Any move from one database to another is a migration, even if only to deal with dialect-specific things. Disclosure: I work on Google Cloud (but not Spanner).
- deesix 10y agoThere is real work to migrate you application to use Cloud Spanner. Your schemas and queries will work with some tweaking but we don't have ORM support at beta. We are going to produce some additional collateral on migrating from popular RDBMS, but the Quizlet post is the best reference right now for migrating from MySQL. https://quizlet.com/blog/quizlet-cloud-spanner https://quizlet.com/blog/quizlet-cloud-spanner We have released client libraries for Java, Go, Node and Python on Github, but we haven't used those clients to implement support for popular ORMs. Basically, the open-source ecosystem will need to add support for these ORMs but we will contribute wherever we can to push these initiatives. If we get lots of demand for a specific ORM, we will look into doing something special for that. Hope that helps. (disclaimer: I work on Cloud Spanner)