jstrong

do you have to type the sql keywords (e.g. "SELECT") in all caps? I couldn't tell from the docs.

riding the bus is already such a nice experience, I bet this will make it even better!

> But now this is yet another PR cycle for the "Google kills everything" meme.

I mean, they earned their reputation, and then some.

if it's too hot in socal, that's what the beach is for

of all the places to be homeless in California, I'm not sure SF is winning the "mild weather" category.

businesses fail, government programs are forever.

> for years

prior to covid? last few years have not been representative about how well the supply chain works over the past 50 years.

> It seems like a step backward in terms of secure package management

what is an example of a language package manager that does this well, in your view? I think the idea is something similar to how apt-get/deb/rpm work at the os-level, but I'm interested in the details of what the improved version of this is in your mind.

I don't understand - if it didn't know what version until after download/install - which version would it download/install?

Cargo does semantic versioning-based dependency resolution, similar to Poetry, it's just a lot faster because it's written in a Rust. I don't think there's a big difference in the work that happens.

I have a server rack in my basement, with a few different machines. One is a storage server with a zfs array. Another is a 1u with lots of cores.

> What are you doing with your home server?

So much stuff. But the reason I have a servers at home is not because it's practical, it's because I love computers and making them go fast. The one's in my basement are often used for performance experiments.

I have experimented with a different query model from sql for time series data. A query took the form of a Rhai script. (Rhai is a scripting language that has great interop with rust, so it was similar to how lua would be used to script parts of a game.)

Each query script would act on a few objects in global scope: `db` (handle to database), `start`, and `end` (time range of grafana dashboard that query was for).

I found being able to write imperative (rather than declarative) code to build a query to be extremely powerful, especially for storing variables and looping over things.

e.g. query script - just to get a feel for it:

    let dalmp = db.ts("pjm-da-lmp/western-hub") // ie retrieve the timeseries named 'pjm..'
        .with_time_range(start, end);
    
    let rtlmp = db.ts("pjm-5min-lmp-rt-lmp/western-hub")
        .with_time_range(start, end)
        .resample("1h", "mean");
    
    let da_err = rtlmp.diff(dalmp);
    
    #{
        dalmp: dalmp,
        rtlmp: rtlmp,
        da_err: da_err,
    }

A query script would be expected to return a dictionary-like object. the keys would be used as labels and the values would each be a time series object.

This is not the perfect solution for every problem but though it might be interesting to see an example of a very different approach to querying compared to sql.

you wouldn't let a three-year-old walk across a busy street by himself. the reason why is, he's not capable of handling that yet. same for lots of other things, too.

the trend of having every aspect of life scrutinized for its worthiness by environmentalists is getting pretty tedious. octoberfest causes emissions, too. so do birthday parties, and weddings. are we sure those should make the cut?

"yeah, what did wasps ever do to you?" attack the shit out of me for no good reason!

sounds more like a repugnant fact to me

I love stories about smiting wasps

in my judgement, the quality of this information (methodology, population size, etc.) is not even close to good enough to rely on when making decisions about the well-being of my children. 250 kids, 5 years, study ends when they were 11-15 ... nope, nope, nope.

reminds me of the scene in the most recent yellowstone episode, the scientist stridently insisting destroying 7000 acres of sage brush couldn't possibly hurt sage grouse.

> No amount of money would make FTX a good asset

whatever your opinion of crypto, exchanges have generally been great businesses. lots of small fees add up to significant revenue. Binance generated $20 billion revenue in 2021.

the "crypto recovery fund" is not a govt bailout, it's binance investing private money into firms that are struggling to survive in the short-term: https://news.yahoo.com/cryptocurrencies-rally-binance-ceo-an...

In that sense, I guess a 100cm2 apartment is "pretty spacious" compared to a 25cm2 one. My point was that a family of four living in a 100m2 apartment is going to feel cramped.

> A family with two young kids living in 100m^2 is pretty spacious.

depends on your perspective, I guess! that sounds horribly cramped to me.

what do you get for $250 a month on ec2? is it 24c/48t dual xeon with 96gb ram, 2x 960gb nvme, with bare metal performance? https://us.ovhcloud.com/bare-metal/infra/infra-4-le/

I dunno. There's nice CLI interfaces and there's one's that make things annoyingly hard to do. I haven't used firebase ever but I have had that problem before.

> There have been a few times that I have ripped out my own code in favor of a popular library when I discovered it.

I'm much more likely to rip out the one function I need out of a framework or library and put it in my code, with a comment "// stolen from <source>". I've spent lots of time untangling the crux of someone's implementation away from the problematic abstractions they built up around it to make it universally adaptable.

why do people care about binary size? I have never understood this. Disk space isn't free but the size of the binaries on my machine doesn't seem like a big problem to me in that regard.

100% agree, do not understand the resistance to adding a flag or other way to temporarily disable that.

in that vein: status is pretty useful, seems like a good solution is using two separate non-200 status codes to differentiate between employee not found vs typical 404 no such endpoint/url/path.

I am ambivalent about 200 for employee not found, but that is clearly a different category of error compared to an api version not existing. for employee not found, the error is purely in data: there is no responsive data, but the request itself was made to an existing endpoint/url/route correctly. no api version existing is an improperly made request: whether or not there is data cannot be determined as the request itself was problematic, so we never even got there.

you have any recs for lower-end bare metal providers?