malisper

15 ms·

151.
by malisper 5y ago
The "algorithm" I wrote in this post is a formalized version of some problem solving techniques I picked up from the classic book "How to Solve It"[0]. In particular "working backwards". You start from the goal
152.
by malisper 5y ago
There's a specific reason I didn't mention priority queues in the post. In most cases, anything you can do with a heap you can do with a binary tree instead! A binary tree has O(log(n)) insert and deletion which is the same as a t
153.
by malisper 6y ago
The post touches upon it, but I didn't really understand the point. Why doesn't synchronous replication in Postgres work for this use case? With synchronous replication you have a primary and secondary. Your queries go to the prim
154.
by malisper 6y ago
(I used to work at Heap.) I think the post is spot on and it shows the Satchel team put did a ton of research into the post. There are two comments I would make on top of the post. First, know if the advice applies to you. If you are pre-pr
155.
by malisper 6y ago
That's a different argument that what most people in the thread are making and in my opinion, a reasonable one.
156.
by malisper 6y ago
ITT: people claiming DoorDash has no path to profitability - the numbers in the S-1 tell a different story. On page 112, there's a chart of how much profit they make per order based on how long the user has been on the platform. In the
157.
by malisper 6y ago
IIRC, EXPLAIN VERBOSE will show you the columns being selected by each step of the plan. The inlining showed up there.
158.
by malisper 6y ago
I've mentioned this story here before, but one of the most surprising performance gains I saw was by eliminating TOAST look ups. If I recall correctly, each time you use the `->>` operator on a TOASTed JSONb column, the column wi
159.
by malisper 6y ago
For a post detailing the modern data infrastructure I'm surprised they intentionally leave out SaaS analytics tools. I find this especially surprising given a16z has invested >$65M into Mixpanel. Based on my experience working at an
160.
by malisper 6y ago
> Absolutely false. This is simply not how copyright works! How so? Here's what section 5 of the AGPL says[0]: > You may convey a work based on the Program, or the modifications to produce it from the Program, in the form of sour
161.
by malisper 6y ago
> Disgusting amount of control over people's lives. Y'all need a union. FWIW this is more Google being risk adverse than Google being evil. If a Google employee in their free time contributes to an AGPL project, that employee n
162.
by malisper 6y ago
> But this only can happen if replace X with Y and add Z are in the same transaction. If you rollback the transaction, then you start by removing Z, then replacing Y with X. What I'm missing here? Z can be in a different transaction
163.
by malisper 6y ago
> Does it do this in the reverse order? I would guess so, but I haven't looked up the implementation so I'm not sure. There's a ton of race conditions that can come up depending on the exact order you write things so I&#x2
164.
by malisper 6y ago
In Postgres 12, the pluggable storage API was introduced. That allows use of multiple different storage engines with Zheap being one of the new storage engines. IIRC, one of the big reasons for implementing pluggable storage was for Zheap.
165.
by malisper 6y ago
For those unaware, Zheap is a new storage engine for Postgres that handles updates and deletes in a different way. Currently, when you update a row in Postgres, Postgres creates a new copy of the row and marks the old one as deleted. This i
166.
What Is Snowflake and Why Is Everyone Excited About It?(freshpaint.io)
2 points by malisper 6y ago|0 comments
167.
What Is Snowflake and Why Is It Exciting?(freshpaint.io)
6 points by malisper 6y ago|1 comments
168.
by malisper 6y ago
Q: Since users of Plausible are sending you their visitors IP addresses, doesn't that mean GDPR applies? GDPR mentions "disclosure by transmission" as an example of processing[0]. Since that's the case, doesn't that
169.
Web Analytics Company, RudderStack, Accidentally Collecting Passwords(freshpaint.io)
4 points by malisper 6y ago|0 comments
170.
by malisper 6y ago
GDPR article 12[0] explicitly permits this: > Without prejudice to Article 11, where the controller has reasonable doubts concerning the identity of the natural person making the request referred to in Articles 15 to 21, the controller m
171.
by malisper 6y ago
(I'm the author of the post.) I've worked with a large Postgres cluster before (~1PB of data) and have been experimenting with Snowflake recently. I would say there's two clear technical advantages of Snowflake over Redshift.
172.
Why is Snowflake so Valuable?(freshpaint.io)
247 points by malisper 6y ago|163 comments
173.
by malisper 6y ago
So I understand the rationale for writing your own storage layer and think this is an awesome project, but there's something missing for me. One of the issues Peter brings up is they've come across a number of serious bugs in Rock
174.
by malisper 6y ago
I think some seed rounds work this way. Some seed rounds have a small number of large checks that fill up the entire round. For managing chemistry, the extent of our interaction with most of the investors is they are on our investor mailing
175.
by malisper 6y ago
> A $1.5m is barely enough to invest in one early stage startup these days. I just raised a $1.5m seed round for my startup and can tell you this isn't true. We've published all the numbers on our raise so you can take a look f
176.
by malisper 6y ago
I've had a number of chats with Dan Luu about this. If you want the high risk, high reward of a startup, while earning the total comp of a FAANG, you can work for FAANG and angel invest on the side. If out of college, you work for FAAN
177.
by malisper 6y ago
IANAL - I don't believe acquiring another company and the PII along with it is necessary a GDPR violation. Article 14 of GDPR[0] lays out the requirements for what a company needs to do when a company acquires personal data, not direct
178.
by malisper 6y ago
Even though it says "initial back-end language(s)" it looks like the information is often pulled from the startup's current career pages. Mixpanel is listed as using Go as one of their initial back-end languages, even though
179.
by malisper 6y ago
I've worked in the space for over four years now and I'm currently building a startup in the space. Google Analytics is the gold standard. It's the tool everyone is familiar with and is often the thing someone does after sett
180.
Raising a Seed Round During Covid-19(freshpaint.io)
2 points by malisper 6y ago|0 comments

More ›