Tuesday, November 9, 2021

Ask HN: What is the Hacker News database structure? Does it use tables or NoSQL?

HN always seems pretty fast and is probably well designed from a data structure standpoint.

It seems that each comment and submissions are assigned a monotonically increasing number; do both submissions and comments share the same numeric space?

How is the content hierarchy stored? Is it a single large table with (for example) a structure that looks like id, parentID, contenttype, content?

Is data stored in an OLAP SQL database, on disk as flat files, in DBM files, etc?

What kind of performance is required? Is the database distributed across more than one machine?


Comments URL: https://news.ycombinator.com/item?id=29165586

Points: 3

# Comments: 0



from Hacker News: Newest https://ift.tt/3EZSNb1
via IFTTT

No comments:

Post a Comment

ICE has killed another person in Minneapolis

Article URL: https://www.theverge.com/news/867245/ice-has-killed-another-person-in-minneapolis Comments URL: https://news.ycombinator.com/i...