2,405 karma · joined April 10, 2008
Thus you can end the year with 0 net profit, but a huge tax bill!
Here's an "attack table" for one specific weapon in Rolemaster: you roll a 1-100, add and subtract a whole lot of offensive and defensive bonuses and end up with a result like "15DK" -- 15 hit points of damage and a severity D critical hit on the K (Crushing) table. The broadsword can give both Crushing and Slashing criticals. That again has 20 random outcomes such as "Strike lower level; tear tendons. Foe is at -25%. +3 hits. Foe is stunned and unable to parry next round"
If your problem can be solved by just regexps, there's a "rename" tool installed by Perl I've used for decades. E.g.
rename -n 's/JPEG$/jpg/' *JPEG
Will apply the substitution for JPEG at end of the filename to just jpg. The -n will run without renaming so you can see what it intends to do.(Remember those crazy days of MS Windows claiming POSIX compatibility so it could win some government bid?)
The ad-supported users outnumbers premium users (236 million to 180 million) but bring in only 1/6th the revenue. So that's a factor depressing the payout per stream.
https://investors.spotify.com/financials/press-release-detai...
The 2021 Biology winner was:
> Susanne Schötz, Robert Eklund, and Joost van de Weijer, for analyzing variations in purring, chirping, chattering, trilling, tweedling, murmuring, meowing, moaning, squeaking, hissing, yowling, howling, growling, and other modes of cat–human communication.
You can then run SQL queries that in the end call your own data functions to generate data. I had a project where I had several diverse data files (each with its own set of functions to iterate over, but no useful querying) where wrapping each data file with a SQL Virtual table allowed med to use SQL to join them up and query them.
Here's a 2014 article where the author exposes redis as a virtual table within your sqlite code using this mechanism: https://charlesleifer.com/blog/extending-sqlite-with-python/
Postgres has some support for this (you run your SQL code but it really talks to some other service, or another postgres database) through foreign data wrappers. There's some Python library to also make adding that easy.
Interestingly a few projects do it in reverse: you are talking the postgres protocol (using library, psql client) to your database server, but it's not postgres but something else entirely (CockroachDB does this).
I like the idea of the entire world being just SQL, but you have to be careful with those wrappers and expose any indexing you might have, otherwise it's lots of expensive table scans.
It's interesting to compare the Amiga 500 with its 640x256 resolution and 4096 colors driven by a 68K processor with 68k transistors (coincidence?) and my current 4K screen driven by a 3080ti card and 28.3 billion transistors. Certainly the computing and graphics power has increased greatly, but not so the music output.
This is behaviour I've seen on 9.x on the Aurora variant; for that the solution was to use the FASTUPDATE=OFF index storage option. You can see the delayed tuples by using "pgstatginindex" function.
Using some of the extra options of EXPLAIN (ANALYZE, BUFFERS, COSTS) might give more hints.
If not HSTORE/GIN, then it could be that the analyzer, after some auto-analyze of the table things that what you are asking for will match a significant number of the rows in the table. So there's no point in random seeking through an index because it thinks it needs to read e.g. 50% of the table anyway, so it might just as well not use the index.
Back when the test was relevant (around 2000?) there was lots of multiplayer games (MUDs) and so you could enter what MUDs you were playing after you got your score -- it was interesting to see the averages for each aspect matching up with type of MUD (e.g. PVE versus PVP versus purely social/RP).
I also tried to match the results against a volunteered MBTI: http://mud-dev.zer7.com/2001/8/20412/#post20412
In 2018, the police indicted 1000 of them (tracking them down with Facebook's help). Legal results were a child-porn law judgement for 334 of them, and simpler penalties for 400.
The child-porn judgement was mostly suspended sentences, but it precludes working with children (as a teacher or even sports trainer if children under 15yo are involved) for between 10 and 20 years.
If there was a system that would have caught it sooner, prior to sharing, the spread would be minimized. The police took 3 years to form a plan to indict the 1000+ people.
Even open source products like ClamAV rely on a opaque database of virus strings.
You are more likely to be in a country that has banned anti-personnel land mines than one using Fahrenheit.
The Flavor Thesaurus does the same for ingredients -- you want to do something with figs, what dishes have figs in them, what complements them? The books cover the Western world, and Niki is the most witty writer among the dozens of culinary books I have.
Outside of that I like the "Perfect" columns by Felicity Cloak in the Guardian. Felicity takes a well-known dish and analyses all the differences in recipes, e.g. 6 cookbook authors have 6 different takes on coq au vin, what works best and how do they end up differently to each other? Like on Serious Eats, there's always well-spirited discussion.
Unless that was meant to be 2483.5-2495 which is something called "Globalstar".