Communick News

Cross-posted from "What would be the best way to store the country of a user in SQL?" by @lena@gregtech.eu in !learn_programming@programming.dev

I use Gorm. This is the current code:

package main

import (
	"fmt"
	"log"

	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
)

type Env struct {
	DB     *gorm.DB
	Logger *log.Logger
}

type User struct {
	ID           uint
	Username     string
	Name         string
	Email        string
	PasswordHash string
	Country      string //should probably be a foreign key of another table
}

func initDB() {
	env := &Env{}
	db, err := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})
	if err != nil {
		fmt.Printf("Error opening database: %v", err)
		return
	}
	env.DB = db
	env.DB.AutoMigrate(&User{})

}

func main() {
	initDB()
}

As you can see in the comment in the code, I assume the best way would be to have a table of countries and then assign each user to one via a foreign key. However, it seems a bit cumbersome to manually create a list of all countries. Is there a better way to do this?

As noted by the news release from CalyxOS and Mastodon thread from GrapheneOS, Google did not release the Pixel device-specific source code alongside their Android 16 AOSP release like they usually do. I think many of us, including myself, are hoping this will be published in the near future, but considering they moved AOSP development behind closed doors earlier this year, it's more likely Google has stopped publishing this section or their code altogether, making development of custom ROMs for Pixel devices significantly more difficult. Sad news for the Android ecosystem, and for open source in general.

Here is my current setup:

• Nest Mesh Wifi router (not the pro model)
• 1x Nest Mesh Wifi Point (this device is in the hallway, midway between the router and mini)
• Brightspeed C4000LZ DSL Modem
• 1x Raspberry Pi 1 running Pihole
• Mac mini m2 running Pihole in Docker Container (this device is on the other side of the house from the router)

All this is in a 1500 ft2 home with solid wood construction, single floor at this time, but the option to finish out the attic, and it is on a crawl space. It soaks wifi signals up like nobody's business, which is why I initially went with the Nest mesh system.

I have had 2 instances where something happens with a power flash with my existing Nest mesh wifi system, and then I can't connect to anything, and the Home app won't connect either. It happened last night, and a few months back. The lack of a web interface to connect directly to the router and change DNS settings is ridiculous. Not being able to do WPA2/WPA3 at the same time stinks. After starting back up the pihole system on the Mini, (I think the flashes corrupted the Pi 1), a bunch of swearing and ranting, and FINALLY it came back up. Right now, so that everything just works, both Piholes are offline, and I am defaulting to Google DNS servers. Surely there is a better option.

