sceadu

156 karmajoined 19 jaar geleden

comments

by concentrating the load into a single location like that, you would likely overload the transmission system at that location and trigger a ton of system upgrades. so they would likely need to build their own generation and still probably upgrade lines if they just took over a county.

sceadu

22 dagen geledendiscuss

I really hate SQL as a language for doing data-related tasks, but the core tech for it is often much better in terms of reliability (and is close to having performance parity IME)... specifically for working with larger-than-memory datasets. I think the team at Polars is working on improving larger-than-memory operations though.

sceadu

22 dagen geledendiscuss

In my experience it works OK with spilling to disk so I haven't had too much of a concern with memory usage... previously I had issues with it OOM'ing and failing (or maybe this was a skill issue?), but haven't had that happen recently.

sceadu

vorige maanddiscuss

the I in ACID stands for isolation, not idempotency

sceadu

2 maanden geledendiscuss

I'm a TI guy, but really like RPN and there is (was?) an excellent RPN package for the TI-89 https://old.reddit.com/r/calculators/comments/fdytes/lars_fr...

sceadu

4 maanden geledendiscuss

also I would recommend looking at videos from matt harrison for polars or pandas, e.g.:

https://www.youtube.com/watch?v=Z9ekw2Ou3s0

sceadu

4 maanden geledendiscuss

dang I had no idea you wrote the asof join for pandas. thank you for that

sceadu

7 maanden geledendiscuss

I usually do REPL driven development in Python via emacs but you can tell it's not the natural way to do things, esp. if you start doing stuff with async. But I still feel that it makes me way more productive than I would otherwise be

sceadu

7 maanden geledendiscuss

Always Increasing

sceadu

10 maanden geledendiscuss

You might be able to do it with ibis. Don't know about the performance though

sceadu

10 maanden geledendiscuss

I also use: https://github.com/kostafey/ejc-sql for stuff not natively supported by sql-mode in emacs FWIW

sceadu

2 jaar geledendiscuss

Not sure if you're making a jungle Brothers reference to Amen break reference :)