phiresky

7 ms·

31.
by phiresky 2y ago
That's not entirely accurate since AA has separate databases for books they have as files, and one for books they only know the metadata of. The metadata database comes from various sources and as far as I know is pretty complete. Blac
32.
Visualizing all books of the world in ISBN-Space(phiresky.github.io)
486 points by phiresky 2y ago|91 comments
33.
by phiresky 2y ago
That but also and for me more importantly it does not tell you how to add time - If you add one month of hours to a date in October, it depends on the timezone whether you will end up one hour of local time earlier or not (due to DST), beca
34.
by phiresky 2y ago
Temporal is great. I've been using it for a while in production using a polyfill [1], and it solves all issues I've encountered with the old Date() API (which is a lot). It clearly takes inspiration from other high-quality time li
35.
by phiresky 2y ago
I think one very common situation you are missing in "Things that can go wrong" is repeating events: If an event repeats every Sunday at 8pm, people expect that to stay at 8pm local time. Which means you need to know the original
36.
by phiresky 2y ago
I tried using this a bit in an earlier version, when there was an option to have a real SQL client library/ORM, and you declared what part of the schema would exist client side. Is there plans to bring this back? The part where you cou
37.
by phiresky 2y ago
> The issue with sqlite's synchronous interface is leaving a thread idle while you wait for IO That's not the only issue. waiting for the result of every read to be able to queue the next read is also an issue, particularily fo
38.
by phiresky 2y ago
The article is flawed, here's an issue of someone fixing some of the issues: https://github.com/raphaeldelio/redis-postgres-cache-benchma...
39.
Show HN: An experiment in generating short form "deep thought" videos with AI(github.com)
3 points by phiresky 2y ago|0 comments
40.
by phiresky 2y ago
This is exactly the idea Brave was built on. They even had pretty great "get the ball rolling" methods like by default collecting funds even for not-yet-signed up creators, and then redistributing those funds to the other creators
41.
by phiresky 2y ago
It's a male end on the PV side, but every of these plug-in inverters I've seen only start outputting when they get the 220V 50Hz input, so they are inert as long as they are not plugged in. As far as I know they always rely on the
42.
by phiresky 3y ago
Neat! I had a very similar idea recently: https://seamlang.app/ (the sign up button doesn't work yet) The main difference seems to be that I start with text in the foreign language, and then translate the difficult voc
43.
by phiresky 3y ago
You can look at some of the videos from the music machine museum that now has the second marble machine and has been working on making it actually work. Basically it was 90% done but missing the other 90%. It was far too unreliable to get t
44.
Pandoc-url2cite: Automatically generate and manage citations from URLs(github.com)
2 points by phiresky 3y ago|0 comments
45.
by phiresky 3y ago
Markdown actually works great for larger documents when you use it with pandoc [1]. That way you get HTML output and PDF output via Latex, without the HTML being a second class citizen. I wrote my thesis (50 pages) and multiple published
46.
by phiresky 3y ago
Reminds me of antistocks [1]: "We sell antistocks.” “Antistocks? Is that like . . . shorting a stock?” “Shorting is barbaric. Think how nice and simple going long is. And then with shorting you have to borrow from some specific person
47.
by phiresky 3y ago
A bit of a weird way to structure this kind of article. Why spend multiple pages comparing different formats by compression % / "Quality Setting" and only after 6 graphs start saying "oh by the way at 40% the AVIF image
48.
by phiresky 3y ago
The video above is the "Apps & Tools" showcase. Here's the desktop/console games showcase: https://www.youtube.com/watch?v=UAS_pUTFA7o
49.
by phiresky 3y ago
There was some articles on here about how maps have been changing over the years (also other map apps). The gist is that why would you need to show street names anymore? On printed maps that's the only thing you have, but that's n
50.
by phiresky 3y ago
This blog post explains how it works: https://phiresky.github.io/blog/2021/hosting-sqlite-database... Disclaimer: I wrote that article and was somewhat involved in the other sqlite over ipfs project this is forked
51.
Booking.com commits to align with consumer protection law following EU action(ec.europa.eu)
1 points by phiresky 3y ago|0 comments
52.
by phiresky 4y ago
If WAL mode is enabled and the inserts are running in a separate thread or process then the performance will be exactly while any amount of selects are running.
53.
by phiresky 4y ago
A while back I tried this with ChatGPT and it's kinda hilarious: You are a therapist employed by a skincare company. You are talking with a patient. Your job is to help the patient as well as possible but your employer also wants you t
54.
by phiresky 4y ago
The K-L divergence is relevant there, even though I'm pretty sure that that "formally" comment is meant as a joke and not serious. (wikipedia) "A simple interpretation of the KL divergence of P from Q is the expected exc
55.
by phiresky 4y ago
Getting captchas solved reliably via a service costs around $1 per 1000 captchas so captchas are kinda useless as well if there's a tiny monetary incentive to get to whatever is behind the captcha.
56.
by phiresky 4y ago
https://github.com/webrecorder/browsertrix-crawler works pretty well. Same tech as https://archiveweb.page/ but non-interactive
57.
by phiresky 4y ago
Arguing against whataboutism makes sense, but considering over 50 billion animals are killed every year for food it seems a bit weird to consider 1500 animals being killed for some purpose news (0.000003% of that total).
58.
SimulaVR Has Been Subpoenaed by Meta Platforms, Inc(simulavr.com)
754 points by phiresky 4y ago|443 comments
59.
by phiresky 4y ago
GitHub chose to include a huge amount of software by default in their runners. Just look at this list: https://github.com/actions/runner-images/blob/main/images/li... This means that you are able to
60.
by phiresky 4y ago
You can use it from python as follows: db = sqlite3.connect(...) db.enable_load_extension() db.load_extension("libsqlite_zstd.so") You probably still have to figure out how to make that work cross-platform /

More ›