jiaaro

6 ms·

1.
by jiaaro 8mo ago
Exists is a useful tool that you should certainly know how to use. Whether or not it's faster than distinct depends on the rest of the query. I've optimized queries where distinct is faster than exists. It's been some time, b
2.
Neon PostgreSQL Tutorial(neon.com)
1 points by jiaaro 1y ago|0 comments
3.
by jiaaro 2y ago
Cool project! But, I wonder how long can a project like this use a Pokemon as their namesake and mascot before you hear from nintendo's lawyers?
4.
by jiaaro 2y ago
Random and round robin partitioning are the configurations being discussed. The main point of the article is that low message volumes mean you can get unlucky and end up with idle workers when there is still work to be done
5.
by jiaaro 2y ago
The linked article says, in reference to Oracle relocating its HQ to Austin: > Oracle, which was founded in Santa Clara, Calif., in 1977, later had its headquarters in Redwood City. The software giant, at the time of its move to Texas, s
6.
Franz: Native Kafka Client for macOS, Windows and Linux(franz.defn.io)
3 points by jiaaro 2y ago|0 comments
7.
by jiaaro 3y ago
The main difference is that you wouldn’t instead drive the whole way instead once you find out the risk. But people do drive the same places they fly
8.
by jiaaro 3y ago
`str(queryset.query)` does not give you executable SQL. Query parameters are not escaped or encoded in that representation of the query. That escaping/interpolation of query parameters is performed by mogrify. I agree the name is odd,
9.
by jiaaro 3y ago
If you use postgres, psycopg provides `cursor.mogrify(query, params)` which returns the actual query that will be executed . For example: cursor.mogrify(*queryset.query.sql_with_params()) Alternatively, you can set the log level of
10.
by jiaaro 3y ago
On the other hand, these things see a lot more annual miles than consumer vehicles so the payback period should be shorter. I agree though, that probably it would require some kind of government involvement to get broad adoption. Also, I im
11.
by jiaaro 3y ago
I think the suggestion is that a spreadsheet is the not the right tool for the job. There is very likely value in dedicated genetics-specific software, even in the form of an excel add-on. [edit] Here's one, and it's free: https:
12.
by jiaaro 3y ago
Based on the paper Dang linked, it appears that epoxy is involved in all queries to all data stores it coordinates
13.
by jiaaro 3y ago
Does Epoxy use postgres' own transaction ids across datastores? If not, does it implement its own "transaction id horizon" like postgres has so that you can assume all transactions before a certain counter are committed?
14.
by jiaaro 3y ago
I’m not an industry expert either, but ear plugs don’t block sound taking other paths to the ear drum like bone conduction. The mix knob on this limiter can’t be turned to 100%
15.
by jiaaro 3y ago
The blog post mentions that partitions are too low-level an abstraction to program against. Does that mean WarpStream doesn't use partitions? Do you provide any ordering guarantees like Kafka does at the partition level?
16.
by jiaaro 3y ago
And this is even true for some more exotic indexes where you might not expect it like exclusion constraints with gist. It’s much more expensive to maintain with a range as the first column and a highly selective id for the second column tha
17.
by jiaaro 3y ago
As an American I can confirm that, not only do we say “4th of July,” both phrasings are in common use for any date of the year. March 5th is more commonly heard in USA than 5th of March, but nobody would look at you funny either way.
18.
by jiaaro 4y ago
One could argue that for some content, how to style it is just a suggestion anyway. Ie you could think of “our style guide for text content can be found at this address” as metadata for semantic HTML documents
19.
by jiaaro 4y ago
Yeah - It does seem like the author is trying to apply too many lessons learned from managing computers and software to managing people.
20.
by jiaaro 4y ago
Agreed, 70 USD probably has a healthy margin. But, I also value that it's been calibrated, tested for reliability, and is already designed/assembled.
21.
by jiaaro 4y ago
Agreed, I use the cheapest monitor on this page (currently $69 USD) – a little awkward to change the settings, but runs on USB power, monitors CO2 and temperature, and beeps when you exceed a (configurable) threshold so you know to open a w
22.
by jiaaro 4y ago
K9s - https://k9scli.io/ Terminal (ncurses?) Kubernetes client Bash “wait” command to do multiple things in parallel without extra _stuff_. Eg ( dothing.sh & slow_stuff.sh & more.sh &
23.
by jiaaro 4y ago
Those of us born in 1986 (in New York at least) had neither form of drills
24.
by jiaaro 4y ago
Lots of people have already written programs in Python. Now their programs will run a little faster without any work. It’s like the barista saying, “coffee’s on me today.”
25.
by jiaaro 4y ago
I live in Austin, and I frequently have to tell people I know, especially people from New York, that hardly anyone here talks the way they expect (I lived in New York for a long time before Austin). A related misconception: thinking it’s a
26.
by jiaaro 4y ago
I think that ship has sailed - ICE vehicles have obscene amounts of power these days even in “slow” vehicles
27.
by jiaaro 4y ago
Would be cool to show actual uses of struct in the CPython source in the examples (with the link to explain and a link to the struct in the context of its use)
28.
by jiaaro 4y ago
I’m working on a triangle-grid board game, probably for playdate (wip builds: https://jiaaro.itch.io/3nclosure ) I was surprised to find play testers had a hard time internalizing the grid - e.g. making mistakes that result
29.
by jiaaro 4y ago
You should put those instructions in the page :)
30.
by jiaaro 4y ago
I'd love to see range data on the USA Cars tab

More ›