5,383 karma · joined November 29, 2012
I am still happy with our decision, because Wikia/Fandom has since then just gotten worse.
Like the egg cooker, this is an inherited appliance.
Often people do not discuss the time it takes for the database to parse the SQL query. If you run an ORM, with a one to many relationship between two tables, which are modelled in an application layer, you may wish to preload the children onto the main object. Suppose you are loading thousands, if not millions of objects, and you wish to preload all of their children, your ORM might simply do this by running two SELECTs, first the main object's table, then children's table with the parent IDs of the main objects included in the query.
When using the `IN` syntax, parsing this will be very slow compared to the `= ANY(array)` syntax. I remember running some tests to compare them, and once you get to 100'000 values, `IN` becomes significantly slower compared to `= ANY(array)`. I cannot recall whether it was 100'000 or 1'000'000 values, but at one of them, PostgreSQL just never finished the job with `IN`, where `= ANY (array)` took a couple of seconds.
[0] https://www.postgresql.org/docs/current/functions-comparison...
Not sure how it works for electric cars, come to think of it.
Seems strange they would not use a 24 hour clock to associate the songs, and the songs not specifically being about before or after noon could be associated with both.
Indeed, it would feel weird to play 2 Minutes to Midnight two minutes before noon.
But honestly, why not just use US Intl AltGr dead keys?
There are definitely examples of countries upgrading their existing roads to become E-routes, which sometimes include raising bridges.
[0] https://commission.europa.eu/document/fa09cbad-dd7d-4684-ae6...
Our lead developer was interested in building a RabbitMQ prototype. There were two libraries around to find, but none of them were finished, so we spent a lot of time finishing one of those implementations. We also looked into ProtoBuf, but that was a steeper hill to climb. When I left in early 2019, we were still using the old WinSock communication, though I understand from former co-workers, that they've switch to an UDP-based system instead now.
That's the most vivid one I can remember, because we pushed on, despite the available libraries being weak. I also remember trying MongoDB, which required a lot of polishing the available libraries as well. Other ideas I remember pursuing briefly, until I recognised finished some of the libraries would be too tall an order.
For the record, I don't have a problem with Pascal in general, nor its community. But considering how trivial it is to find a solid robust library for modern technologies (even if kind of fads) for other popular languages, compared to Pascal, it definitely feels weird to call its ecosystem "great".
Of course, the libraries I've mentioned may be great today. But RabbitMQ and MongoDB are also a bit older technologies today.
Hard disagree. I worked with Pascal for about 10 years, and the lack of modern libraries was a source of frequent frustration, meaning we often had to develop the solutions ourselves, or abandon an idea entirely.
[0] https://www.statista.com/statistics/443677/cashless-payment-...
Also, I am 36, and I live in a country (Denmark) that has entirely abandoned cheques, but I am still familiar with Danish cheques (even if I never managed one myself). Additionally, I still see them frequently when I am in France. (Though these days, the vast majority of cheques I see are US cheques, since my wife is American.)
Other countries don't have these restrictions (fixed or relative), where it's usually because those countries' constitutions allow the executive branch to simply borrow money whenever it sees fit.