Story

On air. The free wire runs 15 minutes behind live. See pricing

World, crypto, finance and tech news, scored for impact.

TechHacker NewsFiled 2 days ago

Rows vs Columns: How different are they, really?

Open the sourceReported by Hacker News, spiraldb.com, 12 November 2026

Not investment advice. Muhabbit scores how much a story may matter, not which way to trade.

Rows and columns represent fundamentally different approaches to data organization, with row-based storage optimized for transactional workloads like user logins, comments, and bank transfers, while columnar layouts better serve analytical queries that aggregate across entire datasets. The article, published November 11, 2026, by Connor Tsui, uses a New York City bike-share CSV dataset to illustrate how row-oriented systems such as Postgres and MySQL keep each record's details together, making single-record lookups and updates efficient. Analytics questions—such as which neighborhood is busiest on Monday and Friday mornings, or whether electric bikes yield longer rides than classic ones—cannot be answered by any single record and require scanning the dataset as a whole. The piece argues this distinction matters because most applications are built around row-based thinking, yet the growing demand for analytics pushes databases toward column-oriented designs. What to watch next is how database vendors and data teams reconcile these competing workloads, likely through hybrid architectures or specialized analytical engines.

Muhabbit's AI wrote this summary in its own words from Hacker News's report. It can get details wrong, so check the source.

Named in this story

Postgres, MySQL, New York City