These are chat archives for mfenniak/rethinkdb-net

29th
Jun 2016
James Tindall
@atomless
Jun 29 2016 14:42
Wondering if anyone has suggestions for migration tools for rethinkdb?
Mathieu Fenniak
@mfenniak
Jun 29 2016 14:46
Hey James. What do you have in mind when you say migration? Typically I'd think schema-migration with that word, but I'm not sure how that applies to a schema-less DB. :-)
James Tindall
@atomless
Jun 29 2016 15:06
@mfenniak Hey Mathieu - you're correct, I mean schema migration and perhaps you hit on why I'm not seeing rethink migration tools anywhere near what's available for SQL alternatives
The thing is Rethink is not entirely schemaless no is any db really is it?
Mathieu Fenniak
@mfenniak
Jun 29 2016 15:07
Yeah, that's probably why there aren't strong tools like RDBMSes. However, that isn't so say that you'd never have to run maintenance to make changes on a RethinkDB system... it doesn't make sense to assume that your data always stays in the same format.
Agreed, it definitely has a schema, so to speak
I'm not sure what people would be doing to solve that problem today. My first thought would be to release software that is compatible to a before and after schema, and then once it is deployed, run a complex ReQL query to rewrite records?
(or if happy with a downtime deployment, skip the first part of that step)
James Tindall
@atomless
Jun 29 2016 15:09
yeah - downtime would not be an issue
I'm more concerned managing disparate schema versions
not sure I can guarantee it will always be an a to b migration
possibly a to e
Mathieu Fenniak
@mfenniak
Jun 29 2016 15:10
Hm, interesting. Yeah.
James Tindall
@atomless
Jun 29 2016 15:10
or worse
I am really hoping this is not going to mean I'll have to drop rethink and use postgres
Mathieu Fenniak
@mfenniak
Jun 29 2016 15:11
I'd suggest trying to reach out on the rethinkdb mailing list. I have very little rethinkdb production experience, but there are probably people who have tackled this already in some way
James Tindall
@atomless
Jun 29 2016 15:11
good suggestion
thanks!
Mathieu Fenniak
@mfenniak
Jun 29 2016 15:12
No problem. Good luck. :-)