meritt

I'd really like to start seeing a series of blog posts from companies who are running extremely lean and efficient tech environments by utilizing cloud in an intelligent manner and avoiding the expensive and unnecessary bullshit that's so prevalent today. The ones that can brag "How we run a $4M/yr SaaS on $40k/yr of AWS spend!" are far more interesting than "How we stopped incinerating millions of VC money by simply turning off shit we didn't need"

Holy sense of entitlement. No, that's not going to happen. That's not how any of this works. You don't see companies paying outsourced workers $150k/yr due to the "amount of money they save by not hiring expensive talent in SF"

[1] https://dev.mysql.com/doc/refman/8.0/en/gone-away.html

    foreach(range(1,20) as $j)
        foreach(range(1,1000000) as $i)
            strval($i);

    php7.3 py.php == 1.258s
    python2 py.py == 3.714s
    python3 py.py == 4.530s

All of it? A very small chunk of these slides are even about bash scripts. Most of it is about standard unix commands and pipe and redirection operators.

VSCode very quickly freezes because it cannot handle a file that size. Sublime not only opens it but syntax highlights immediately.

8,243 games were released on Steam in 2019 and 3,434 so far in 2020.

Unless you approach indie development like a business and you have a concrete plan for gaining a following, your chances of making a living are near zero. That's not to say you shouldn't do it, but don't expect to make a living doing so.

As an example, David Brevik (of Diablo and Diablo2 fame) spent several years working on It Lurks Below -- a procedurally generated roguelite/dungeon-crawler. According to SteamSpy [1], he's sold 20k-50k copies at around $15-20 per copy, and as of today the game only has about 20 peak daily players.

So probably $500k-$1M in gross sales (and then Steam takes 30%) for someone of his caliber and reputation, after 3+ years in development and a year or so since initial sales. It's just an unbelievably difficult chance of making it financially viable.

[1] https://steamspy.com/app/697550

No, it isn't. Consumer data being sold in a completely unregulated manner is the culprit.

Paying for the product or service has nothing to do with whether or not your data is being sold.

For example, there's a popular email client that scrapes people's inboxes and sells their purchase history to anyone willing to pay. That purchase history is provided on an individual email level and is "anonymized". But if you know your target has this email client installed and you know a single purchase (e.g. a coworker saying "Oh, I bought this awesome coffee maker on Amazon last night!") you can now access their entire individual purchase history backward and forward.

Because Uber's market cap is indeed egregious, but not nearly as inflated as Tesla. So it's amusing when people like yourself rationally find issue with Uber, but cannot find any flaw in the valuation of Tesla.

Not defending Uber here in the slightest, but given your post history on Tesla, I find it amusing you think Uber's market cap is egregious

I've always found explicit temporary tables, where I can add indexes, are often a great solution for performance and readability.

Your statement is making the assumption you have completely dense data and you can simply offset a number of rows to get the desired denominator. Sparse data is a very common occurrence, and now your MoM/YoY/XoX queries are completely incorrect.

It's not a band-aid. When a file is uploaded (see RFC 1867) via HTTP POST, PHP internally allocates a hash table that tracks which files on the filesystem have been uploaded. When the process terminates, it uses that hashtable to remove any remaining uploaded files in the tmp space.

move_uploaded_file() confirms that the filename was indeed created as a result of an upload, and additionally removes that entry from the hash table.

Do they want the free advertising on networks but then disintermediate those same platforms in an effort to work directly with the customers who may have never found them in the first place? I'm all about supporting local businesses but me deleting GrubHub isn't going to stop other people from ordering on it from their restaurant.

No, because in Swagger the first step is carefully designing exactly what the inputs and outputs are of each and every API call. Most GraphQL servers you simply point it at a database and it automatically makes your entire schema, including tables and fields that shouldn't be exposed to end users, readily available.

> doesn't remotely mean the queries "run on the client side".

Sorry, that was poorly written. Obviously the queries are not running on the client side. My point was that the client can provide any query they want and the system will process it.

As a penetration tester though I like GraphQL, it's a very handy data exfiltration engine. By default, there's no authorization, no authentication, and it even comes with introspection. One query and I get your entire schema! This trendy movement will be far worse for data security than SQL injection, unsecured S3 buckets, or misconfigured NoSQL instances.

Nat is the CEO of GitHub, not Microsoft, and despite any promises made on a Reddit AMA a year ago, why would they devote resources to two competing editors?