Republicans test a new red line: Denaturalization
Republicans test a new red line: Denaturalization
White House press secretary Karoline Leavitt was asked about the possibility of revoking Zohran Mamdani’s citizenship status and didn’t say no.David Weigel (www.semafor.com)
Trump Dismisses Extension of July 9 Tariff Deadline, Hits Japan
Trump Says He Won't Delay July 9 Tariff Deadline, Criticizes Japan
President Donald Trump said he is not considering delaying his July 9 deadline for higher tariffs to resume and renewed his threat to cut off talks and impose duty rates on several nations, including Japan.Jennifer A Dlouhy (Bloomberg)
Lugansk People's Republic: Freed and Fueling a New Future
Lugansk People's Republic: Freed and Fueling a New Future
Now that the LPR is fully liberated, it's ready to shift back to peaceful economic growth.What's the region's potential?Sputnik International
First Victory In Dnepropetrovsk Region: Russian Forces Won Dachnoe
First Victory In Dnepropetrovsk Region: Russian Forces Won Dachnoe
The Russian military has secured significant territorial gains in June 2025 through systematic offensive operations, especially in the southern Donbas...Anonymous103 (South Front)
Maybe the downvoters are just waiting for a credible western media outlet to pick up the story.
Oh wait... 🤔
Date systems in Excel - Microsoft Support
Learn about the 1900 and 1904 date systems and how to change the default if necessary.support.microsoft.com
I thought about that, but decided to leave it as an exercise for the reader.
Don’t forget that Integer8 (the middle dragon) counts increments of 100 nanoseconds, because… reasons.
And don’t forget that 1900 still is a leap year in Excel.
I have been able to outsource low level parsing to third party libraries
Hahaha!!!
Today I watched a Java server crash because a library decided it needed more than 3GB of heap space to read a 10MB file. That was after manually removed background colors from around 100,000 cells, which apparently caused the parser to create even more objects in its internal representation of the sheet.
Yeah, I get it. I've had many libraries fail me in as many ways, which is why I consider it lucky to not have to implement my own. I work in .net these days, but there have been times where I had to just dig into the xml inside the xlsx and use xml tools. Those were mostly one-offs, thankfully.
Back when I did Java I had a frustrating experience with IBM's libxml causing our app to crash after several days due to a memory leak. I didn't have access to the production environment so it took me probably 3 weeks to find the cause and only after digging through a crash dump provided by the sysadmin. Not related, but you triggered my traumatic memory 😀
And don’t forget that 1900 still is a leap year in Excel.
Thank you! Saying this finally made me realize why I always need to add/subtract one day when I’m trying to convert dates to and from the Excel representation. 🤦
Converting numbers is easy
Explanation (which might be wrong, since I’m writing this after banging my head against a wall. Please do correct me if I’m wrong):
In regular numbering systems (i.e., decimal), we exhaust all 10 digits (0–9) before we reach two-digit numbers. The first number to require 3 digits is 10². The first to use 4 is 10³, and so on.
In music intervals, there is no “0”. The interval c’–c’, for instance, is called a prime (1). This has the funny consequence that moving by a fifth and then by a fourth doesn’t land you on the ninth, but the octave (8). Moving by an octave and then another octave gets you to the 15th, not the 16th.
In Excel, shit hits the fan when you need to convert column names (A, B, C…) to numbers (0, 1, 2…). Since we use 26 characters as our ‘digits’, we’re in the hexavigesimal system. Knowing what I told you in the first paragraph, you’d expect the first double-digit column (AA) to be 26. And you’re right.
However, when do we need 3 digits? Which column is column AAA? A sane person would say it’s 26², so 676. Ha! No. Column number 676 is actually ZA. What gives? Well, we only ditch the zero for single digit numbers. All subsequent columns actually use 27 different characters, the ‘empty character’ being one of them. That’s where we get the ‘single digit’ – there actually is a second digit, only it’s empty.
So the column AAA actually has index 702, or 26×27. Which index does the column AAAA have? 26×27². The system of adding powers of the base works, only we changed bases midway through.
You can see the lopsidedness in the index lookup table (I’m not displaying all characters for brevity). Sane number systems have square tables. Excel’s is 26×27 (shown are 4×5).
like this
Major reports about how climate change affects the US are removed from websites
WASHINGTON (AP) — Legally mandated U.S. national climate assessments seem to have disappeared from the federal websites built to display them, making it harder for state and local governments and the public to learn what to expect in their backyards from a warming world.
Scientists said the peer-reviewed authoritative reports save money and lives. Websites for the national assessments and the U.S. Global Change Research Program were down Monday and Tuesday with no links, notes or referrals elsewhere. The White House, which was responsible for the assessments, said the information will be housed within NASA to comply with the law, but gave no further details.
Searches for the assessments on NASA websites did not turn them up. NASA did not respond to requests for information. The National Oceanic and Atmospheric Administration, which coordinated the information in the assessments, did not respond to repeated inquiries.
Kurdish PKK leader says Israel secretly promised them a state for 30 years
Ocalan’s anti-Israel stance is well-known, as his group was based in the Bekaa Valley in the 1980s, cooperating with the leftist Palestinian liberation groups. In the document, Ocalan presents himself as the leader who could stop Israel from becoming a hegemonic power in the Middle East.
"Israel has been at this for 30 years. For three decades, Israel has been secretly promising us a state," Ocalan said during the meeting, according to the document.
He added that Israel was using the media to encourage Kurds to establish an independent state. "Whoever aligns the Kurds with themselves will gain dominance in the Middle East," he said. "They realized this before I did."
He also described an exchange of messages with then-Israeli Foreign Minister Yitzhak Shamir in 1982, when Ocalan was based in Damascus under the protection of Syrian President Hafez al-Assad.
A series of Israeli governments lent political and military support to Turkey in the 1990s, establishing a close alliance with secularist generals at that time.
But under Turkish President Recep Tayyip Erdogan, the relationship has deteriorated, and Ankara has occasionally accused Israel of indirectly supporting the PKK.
In November, Israeli Foreign Minister Gideon Saar openly called for closer relations between Israel and Kurdish communities, saying that his country should reach out to Kurds and other regional minorities that are "natural" allies. Ocalan said the Israeli intelligence agency Mossad also contacted him in Moscow, where he was seeking refuge from Turkish authorities in 1998, telling him they could hide him even in Russia.
PKK's Abdullah Ocalan: 'No Israeli dominance through Kurds'
Since the Israel-Iran conflict erupted last year, Turkey has found an unexpected ally: Abdullah Ocalan, the imprisoned leader of the Kurdistan Workers Party (PKK).Ragip Soylu (Middle East Eye)
If you’re not deliberately min-maxing the CAP Theorem or doing EDA, there’s no reason to use microservices and every reason not to.
It is not just an implementation detail or a matter of preference. There are fundamental UX implications.
That can be a net positive for users (and developers). But if you’re doing it “just cuz”, you’re gonna have a bad time.
Italy limits outdoor work as heatwave breaks records across Europe
Outdoor working has been banned during the hottest parts of the day in more than half of Italy’s regions as an extreme heatwave that has smashed June temperature records in Spain and Portugal continues to grip large swathes of Europe.
The savage temperatures are believed to have claimed at least three lives, including that of a small boy who is thought to have died from heatstroke while in a car in Catalonia’s Tarragona province on Tuesday afternoon.
In Palermo, Sicily, a 53-year-old woman died on Monday after fainting while walking along a street. She had reportedly suffered from a heart condition.
Italy limits outdoor work as heatwave breaks records across Europe
June temperature records have been broken in Portugal and Spain, as French schools close amid heatAngela Giuffrida (The Guardian)
Daddy
Daddy
Instance PeerTube généraliste francophone. General French-speaking PeerTube instance.Mes Numériques
Chairman of Azerbaijan-Ural organization detained in Yekaterinburg
Chairman of Azerbaijan-Ural organization detained in Yekaterinburg
Law enforcement agencies did not specify the reason for the detentionTASS
Russian forces strike Ukrainian army’s command system, UAV workshops over past day
Russian forces strike Ukrainian army’s command system, UAV workshops over past day
Russia’s Battlegroup North inflicted roughly 180 casualties on Ukrainian troops and destroyed three enemy armored combat vehicles in its areas of responsibility over the past day, the Defense Ministry reportedTASS
Bessent: There has been no inflation, no recession
Bessent: There has been no inflation, no recession
Instance PeerTube généraliste francophone. General French-speaking PeerTube instance.Mes Numériques
Putin Holds a Phone Call With Macron - Kremlin
Putin Holds Phone Call With Macron - Kremlin
Putin, in a conversation with Macron, discussed the situation surrounding Ukraine and reminded that the conflict is a direct consequence of the West's policies.Sputnik International
I can track my old lease car
So, I still receive telemetry information from my old lease car, a Kia e-Niro, to my app. A huge, HUGE privacy issue.
I made sure to remove my profile from the car before turning it in, and doing a factory reset of the car's software.
I can see everything, AC, whether there are doors open, odometer, and above all, location.
Also tried to see if I can turn off the AC, but any commands throw an error, so disabling my account on the car at least did something 😅
I had it in the Netherlands, it's in Poland, and it looks like it's on its way to Ukraine.
Kia, you need to check your security.
Edit:
Holy shit it gets real bad. I can lock and unlock the car.
like this
Nissan does this too. I leased a new Kicks when they came out and HATED it. Seats were terrible, car was underpowered, and some jackass decided to program the cvt to "shift" because Nissan got complaints that the car was stuck in gear. Just learn how a CVT works.
Anyways, 4 years later, I still get emails about monthly maintenance work, tow alarms, and tracking updates. I never asked for them to begin with and I guess I'm stuck with it as a VW guy now.
Statement by Bob Vylan:
"Not the First. Not the Last.
Today, a good many people would have you believe a punk band is the number one threat to world peace. Last week it was a Palestine pressure group, the week before that it was another band.
We are not for the death of Jews, Arabs or any other race or group of people. We are for the dismantling of a violent military machine. A machine whose own soldiers were told to use ‘unnecessary lethal force' against innocent civilians waiting for aid. A machine that has destroyed much of Gaza.
We, like those in the spotlight before us, are not the story. We are a distraction from the story. And whatever sanctions we receive will be a distraction.
The government doesn't want us to ask why they remain silent in the face of this atrocity? To ask why they aren't doing more to stop the killing? To feed the starving?
The more time they talk about Bob Vylan, the less time they spend. Answering for their criminal inaction.
We are being targeted for speaking up. We are not the first. We will not be the last. And if you care for the sanctity of human life and freedom of speech, we urge you to speak up, too.
Free Palestine."
Russian Official Says BRICS Internal Trade Has Surged to $1 trillion
Russian Official Says BRICS Internal Trade Has Surged to $1,000,000,000,000
The BRICS economic alliance has clocked $1 trillion worth of internal trade between its member countries, according to a Russian official.Conor Devitt (The Daily Hodl)
Elon Musk fonda il suo partito dopo il sondaggio su X: «Oggi nasce l'America Party per restituirvi la libertà »
L'intelligenza artificiale Grok è pure diventata un sondaggista per l'occasione. 😂
Secondo la sua intelligenza artificiale, Grok, la nuova formazione potrebbe assestarsi intorno al 5-10%, rompendo così il granitico bipolarismo americano.
Elon Musk fonda il suo partito dopo il sondaggio su X: «Oggi nasce l’America Party per restituirvi la libertà»
L’annuncio segue un sondaggio lanciato dal miliardario il 4 luglio, in cui il 65% degli americani si è detto favorevole alla nascita di una nuova formazione politicaUgo Milano (Open)
reshared this
Bob Vylan social credit score depleted
Bob Vylan is dropped from United Talent Agency after controversial Glastonbury set; United States withdraws band’s visas
After a provocative weekend at Glastonbury, the band faces a litany of backlash.Tony Le Calvez (The Needle Drop)
"The BBC respects freedom of expression but stands firmly against incitement to violence. The antisemitic sentiments expressed by Bob Vylan were utterly unacceptable and have no place on our airwaves…The team were dealing with a live situation but with hindsight we should have pulled the stream during the performance. We regret this did not happen."
British state media is absolute trash. Everything that comes out of it should be considered false before proven otherwise by a reputable source.
THE LUGANSK PEOPLE'S REPUBLIC HAS BEEN LIBERATED FROM THE NAZI TROOPS OF THE ARMED FORCES OF UKRAINE
like this
Stepan Bandera : the Life and Afterlife of a Ukrainian Nationalist ; Fascism, Genocide, and Cult - Anna’s Archive
Grzegorz Rossoliński-Liebe; Grzegorz Rossoliński-Liebe The Life and Afterlife of a Ukrainian Nationalist is the first comprehensive and scholarly biography ibidem-Sachbuch. ein Imprint von Jessica Haunschild u. Christian Schön GbRannas-archive.se
You have a really good spelling for an American.
Also let me use this opportunity to welcome you to the Fediverse - as your account is less than 24 hours old.
I had an account with the same name on the Lemm.ee server that was about 5-6 months old but the hosting just shut down out of nowhere.
Yeah, I’m a highly educated anti fascist. My grandmother sent me to religious schools because she is a racist and…. well it’s kind of a long story, but also to brainwash me into being a mindless drone to serve imperialist capitalism and believe in fairy tales but it kind of backfired on her.
Cloudflare offers to make AI pay to crawl websites
Cloudflare offers to make AI pay to crawl websites
Cloudflare will block AI bots from crawling websites by default for new customers, and broker pay-per-crawl deals between its customers and bot operators.Lynn Greiner (Computerworld)
This could further accelerate the arms race between malicious srappers and websites.
My fear is this would create collateral damage, block legitimate scrappers and visitors, hassle people with an increasing number of captcha.
Richard Sakwa: Democratism & Liberal Authoritarianism
- YouTube
Profitez des vidéos et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.www.youtube.com
Official Brave F-Droid repository now available
Official Brave F-Droid repository now available
Our new officially-supported repository allows users of the F-Droid client to install the browser and receive automatic updates without requiring Google Play.Brave Software
like this
This announcement is for Brave hosting their own repository to host the Brave browser on that's compatible with F-Droid, rather than the Brave browser being added to F-Droid's official repository.
Otherwise, perhaps you meant that you did add their repo and it's still not showing up.
Fchan, the federated imageboard, is apparently still alive
one of the Fchannel0 forks is still getting updated, and has an instance running.
::: spoiler link to instance, but visit only if you are completely degenerate
usagi.reisen/
:::
But it seems to be an isolated instance, as the federation appears to have been broken:
github.com/anomalous69/FChanne…
usagi.reisen/followers
more info:
fediverse.wiki/wiki/FChan
instance crashed after trying following board on another instance
1.have 2 fresh installed instances (from current last commit f34db39) http://iwojimafy6sxclfall2ixzyuq2xcdbqj3tlxgi46ik3ssigxz7fa.b32.i2p http://fchan.iwojimagzktuisvveh6zjuv453wm6rnch6oefof66mt7nu...iwojim0 (GitHub)
Lemmy Development Update June 2025
This was a busy month, with ~80 pull requests merged, as we're trying to get all the breaking changes we can added before the 1.0 release.
The release is still several months away, as even after finishing up the rest of the 1.0 milestone issues, we still have to add this new functionality to Lemmy-UI and Jerboa, and do extensive testing.
Here are some of the major changes made over the past month:
- Added multi-communities (One of the most requested features).
- Added a new rate limiting library.
- Refactored the API structs and library for better usage in Rust projects.
- Improved the migration diff checker.
- Using an external library for checking invisible characters.
- Votes are now removed when banning + removing data.
- Added a GDPR style data export.
- Storing upvote / downvote totals you gave to each user, and a setting to display that history next to their name.
- Added ability to make a note for a user.
- Added an RSS feed for modlogs.
- Added an API action to get liked / disliked content.
::: spoiler Full list of changes by user
Lemmy:
- Improve migration diff check and fix old migrations (#5204) dullbananas
- Implement multi-community (fixes #818, fixes #5340) (#5601) Nutomic
- Add endpoint to get Liked / Disliked comments and posts. (#5616) dessalines
- Add permitted display characters check for post titles (#5692) SleeplessOne1917
- Adding Modlog RSS feed. (#5708) dessalines
- Decrement fail_count instead of reset to 0 (ref #5716) (#5717) Nutomic
- Leave mod teams on account deletion. (#5721) dessalines
- Throw error if the removed code_migrations.rs needed to run but didn't (#5723) dullbananas
- Fix assumption that is_err always means the local site doesn't exist, which may cause the local site's keypair to be regenerated (#5724) dullbananas
- Simplifying transaction call (#5703) (#5726) momentary-lapse
- Switch to library for rate limit (fixes #5550, fixes #5548) (#5731) Nutomic
- Dont run scheduled tasks at startup (ref #5716) (#5732) Nutomic
- Adding proper NSFW filtering to search, based on user settings. (#5733) dessalines
- Move lemmy_api_common structs to view crates, make a lemmy_api_utils crate (#5735) SleeplessOne1917
- [0.19] Decrement fail_count instead of reset to 0 (#5737) Nutomic
- [0.19] Update user count from local_user table instead of person table, and only count users with accepted application (#5738) Nutomic
- Mark some *Action struct fields as serde(skip) (ref #5532) (#5739) Nutomic
- [0.19] Only use HTTP/1 (#5744) flamingos-cant
- [0.19] Dont run scheduled tasks at startup (#5732) (#5745) Nutomic
- Pin cargo-workspaces version (#5746) Nutomic
- Test case for activity send errors (#5747) Nutomic
- Revert "[0.19] Downscale proxied thumbnails (#5686)" (#5751) Nutomic
- Resolve objects as part of search api call (fixes #5740) (#5752) Nutomic
- Specify rust 1.81 (#5754) Nutomic
- Update extism (#5755) Nutomic
- Fix lemmy_federate test (#5756) Nutomic
- Fix lemmy_federate test (again) (#5757) Nutomic
- Use invisible_chars library (#5759) dessalines
- Rename timestamp fields to _at
(#5761) dessalines
- Upgrading deps. (#5764) dessalines
- Adding ability to make a note for a given person. (#5765) dessalines
- 0.19 specify rust 1.81 (#5766) Nutomic
- Remove feature full
for api_utils (#5767) Nutomic
- Rename upgrade check migration to run first (#5768) Nutomic
- Remove private instance check for get image (fixes #5763) (#5769) Nutomic
- [0.19] Remove private instance check for get image (#5770) Nutomic
- Make search query mandatory (#5772) Nutomic
- Parallel sql format (#5773) Nutomic
- Keep rustup home dir between ci steps (#5775) Nutomic
- Enable urlencoding for pictrs proxy parameter (fixes #5749) (#5776) Nutomic
- Upgrading ts-rs, and adding feature flag (#5777) dessalines
- Implement multi-community search (fixes #5778) (#5779) Nutomic
- Use binstall for diesel-cli (#5780) Nutomic
- Move db_perf check to unit test (#5781) Nutomic
- Fixing a few optionals. (#5782) dessalines
- Small lemmy_api_common
/db_views
fixes/tweaks (#5783) SleeplessOne1917
- Keep totals of upvotes and downvotes given to each user. (#5786) dessalines
- Test migrations improvement (#5788) momentary-lapse
- Replace most uses of context.reset_request_count() with clone() (#5790) Nutomic
- chore: replace nightly API Duration::from_days with Duration::from_secs (#5791) Integral-Tech
- Add incoming activity hook for plugins (#5792) Nutomic
- Remove ts-bindings null check from CI. (#5795) dessalines
- More re-exports (#5796) SleeplessOne1917
- Delete scripts/ts_bindings_check.sh (#5797) Nutomic
- Fix migration local_image_person (#5799) Nutomic
- Optimize migrations (#5800) Nutomic
- Adding GDPR-style data export (#5801) dessalines
- Move config updated check to unit test, use diffy (#5803) Nutomic
- Removing an existing deferrable constraint, and fail test if any constraint is deferrable. (#5806) dessalines
- [0.19] Reduce false positives in URL blocklist to reduce scunthorpe problem … (#5807) Nothing4You
- Remove creator_*_actions
fields from api (ref #5532) (#5808) Nutomic
- Set Accept: Vary
header for federation endpoints (fixes #5632) (#5809) Nutomic
- Remove votes when ban + remove data for a site or community. (#5810) dessalines
- Fixes for "Move config updated check to unit test, use diffy" PR (#5812) dullbananas
- Remove outdated comment about deferrable constraints in triggers.sql (#5813) dullbananas
- Fix db_perf.sh (#5815) dullbananas
- Optimizing person_content_combined migration. (#5819) dessalines
- Fixing docker_update.sh script to not add context. (#5820) dessalines
- Optimizing a few more combined migrations (#5821) dessalines
- Better way to check if we should accept activity in remote community (#5823) Nutomic
- Rename rate limit columns (fixes #5805) (#5824) Nutomic
- Send Undo/Dislike activity (fixes #4465) (#5825) Nutomic
- Add post_actions.disable_notifications (fixes #3042) (#5826) Nutomic
- Revert "Use same federation keypair for all new users and communities (#5709) (#5830) Nutomic
- Drop table person_ban (fixes #5828) (#5831) Nutomic
- Use vec_into (#5833) dessalines
Lemmy-ui:
- Show upvoted posts, comments in user's profile (#3057) Tyoda
- Add a denial reason using the error.message field. [0.19] (#3175) dessalines
- Add a denial reason using the error.message field. [main] (#3176) dessalines
- Fix spoiler escaped characters (#3181) bryewalks
- Hide Next button for Overview, Saved, Upvoted (#3182) Tyoda
- Click anywhere on byline to collapse a comment (#3198) philip-peterson
:::
Or see the full list of changes at the links below:
An open source project the size of Lemmy needs constant work to manage the project, implement new features and fix bugs. Dessalines and Nutomic work full-time on these tasks and more. As there is no advertising or tracking, all of our work is funded through donations. Even so there is barely enough time in the day, and no time for a second job. The only available option are user donations. To keep it viable donations need to reach a minimum of 5000€ per month, resulting in a modest salary of 2500€ per developer. If that goal is reached we can stop worrying about money, and fully focus on improving the software for the benefit of all users and instances. We especially rely on recurring donations to secure the long-term development and make Lemmy the best it can be.
Pulse · LemmyNet/lemmy
🐀 A link aggregator and forum for the fediverse. Contribute to LemmyNet/lemmy development by creating an account on GitHub.GitHub
like this
por qué elegí Tuta como mi servicio de correo electrónico
-precio justo
- empresa fiable, no venden tus datos
- la mejor opción si necesitas varios dominios o alias con varias bandejas de entrada
- servicio de calendario
- aplicación móvil multiplataforma, escritorio para Linux mantenido
-Me encanta el modo offline
-Privacidad
-utiliza y apoya el software libre
¿Más información? tuta.com/es
Tuta: Activa gratis la privacidad de tus correos electrónicos, calendarios y contactos | Tuta
Tuta garantiza la privacidad de tus datos de forma gratuita y sin publicidad. El cifrado quantum resistente hace de Tuta la mejor solución tecnológica segura para proteger tu privacidad.Tuta
The American 'Nazi party' Grew to Disturbing Levels in the 1930s | War History Online
Yes, there was a time in the 1930s when the Nazis were a political force not just in Germany but all over the world, including in the United States.Joseph O'Brien (War History Online)
tartarin
in reply to ☆ Yσɠƚԋσʂ ☆ • • •like this
geneva_convenience likes this.
Grapho
in reply to tartarin • • •like this
geneva_convenience likes this.