Live data from Hacker News

Nobody ever got fired for using a struct

feldera.com

11–20 of 140 posts

Re: Nobody ever got fired for using a struct

#11

Earlier quoted context omitted.

It might not be common in typical software shops. I work in manufacturing and our database has multiple tables with hundreds of columns.

What's in them?

Property1 to 20 or more is an example. There are better ways to do it but I have seen columns for storing ‘anything’

Re: Nobody ever got fired for using a struct

#12

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

It might not be common in typical software shops. I work in manufacturing and our database has multiple tables with hundreds of columns.

I’m working on migrating an IBM Maximo database from the late 90s to a SQL Server deployment on my current project. Also charged with updating the schema to a more maintainable and extensible design. Manufacturing and refurbishing domain - 200+ column tables is the norm. Very demoralizing.

Re: Nobody ever got fired for using a struct

#13

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

No idea what these guys do exactly but their tagline says "Feldera's award-winning incremental compute engine runs SQL pipelines of any complexity"

So it sounds like helping customers with databases full of red flags is their bread and butter

Re: Nobody ever got fired for using a struct

#14

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

It is very common to find tables with 1000+ columns in machine learning training sets at e-commerce companies. The largest I have seen had over 10000 columns.

Re: Nobody ever got fired for using a struct

#15

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

https://jimmyhmiller.com/ugliest-beautiful-codebase

I kinda love this. That sounds like an incredibly entertaining place to work for between 1 and 2 years in your late 20s and not a second longer.

Re: Nobody ever got fired for using a struct

#16

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

That statement jumped out at me as well. I've worked as a DBA on tons of databases backing a wide variety of ERPs, web apps, analytics, data warehouses...700 columns?!? No.

Re: Nobody ever got fired for using a struct

#17

> But SQL schemas often look like this. Columns are nullable by default, and wide tables are common. Hard disagree. That database table was a waving red flag. I don't know enough/any rust so don't really understand the rest of the article but I have never in my life worked with a database table that had 700 columns. Or even 100.

https://jimmyhmiller.com/ugliest-beautiful-codebase

This is like the functional ugly tier of buildings from "how buildings learn". Excellent stuff

Re: Nobody ever got fired for using a struct

#19

Earlier quoted context omitted.

It might not be common in typical software shops. I work in manufacturing and our database has multiple tables with hundreds of columns.

What's in them?

Data from measurement tools. Everything about the tool configuration, time of measurement, operator ID, usually a bunch of electrical data (we make laser diodes) like current, potential, power, and a bunch of emission related data.
Post reply on HN