Searching We Love Privacy Club

Twts matching #html
Sort by: Newest, Oldest, Most Relevant
movq
www.uninformativ.de
 (18w ago)
↳ In-reply-to » Eehhh, what the hell is going on here!?

@lyse@lyse.isobeef.org

Disclaimer: Can’t guarantee that I’m fully awake and I’m being trained at work not to use my brain anymore, so maybe this is complete bullshit. 😪🧟‍♀️

It says here that SQLite uses signed integers:

https://sqlite.org/datatype3.html

In pure bits, 1 << 63 would be 0x8000000000000000, but as a signed value, it gets interpreted as -9223372036854775808. Subtracting 1 yields -9223372036854775809 – but that doesn’t fit in 64 bits anymore. It’s possible that SQLite doesn’t want to wrap around but instead saturates? Haven’t checked. 🤔

With 62 bits, there is enough room.

With 1 << 64, I have no idea how SQLite wants to handle this, because this should immediately trigger a warning, because it doesn’t fit right away. Maybe it gets truncated to 0?

sqlite> select printf('0x%x', 2 * (1 << 64));
╭──────────────────────╮
│ printf('0x%x', 2 ... │
╞══════════════════════╡
│ 0x0                  │
╰──────────────────────╯
sqlite> select printf('0x%x', 0 - 1);
╭──────────────────────╮
│ printf('0x%x', 0 ... │
╞══════════════════════╡
│ 0xffffffffffffffff   │
╰──────────────────────╯
sqlite> select printf('0x%x', 0 - 2);
╭──────────────────────╮
│ printf('0x%x', 0 ... │
╞══════════════════════╡
│ 0xfffffffffffffffe   │
╰──────────────────────╯

⤋ Read More
TheAge_Technology
feeds.twtxt.net
 (18w ago)

This superintelligent AI is so powerful, even its creators are afraid of what it’s capable of
If Anthropic’s new AI tool falls into the hands of bad actors, they could hack pretty much every major software system in the world. And so could your kids. ⌘ Read more

⤋ Read More
lwn-net
feeds.twtxt.net
 (18w ago)

[$] A flood of useful security reports
The idea of using large language models (LLMs) to discover security problems is
not new. Google’s Project Zero
investigated
the feasibility of using LLMs for security research in 2024. At the time, they
found that models could identify real problems, but required a good deal of
structure and hand-holding to do so on small benchmark problems. In February
2026, Anthropic
published a report
claim … ⌘ Read more

⤋ Read More
TheAge_Technology
feeds.twtxt.net
 (19w ago)

14 years and $1.3 billion later, video game Star Citizen is nearing a major milestone
After 14 years, Star Citizen is nearing a major milestone. Creator Chris Roberts speaks with 9news.com.au about the ambition, community, and the billion dollars in funding behind the project — as well as the upcoming single-player campaign, Squadron 42.

The long-awaited game features a cast inc … ⌘ Read more

⤋ Read More
TheAge_Technology
feeds.twtxt.net
 (19w ago)

Five social media giants face crackdown over under-16 ban
Facebook, Instagram, TikTok, Snapchat and YouTube are under investigation and facing fines of up to $49.5 million for potential non-compliance with Australia’s world-first social media ban. ⌘ Read more

⤋ Read More
TheAge_Technology
feeds.twtxt.net
 (19w ago)

Five social media giants face crackdown over under-16 ban
Facebook, Instagram, TikTok, Snapchat and YouTube are under investigation and facing fines of up to $49.5 million. for potential non-compliance with Australia’s world-first social media ban. ⌘ Read more

⤋ Read More
TheAge_Technology
feeds.twtxt.net
 (20w ago)

Instagram falsely accused me of vile behaviour. Now I’m locked out of my life
Meta banned me over mistaken “child sexual exploitation, abuse and nudity” alerts. This is the same tech giant that’s just been fined more than $500 million for enabling child sexual exploitation. ⌘ Read more

⤋ Read More