JosephRedfern

Interestingly, Giles Thomas (the guy behind Python Anywhere) originally developed a Pythonic Spreadsheet application, called Resolver One, and then iterated to a a web-based version, called Project Dirigible.

Python Anywhere eventually span out from Project Dirigible when they realised that it was mostly being used for "generic" Python development rather than being used as a spreadsheet. There's an interesting write-up on this evolution here: https://blog.pythonanywhere.com/197/, and a demo of Dirigible here: https://www.youtube.com/watch?v=2ZoIp-5NaiQ.

Project dirigible ended up being open sourced here: https://github.com/pythonanywhere/dirigible-spreadsheet.

Link to David Beazley’s asyncio talk: https://youtube.com/watch?v=Y4Gt3Xjd7G8

Reading between the lines, given they're talking > 1 million rows per minute, I'd guess on the order of trillions of rows rather than billions (assuming they retain data for more than a couple of weeks)

Very pretty! As it happens, I too have started ingesting ADS-B Data into ClickHouse recently, but have nothing nearly as beautiful as this.

I'm hitting the airplanes.live API every 10 seconds using ClickHouse's URL table function and storing in a MergeTree: https://github.com/JosephRedfern/airhoover/blob/main/airhoov.... Would love to use refreshable materialised views for this, but at the moment there's no append functionality (refresh only), so have to use Python to to trigger the query.

There's an open instance here: https://airhoover.joesstuff.co.uk/play?user=default#U0VMRUNU.... Only 1.5 days or so of data, I truncated before setting up tiered storage (local disk + backblaze b2).

Cool being able to e.g. get a break-down of aircraft type by operator (https://airhoover.joesstuff.co.uk/play?user=default#U0VMRUNU...) or who (supposedly) flies their planes fastest (https://airhoover.joesstuff.co.uk/play?user=default#U0VMRUNU...)

Oddly enough, I was wondering if this project for some reason came from Unilever -- the logo is quite similar!

This summary article may be biased, but note that the cited paper has been peer reviewed and was published in Nature: https://www.nature.com/articles/s42003-023-05517-3.

There's also a gnu-radio flow graph which serves a similar purpose: https://github.com/bastibl/gr-keyfob.

Presentation here: https://www.fleark.de/keyfob.pdf

> Mr. Altman’s departure follows a deliberative review process by the board, which concluded that he was not consistently candid in his communications with the board, hindering its ability to exercise its responsibilities. The board no longer has confidence in his ability to continue leading OpenAI.

Ouch -- were there any signs this was coming?

It feels like an IAP would be more fitting than an entirely separate app, though -- it'd be a shame to require a new listing just to work around this filtering.

Maybe static analysis could determine whether the IAP unlocked a new feature/functionality or not, feeling into the labelling/filtering?

Most likely because she quote-tweeted a another tweet, originating from a private account.

The article explicitly mentions this: "PiVPN, luckily, runs on any other Pi-like device, though, as long as it's running a Debian or Pi-OS-like distro. Something like a Libre Computer Le Potato should work in a pinch, without breaking the bank—though if you want faster networking, you'll have to pony up a little more cash, at least until the Pi shortage abates."

I personally wouldn't want to blanket-drop sponsored content from the videos I watch, but this seems really nicely put together, and a version which let me exclude "sketchier" sponsors but keep everything else (or perhaps lets me skip ones I've seen before) would be great.

This comment:

> Just look at the poor leftist Youtubers

felt a little out of place, though?

You can put whatever you like into ChatGPT and get _something_ out, but that doesn't mean it's accurate or good advice.

Even if what you're saying is true, the skill would be in knowing whether the response is good and proper or not, which requires subject matter expertise. You'd be a fool to blindly trust output from ChatGPT right now for anything important.

SenseOn (https://senseon.io) | Remote (UK/EU based) | Senior Backend Python Engineer

At SenseOn, our mission is to design and build the security architecture of the future. We provide our customers with the most comprehensive defence against cybersecurity threats; for every user and asset in an organisation, wherever the location. Since our founding in 2017, we've been working hard to make a difference in our industry, receiving great recognition for our work, and we're now starting to scale. Having recently closed a very successful Series A funding round, we are looking for innovative and driven individuals who want to make an impact and enhance our momentum!

We are looking for a skilled and passionate backend Python developer to join our team, with a focus on developing and maintaining APIs that support the SenseOn UI. Our stack includes Flask, MySQL, SQLAlchemy and Docker on the backend, with Vue/Nuxt.js on the frontend.

For more information, or to apply, see the full job description here: https://wrkbl.ink/ePH0n6E -- please feel free to reach out directly (email in profile) with any questions!

I'm not sure OP was necessarily implying that the Pi specifically wasn't suitable for the job -- perhaps just that requiring /any/ other additional computer to achieve this is not without additional administrative overhead and power costs.

It does seems likely that a Pi is going to consume a fair bit less energy than the x86 SFF PC, so it's probably a net gain there, but that admin overhead thing isn't necessarily one to ignore -- it's not entirely set and forget.

I'm just clarifying my interpretation of OP's comment, not necessarily agreeing with it.

Anyway, involving humans (funded by NPM's commercial revenue) doesn't reduce the options to "letting the spam happen and dealing it after the fact" or "holding all submissions until a human reviews [them]".

If I was trying to solve this problem, I'd be open to a solution that tried to automatically classify submissions as either legitimate or spammy, with an associated confidence level. If the confidence level fell below a given threshold then I'd involve a human.

I think the suggestion was that the revenue generated by NPM's commercial dealings should cover any cost associated with a review process for OSS submissions (which in itself would make such spam repositories ineffective)

Not necessarily -- if the drive was found and decrypted after the exploit was leaked and made public (perhaps YEARS after it being a 0-day), it wouldn't necessarily be a skilled attack.

What is wrong with you?

This post links to another post by the same author which goes into this in a little more detail: https://pythonspeed.com/articles/python-multiprocessing/

Is this kinda what thumb mode on (some) ARM chips is?

Sounds painful.

> For just 5x more cash

I don’t feel the words “just” and “5x more cash” really fit in the same sentence!

Not questioning 3090s being more performant, but that’s a whole lot more money before even thinking about buying the supporting components.

> .. and become the preferred information delivery mechanism for business and entertainment because the internet was "just a fad."

Was it not as much a case of network limitations making such delivery impractical, rather than the internet being considered a fad? I was just about on 512Kb DSL at that point (if not, dial up). Downloading games and streaming movies would have been totally impractical.

> Computer literacy is on its way down

Perhaps it depends on your definition of "Copmuter literacy", but do you have any evidence to back up that claim? I find it surprising.

Seems pretty wild that JEB would _default_ to just turning the sandbox off when `SecurityManager` is missing.

I was wondering the same. So infuriatingly obnoxious!

> For example if they reported a bug and got a fix they diffed the binaries and looked at every difference to be sure that the change was a result of the fix, and nothing else (no, they didn’t want upgrades).

That sounds pretty diligent!

I suppose that in practice you'd need to consider burst bandwidth and not just 95/99 percentiles.

This isn't a CRT.