mytherin

9 ms·

31.
by mytherin 4y ago
The tagline is likely inspired by the SQLite tagline [1]: "Small. Fast. Reliable. Choose any three". [1] https://www.sqlite.org/index.html
32.
by mytherin 4y ago
Looks really nice, but I'm really curious about what hurdles you encountered in making a native WASM version of Postgres. It seems that both the performance and binary size suffer immensely from the VM running underneath. For example,
33.
by mytherin 4y ago
Having to prove yourself innocent of criminal accusation after killing someone else seems like a pretty reasonable system. The idea that killing other human beings using a car is "expected" and "the norm" seems to me lik
34.
by mytherin 4y ago
That is actually extremely common in the Netherlands. [1] [1] https://www.youtube.com/watch?v=rQhzEnWCgHA
35.
by mytherin 4y ago
Odds are the drunk driver is going to be driving a pick-up truck themselves [1]. This is a perfect example of prisoner's dilemma - everyone would be safer if everyone else was driving smaller cars. But because people are optimizing for
36.
by mytherin 4y ago
Is that really so crazy? Driving a vehicle means constantly putting others' life at risk. Being a pedestrian does not. Holding people driving vehicles up to (significantly) higher standards seems like the sane thing to do, considering
37.
by mytherin 4y ago
Exactly. Pull requests are not a golden ticket here - they still take (a lot of) time to review and maintain. In my experience pull requests, particularly for (larger) features, can be net negative contributions. If the pull request is done
38.
by mytherin 4y ago
Secure notes are end to end encrypted [1] [1] https://support.apple.com/en-gb/guide/security/sec1782bcab1/...
39.
by mytherin 4y ago
That's just not true. In C++ you can use std::string everywhere and everything will mostly "just work". In Rust there are 5+ string types that are each subtly different, support subtly different operations and cannot be used
40.
by mytherin 4y ago
Walkability and crime go hand in hand. If crime is high on a street, people will not want to walk on that street. Because of this, shops will close, and any reasonable walkability score will drastically go down. You cannot have high walkabi
41.
by mytherin 4y ago
That works and is similar to what DuckDB does for small CSV files. We have the sampling step primarily for larger CSV files, when you might not want to do two passes over the file. This way we can keep the benefits of streamed file reading
42.
by mytherin 4y ago
The CSV auto-detector was implemented by Till Döhmen, who did his master thesis on the subject [1] and has actually written a paper about it [2]. Essentially we have a list of candidate types for each column (starting with all types). We th
43.
by mytherin 4y ago
Using DuckDB [1]: duckdb -c "SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi.csv GROUP BY ALL" DuckDB will automatically infer you are reading a CSV file from the extension, then automatically infer column nam
44.
by mytherin 4y ago
> Food, Fuel, Housing - You know, the basics. So, exactly what the HICP contains then [1]? [1] https://ec.europa.eu/eurostat/statistics-explained/index.php...
45.
by mytherin 4y ago
SQLite does not use mmap as a main I/O mechanism by default, it provides it as an optional feature [1]. mmap has one large advantage, which is that it allows you to share buffers with the operating system. This allows you to share buff
46.
by mytherin 4y ago
On the topic of Friendlier SQL, I have extended the similarity search to types in this PR [1], so the system will now offer you this correction as well :) [1] https://github.com/duckdb/duckdb/pull/3633
47.
by mytherin 4y ago
We thought about that, but particularly with `GROUP BY ALL` the problem is that we would get different results from SQLite. When a column is not mentioned in the `GROUP BY` clause in SQLite it automatically pushes a `FIRST` aggregate over t
48.
by mytherin 4y ago
The correct type is TIMESTAMPTZ. Is the type TimestampZ mentioned anywhere in our documentation? If so, that looks like a typo. I fully agree that error message needs to improve, however. I will have a look at that.
49.
by mytherin 4y ago
If the miners don’t like you what stops them from not including your transactions in the chain? It is my understanding that if a large enough pool of miners decides they don’t like you (>50%) they can completely prevent your ability to s
50.
by mytherin 4y ago
> But even if we insist on getting in harm's way, safe Rust promises to protect us anyway. For example if I make an array of a thousand misfortunate::OnewayGreater<u8>s they're only one byte each, yet they all insist they
51.
by mytherin 4y ago
The provided evidence for a GPL violation by cheat-engine seems extremely thin. Here is a list of the supposed violations, as per this comment [1]: ./Cheat Engine/tcclib/texi2pod.pl copyright Free Software Foundation via
52.
by mytherin 4y ago
Note the "(at your option) any later version" clause. The COPYING file contains this: * GNU LESSER GENERAL PUBLIC LICENSE * Version 2.1, February 1999 * [This is the first released version of the Lesser GPL
53.
by mytherin 4y ago
Those GPL files are part of a vendored dependency (TCC) [1] which has been licensed under LGPL. IANAL but GPL does state that you can relicense under any other later version of the license, and LGPL states that it counts as GPL 2.1. Either
54.
by mytherin 5y ago
How do you verify that people are actually posting historic data instead of random garbage, without either (1) you yourself already having access to that historic data, or (2) looking up each tweet through a Twitter API to verify that it is
55.
by mytherin 5y ago
Green energy production is highly location dependent. Global production is irrelevant - this is about the Netherlands. The Netherlands is a densely populated country that does not have a lot of space for renewable energy, neither does it ha
56.
by mytherin 5y ago
Better for end users depends entirely on their workloads, and is a moving target. Presumably as Apple’s new chip gets more adoption more games will be designed and optimized for it. There are already games (partly) optimized for it, so why
57.
by mytherin 5y ago
A private organization does not have efficiency as a primary goal, it has making profit as a primary goal. In a highly competitive market where consumers have many viable alternatives efficiency is required to be able to compete and offer t
58.
by mytherin 5y ago
You can use DuckDB as a processing engine on top of Pandas [1], while continuing to use Pandas as a data storage/data interchange format. [1] https://duckdb.org/2021/05/14/sql-on-pandas.html
59.
by mytherin 5y ago
> Monopoly is a vastly over simplified model that doesn't consider much of modern economics. Interestingly, it was actually invented to demonstrate to people how evil capitalism is[2]. Close. Monopoly was created by Lizzie Magie, a
60.
by mytherin 5y ago
That fails to account for drastically reduced space and operating costs of self-checkout machines. In my experience one cash register is generally replaced by 3-5 self checkout machines. Even if the cashier is twice as good at scanning and

More ›