I am wanting another mesh system, if possible, the option of wired backhaul, and a web interface for when I mess something up, or power flashes mess something up. I also am currently using the mini as a kind of DIY NAS (don't recommend), and am running various services on it. The ability to put a 2.5G wired connection would be a plus for it for large file transfers. Are there any suggestions, or am I overthinking something? I have been considering Ubiquiti hardware, as I am also wanting to divest myself from my Blink and Ring systems for cameras.

Okay guys. I was born in 1976. I admit that I'm 48 years old and damn proud of it.

Growing up in the 80's, I realize that the best games were from the 1980's and to this day it still is.

Retro gaming for me isn't just about game play and getting from one point to another. To me it's about the friendships that I made while playing the games.

From Pac-Man to Super Mario Bros. It's about the human friendships that we made along the way. Not like the disconnected way we play games now.

So here's the question that I would like to pose to those of similar age... Do you feel the same way I do? Do you think that the way we played games then is a stark contrast now that we've grown up?

Let me know in the comments.

Also, if you have any stories about video game friendships, I would like to here from you as well.

San Francisco author and activist Rebecca Solnit reported her account on Meta’s social media network was suspended in a post to Bluesky on Tuesday, June 10, adding that she was soon told the decision was permanent.

But less than 24 hours later, the account was reinstated after a Meta spokesperson said the suspension had been made in error.

On Tuesday, Solnit wrote, “Facebook decided to suspend my account because of a piece I wrote Monday about violence which in no way advocates for it (but does point out who is violent in the current ruckus).”

Text to avoid paywall

The Food and Drug Administration is planning to use artificial intelligence to “radically increase efficiency” in deciding whether to approve new drugs and devices, one of several top priorities laid out in an article published Tuesday in JAMA.

Another initiative involves a review of chemicals and other “concerning ingredients” that appear in U.S. food but not in the food of other developed nations. And officials want to speed up the final stages of making a drug or medical device approval decision to mere weeks, citing the success of Operation Warp Speed during the Covid pandemic when workers raced to curb a spiraling death count.

“The F.D.A. will be focused on delivering faster cures and meaningful treatments for patients, especially those with neglected and rare diseases, healthier food for children and common-sense approaches to rebuild the public trust,” Dr. Marty Makary, the agency commissioner, and Dr. Vinay Prasad, who leads the division that oversees vaccines and gene therapy, wrote in the JAMA article.

The agency plays a central role in pursuing the agenda of the U.S. health secretary, Robert F. Kennedy Jr., and it has already begun to press food makers to eliminate artificial food dyes. The new road map also underscores the Trump administration’s efforts to smooth the way for major industries with an array of efforts aimed at getting products to pharmacies and store shelves quickly.

Some aspects of the proposals outlined in JAMA were met with skepticism, particularly the idea that artificial intelligence is up to the task of shearing months or years from the painstaking work of examining applications that companies submit when seeking approval for a drug or high-risk medical device.

“I don’t want to be dismissive of speeding reviews at the F.D.A.,” said Stephen Holland, a lawyer who formerly advised the House Committee on Energy and Commerce on health care. “I think that there is great potential here, but I’m not seeing the beef yet.”

got it from here https://front-end.social/@elly/114668957184577014

Elon Musk has lost some of his luster with Republicans since his messy public falling-out with Donald Trump last week, a new survey finds.

Fewer Republicans view Trump’s onetime government efficiency bulldog “very favorably” compared with April, according to the poll from The Associated Press-NORC Center for Public Affairs Research.

Though most Republicans continue to hold a positive view of Musk, their diminished fervor suggests his vocal opposition to Trump’s signature spending and tax cut legislation — and Musk’s subsequent online political and personal taunts — may have cost him some enthusiasm within the party.

It looks like they're speedrunning to the finish line to get things over with as quickly as possible.

Since nothing is going to stand in their way, how can we make sure they are held accountable for generations to come?

Maybe we can have a day of remembrance for the Palestinians.

I'm afraid that once Israel has completed their genocide, the media cycle and influencers will ensure its never spoken about again.

How do we keep it fresh in people's minds until the perpetrators and/or their offspring face justice?

Mozilla Petition> Meta: Help Users Stop Accidentally Sharing Private AI Conversations

Meta recently launched its own AI app, like ChatGPT. The Meta AI app comes with a “Discover Feed” — a public stream of real user AI conversations posted by users. Meta says that users know that they're sharing their AI conversations publicly. But a number of posts suggest otherwise. You can find posts that appear to show users' personal data, medical issues, work problems, and calendar reminders in the Discover Feed.

Defense Secretary Pete Hegseth appeared to acknowledge that the Pentagon has developed plans to take over Greenland and Panama by force if necessary but refused to answer repeated questions at a hotly combative congressional hearing Thursday about his use of Signal chats to discuss military operations.

Democratic members of the House Armed Services Committee repeatedly got into heated exchanges with Hegseth, with some of the toughest lines of questioning coming from military veterans as many demanded yes or no answers and he tried to avoid direct responses about his actions as Pentagon chief.

In one back-and-forth, Hegseth did provide an eyebrow-raising answer. Rep. Adam Smith, D-Wash., asked whether the Pentagon has developed plans to take Greenland or Panama by force if necessary.

I would like to start using floorplans/maps with various device actions on them. This means I need locally stored images, that can be seen over the network.
I managed to upload images to HA, but as they need to be accessed with a token, I either need to refresh the token every day (no), or have an image with a long-lived token (also not a good idea).

How have other people done things?
Is it worth spinning up an http image host?
Or maybe throwing files into an nginx folder inside HA?

Thoughts on a postcard :)