top | item 45207800

(no title)

dave333 | 5 months ago

Maybe I don't know enough about spreadsheets but two dimensions isn't enough for most applications. Maybe pivot tables? They are too hard to figure out. Need something like "SQLSheet" that takes a more complex data structure and presents viewing and editing it in a natural way with drill down and joins etc. AI should be able to help you design the DB and then create a tool to interact with it.

discuss

order

withinboredom|5 months ago

The people using these sheets have no idea what you’re talking about. They use multiple sheets to layer the dimensions and understand pivot tables perfectly.

Tabular-Iceberg|5 months ago

Are people who understand relational databases and people who understand pivot tables disjoint sets?

I can look at someone’s finished pivot table and reproduce it from the data through other means, but any explanation of what a pivot table actually is and does reads like pure gibberish to me.

riffraff|5 months ago

Microsoft Access?

incone123|5 months ago

If someone is going to invest the time in learning how to design a database and how to build a UI then they might as well do so on something more modern.