michalc

8 ms·

61.
by michalc 3y ago
Ah thanks for this (maybe not so much for the code itself admittedly, but for the push to implement locking) So after a few attempts, I _think_ I have something reasonable: https://github.com/michalc/sqlite-memory-vfs&#
62.
by michalc 3y ago
> and the associated sqlite3_serialize and sqlite3_deserialize APIs So... I have to admit I missed the existence of these. So for many cases, using sqlite3_deserialize is probably a very reasonable choice over sqlite-memory-vfs Still, as
63.
by michalc 3y ago
No benchmarks right now. And in fact, I'm not even really sure what would make good ones, so suggestions welcome. In terms of the difference from pointing SQLite to /dev/shm, my answer is somewhere between "I don't
64.
Show HN: sqlite-memory-vfs - Open a SQLite db in Python without hitting disk(github.com)
17 points by michalc 3y ago|14 comments
65.
by michalc 3y ago
> Now, you change a little thing in your code base, and the only thing the testing suite tells you is that you will be busy the rest of the day rewriting false positive test cases. If there is anything that makes me cry, it’s hearing “it
66.
Show HN: to-file-like-obj - the inverse of Python's two-argument iter function(github.com)
2 points by michalc 3y ago|0 comments
67.
Show HN: Parallel bulk delete objects in S3 using Python(gist.github.com)
1 points by michalc 3y ago|0 comments
68.
Jellyfish: Our complex relationship with the oceans’ anti-heroes(theconversation.com)
2 points by michalc 3y ago|0 comments
69.
by michalc 3y ago
My own attempt at bridging the Python and, well, maybe not quite shell but more subprocess, boundary: https://github.com/uktrade/iterable-subprocess .
70.
by michalc 3y ago
Shameless plug of a couple of Python libraries I’ve been involved with that work around memory issues of ODS files (for very specific use cases): https://github.com/uktrade/stream-read-ods https://github.com
71.
by michalc 3y ago
You can also make a single file Python package that achieves the same API. https://www.stefaanlippens.net/single-python-module-packagin... has info on how to do this (not my page, but seems clear)
72.
by michalc 3y ago
Shameless plug for a short post/guide to “the good bits” of asyncio from a few years ago: https://charemza.name/blog/posts/python/asyncio/I-like-pytho...
73.
Show HN: pg-bulk-ingest – Bulk ingest into PostgreSQL with high-watermarking(github.com)
2 points by michalc 3y ago|0 comments
74.
by michalc 3y ago
I'm sad that it was. I think it's interesting pretty much any way you slice it - either from a sort of social point of view, or from a statistical point of view.
75.
Portugal has a divorce rate of 94%(twitter.com)
24 points by michalc 3y ago|25 comments
76.
Show HN: pg-force-execute – Run a PostgreSQL query even if blocked(github.com)
1 points by michalc 3y ago|0 comments
77.
by michalc 4y ago
I do something very similar - I didn’t realise this had a name. I plan that I will essentially have to context change in a short amount of time, so try to achieve some tiny thing before that. It really works - at least for me.
78.
by michalc 4y ago
I have previously thought a bit about using something like Supervisor. And if I was running something a bit closer to the metal, with no other infrastructure to restart stuff, then I would be much more pro. But if inside Docker when somethi
79.
by michalc 4y ago
I've never been sure if it's too much of a hack, but I've used GNU parallel in Docker containers as a quick and easy way of getting multiple processes running for web applications. And with the `--halt now,done=1` option (tha
80.
Show HN: mirror-git-to-s3 – Python function and CLI to mirror Git repos to S3(github.com)
1 points by michalc 4y ago|0 comments
81.
Show HN: stream-read-ods – Read OpenDocument spreadsheets on the fly in Python(github.com)
1 points by michalc 4y ago|0 comments
82.
by michalc 4y ago
I have a very minor example of something similar myself: A quick 1-liner Stack Overflow answer that addresses a common typo is my highest rated answer. Those that I spent hours (or maybe even days!) answering: almost nothing.
83.
by michalc 4y ago
One thing seems odd to me... about a guest's rating (not a host's): "she got a three-star review because the cleaning wasn’t up to the mark. Her perfect five-star rating dipped to 4.1." Can guests see their own star rati
84.
by michalc 4y ago
Aha! This is done in https://github.com/uktrade/mbtiles-s3-server , but using an alternative library to query SQLite on S3, https://github.com/michalc/sqlite-s3-query (Full disclosure: I wrote most
85.
by michalc 4y ago
Ah even if this were the case, in some situations you can’t mount filesystems (e.g. Docker without certain capabilities enabled?), and so something more in the application layer would be the only way to access SQLite on S3?
86.
by michalc 4y ago
The many references to children as instruments of profit is… pretty bleak
87.
by michalc 4y ago
I think other projections have been on my mental todo list for about 5 years now… one day!
88.
by michalc 4y ago
Thanks!
89.
by michalc 4y ago
Ah for me the lack of sense of what’s going on is sort of the point of it. The rotated projections are just as right as the regular Mercator projection in an objective way, but it really doesn’t feel that way.
90.
by michalc 4y ago
I’ve posted this on HN before, but my own “brain reboot” came from making http://projections.charemza.name/ that allows you to rotate the world before applying the Mercator projection. The “crazy looking” distortions make m

More ›