News for hackers. Stuff that matters.

Pv9KKy3

Re:SQLite or PostgreSQL? It's Complicated on Tuesday June 28, 2022 @01:26PM (#31910499)
As a former php dev I absolutely believe this. I can't get over how slow and bloated stuff is these days. I can't even do front-end anymore.

We once did an app ages ago where the database was used to create a materialized view of code (PHP) + web pages for everyone and everything. We then rsynced that to 6 machines. This is ancient times, but this thing FLEW -> click click click click you could fly through the pages. It was a read heavy workload, but still, even the front-end (just hand coded) was somehow faster than all the latest and greatest going on these days.

Re:SQLite or PostgreSQL? It's Complicated on Tuesday June 28, 2022 @01:21PM (#31910436)
I use and prefer varchar(1000) personally, extremely easy to change in the future if needed.
It's the lure of money. You did something, it worked, you made a killing. Very tempting to do it again (give 3AC more money etc etc).
Re:PyPI: Python packets steal AWS keys from users on Monday June 27, 2022 @07:40AM (#31893153)
Not really, because the dependencies to your python code often have access to all global variables and/or run at same permission level as all your code etc.
Re:PyPI: Python packets steal AWS keys from users on Sunday June 26, 2022 @07:43PM (#31889162)
Yeah, I'd love to have a decorator at the top of a file - @env to provide access to env variables or @secrets for some kind of secrets access, nothing else gets this.

Python is tough though, a very dynamic language so probably kind of hard to lock it down.

Re:The SEC's response to the 'meme stock' rally on Sunday June 26, 2022 @07:39PM (#31889147)
Not a meme stock investor.

The penalties are pathetic in most cases. If I fail to deliver $100M in treasuries I'm paying maybe 5K a day.

Folks are playing games under the hood with this. Stock price crashing on some shares you sold? Buy them late and settle late. I'd be curious what happened with FTD on things like bear sterns imploding.

I like how folks keep on assuring us that selling something you don't own is a non-issue :) That's a tell right there on where the morals of wall street are - in the toilet.

We are in 2022. We still have T+2 settlement (in part so folks can shuffle stuff on the backend). T+1 should be an obvious no brainer requirement. And frankly I'd go for gross real time personally - and nuke these firms out of the water including their financing and margin revenues.

Re:The SEC's response to the 'meme stock' rally on Sunday June 26, 2022 @02:28PM (#31886518)
Except it's a massive issue. Millions of shares and billions of dollars in stuff fails to deliver. For something that shouldn't be an issue this should be impossible, but it happens routinely.

https://www.sec.gov/data/foiadocsfailsdatahtm

and download and total up the value of all the fails - it's eye opening.

Fail-to-Deliver Shares Value PIMCO DIOF Jan. 29 $422M iShares Core Bond ETF Jan. 20 379M iShares U.S. FA Bond ETF Jan. 19 361M GameStop Jan. 28 359M GameStop Jan. 27 292M

These are fails on just one day. It's pathetic this is allowed. You should not be able to sell something you can't deliver.

Re:Who is going to replace Google for us? on Sunday June 26, 2022 @02:10PM (#31886335)
The shopping links to SEO spammers and shopping comparison sites is in part because the govt has said google CAN NOT discriminate against these sites.
Re:The SEC's response to the 'meme stock' rally on Saturday June 25, 2022 @07:15PM (#31879527)
Any resolution to the failure to deliver issue?

Folks selling stuff they don't own, and then not even fixing the issue in time for settlement?

It's so weird that the SEC doesn't crack down harder on this behavior by the bigger players. The volume in dollars and shares is massive. The penalties way too light.

This would seem casually to create real fragilities in the system.

If I'm reading this correctly about $42B worth of fails in the second half of may alone.

"flagrant polluters."

This is such a sloppy take, backed by no data. If anyone would spend 10 minutes analyzing GHG and other emissions they would find that BURNING / USING these products is what produces the most emissions. So 40 million+ tons per year easily (in the US) of JUST carbon monoxide. FAR worse globally. Billions of tons of CO2. And heads up, LNG is much CLEANER than many other fuels currently in use, particularly coal.

"We are defending our communities from being obliterated,” says John Serna, a resident of Portland, Gregory, and Ingleside.

Hardly - look at ukraine for what the word "obliterated" means.

They cribbed a fair bit from coinbase. Some of the lines do result in a bit of an eye roll.

"We want to assure you these are one-time measures that we took to make sure Bitpanda keeps what it is and has been: a rock solid company and a great employer. "

I don't think the "great employer" definition in the normal world involves rescinding job offers etc, but it's fun to read the crypto speak.

Keep on being a "rock solid" company compared to those loser companies like AWS etc. I'd personally put crypto folks as far away from "rock solid" as possible!