top | item 46436593 (no title) cobolcomesback | 2 months ago 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. discuss order hn newest formerly_proven|2 months ago The schema is this: items(id INTEGER PRIMARY KEY, type TEXT, time INTEGER, by TEXT, title TEXT, text TEXT, url TEXTDoesn't scream columnar database to me. embedding-shape|2 months ago 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 load replies (1)
formerly_proven|2 months ago The schema is this: items(id INTEGER PRIMARY KEY, type TEXT, time INTEGER, by TEXT, title TEXT, text TEXT, url TEXTDoesn't scream columnar database to me. embedding-shape|2 months ago 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 load replies (1)
embedding-shape|2 months ago 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 load replies (1)
formerly_proven|2 months ago
Doesn't scream columnar database to me.
embedding-shape|2 months ago