Clever headline writer making me think he didn't like the Ubisoft games.
I doubt that. Sands of Time trilogy was very well received. Jordan Mechner was also involved in production in those, I'm just not sure in what capacity.
Readit Newskanobi commented on Jordan Mechner vs. the sands of time washingtonpost.com/entert... · Posted by u/anonymousab
kanobi commented on PostgreSQL and Its Annoying Crosstab blog.aurelianix.com/2024/... · Posted by u/leononame
Most of the time I'm using `filter ... where` for cases like these... for example
select
column_name,
MAX(value) FILTER (where meta_key='total_rows') as total_row,
MAX(value) FILTER (where meta_key='not_null_count') as not_null_count,
ROUND(SUM (amount_in_cents) FILTER (WHERE EXTRACT(MONTH FROM TIMESTAMP '2006-01-01 03:04:05) = 1) / 100.0, 2) as 'january_sub_total'
FROM table
GROUP BY column_nameYup, that's even better. I think it didn't work for me because I was using Redshift, which didn't support FILTER at that time.
kanobi commented on PostgreSQL and Its Annoying Crosstab blog.aurelianix.com/2024/... · Posted by u/leononame
Whenever I needed to do a pivot in postgres, I used this approach that is described in this stackoverflow anwser:
https://stackoverflow.com/questions/20618323/create-a-pivot-...
So for example when you have a table like described (column_name, meta_key, value), you would create a query like this:
SELECT
column_name,
MAX(CASE WHEN meta_key='total_rows' THEN value ELSE NULL END) AS total_rows,
MAX(CASE WHEN meta_key='not_null_count' THEN value ELSE NULL END) AS not_null_count,
-- for all other metrics....
FROM tall_table
GROUP BY 1
kanobi commented on Your AI Girlfriend Is a Data-Harvesting Horror Show gizmodo.com/your-ai-girlf... · Posted by u/nickthegreek
Is there anything intrinsically privacy hostile about this potential industry, beyond sending data to a server - which is something you might do if you engage with doctors or therapists virtually?
I hope that consumers choose to pay a premium for privacy preserving services. If users are indeed getting alot of value from the arrangement - I would hope they don't use free or cheap services that need data harvesting as part of the revenue.
My concern is that even premium products would want to pool user interaction logs in order to train better models - which isn't as directly hostile as packaging user labeled data and selling it, but it is a sloppy art to claim you are anonomyizing user data. As any sufficient anonymization necessarily destroys information that would be useful to training.
But the problem is how can consumers really know if the company is selling this data and to who, without some kind of legislation? Being a premium product is just an indicator, but it's not definitive.
I think even CCPA in California should be able to prevent abuses like that. At least you should know what data is being sold and you should be able to opt-out. If that's really the case, only time will tell.
kanobi commented on Your AI Girlfriend Is a Data-Harvesting Horror Show gizmodo.com/your-ai-girlf... · Posted by u/nickthegreek
Go to the direct link then: https://foundation.mozilla.org/en/privacynotincluded/eva-ai-...
I mean the point of the article still stands, it was just an observation of how funny it seems.
I have ublock installed, so this can be at least prevented with news websites. Which can't be said for unseen tracking in chat-bots. Collecting and storing this data without consent obviously sidesteps GDPR, so I'm not even sure about legality of these practices in EU.
kanobi commented on Your AI Girlfriend Is a Data-Harvesting Horror Show gizmodo.com/your-ai-girlf... · Posted by u/nickthegreek
It's always ironic to find these kinds of articles on sites that have hundreds of background trackers. Even though I "rejected all" unnecessary cookies I still see around 16 of them coming through. Like adsafeprotected, adlightning, google-analytics.
kanobi commented on Extremely high-energy particle detected falling to Earth theguardian.com/science/2... · Posted by u/hdivider
Perhaps thats what would happen if you put your hand in the electron beam at the LHC, but a million times more energetic.
There is a real life example, unfortunately. In 1978 Soviet scientist Anatoli Bugorski was hit by a 76 GeV particle. https://en.wikipedia.org/wiki/Anatoli_Bugorski
Looks like he survived the incident and even completed his PhD in following years. He did lose hearing on one ear and was partially paralyzed though.
Now the particle mentioned in the article was million time more energetic so...
kanobi commented on Indiana, Iowa, and Tennessee Pass Comprehensive Privacy Laws schneier.com/blog/archive... · Posted by u/mikece
Serious question, in an interconnected online marketplace how are you supposed to comply with these granular state and sometimes municipal laws.
Is there some kind of monitoring database or notification that you can subscribe to?
It seems very expensive for every single business to have a compliance lawyer specifically for this task of complying with each state's mandates to a tee.
I think in practice, what ends up happening, is that small businesses don't really bother to comply while they fly under the radar. Or they just end up buying an e-commerce plugin that handles the minimum.
We had one for GDPR and then they just added support for CCPA when that was a thing.