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

Ranter

Comments

88

yellow-dog

44133

8y

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

(Source: me)
14

anon81

1494

8y

In 3NF?! Else, normalize it!
3

infiniteloops

1036

8y

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

8y

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

hell

16959

8y

Behold

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

jamlam

1517

8y

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

jamlam

1517

8y

@azous holy shiiiiitttt
0

hell

16959

8y

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

inkt

1168

8y

Sounds like the work of one of my PMs.
2

codeblue

1416

8y

Is it Lotus notes?
0

johnDoe

3232

8y

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

juniordev

380

8y

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

623

8y

You should read normalisation
0

jamlam

1517

8y

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

adnanh

1003

7y

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

priyan

265

7y

Table right😂😂
0

linuxxxxxx

1219

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