Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
murkt
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
19 ms
·
181.
▲
by
murkt
5y ago
> The travel pass is a horrible idea, that effectively will force many to be vaccinated. Good. It’s not like a concentration camp. There are other options if you don’t want to vaccinate. You can just stay at home (I’ve been declined Sche
182.
▲
by
murkt
5y ago
> Everything from banks through insurance companies through delivery companies to media groups is owned by people formerly involved with state security. Not the case with Kolomoisky, who was not involved with state security. Generally, U
183.
▲
by
murkt
5y ago
Do you work alone by chance? Because it's pretty easy to avoid problems when you work alone, remember what exactly the code does. However, when working even in a small team (3-5 devs), it's becoming much harder to avoid such footg
184.
▲
by
murkt
6y ago
Yes, they clearly mean process spawn time: > It runs a bunch of separate git commands
185.
▲
Ask HN: How YouTube made their comments good?
4 points
by
murkt
6y ago
|
2 comments
186.
▲
by
murkt
6y ago
A more complex plan isn't already more expensive in a way that captures how much work the JIT will need to do. I think I'll need to write a separate blog post about that, with details and examples.
187.
▲
by
murkt
6y ago
I'm not sure I can, and I definitely do not want to do that. I'm happy with a separate table and `btree` index on it.
188.
▲
by
murkt
6y ago
I have thought about expression indexes, and for expressions I need (@> on jsonb) they can't be used.
189.
▲
by
murkt
6y ago
Parent comments about tuning Postgres itself, though
190.
▲
by
murkt
6y ago
What I called complexity is an amount of different nodes (not sure this is the proper term) in a query plan. So, the more complexity for a given cost - the more work JIT needs to do.
191.
▲
by
murkt
6y ago
> PostgreSQL does not yet support reusing compiled plans at all Well, that explains why I couldn't make it work :) > PostgreSQL already has a threshold based on query complexity. PostgreSQL has settings that threshold based on a
192.
▲
by
murkt
6y ago
It's enabled by default since Postgres 12, and in some cases can be harmful, I mentioned it in my blog post about JSONB indexes [1]. I found it hard to make Postgres reuse JIT-compiled plans, and quite often JIT compilation can kick in
193.
▲
Fix your fraud problems with this simple trick
(vsevolod.net)
4 points
by
murkt
6y ago
|
0 comments
194.
▲
by
murkt
6y ago
Thank you very much, I use screen rarely and the thought that screen can be configured has never crossed my brain.
195.
▲
by
murkt
6y ago
Well, Android site says that it supports UVC cameras over USB, so presumably you get this feature for free!
196.
▲
by
murkt
6y ago
C920 is literally 8 years old.
197.
▲
by
murkt
6y ago
Brio is better than most webcams, still worse than all top smartphones.
198.
▲
by
murkt
6y ago
Would you buy a webcam with 1080p only (I promise it's good though!) for $250-$300?
199.
▲
by
murkt
6y ago
Yes, optical depth-of-field is only possible with reasonably big sensor sizes and wide-open lens. Reportedly, Huawei P40 Pro has an IMX700 sensor with the 1/1.33" diagonal. I didn't run the numbers for it, but it is big enoug
200.
▲
by
murkt
6y ago
>> but his camera can't output a live stream into HDMI > Buy different camera. He did :)
201.
▲
by
murkt
6y ago
> IDK why the author thinks a "good" webcam should be able to do 4k, just to show one's face?? I don't think it's very useful. I think it will be very problematic to sell a webcam for $250-300 that can't do
202.
▲
by
murkt
6y ago
I too wanted the article to be a luring into my Kickstarter. Won't happen, though
203.
▲
by
murkt
6y ago
> There is always a way to obtain engineering samples/devkits. That's how the products in these 100,000 runs get to be. Of course there is. But what's the point for me to produce a prototype if I'll have to produce hu
204.
▲
by
murkt
6y ago
I agree that we should distinguish quantity and quality. If we don't have enough light in a scene, we need to raise ISO for a given camera and that can easily make scene look bad. For other camera with bigger and less noisier sensor, b
205.
▲
by
murkt
6y ago
> Though minimum qty for parts can be as high as 5000 It can be as high as 100 000. No stock anywhere. > $30k is pretty cheap from a capital expense if you're just talking about testing a market. Yep. That's what I thought b
206.
▲
by
murkt
6y ago
It seems I needed to include a couple of shots - one is from my laptop webcam, and the other is from my phone. What "bad lighting" is changes very much based on the camera capabilities (lens, sensor, post-processing).
207.
▲
by
murkt
6y ago
> The article doesn't really go into a lot of depth about which Logitech cameras they looked at. All of them. Brio is better, but still has much worse quality than any top smartphone.
208.
▲
by
murkt
6y ago
Brio is retailing at ~$330 in my country.
209.
▲
by
murkt
6y ago
You actually want a mirrorless camera, not a DSLR one. If you intend to only use it as a webcam, probably just buy Panasonic G7 or Canon M200 for $500.
210.
▲
Why can’t you buy a good webcam?
(vsevolod.net)
783 points
by
murkt
6y ago
|
772 comments
More ›