:/ - There's a database table at work with over 190 columns 🙃🙃🙃🙃 - devRant

Ranter

Comments

89

yellow-dog

44541

7y

Call it big data so you can say you are a big data analyst

(Source: me)
14

anon81

1500

7y

In 3NF?! Else, normalize it!
3

infiniteloops

1041

7y

I have seen tables with more than 1000. Of course at this point you should not use a regular RDBMS, because your data is heavily denormalized and probably quite sparse.
1

Yawned

29

7y

It's easy to start hitting limits too. Every row in MySQL has a limit of 65,535 bytes.
3

hell

17012

7y

Behold

https://www.devrant.io/rants/258348
1

jamlam

1517

7y

@anon81 nooooo don't be silly, no sensible advice is allowed at work
2

jamlam

1517

7y

@azous holy shiiiiitttt
0

hell

17012

7y

@jamlam my thoughts exactly when I saw it first time 😂😂😂
1

inkt

1172

7y

Sounds like the work of one of my PMs.
2

codeblue

1424

7y

Is it Lotus notes?
0

johnDoe

3238

7y

I'm hoping that it's not in 1NF 😅
0

juniordev

380

7y

I've had to write a database importer from a (shitty) system which had a db table with ~230 columns (I can't remember exactly how many). It was... so crap.
0

ashwini0529

622

7y

You should read normalisation
0

jamlam

1517

7y

@ashwini0529 tried to tell them to change it, but it's a legacy system
0

adnanh

1004

7y

Haha, please, we had to implement table chunking to support 40.000 columns :-)
0

priyan

266

7y

Table right😂😂
0

linuxxxxxx

1222

7y

reading that 1NF 3NF and thinking back when i started my cs degree. I'm glad i never work woth databases :3.

Good luck OP

Related Rants

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service