Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Root797677yAt first glance I thought this was Antarctica.
I suppose for a size comparison that's a fair assessment... -
Tobyvw6987yOn the other hand. Making that program function in bloody sql is quite an achievement too.
A terrible choice, but quite an achievement -
enoon4237yI saw fractals in the thumbnail preview. Was somewhat disappointed. :(
Nice rant though. -
scroach12197yI have to save this and whenever I stumble a bullshit legacy project of ours I look at this and remember: it could have been worse!
-
Awlex177457yAt first glance, I confused the database structure with a fractal image. Holy cow, I suffer together with these poor servers...
-
I won't even ask if there's documentation for that monster, I would just say fuck that shit and good luck with it.
-
Buggz6157y@hyperlisk This thing was the data AND business layer of an application for property brokers. And it did both auths too, so the new web application had to perform an sql connection using the supplied credentials to verify.
-
Tobyvw6987y@Shardj the sql to handle the db isn't wrong, but as @Buggz points out in his last comment, you have to put access credentials to the db like everywhere.
-
Buggz6157y@Tobyvw is spot on, @Shardj It was mostly relational data so a relational database is great. One just has to remember that a relational database is, obviously, best at storing relational data. Once you start putting in functionality (or documents) you're doing it wrong and should sit in the corner.
-
So many lines of SQL just to print a Mandelbrot set? (Somewhere I saw it done in PostgreSQL, was neat,..but then there's probably an APL one liner - yep)
-
If you look closely, inside each rectangle there is another network of rectangles.
That thing is really fractal-ed up. -
Buggz6157yThat's the name of each table/sproc inside the rectangles. It's f-ed up enough, no need for another dimension.
-
@Buggz I'm talking about weather the company he did this for was Greenfield Global or Greenfield Ethanol?
-
Buggz6157yNeither. Green field means starting from scratch making something new. This was a tool for property brokers.
-
Buggz6157yDo we really want to know what procedure needs a finger in every pot in the entire system? That one dot scares me.
Related Rants
I worked on a greenfield project a couple of years ago. The company had an old solution written in Omnis (heard of it? Yeah, me neither) with an SQL database. My team was to create a completely new web based system... on top of the old database, so the customers could keep their existing stuff.
The dba was an intelligent man, one of the nicest people I've met, and over the course of fifteen years he had made a remarkably terrifying monstrosity of a database. Some years before me they wanted to "future proof" the system and make it "easier to switch to new technologies". So they moved the entire business logic into the database...
I used a tool to create a visualization of said database when we started. It had no views, only tables and sprocs. Look at it! Tables and sprocs are rectangles (well, dots) and any connections are drawn in grey lines. There were no foreign keys, so a tables only visualization only yielded a collection of independent rectangles without a single line.
Now, the stored procedures were bloody MASSIVE. A single procedure that only registered a new interested party and attached them to a property had 2500+ lines and over 150 parameters.
Also, this dba added features and fixed bugs by logging into the respective customers production server and writing SQL.
That database is the stupidest thing I've ever seen a developer do.
rant
wk99
sql
holy hell