cedricd

14 ms·

61.
by cedricd 5y ago
We've been running shareable / configurable data analyses in production for the past several years. In the data analysis world this has always been seen as a bit of a pipe dream, because no one's data is structured in the sam
62.
Shareable data analyses using templates(narrator.ai)
8 points by cedricd 5y ago|1 comments
63.
by cedricd 5y ago
Thanks. I was thinking the same thing. The language is hard to read. http://paulgraham.com/simply.html
64.
by cedricd 5y ago
Narrator | New York, NY | Full stack engineer | Full-time | Remote | https://www.narrator.ai Narrator (YC S19) is an end-to-end data platform that models all data in a single time-series table. We're a totally new kind of d
65.
by cedricd 5y ago
In other words: please go home and I'll call you. 'Head on home' is a real expression. Similar ones are 'head over there', 'head to ...', all of which just mean 'go to'.
66.
by cedricd 5y ago
Exactly. I wonder if this trend will create a meaningful turnaround for them. What a wild world.
67.
by cedricd 5y ago
That's a common take, but a well-designed carbon tax could be made revenue-neutral and non-regressive. In other words, the amount it takes in can be given back to the average person -- in forms of tax rebates, investment in public tran
68.
by cedricd 5y ago
This suggests a potentially disturbing trend -- companies or managers that will start implicitly punishing employees for working remotely. My guess is that even at companies that officially support partial remote time employees will start t
69.
by cedricd 5y ago
I think you're right but it's a bit out of scope. Hard to give generalizable advice around this I think. What we personally do in practice is put everything into a single time-series table with 11 columns. [1] 1: https:/&#x2
70.
by cedricd 5y ago
Yep. Fully agree. The point of the post wasn't to say that you should use PG as a data warehouse. Just that if it's what you've got available (for various reasons) that you can .
71.
by cedricd 5y ago
Luckily Postgres' autovacuum works really well in normal workloads. If there's an even mix of inserts spread throughout time then it's probably best to just rely on it. For data warehouses inserts can happen in bulk on a regu
72.
by cedricd 5y ago
Also, what's your take? Do people use citus for analytical workloads as well as production at scale? I'd assume yes, but I haven't personally used you guys. I'm just aware of you and broadly how you scale Postgres.
73.
by cedricd 5y ago
Ahh! So sorry. Fixed it.
74.
by cedricd 5y ago
I updated the blog post :)
75.
by cedricd 5y ago
That's a great point. This isn't really what you're saying, but citus [1] ships a distributed Postgres. A lot of the things they improve would help massively with analytical workloads actually. 1: https://www.citus
76.
by cedricd 5y ago
Yeah, I think using Snowflake or BigQuery or something is ultimately the better move. But sometimes folks use what they know (what they're comfortable managing, tuning, deploying, whatever). In my own testing PG performed very similarl
77.
by cedricd 5y ago
Maybe it doesn't get prioritized until it's important. I know PG upgrades are pretty straightforward, but sometimes people don't want to touch something running well. That said, given the performance implications, if someone
78.
by cedricd 5y ago
Would TimescaleDB be much faster for analytical queries that aren't necessarily segmented or filtered by time? My uninformed assumption is if I do a group by over all rows in a table that they may not perform better. I'll look int
79.
by cedricd 5y ago
Yes, that's a really great point. I should emphasize that more clearly in the blog :).
80.
by cedricd 5y ago
We support multiple data warehouses on our platform. We recently had to do a bit of work to get Postgres running, so we wrote a high-level post about things to consider when running analytical workloads on PG instead of normal production wo
81.
Using PostgreSQL as a Data Warehouse(narrator.ai)
435 points by cedricd 5y ago|150 comments
82.
by cedricd 5y ago
Narrator | New York, NY | Full-time | Remote | https://www.narrator.ai Narrator (YC S19) is a library of expert-written data analyses that anyone can run instantly on top of their data. Our stack is Python and React. We're
83.
by cedricd 6y ago
SEEKING FREELANCER | Narrator.ai | remote | part time Looking for someone with a data or technical background to write content for us. Mostly blog posts aimed for data engineers and analysts. https://www.narrator.ai Narrator (YC
84.
by cedricd 6y ago
Narrator | New York, NY | Full-time | Remote | https://www.narrator.ai Narrator (YC S19) is a library of expert-written data analyses that anyone can run instantly on top of their data. Our stack is python, react We're look
85.
by cedricd 6y ago
Not sure if they make them still today, but I saw those pots for sale by the hundreds at a market in Bagan about 10 years ago.
86.
WeWork to Become Publicly Traded via SPAC Merger with BowX Acquisition Corp(wework.com)
3 points by cedricd 6y ago|0 comments
87.
by cedricd 6y ago
Narrator | New York, NY | Full-time | Remote | https://www.narrator.ai Narrator (YC S19) is a library of expert-written data analyses that anyone can run instantly on top of their data. Our stack is python, react We're look
88.
Generating realistic user timestamps in SQL(blog.narrator.ai)
2 points by cedricd 6y ago|0 comments
89.
by cedricd 6y ago
I've been to Machhapuchhare base camp. You can see the mountain from further out on the way up, and when you turn a corner several days later right up close. It's easily one of the more beautiful peaks in the Himalayas.
90.
How to Calculate LTV for Ecommerce(blog.narrator.ai)
2 points by cedricd 6y ago|0 comments

More ›