wmanley

15 ms·

121.
by wmanley 4y ago
I copy-pasted the quote from "Contributed Code" on that page.
122.
by wmanley 4y ago
SQLite doesn't accept patches: > In order to keep SQLite completely free and unencumbered by copyright, the project does not accept patches. https://www.sqlite.org/copyright.html
123.
by wmanley 4y ago
> in rust, bounds checks are only available on debug builds This is not true - bounds checks are always enforced: https://play.rust-lang.org/?version=stable&mode=release&edit... Maybe you're confusing it wit
124.
by wmanley 4y ago
I've not looked at the implementation details of Ruff, but I am of the opinion that lint tools should be based on an architecture like GitHub's stack graphs[1]. This is the technology that powers GitHub's code navigation. Sp
125.
by wmanley 4y ago
Thanks, but that wasn't quite what I meant. What I was thinking about was processing existing gzipped or zstd compressed JSON rather than having a new compression format. I could see how customising the compressor could be helpful - a
126.
by wmanley 4y ago
You'd compress the JSON, and leave the data that you extract from the JSON uncompressed using Generated Columns[1]. That way you can save the original JSON data, but still have fast querying, etc. It would look something like this:
127.
by wmanley 4y ago
On that subject I've often thought of writing a combination decompressor/JSON parser that can parse the contents of the dictionary before decompression for faster JSON parsing and lower memory usage.
128.
by wmanley 4y ago
This is really neat. I like how the compression can be applied to specific columns rather than whole rows - or whole pages. I could imagine storing JSON from an HTTP request here and using Generated Columns[1] to extract the bits my applica
129.
by wmanley 4y ago
With apt2ostree[1] we use lockfiles to allow us to version control the exact versions that were used to build a container. This makes updating the versions explicit and controlled, and building the containers functionally reproducible - al
130.
by wmanley 4y ago
I think "common culture" is precisely the problem with reddit. Before reddit there were many different separate forums. Each had to be signed up to separately and each had their own culture. With reddit there's little barr
131.
by wmanley 4y ago
Wow, I hadn't come across that before. It's so close to being what we want, but not quite right. They've even considered this specific use case: > 3. The sqldiff utility is not designed to support schema migrations and i
132.
by wmanley 4y ago
Disclosure: I'm the co-author of the blog post. One nice thing about this approach is that because it works by inspecting a database that has been put in a desired state. This means it doesn't matter how you set up your database
133.
by wmanley 4y ago
Disclosure, I'm the co-author of the blog post. > My preferred approach to database migrations is the one implemented by Django: migrations are a sequence of transformations stored in files on disk, and the database includes a table
134.
by wmanley 4y ago
The lesson isn’t how to invest, it’s how to not spend.
135.
by wmanley 5y ago
> Are you worried that the processor in your keyboard or mouse isn't backwards compatible with the processor you used in your previous mouse or keyboard? No, but the keyboard manufacturer might be, as might the people who are writin
136.
by wmanley 5y ago
Things get locked in not by standards, but by usage. If your software depends on particular instructions being present you’re not going to buy a processor that has superseded those instructions, even if the new instructions conform to a the
137.
Pip and cargo are not the same(blog.williammanley.net)
3 points by wmanley 5y ago|0 comments
138.
by wmanley 5y ago
It seems the goal is to make it easier to craft JSON by having curl perform escaping, while the proposal would seem to require some sort of in-memory tree representation of the data. One alternative would be to provide escaping more directl
139.
by wmanley 5y ago
I have a bash alias for `make` and `ninja` to do something similar. Just having all the spawned processes in a cgroup helps with system interactivity while building. This works because the kernel will then schedule the whole build as a si
140.
by wmanley 5y ago
For me it was "Git for Computer Scientists": https://eagain.net/articles/git-for-computer-scientists/
141.
by wmanley 5y ago
To pick just a small piece of the pie: Dependencies in make are equivalent to systemd's Requires= and After= combined. Systemd is far more general in this regard, both in that Requires= and After= are separate concepts, but also in th
142.
by wmanley 5y ago
I don't know why you're being downvoted: You've hit the nail on the head - Bitcoin is a Pyramid scheme, not a Ponzi scheme. I've been seeing comparisons to Ponzi schemes a lot in the last few weeks. AFAICS "Bitcoin
143.
by wmanley 5y ago
> the code is not "equivalent" when it comes to refactoring and certain changes. Yes, there are a very specific and limited set of changes you could make to the types here and not have to change this code. You can't repla
144.
by wmanley 5y ago
This is equivalent to: let x = match may_fail_who_knows() { Ok(y) => Ok(another_computation_which_can_fail(use_value(x))), Err(e) => with_some_error_handling_that_can_rescue( some_error_processing(e))
145.
by wmanley 5y ago
> SQLite doesn't support functional indexing SQLite has "Indexes On Expressions"[1] since 2015. I'm assuming functional indexing in Postgres is the same. So I think the syntax would be: CREATE INDEX idx_t_bar O
146.
by wmanley 5y ago
Unless I'm misunderstanding SQLite can do this as well, but with less nice syntax. The above could be written something like: SELECT id, json_extract(data, '$.foo') FROM t WHERE json_extract(data, '$.ba
147.
by wmanley 5y ago
Could you expand on what Postgres offers that SQLite doesn't in this regard? I'm curious to know what I'm missing out on.
148.
by wmanley 5y ago
That's exactly what's being counted. A database is a SQLite document.
149.
by wmanley 5y ago
I think it's because the thumbnails are small, so if the faces aren't exaggerated you won't perceive any particular emotion at all. It's a bit like the difference between theatre and film acting.
150.
by wmanley 5y ago
I would quite like to see some syntax sugar around this. If we could elide the type and made `...` equivalent to `..Default::default()` it would be a lot closer to kwargs without having to introduce any new "real" features. So w

More ›