Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
pedrocr
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
78 ms
·
691.
▲
by
pedrocr
7y ago
Duplicate: https://news.ycombinator.com/item?id=21018675
692.
▲
by
pedrocr
7y ago
There's a limit to how far you can go with that policy but it does seem that in this case the regression was fairly obvious. As always there's a xkcd about it: https://xkcd.com/1172/
693.
▲
by
pedrocr
7y ago
Unlocked bootloaders everywhere would be nice but there are already manufacturers that give you that across the range. The big issue is that none of the drivers are upstream so even with LineageOS you're stuck on and old and often unpa
694.
▲
by
pedrocr
7y ago
What are you calling "Android OS" in this context? My understanding is that a lot of APIs that used to be shipped with AOSP and be updated with each new Android version are now shipped in the Play store to avoid the mess that is A
695.
▲
by
pedrocr
7y ago
Some phones in the Android One program should also have a decent chance of getting it quickly. Everything else will probably get quite a few of the features from the closed source parts of Android that are shipped by the Play Store anyway.
696.
▲
by
pedrocr
7y ago
I'm thinking of these things: https://en.m.wikipedia.org/wiki/Quadricycle_(EU_vehicle_clas... With a limitation of 50cc capacity a four-stroke may be hard. But they should all be replaced by the electric subclass
697.
▲
by
pedrocr
7y ago
You can still buy cars with two stroke engines today. In Europe they're these mini cars sold to teenagers and old people because they don't require a full driving license.
698.
▲
by
pedrocr
7y ago
I also assumed the intentional leak at first. But the update says the number was then discontinued. Having lots of people calling from other places than the one your spy is in doesn't help.
699.
▲
by
pedrocr
7y ago
Running a numbers station out of a phone number seems odd. With radio it's hard to detect who is listening. With a telephone number it should be much easier to figure out who is calling the number.
700.
▲
by
pedrocr
7y ago
Definitely. We use seasonal demand peaks to learn how to cope with extremes. But if we didn't have those plus strikes I'd definitely be planning a few test runs.
701.
▲
by
pedrocr
7y ago
That depends on the link size. But I guess it may very well be better to have a big enough DC link and have it automatically modulate power all the way up to maximum and then keep it there, instead of tripping.
702.
▲
by
pedrocr
7y ago
Isn't this kind of fault a good argument for synchronizing the UK grid to the rest of Europe? They seem to already have an interconnect that's of the scale of demand needed here, but it's a DC link.
703.
▲
by
pedrocr
7y ago
In a way these events become a blessing in disguise because of those things. We've had to deal with similar crisis situations in our supply chain. It really helps to test your procedures and operations fixing stuff along the way. The t
704.
▲
by
pedrocr
7y ago
Creating a chest fridge from a freezer is actually trivial at least in simple chest freezer units. Just swap out the thermostat for a fridge one and everything works. The freezer thermostats just work on a different temperarure range but th
705.
▲
by
pedrocr
7y ago
I'll believe Microsoft loves Linux when I can install Microsoft Office in my desktop Linux machine. Everything else is marketing. Edit: to expand, the corporate world runs on Excel/PowerPoint/Outlook. Microsoft milks them on
706.
▲
by
pedrocr
7y ago
This is really annoying because Skype video inside a Windows VM basically doesn't work. Encoding/decoding probably falls back to software and is much too slow.
707.
▲
by
pedrocr
7y ago
You must be driving in much better places than I do. Human drivers do incredibly unreasonable things even without edge cases.
708.
▲
by
pedrocr
7y ago
It will depend on the climate and date if september is still forbidden. It's not the same every year. Local policing is also highly variable. Calling the national emergency number is the correct procedure I believe (112).
709.
▲
by
pedrocr
7y ago
It's a perfectly fine practice for 8 or 9 months of the year. It's illegal in the summer for good reason.
710.
▲
by
pedrocr
7y ago
That year there was a second event where a lot of people died later in the year. That happened in a weekend just before rain was forecasted. I can't confirm the criminal intent but there is no doubt that all throughout the country peop
711.
▲
by
pedrocr
7y ago
> Not to be a complete cynic but IMO you should just use any of the pretty well-done NoSQL K/V stores if you don't mind ditching SQL. My thought process is that the current solution works so I'd only change to a K/V
712.
▲
by
pedrocr
7y ago
I've been loosely following this: https://github.com/spacejam/sled Since I'm writing in rust it might be a good fit. It's non-SQL but does have some nice features. I would need to figure out how to adapt
713.
▲
by
pedrocr
7y ago
> I have the same impressions as your parent commenter: passing around an sqlite connection handle is thread-safe and always will be faster than application-level locking. I'm not debating that. It's just that that's not
714.
▲
by
pedrocr
7y ago
If the locking is moved to the database concurrent transactions can happen. If those touch the same rows one of them will have to fail to maintain consistency. The bottleneck wasn't there though. Even a single thread doing INSERTs is m
715.
▲
by
pedrocr
7y ago
It's a simplification for the threading implementation. Spawning a new connection per thread would work but then I'd probably have to deal with failed transactions. The bottleneck wasn't there though, INSERT performance will
716.
▲
by
pedrocr
7y ago
The code for my most recent case is here: https://github.com/pedrocr/syncer/ The db code itself is here: https://github.com/pedrocr/syncer/blob/24d70fd452aa6b1463090... WAL is being
717.
▲
by
pedrocr
7y ago
This is exactly true, which is why embedding postgres would be great. It's very easy to hit the performance limitations of sqlite and then be stuck with the choice of either poor performance or forcing users to setup postgres like you
718.
▲
by
pedrocr
7y ago
Read what I wrote. What I want is always-running in-memory. Being embeddable doesn't mean you need to have the sqlite model where several processes access the same database. None of the sqlite uses I've had required that at all.
719.
▲
by
pedrocr
7y ago
There's nothing about being embeddable that's a limitation. All I really want is a lib I can link to that gives me an entry point to launch the database against a given folder, with some of the tweaks the postgres config file has,
720.
▲
by
pedrocr
7y ago
In the past I've had huge speedups by moving simple single-table databases that had grown a bit (e.g., time series data) from sqlite to postgres. Insert performance is also quite bad forcing you to write applications with extra caching
More ›