| # |
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. |
| # |
Jul 20th 2018, 09:33 |
neon1024 |
File uploaded https://cakesf.slack.com/files/U1BT622HW/FBTT81A9Z/-.sh / https://slack-files.com/T053DPNCM-FBTT81A9Z-75c044b96b |
| # |
Jul 20th 2018, 09:33 |
neon1024 |
` == 20180720083451 CampaignScripts: migrating Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`telecoms_call_centre`.`#sql-2ce5_a83`, CONSTRAINT `#sql-2ce5_a83_ibfk_1` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`)) in [/Users/david/Sites/TelecomsCCA/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php, line 338]` |
| # |
Jul 20th 2018, 09:32 |
neon1024 |
How do I get around adding a migration with a new foreignKey constraint? |