Time
S
Nick
Message
00:51 jri joined #dataverse
03:07 jri joined #dataverse
07:07 jri joined #dataverse
08:27 jri joined #dataverse
08:33 MrK joined #dataverse
11:35 pdurbin
MrK: hi. I don't know if you saw my latest comment on Flyway but I'm going to try to explain my experience with it to other developers at standup in a few hours.
11:48 jri joined #dataverse
12:08 MrK
pdurbin: Hi, yeah I just saw it :P.
12:10 pdurbin
Are you familiar with Django migrations?
12:20 MrK
Nope :<
12:20 MrK
Could you give tl:dr?
12:37 pdurbin
It's a lot more automated. "Without migrations, you would have to figure out the SQL syntax to turn a PositiveIntegerField into a DecimalField. Luckily, Django will handle that for you. Just tell it to make migrations" https://realpython.com/django-migrations-a-primer/
12:38 pdurbin
Except for advanced changes, you can just change the Python code and run `makemigrations` rather than writing the SQL update script yourself.
12:45 MrK
Hmm interesting, but I guess if you want full automation you would just use hibernate/eclipse-link ddl generation.
12:45 MrK
In java*
13:21 pdurbin
Well, I guess I don't know exactly what I want. I'm just wondering what solutions are out there. Creating new tables automatically is easy and we've always done that. I don't know if there are good solutions in Java for the higher level of automation that Django's builtin migrations seem to have.
13:25 pdurbin
I think what Flyway does is useful. It just does less that what I imagined. And it doesn't seem to break anything. :)
13:34 donsizemore joined #dataverse
13:39 MrK
Well, so far you have used ddl to generate only new tables and sql for manual migration. Now sql migration is automatic :p. Or you can abandon sql and change eclipse-link ddl settings.
13:54 pdurbin
I'm not sure what settings you're talking about. I'm not sure what's possible.
13:55 pdurbin
And I wouldn't say that SQL migration is automatic. Someone still has to manually write even the most straightforward the SQL upgrade scripts to add a column or whatever. This isn't Django. Yes, once someone has written the SQL upgrade script, it will be run automatically by Flyway.
14:17 MrK
pdurbin: I'm talking about this https://www.eclipse.org/eclipselink/documentation/2.5/jpa/extensions/p_ddl_generation.htm , but you are writing SQL migration right now anyway :P, execution is just manual.
14:21 Julio_Chaves joined #dataverse
15:10 pdurbin
I think I see what you mean. "create-or-extend-tables" says, "If the table exists, EclipseLink will add any missing columns." Interesting.
15:27 pameyer joined #dataverse
16:58 pdurbin
donsizemore: knock knock
19:28 jri joined #dataverse
19:51 pameyer joined #dataverse
21:50 pdurbin
have a good weekend, everybody
21:50 pdurbin left #dataverse
