cedricd

7 ms·

31.
Identifying Bot Traffic with SQL(narrator.ai)
3 points by cedricd 5y ago|0 comments
32.
by cedricd 5y ago
Surprisingly it's not that much. At a constant 1G acceleration you could travel across the galaxy (100k light years) in 12 years (from your reference frame)[0]. I definitely agree that such travel would require enormous amounts of ener
33.
by cedricd 5y ago
My answer to maintaining a minimal set of photos on a local machine isn't great unfortunately. The desktop holding all the photos acts like a file server and I connect my laptop to that when browsing images. There's a way to do it
34.
by cedricd 5y ago
I'm surprised how technical and homegrown all these solutions are (well, it's an HN crowd so maybe I shouldn't be). I'm a techy too and pretty into photography, but I've gone the other way. I store all my photos on
35.
by cedricd 5y ago
That's true. I wasn't sure what else to call it. I guess it's more investment upfront at a later valuation. It's almost like a SAFE where the next SAFE acts like a priced round. It's a non-trivial amount though -- i
36.
by cedricd 5y ago
I'd be curious to see if YC founders, for whatever reason, are able to choose to opt out of the 375. Overall I think this is a great move, and it's good for founders going through the batch. But they could have reasons to not want
37.
by cedricd 5y ago
It's clearly a breaking change how a core feature of the library behaves. This is extremely unprofessional on the part of the maintainers. I'd completely lose trust in the gem. They knew they were making a breaking change, documen
38.
A guide to data-driven prioritization for Product Managers(narrator.ai)
1 points by cedricd 5y ago|0 comments
39.
by cedricd 5y ago
I live in NYC and on many heavy machinery I hear a white noise-type sound when they back up -- just like the article describes. It's still pretty noticeable, but the ambient noise is already pretty high in the city, so it does fade qui
40.
by cedricd 5y ago
The point of the function is that it doesn't matter you've crossed the year boundary when counting days. A naive implementation would accidentally get tripped up by the year -- extracting the 'day' part of a timestamp, a
41.
by cedricd 5y ago
These are used pretty often when doing data analysis. It's a simple way to group things together. For example, find all users who have have been active at least 10 days. This provides a simple way to do a complex operation (if a user s
42.
by cedricd 5y ago
Yep. That's exactly why this function isn't trivial to write. Boundaries are not obvious and native pg functions (insofar as I'm aware of them) don't do these kinds of diffs. Semantically the code has to diff days (for e
43.
by cedricd 5y ago
Those postgres docs are usually so dry but this is great > The first century starts at 0001-01-01 00:00:00 AD, although they did not know it at the time
44.
by cedricd 5y ago
I've always wondered myself. Maybe it's because it's mostly useful for analytical workloads instead of operational ones. Redshift, famously based off Postgres, chose to implement it
45.
PostgreSQL's Missing DateDiff Function(narrator.ai)
78 points by cedricd 5y ago|57 comments
46.
by cedricd 5y ago
I've run all of them over the years (progressively upgrading like a good computer user). It's not even subtle. The good / bad dynamic is drastic. And each 'bad' always brings to it a horrible UI change. Vista brough
47.
by cedricd 5y ago
Has anyone used some of these in production? Tina, Builder, Storybloks, React Bricks, or this one? Curious what the experience is like.
48.
How to generate a series of numbers in SQL(narrator.ai)
2 points by cedricd 5y ago|0 comments
49.
by cedricd 5y ago
So does that mean that YC is now a paid subscriber to the service? ;). Very classy callout in any case. I love the story of a startup getting good press for doing something nice. Also this sounds like a really good case study for them to pu
50.
by cedricd 5y ago
Yeah, this one bugs me too. I try to use 'requests' instead.
51.
What Would Feynman Do? (2011)(ericlippert.com)
2 points by cedricd 5y ago|0 comments
52.
One question to make your data project 10x more valuable(narrator.ai)
1 points by cedricd 5y ago|0 comments
53.
by cedricd 5y ago
This isn't widely known, but activity schema[1] is aiming for this space (disclosure - I co-founded the company supporting it). It's a modeling approach that separates data modeling from data querying -- meaning that once data is
54.
PostgreSQL's Missing DateDiff Function(narrator.ai)
2 points by cedricd 5y ago|0 comments
55.
by cedricd 5y ago
If I'm understanding correctly you think the boundary crossing thing is weird. Like why would it say that Jan 1st 2021 - Dec 31 2020 is 1 year, when it's more like 1/365 of a year. I'm not necessarily the best person to
56.
by cedricd 5y ago
Author here. I've used pg a ton in the past in production systems as an operational database. Never really missed having datediff. Once we started using it as a data warehouse I noticed that function was missing -- most other data ware
57.
PostgreSQL's Missing DateDiff Function(narrator.ai)
8 points by cedricd 5y ago|4 comments
58.
by cedricd 5y ago
Yeah, this advice looks targeted to companies that benefit hugely from targeting their users. If I'm reading correctly it's basically saying 'once a user has identified themselves to you, then you can go back and figure out t
59.
by cedricd 5y ago
The identifier on the urls isn't meant to identify the actual user I think. If you look at the examples given they're more like identifiers to something else -- an order id or subscription id. Wouldn't tracking something like
60.
by cedricd 5y ago
I'm not sure that spinning that as a positive is a good idea. It's objectively a massive amount.

More ›