ERM Diagrams.

They make nobody happy. Except maybe professors

Except for auto-generated ones

I find them somewhat useful. But I'm also lazy and hate making them by hand.

Pro tip: I usually just screenshot the "Designer" Tab from phpMyAdmin for most projects. Professors usually don't care and are happy.

@rEaL-jAsE what hapoened to your ++ count?

@LinusCDE if everybody planned out what they code they’d hand the work to juniors after they were done to prevent their own suicide lol

I consider ERM one of the great tools..I have been using power designer for the past 15 years consistently and I cannot do without it..even considering that I once quit a job because of sql anywhere..

@pwac092 what exactly are you modeling that requires a special tool of this sort ? Do you like code export of classes to different languages ? Does it do automatic bol generation ?

@MadMadMadMrMim now it’s smaller stuff, it’s just force of habit.
I used to work for a company that had the illusion of a core ERP from which several flavours were branched.

In reality these branches were copy-paste code, with the entire thing replicated and modified.

At one point, the largest incarnation of this aberration had 780 tables. It’s been 10 years now and I still dream about it..

So even before you get around to repeating your response I remembered zim saying that was a ridiculously expensive tool and low and behold 3000 to 7500 per seat !
Damn I’ll just do what I did and write a class generator that reads and converts to my language from a sql schema and use Smms to node the data ! Lol

Visual understanding environment vue from tufts is a nice free gpl diagramming tool too

@pwac092 illusion as in it didn’t work worth shit ?

Still I’d love that project it sounds like a never ending paycheck lol

What was the companies core business ?

@MadMadMadMrMim illusion as in management thought that is what they had, and not 10 different development teams with little practical overlap..

The owner was (still is) incredibly smart man. Built the entire company (over 50 developers) in order to finance his research projects. He does optimisation and just subsidised his passion software. He’s my idol, but his software products are crap..

Core business was an ERP system for supermarkets..a chain of about a 130 locations and some fancy synching features to allow for network outage..to give some perspective, the other ERP was a cattle ranch manager..

@pwac092 lol that’s a rather diverse range of applications hehe

@pwac092 still minus many customizations shouldn’t the core data be about the same ?

@pwac092 wave if you’re still real

We are in an alternate dimension where people waste their lives denying the past and living like gentrified apes with little to no personality drive or intelligence and somehow believe this is optimal

Still

@MadMadMadMrMim I am real..yes..Sure the concept behind data flow was shared, but that did no mean that business logic translated well.

It was hard to transition, even if bits were similar..still, one of the nest jobs of my life..

@pwac092 let’s talk about something new

You know I had this wonderful idea many times now about how to rebuild a well adjusted population to replace the teetering mound of trash and restore the life to untold numbers of decent people who are presently being fucked over much the same way as I am and was when I read this before

Still real ? Novelty
Divert from the script

@pwac092 in fact however you responded last time try something else

Wake up wake up!

@MadMadMadMrMim holy fuck..ok. Sure..I have dabbled myself in that topic..in three bullets, outline your plan, just no eugenics please.

@pwac092 still not convinced you’re alive you said that last time
Tis the problem with online
No. No eugenics

@pwac092 sigh still
Tis cold here in hell

@pwac092 is there anyways to determine who’s a bot repeating things and a real separate person this time around ?

@MadMadMadMrMim is there ever a way? Do you truly believe the Turing test remains sans solution? Sorry I took longer..my kid came down with a fever..

@pwac092 no and psychological effects can make someone more like a robot by creating a stabilized environent of events and stimuli

Running out of novel solutions because of these people

@pwac092 why don’t they just let things stand ?

Maybe they’re trying to come up with an excuse as to why we died

ERM diagrams are useful.

If auto generated.... Especially for restructuring of databases, index optimizing and analysis.

When you have very small databases... Not so much

But if you unclog a large database with several hundreds of tables... It's the thing that saves your brain from going into fried mode.

@IntrusionCM yes. Auto generated.
Not drawn with a pencil for an exam.

@Ranchonyx I think everything that's drawn should be allowed to be drawn handsfree... Yes. Standards exists...

But unless you work in corporate clusterfuck / fang, noone should care wether it's standard correct or not.

The diagrams should be a visual support, not an time-consuming task with no value.

Same btw for sequence diagrams / UMLs et cetera...

@IntrusionCM I think this is key..for me, SQLite was the biggest driver of change. So easy to compartmentalise apps, pulling only what is required, user management etc. No erm driven design needed.

@pwac092 if you have no design for your database at all... Then it's shit.

Has nothing to do with SQLite. :)

@IntrusionCM agreed..still, I take offense because everything I code is generally shit..

@pwac092 *hug* learn from your mistakes and it will change.

I believe in you :)

@IntrusionCM fuck of with the positivity. Not even I believe in myself. I embrace the shit code..I see it as a job security stratagem. I make myself indispensable for a few years after wiring an important piece

@pwac092 *sigh* another dev making life miserable for others.

there's a thing called pen and paper.
Usually use those diagrams loosely on there, just to give me an idea. No need to make the diagrams perfect.

Helps with coding stuff a lot, even if your coding habit is terrible.