VWWHFSfQ

17 ms·

241.
by VWWHFSfQ 2y ago
I guess I'm wondering what is the point of tail-call optimizations, or even async/await when it's all super slow and bounded by the runtime itself? There are basically no improvements whatsoever to the core cpython runtime.
242.
by VWWHFSfQ 2y ago
Will Python ever get fast? Or even _reasonably_ fast? The answer is no, it will not. Instead they'll just keep adding more and more syntax. And more and more ways to do the same old things. And they'll say that if you want &q
243.
by VWWHFSfQ 2y ago
Why are you following 1,200 people? What is the point of your home feed? What are you trying to see?
244.
by VWWHFSfQ 2y ago
At some point they'll end up just doing the Bieber rack [1]. It's when a shard becomes so hot that it just has to be its own thing entirely. [1] - https://www.themarysue.com/twitter-justin-bieber-servers/ @b
245.
by VWWHFSfQ 2y ago
> It's _insanely_ frustrating. > at only 1,200 followed people. I follow like, 50 people on bluesky. Who is following 1,200 people? What kind of value do you even get out of your feed?
246.
by VWWHFSfQ 2y ago
So a theoretical GC language can hypothetically be faster than Rust or C++. Which language? Does one exist?
247.
by VWWHFSfQ 2y ago
it was clearly just a random number for illustrative purposes.
248.
by VWWHFSfQ 2y ago
I'm not going to use a database that doesn't even have a proper date/time type and treats everything as a string.
249.
by VWWHFSfQ 2y ago
> Be brave. Just try it. This is the exact opposite attitude I would want to have when it comes to choosing the best way to store and manage my data. My data is actually important. I understand that might not be true for a lot of other
250.
by VWWHFSfQ 2y ago
Mongo DB also disables safety features by default to improve their benchmarks. But Mongo DB gets lots of criticism for that and SQLite gets none.
251.
by VWWHFSfQ 2y ago
what databases are those
252.
by VWWHFSfQ 2y ago
SQLite is great for what it is and its stated purpose, but it's a fundamentally poor database if you actually care about your data. I'm not talking about durability. It's perfectly durable, as in it won't lose your dat
253.
by VWWHFSfQ 2y ago
> GC languages can be siginificantly faster exactly because it doesn't have to clean those "garbage" at every step. Which GC languages are significantly faster than Rust and C++?
254.
by VWWHFSfQ 2y ago
It's different because the free() is deterministic, the instruction is encoded into the binary. Completely different than garbage collection where there is a whole runtime that has to periodically go figure out what can be safely dele
255.
by VWWHFSfQ 2y ago
The overwhelming majority of Rust borrowing complexity can be trivially solved by just doing .clone() which is basically all those GC languages like Go and Python are doing themselves anyway. You can avoid the borrow checker altogether if
256.
by VWWHFSfQ 2y ago
I think you're confusing "garbage" with just normal heap allocation. Rust will free that memory automatically when the JSON strings go out of scope. There's no "stop the world" thing that periodically scans a
257.
by VWWHFSfQ 2y ago
Not sure I understand what you mean by this. Rust doesn't create "garbage" in the technical sense. It has RAII. It's a different thing.
258.
by VWWHFSfQ 2y ago
> 'en' plus a bunch of random language codes This is an easier fingerprint signal than just not sending anything.
259.
by VWWHFSfQ 2y ago
Is there way to change this key binding (tab for accept) right now? Because otherwise I have to stop using this program. It is absolutely obnoxious.
260.
by VWWHFSfQ 2y ago
I've used them off and on for basic stuff like "tell me what this query does". They're usually pretty good at that. Sometimes it will make suggestions that are meaningful improvements, most of the time not. Unless you
261.
by VWWHFSfQ 2y ago
> To make writing and maintaining sql easier. From my experience there are a lot of programmers that simply don't write SQL at all. They use an ORM or some query building library in their preferred programming language. So they&#x
262.
by VWWHFSfQ 2y ago
My understanding is that they sold a large chunk of the business to Microsoft in exchange for nearly unlimited Azure credits
263.
by VWWHFSfQ 2y ago
It's the same IOs. PG does it regardless. Both the data and index
264.
by VWWHFSfQ 2y ago
> Downside being that updates to amount are more costly PG always does a delete + create for updates. It will have no additional overhead at all
265.
by VWWHFSfQ 2y ago
This is a great book that explains PG in a step-by-step way. I learned a ton from it https://theartofpostgresql.com/
266.
by VWWHFSfQ 2y ago
It's not that hard to just name the things you care about instead of relying on auto-generated stuff from the database. PG lets you do this easily. > if you have that many violations that points to other problems No, it doesn'
267.
by VWWHFSfQ 2y ago
If you have multiple unique constraints in the same table then it will spit back the same error code. I want to know the name of the specific constraint that was violated. Always name your indexes. Always name your constraints.
268.
by VWWHFSfQ 2y ago
> don't name them manually let PG name them for you If you care about catching stuff like unique constraint violations in your code then you should know what the indexes are named. Always name your indexes and constraints. They&#x2
269.
by VWWHFSfQ 2y ago
You will find major performance improvements by using `include` with your indexes. For instance, on something trivial like counting votes on a blog post: create table post_vote ( post_id bigint not null references posts (id),
270.
by VWWHFSfQ 2y ago
Very common in NYC. People will use all of "New York, NY", "Queens, NY", or "Astoria, NY" all interchangeably and the post office will still just deliver it to the same place.

More ›