Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
rezonant
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
16 ms
·
241.
▲
by
rezonant
2y ago
I believe they meant on https://google.com (the home page)
242.
▲
by
rezonant
2y ago
Take from it what you want, but he did not say that SQLite is worse, that's an inference. He just said Postgres is the best database in the world, and that's quite valid from the perspective of features, correctness, and performan
243.
▲
by
rezonant
2y ago
Your example underscores why it doesn't read that way for me. A Ferrari Enzo and a horse are such different transportation methods that the two barely overlap in use case. A horse needs no gasoline, can work off road, and is much quiet
244.
▲
by
rezonant
2y ago
You can reflect on your early experience with SQLite while simultaneously reflecting on why Postgres is a great database. If it wasn't that way, we'd all be running SQLite for our web services, but we're not. All technologies
245.
▲
by
rezonant
2y ago
I didn't take this post to be overly negative, just a reflection of their experience in working with the tech. For anyone coming from a heavyweight SQL background, it is indeed pretty easy to be caught off guard with SQLite. That doesn
246.
▲
by
rezonant
2y ago
What is the problem here? Google already has your document, all they are doing with Gemini is running it through a bunch of transformers and spitting back some information. The act of sending input into an LLM does not itself train the LLM
247.
▲
by
rezonant
2y ago
Of course. A few more kilobytes is a good tradeoff for debuggability and the ability to read the original code during development. Web apps that get bundled won't include it, ESM web apps won't request them, and if a server side a
248.
▲
by
rezonant
2y ago
Well, if they want no one to use their libraries, then fine. You would think that as a person publishing library code to a public registry, you would be incentivized to ensure your code is broadly usable. At least in general. I know this is
249.
▲
by
rezonant
2y ago
Fair, but if you don't fall into the pit of despair by consuming micro libraries (ie "is-true" or "leftpad"), the overhead of having source and source maps present on a developer environment or even a server deploym
250.
▲
by
rezonant
2y ago
Sure-- the first issue is that NPM is a JavaScript registry, and it's bad form to restrict usage of your library to Typescript projects, or require non TS users to go through hoops to use your code. Additionally, if your own project ex
251.
▲
by
rezonant
2y ago
Yes, I recommend shipping TS source alongside compiled JS+d.ts even if you don't support a TS native environment, because you then have the potential of a source mapped debugging experience within that library (though currently doing t
252.
▲
by
rezonant
2y ago
Please do not start publishing raw Typescript into the NPM registry thinking that all the reasons we have not done that in the past do not continue to apply. I shouldn't have to say this, but at least 27 people upvoted this article,
253.
▲
by
rezonant
2y ago
This confuses me. You either write the d.ts manually before build, which only makes sense if you wrote the original code in JavaScript (not Typescript) or you write the source in Typescript and enable the declaration option in your tsco
254.
▲
by
rezonant
2y ago
This is all fully correct, which is why isolatedDeclarations is a nice feature... for authors of large Typescript projects . The tradeoff is to be more explicit on your public API surface so that you can reduce build times. That's gre
255.
▲
by
rezonant
2y ago
> but will it actually work in practice? No. It seems like they are assuming the user is using JSR, which handles generation of JS and d.ts for you. But then none of this would even be a problem. The NPM registry doesn't do any of t
256.
▲
by
rezonant
2y ago
But then they assume the code is authored in Typescript... Who is authoring in Typescript and then simultaneously writing their d.ts manually?? It makes no sense.
257.
▲
by
rezonant
2y ago
You wouldn't expose the numeric IDs publically, and ideally you'd use your database's automatic ID selection to avoid any complexity. The UUID sorting works in the common case, but if you happen to end your batch near the cur
258.
▲
by
rezonant
2y ago
As mentioned elsewhere, it ensures the ability to perform resumable and consistent batching queries across the data set without missing records. Ordering over an insertion timestamp is not enough if two records may have the same timestamp:
259.
▲
by
rezonant
2y ago
This. Highly recommend using a numeric primary key + UUID. Using UUID relations internally can have some strategic advantages, but when UUIDv4 is used as the only primary key, you completely lose the ability to reliably iterate all records
260.
▲
by
rezonant
2y ago
That would be great, but wireless earbuds and watches greatly need battery advances to overcome the current tedious ways to use them. Most smart watches need to be charged in a matter of 1-2 days, and wireless earbuds have to use extra batt
261.
▲
by
rezonant
2y ago
Similarly, for sites which configure robots.txt to disallow all bots except Googlebot, I don't lose sleep about new search engines taking that with a grain of salt.
262.
▲
by
rezonant
2y ago
I think the big take away is that GitHub should add a "Merges #X" feature similar to Closes #X as Daniel suggests. An additional problem with closing a pull request instead of "purple merging" it is that it gives off the
263.
▲
by
rezonant
2y ago
Yeah, my machine connects over WiFi on an external USB 3 adapter because I'm too lazy to finish my Ethernet project. The adapter requires drivers, which are handily included on the device itself as a mass storage device. But there'
264.
▲
by
rezonant
2y ago
Interesting, our experiences are different here. I suspect it's because I installed Windows 11 (23H2) using a local account using the OOBE bypass (not because I particularly hate the Microsoft account thing, but because this machine us
265.
▲
by
rezonant
2y ago
Oh fantastic! Any way we could maybe just solve the second problem to get it done faster? Those poor fossil fuels companies are really hurting-- honestly that should be our priority. We can't have oil execs going hungry. /s
266.
▲
by
rezonant
2y ago
I'm sorry to hear about the struggles this has put you through, but I might mention that it is not universal that diagnosed sufferers of ADHD are unable to engage with their interests. In fact often direct interests can be highly engag
267.
▲
by
rezonant
2y ago
Preventing other users on your network from snooping the administrative credentials to your LAN services for one (easy to do on WiFi, even if you use WPA). Also, if one of your devices switches off your WiFi and onto cellular, and you are u
268.
▲
by
rezonant
2y ago
Friends don't ask friends to install their custom root CA. If someone asked you to install theirs, would you? After all, once they've installed your root CA, you'll now be able to trivially intercept all of their encrypted HT
269.
▲
by
rezonant
2y ago
re (1): Indeed, I think we all agree that "position: relative; left: 31.4em;" is a solid solution to the first challenge.
270.
▲
by
rezonant
2y ago
Not sure that's true, the answer is "it depends". Is your app a content website? Does it have interactive features? Is it a tool that has no state? Does it have tons of transient state? Do you depend on SEO for this thing? Do
More ›