Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
cobolcomesback
16 days ago
|
parent
|
context
|
favorite
| on:
Show HN: 22 GB of Hacker News in SQLite
DuckDB does as well. A super simplified explanation of duckdb is that it’s sqlite but columnar, and so is better for analytics of large datasets.
formerly_proven
16 days ago
[–]
The schema is this: items(id INTEGER PRIMARY KEY, type TEXT, time INTEGER, by TEXT, title TEXT, text TEXT, url TEXT
Doesn't scream columnar database to me.
embedding-shape
16 days ago
|
parent
[–]
At a glance, that is missing (at least) a `parent` or `parent_id` attribute which items in HN can have (and you kind of need if you want to render comments), see
http://hn.algolia.com/api/v1/items/46436741
agolliver
16 days ago
|
root
|
parent
[–]
Edges are a separate table
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
