In my biased sample of SFBA tech companies it’s pretty common for PMs to know at least enough SQL to be dangerous. In early stage startups there’s no analyst to lean on, so they need SQL. In late stage companies there are data lakes and analytics databases specifically designed to be easily queryable, so SQL offers the best flexibility.
But you’re right, many of them are wizards in <whatever query language our tool uses>. Like VizQL for Tableau.
EVE is famously anything-goes, with corporations (EVE equivalent of guilds) being very careful about who they accept specifically to prevent this type of attack. I would be very surprised if there were any moderator intervention about it, as joining up with corps in order to drain their bank accounts is expected behavior.
As another example of EVE conventions, in 2012 the biggest trading hub was attacked [0]. This is nominally a safe area, and indeed the NPC security responded to every attack. This was part of the cost-benefit analysis of the attackers, who were aiming to drive up the price of resources that they had hoarded. When other players complained to the developers, the developers found it hilarious, and helped advertise about the attack.
> EVE is famously anything-goes, with corporations (EVE equivalent of guilds) being very careful about who they accept specifically to prevent this type of attack.
Really? The general run of comments seems to indicate that the attack could only succeed because nobody in the targeted corporation noticed a popup warning them about the attack for 72 straight hours.
That strongly suggests that very few corporations should have any guards at all in place to prevent this type of attack, because there's no way for the attack to succeed unless everyone in the targeted corporation has stopped playing the game.
Eve has a really robust API that allows corporations to use third party apps to gather background checks before a new member is admitted.
You can see corp (clan) history as well as all transactions between players. If you’re claiming to be a new pilot, but a 9 year old or 1 day old account is funneling money to you that would raise a flag.
No it's that corporate membership history is immutable and public on characters. So it's a bad look to be an old character with a string of now bankrupted, stolen or overthrown corps on your history.
The website doesn't say what—for me—is the best thing about it. The course is peer-led which works like this: once your join, you're part of a team which has one objective: get the best score with your ML recommendation system.
There is simulated environment in which all teams of the cohort receive millions of requests per day (and hundreds of thousands of users and items) and you have to build out your infrastructure on an EC2 instance, build a basic model, and then iteratively improve on it. Imagine a simulated facebook/youtube/tiktok-style system where you aim for the best uptime and the best recommendations!
The slides [1] helped me grok what problems this tool solves pretty quickly.
Everything big data is moving to blob storage these days, but streaming can lead to small files problem or longer latencies. File fragments stored locally with proxied readers seems like a simple solution to that.
In a time-series (or event) table you have one date - when the data point is valid (event occurred).
In a temporal table you have two dates - interval when the data is valid.
In a bitemporal table you have two intervals. First describes when the data is valid in real world, the second when does the system know about the real-world state.
I.e. if company changed address on 2022-05-01 but the system will not get that information until three day later (2022-05-03) you have two validity intervals.
Then you may ask - what was the company address on 2022-05-02? And what did the system think the address was on 2022-05-02? You will get two different answers. This is important if you need e.g. to make a correction to previously issued invoice. You need to know what data was used for original invoice and what data should have been used.
Since duckdb is OLAP, it would directly compare with other columnar database technologies like Redshift, Presto/Athena, etc.
Most of these systems strongly encourage or outright enforce JSONL, so that’s the defacto standard, and most tooling or pipelines are going to generate that nowadays.
You can obviously still have a row of arrays, and different systems have slightly different approaches on how to deal with those. In Spark, this is referred to as “exploding”, in Presto you would cross join to unnest an array, in Redshift you can glob on the super type.
I’m not sure I have a particular favorite, only that the database support such an operation since it is a common occurrence.
I started following the crazy penny stock craze in 2020 and this story is a common sight.
Some reddit, Stocktwits, or other stock analysis site have people monitoring obscure tickers looking for anomalous volume spikes. You’re lucky if the company has more than a low quality logo as the entire website. Sometimes there’s minimal contact info, which people use to connect the company to potential real people on LinkedIn. Maybe you’ll even find the company registered in Delaware and keep digging through financial documents.
The companies are almost always random, profitless entities owned by one person acting as a a custodian for the billions of shares in the float. They promise to clean up the finances and submit paperwork so the ticker can move up through the various OTC exchange hoping to appear more credible.
The stock analysis websites are really sad because you’ll see people hoping to get rich believe anything they read. Some “shill” will say they heard from a little birdie that the company is going to merge with another stock soon, or financial documents are about to be released, or the CEO is planning to retire millions of shares (out of several billion, mind you). Of course, nothing happens and people are left bag holding for years until the next pump, or until the stock effectively goes to zero.
Bonus point if their “source” is some blogspam website that looks credible to your average penny stock inventor but will actually post whatever content you want if you send them $50.
There are people who make a nice living just pumping fake companies over and over in the penny stock market or to D-list VCs. These are the white collar equivalent of what cops call “greasy crimes,” crimes not quite serious enough to get real attention. (The dumb street crime epidemic in California is a result of further dialing back enforcement of “greasy crimes.”)
I’m sure those types are all over this NFT craze.
“I see that there are dumb people with money. I have a solution to that…”
I feel like a total sucker sometimes for attempting to do useful work when if I’d put the same effort into cheating people I’d be rich now several times over. This is truly a new golden age of the con artist. I mean we just had one for president.
I bet con artistry flourishes during any time of rapid change, confusion, and upheaval. Nobody knows what is happening so it’s easy to sell empty boxes with charisma.
Couple things that stood out to me was that the incident occurs in December and the raid ensues March 24th, so roughly 3 months. Building the case I presume.
Then after the raid, the accused doubles down and seeds fake news stories.
I'm a big fan of a show called "Forensic Files", which is like a real-life CSI where each episode is a documentary and only takes 20 minutes (I highly recommend).
In addition to the the usual passion killings and random murders, there is the occasional criminal that thinks they are way smarter than everyone else and doubles or triples down even as the noose is tightening, because they 100% believe they are geniuses and will get away with it.
In this episode a member of Mensa, who enjoyed staging murder mystery dinner parties for his Mensa friends, poisoned his neighbor over loud music and barking dogs, and thought he was such a criminal mastermind that he could talk his way out of it. These people have mental disorders.
George Trepal was certainly one of the better episodes! Amazing that one detective had to go undercover for almost two years before he slipped up. Then they found traces of the rare poison in his home. You’d think he would have trashed it and cleaned like crazy but I bet he thought he would get away with it and may want to do it again.
Thanks for the recommendation! Now that you mention it, I’ve seen similar behavior on Dateline. Wonder if there are other terms for essentially “digging the hole deeper.”
It sounds like he got caught because his VPN dropped during some sort of outage. It's funny because I feel like "don't do crime from your home network" should be an incredibly obvious concept.
Surfshark VPN advertises "strict no-logs policy", "independently audited" and "obfuscated, RAM-only servers". Of course, advertising is just advertising, reality may be different.
Yeah, so many say that, but I do find it very hard to believe.
If nothing else, wouldn't they want to keep some information about customers that in the past have abused the service? You need some way to ban assholes, right? How would you do that if you have no idea who anyone is?
While certainly focused on larger vehicles, by all appearances Ford is much more exciting and innovative than its traditional domestic counterparts. The new electric F150, electric mustang, the Bronco series, etc. have all seemed to drum up quite the fanfare. I can’t say the same for GM.
Agreed. Ford has been making some moves over the past year or two that actually made me consider buying one (the Bronco, specifically). I didn’t end up buying one, but I’d never even thought about buying any Ford product in my life. I consider that impressive.
I mean, non-sarcastically, lots of people are excited about it, including me.
They're a dime a dozen in junkyards. They all have high flowing aluminum heads, and coil per cylinder ignition. The pushrod design keeps the engine compact. Aluminum blocks are light, not much heavier than cast iron I4/V6 long blocks. All LSes have six bolt mains. The stock bottom end on every LS engine will survive four digit HP. Gen V LT series engines come with direct injection.
I am. Cars are a big hobby for me, a big part of my life. Chevy is the only company not going out of their way to make things too complex and locked down to repair yourself.
Chevy is the only manufacturer with viable aftermarket parts for many varieties of auto and boat racing. Like yeah, you see supras and Hondas and stuff at the strip on weekends. But serious racing is running Chevy Small Block derivatives.
Tech bros lament the death of open platforms for their hobbies, like the continuing lockdown of phones. The same thing is happening with cars.
Thankfully Chevy has proved you can have a modern competitive car that meets emissions standards using 60's engine layouts that are easy to modify and repair.
And pushrod engines aren't that bad. Overhead cam adds a huge amount of weight and bulk to the engine. This is the only reason Chevy is still able to fit 6 liter engines into their small sports cars. Everyone else has transitioned to small turbo engines because DOHC takes up so much space.
And the modern Chevy V8's shut off half their cylinders when you're not using them so they don't waste tons of fuel either
Yes, things are picking up at Ford. Electric pickup trucks are going to be a very big thing. Ford's real innovation is that the "commercial" model, without all the interior luxury, is priced at not much more than the gas version. That price will probably drop as battery prices go down.
