Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
doh
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
23 ms
·
211.
▲
by
doh
7y ago
> Facebook contains mostly copies of content hosted somewhere else. Not true. Youtube host around 3% of unique videos and everything else are copies, or from somewhere else or each other. Same applies to many platforms, but Tiktok and In
212.
▲
by
doh
7y ago
> Of much greater concern is that the vast majority of videos on the internet are on youtube Nope. Youtube host currently around 6B videos (adds around 1.2B a year). Facebook is currently around 3.5B, Instagram around the same, Twitter a
213.
▲
by
doh
7y ago
First time I discovered Tesla's Valve through this post back in 2013 [0]. Author did some extensive testing on its functionality and made some interesting comments/observations about old patents. Highly recommended. [0] https:&#x
214.
▲
by
doh
7y ago
Godzilla? (It’s a joke of course. HN can be sometimes too serious)
215.
▲
by
doh
7y ago
Unfortunate approach. My company not only encourage transitions, we actually "pay" for them. That means we will assign a senior developer that will have responsibility for growth of the new mentee and we purchase any educational m
216.
▲
by
doh
7y ago
This is an unfortunate law that was passed quite hastily and will bring a lot of challenges to the market. Even my company operates in this space, we were trying to convince politicians not to adopt it. We failed, as you can see. We built a
217.
▲
by
doh
7y ago
One thing that I can tell you is that they are using this to sign the request to their private API. They might be using for tracking it too (I never looked at that), but it's used to prevent their platform from being scraped.
218.
▲
by
doh
7y ago
Pex | Multiple positions | Downtown, Los Angeles, CA; Boulder, CO | ONSITE, FULL-TIME | https://angel.co/pexeso/jobs Pex built one of the largest search engine for audio-visual content ( https://softwareengin
219.
▲
by
doh
7y ago
Unfortunately not at the moment. We would have quite hard time to give you the proper support that you need.
220.
▲
by
doh
7y ago
Actually Paul Buchheit said it wasn't 20% project [0] > Gmail is often given as a shining example of the fruits of Google’s 20 percent time, its legendary policy of allowing engineers to divvy off part of their work hours for perso
221.
▲
by
doh
7y ago
Not a typo, although this is quite specific to LA where people commute for extended periods (we have employees doing 90 minute commute in each direction). We don't count hours of any employees, but as a guidance, we start day at 10:30a
222.
▲
by
doh
7y ago
That's what generated columns [0] are for ;) There is very little you can't do on the side of the database these days. And if all of it fails, then stored procedures and triggers can solve the rest. We [1] as a rule don't all
223.
▲
by
doh
7y ago
Derek's approach is one that can be carried between many old version of PG. Today, you can achieve a lot more with generated columns, (materialized) views, partitioning and other fun features added in recent versions. In any way, we us
224.
▲
by
doh
7y ago
Derek recently wrote about it [0]. The fact that you can have the thinnest client between your front-end and backend makes things incredibly flexible. If you learn PG properly you can do 100% of data preparation on the database side and jus
225.
▲
by
doh
7y ago
That's the same as saying "unoptimized selects can kill performance with large data sets". Of course they can. That's what optimization is for. We have quite large amount of data (100TB+ and trillions of rows at this poi
226.
▲
by
doh
7y ago
Pex | Multiple positions | Downtown, Los Angeles, CA; Boulder, CO | ONSITE, FULL-TIME | https://angel.co/pexeso/jobs Pex built one of the largest search engine for audio-visual content ( https://softwareengin
227.
▲
by
doh
7y ago
Pex | Multiple positions | Downtown, Los Angeles, CA; Boulder, CO | ONSITE, FULL-TIME | https://angel.co/pexeso/jobs Pex built one of the largest search engine for audio-visual content ( https://softwareengin
228.
▲
by
doh
7y ago
Well, not really. It's about how you store the data. For instance all graph data can be stored as hexastore [0] which can be stored literally in any database and you will get similar-ish performance out of them. Some databases are opti
229.
▲
by
doh
7y ago
We moved from SF to DTLA 2.5 years ago. I never been before, but even within the last 2.5 years it improved significantly. A lot of new apartment buildings were built and a lot more are under construction, pushing rents down significantly.
230.
▲
by
doh
7y ago
I'm there with you, however these [0] are the consequences of not having dual class voting structure. [0] https://www.axios.com/starboard-value-box-shareholder-activi...
231.
▲
by
doh
7y ago
Pex | Multiple positions | Downtown, Los Angeles, CA; Boulder, CO | ONSITE, FULL-TIME | $105,000 Minimum Salary + Equity | https://angel.co/pexeso/jobs Pex built one of the largest search engine for audio-visual conten
232.
▲
by
doh
7y ago
> Maybe the fix is to require the submission to include the timestamp start and end. This is already a requirement [0] that was introduced couple of weeks back. [0] https://support.google.com/youtube/thread/9566
233.
▲
by
doh
7y ago
> Do I see systems like Content ID going away without a change in law? Absolutely not. Considering the new EU Copyright Directive, especially with Article 17, if anything, the world is moving closer towards CID-like systems than away fro
234.
▲
by
doh
7y ago
For the curious ones, this policy change impacts slightly less than 10% of all potential claims (not claims that were made, but could've been made). Quite large portion of these potential claims are short videos that are being re-uploa
235.
▲
by
doh
7y ago
I was just thinking about it as I wrote it. I think that's correct and glad you brought it up.
236.
▲
by
doh
7y ago
> But instead of stepping up to the plate and igniting a Red Queen's Race that would have benefited everyone, INTC first tried to discredit the technology repeatedly, then they built an absolutely dreadful series of decelerators tha
237.
▲
by
doh
7y ago
Avast acquired AVG back in 2016. So yes, all that data ends up in the same company.
238.
▲
by
doh
7y ago
They do have some big names sticking around like Taylor Swift ( https://taylorswift.tumblr.com/post/185958366550/for-years-i... ).
239.
▲
by
doh
7y ago
WhatsApp stored no data and ran everything as through service, that's why they did it with so few engineers. Almost no games ever reach scale close to what you just wrote. The few that do are known with large technical teams. Same goes
240.
▲
by
doh
7y ago
In their 50s. The average age in the company is now in mid 30s
More ›