Log message #4160889

# At Username Text
# Jul 20th 2018, 10:24 lubos Is it possible to set default order in the model?
# Jul 20th 2018, 10:14 josbeir browsing, manipulating over ssh is just quicker
# Jul 20th 2018, 10:13 josbeir imo, when designing the db then workbench is probably the better bet, but for day 2 day use i think sqlpro will be more productive
# Jul 20th 2018, 10:13 neon1024 I just like MySQL Workbenches ERD diagram builder for helping design a db. Plus I like that I can forward engineer that into an actual db
# Jul 20th 2018, 10:12 neon1024 To be fair, the beta build of Sequel Pro can do that, but the build also introduces some other bugs
# Jul 20th 2018, 10:12 josbeir not a killer feature for me buts its nice 2 have
# Jul 20th 2018, 10:12 neon1024 Yeah, like being able to export and import JSON columns ;)
# Jul 20th 2018, 10:10 josbeir its still a hog but it has nice features
# Jul 20th 2018, 10:10 josbeir i must admit @neon1024 mysql workbench has come a long way, just tested it again
# Jul 20th 2018, 10:10 sheraliqureshi.mhtech @neon1024
# Jul 20th 2018, 10:00 josbeir yeah
# Jul 20th 2018, 10:00 neon1024 Just in case you miss something in your codebase
# Jul 20th 2018, 10:00 neon1024 The foreign key constraints are a nice fallback for data integrity I find
# Jul 20th 2018, 10:00 neon1024 Anyway
# Jul 20th 2018, 10:00 josbeir beats phpmyadmin in the productivity part
# Jul 20th 2018, 10:00 josbeir hmm i dno i'm using it for years now, it sometimes has it quirks but for the most part it just works
# Jul 20th 2018, 10:00 neon1024 It’s the best of a bad bunch
# Jul 20th 2018, 10:00 neon1024 Don’t get me wrong, it’s one of the better tools available, however it’s a solid 4/10 and the others are 2/10
# Jul 20th 2018, 09:59 neon1024 Like the drag a tab and the sidebar goes black
# Jul 20th 2018, 09:59 neon1024 Or get patches to bug fixes
# Jul 20th 2018, 09:59 neon1024 Or see a database refresh
# Jul 20th 2018, 09:59 neon1024 Or import JSON
# Jul 20th 2018, 09:59 neon1024 Except when you want to export JSON
# Jul 20th 2018, 09:59 josbeir thats +1 for me
# Jul 20th 2018, 09:59 josbeir it starts in seconds.
# Jul 20th 2018, 09:59 josbeir its my go 2 tool for most sql stuff
# Jul 20th 2018, 09:58 josbeir :)
# Jul 20th 2018, 09:58 josbeir wuuuh?
# Jul 20th 2018, 09:58 neon1024 Utter, utter, shite.
# Jul 20th 2018, 09:58 neon1024 Sequel Pro is a pile utter shite.
# Jul 20th 2018, 09:58 josbeir sequel pro !
# Jul 20th 2018, 09:58 josbeir ah ok :slightly_smiling_face:
# Jul 20th 2018, 09:58 neon1024 I’m only using them because i built my database in MySQL Workbench, and I need the constraints to draw the lines in the ERD :P
# Jul 20th 2018, 09:57 josbeir maybe i should change that mindset
# Jul 20th 2018, 09:57 josbeir hmm i always tought that using fkey constraints in combination with framework ORM's was not a good idea
# Jul 20th 2018, 09:45 neon1024 Cool, thanks @dereuromark that’s worked for me :slightly_smiling_face:
# Jul 20th 2018, 09:34 neon1024 Why are foreign key constraints such a PITA
# Jul 20th 2018, 09:34 neon1024 Kinda shonky :s
# Jul 20th 2018, 09:34 neon1024 Ahok, so I guess I can just update the table in the migration
# Jul 20th 2018, 09:34 dereuromark if you can fix your data first, might work as 2 step.
# Jul 20th 2018, 09:33 dereuromark you add it first without constraint, then you fix your data, then you add a constraint. 3 steps usually, same for required (not null) fields.