ncruces

53 ms·

751.
by ncruces 2y ago
If the goal is to improve Chicory WASI support, this is the way. If the goal was pure Java SQLite¹, a VFS from scratch would be better. I think since I started my Go/wazero effort, WASI+SQLite improved a bunch. I had to start with the
752.
by ncruces 2y ago
Author here. If you're interested, do ask questions.
753.
by ncruces 2y ago
What's the file system access like, WASI?
754.
by ncruces 2y ago
There are many layers of that's not how it works at play here. In-memory SQLite databases don't use WAL. Wasm (and browser Wasm, in particular) doesn't support anything like the shared memory APIs SQLite wants for its WAL mod
755.
by ncruces 2y ago
For server side, you'll likely need a different build of Wasm SQLite, that handles concurrency (and file locking) differently. Also, WASI is very far from answer (so far). The SQLite amalgamation builds fine for WASI but concurrency is
756.
by ncruces 2y ago
Oh but it can, as the sister comment alluded to.
757.
by ncruces 2y ago
I'm guessing the “other post” that inspired this might be: https://research.swtch.com/nih
758.
by ncruces 2y ago
Yeah, it'd be much nicer if libraries were designed to be driver agnostic, like redka which supports 4 different SQLite drivers: https://github.com/nalgeon/redka/tree/main/example
759.
by ncruces 2y ago
If you decide to use SQLite with one (single thread) writer pool and an other reader pool, this may help: https://github.com/bxcodec/dbresolver Also sometimes if I have two tables where I know I’ll never need to do a
760.
by ncruces 2y ago
I just love how the days of the week are in english, and the rubbish separation labels are in portuguese.
761.
by ncruces 2y ago
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. Just let that sink in.
762.
by ncruces 2y ago
You didn't complain, you boasted about being in a position of power. And used someone else being worse off than you to justify being right about it. Having said that, complaining is free. We both can do it.
763.
by ncruces 2y ago
Then maybe don't use their plight to boast about how tough your are. Or to complain about the significant monetary penalties you'd have to pay, when it's surely easier to pay those on your salary than theirs.
764.
by ncruces 2y ago
The people who care for your child should themselves tell their employer, in ire, that the earliest they can be at the office is 10, and that they have to leave by 3 at the absolute latest, since they have train commutes themselves.
765.
by ncruces 2y ago
> If Hipp thought that SQLite was suitable for backend applications where the database is the authority then he would allow real types and the associated constraints. But he won't do that because it complicates the code and bloats t
766.
by ncruces 2y ago
That list lists reasons queries might return busy; queries aka. reads. Reads returning busy is rare under WAL, but WAL mode does very little for writer-writer contention.
767.
by ncruces 2y ago
Did VW ever complain about uncertainty in diesel gate? When you do shit to bend and avoid complying with the rules as much as possible, you don't get to complain about uncertainty on application of said rules.
768.
by ncruces 2y ago
Well, my 7 seater has a kerb weight of 2780 lbs (and it's a hybrid, the petrol is lighter); fully loaded it's under 4400 lbs. And it's probably heavier than most cars around here, because most cars are not 7 seaters, but 4&#x
769.
by ncruces 2y ago
Which is a much better system. My country (Portugal) still does mostly displacement, and a turbo-charged 1 liter pays a lot less than a naturally aspirated 1.6 hybrid, despite the former consuming 50% more gas.
770.
by ncruces 2y ago
And how many more SUVs go through that road? If there's a few hundred SUVs for every 18 wheeler, it's no longer negligible: it's 10 or 30% of the damage. And it could be a lot more negligible, if that mostly drive alone, drov
771.
by ncruces 2y ago
If it isn't conscious site by site, you're not volunteering your payment data to the site: you're giving it to a middle man. Then, the middle man who sets this up goes all Apple and says they rule the customer experience, the
772.
by ncruces 2y ago
As long both rust-to-wasm (or zig-to-wasm) and wasm2c are auditable, and every step reproducible, why do you need the generated C to be auditable?
773.
by ncruces 2y ago
See also: https://www.scaleway.com/ They have three zones, Paris, Amsterdam and Warsaw. Not sure if they have a free tier, but I still pay about 1€/month for two (really) small instances that I used for testing their
774.
by ncruces 2y ago
We've definitely had that: “official” government business over WhatsApp to ensure no retention rules apply.
775.
by ncruces 2y ago
Why I like the stuff that can support itself for free with a reasonable level of adds. No expectations of amazing customer support. No refunds. No I'm bound to keep offering the service because it's already paid for.
776.
by ncruces 2y ago
Internally, SQLite uses milliseconds since the Julian day epoch stored as an 64-bit integer for date math, and uses the proleptic gregorian calendar (no leap seconds). Externally, it uses either (a subset of) ISO 8601 with millisecond preci
777.
by ncruces 2y ago
I don't know if it's an accurate description, but I found this passage from Wikipedia intuitive: > Because the universe is expanding, a pair of distant objects that are now distant from each other were closer to each other at
778.
by ncruces 2y ago
> Why not? Minimum wage.
779.
by ncruces 2y ago
And from all of those, which I'd heard of, I think scoop is the only one to allow a package author to just create a git repo, and publish a package that way. Like brew does. That why I use scoop. Chocolatey would rather charge money fo
780.
by ncruces 2y ago
Scoop is nice because, like homebrew, it's easy for package creators to create their own “buckets” and distribute packages that way.

More ›