tal

joined 1 year ago
[–] tal 2 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

No, because the DBMS is going to be designed to permit power loss in the middle of a write without being corrupted. It'll do something vaguely like this, if you are, for example, overwriting an existing record with a new one:

  1. Write that you are going to make a change in a way that does not affect existing data.

  2. Perform a barrier operation (which could amount to just syncing to disk, or could just tell the OS's disk cache system to place some restrictions on how it later syncs to disk, but in any event will ensure that all writes prior to to the barrier operation are on disk prior to those write operations subsequent to it).

  3. Replace the existing record. This may be destructive of existing data.

  4. Potentially remove the data written in Step 1, depending upon database format.

If the DBMS loses power and comes back up, if the data from Step #1 is present and complete, it'll consider the operation committed, and simply continue the steps from there. If Step 1 is only partially on disk, it'll consider it not committed and delete it, treat the commit as not having yet gone through. From the DBMS's standpoint, either the change happens as a whole or does not happen at all.

That works fine for power loss or if a filesystem is snapshotted at an instant in time. Seeing a partial commit, as long as the DBMS's view of the system was at an instant in time, is fine; if you start it up against that state, it will either treat the change as complete and committed or throw out an incomplete commit.

However, if you are a backup program and happily reading the contents of a file, you may be reading a database file with no synchronization, and may wind up with bits of one or multiple commits as the backup program reads the the file and the DBMS writes to it -- a corrupt database after the backup is restored.

[–] tal 1 points 2 weeks ago* (last edited 2 weeks ago)

Some databases support snapshotting (which won't take the database down), and I believe that backup systems can be aware of the DBMS. I'm not a good person to ask as to best practices, because I don't admin a DBMS, but it's an issue that I do mention when people are talking about backups and DBMSes -- if you have one, be aware that a backup system is going to have to take into account the DBMS one way or another if you want to potentially avoid backing up a database in inconsistent state.

[–] tal 38 points 2 weeks ago* (last edited 2 weeks ago) (7 children)

https://en.wikipedia.org/wiki/Invisible_Woman

As the Invisible Woman, Susan can render herself wholly or partially invisible at will by bending light around her.[50] She can also render other people or objects fully or partially invisible too, affecting up to 40,000 cubic feet (1,100 m³) of volume.

EDIT:

Invisible Girl

Initially, her powers are limited to making herself invisible. However, before long Sue discovers she can make other things invisible as well as create force fields of invisible energy.

[–] tal 12 points 2 weeks ago (3 children)

No, but I have purchased Early Access games on Steam.

[–] tal 14 points 2 weeks ago

Big-box stores like Walmart (WMT.N) and Target (TGT.N),

Neither of these are big box stores.

https://en.wikipedia.org/wiki/Big-box_store

A big-box store, a hyperstore, a supercenter, a superstore, or a megastore is a physically large retail establishment, usually part of a chain of stores. The term sometimes also refers, by extension, to the company that operates the store. The term "big-box" references the typical appearance of buildings occupied by such stores.[1]

Commercially, big-box stores can be broken down into two categories: general merchandise (examples include Walmart and Target)...

[–] tal 44 points 2 weeks ago

Frankly, I'm not sure that it's a good idea to have life-critical systems on the Internet in the first place, issues with backdoors aside.

[–] tal 3 points 2 weeks ago* (last edited 2 weeks ago)

Canda's interest is, I expect, to do whatever provides the most political leverage on Trump relative to the cost to Canada. If high egg prices are a cost-effective way to do that, then sure. My guess is that there are a lot of factors that go into that, though.

I would guess that if Canada is doing targeted tariffs -- which they stated that they were -- that the best things to hit are in swing states (which Presidents have to worry about the most), in politically-influential industries, on products that are very visible to consumers, and in areas where Canada can deal with higher domestic prices relatively-well. Given that a major Trump concern in his first term was the auto industry, was what got the most significant change in the USMCA changes, maybe that. They did list vehicles as one of their targets.

This is assuming, though, that Trump isn't just aiming to get in the news for having tariffs for a short period of time, declare that his policy was a success and that fentanyl has been dealt with, and then pull the tariffs. If that's the case, then I wouldn't expect this to go on for long.

[–] tal 5 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

You're right that it's principally bird flu, but it'll still count towards inflation. CPI -- what people are typically referring to when they say "inflation" -- has a basket of goods which I strongly suspect includes eggs. If the price goes up, that's inflation.

goes to check

Yeah.

https://www.bls.gov/news.release/cpi.t01.htm

Meats, poultry, fish, and eggs

Though that whole category, which is not egg-exclusive, only makes up 1.737% of the weighting for the basket. So it's not as significant as, say, the cost of housing in calculating inflation.

[–] tal 9 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

https://unitedegg.com/wp-content/uploads/2019/05/Facts-and-Stats-Summary.pdf

According to this, as of 2019 -- which is a couple years back, though probably good if you want a pre-avian-flu number -- Americans had a per-capita rate of 279 eggs consumed a year, up 16 percent over the twenty years prior.

EDIT: according to this, numbers are about the same in 2023, dipped a little bit over the past couple years, but looks like there's a pretty low price elasticity of demand.

https://www.statista.com/statistics/183678/per-capita-consumption-of-eggs-in-the-us-since-2000/

In 2023, consumption of eggs in the United States was estimated at 281.3 per person. This figure was projected to reach 284.4 eggs per capita by 2024.

EDIT2: On a non-statistical note, eggs are goddamn delicious.

[–] tal 3 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

people cannot just use any phone they want, it needs to be a specific model supporting their network carrier, especially the network bands.

No, you can get phones that will work with any carrier's frequencies. There are some differences in phones and carrier frequency support, but there's loads of overlap -- a phone will be able to talk to another carrier's network. They have to for roaming to work.

What you may be thinking of is phones that are "locked" to a phone provider's network, which is very common when getting a phone. Basically, you get a phone plan and receive a phone from the carrier at a price that loses the carrier money. The carrier then goes and makes up the difference with higher monthly rates on your plan than would have normally been the case -- basically, attaches a small loan to the plan. It lets phone companies have a low up-front price. It's questionable as to whether this is a good financial idea for consumers, but it's not a technical limitation. As I recall, there's some regulation that requires carriers to unlock carrier-locked phones upon request after a period of time.

kagis

Yeah.

https://www.fcc.gov/general/cell-phone-unlocking

Postpaid Unlocking Policy. Carriers, upon request, will unlock mobile wireless devices or provide the necessary information to unlock their devices, for customers and former customers in good standing and individual owners of eligible devices after the fulfillment of the applicable postpaid service contract, device financing plan or payment of an applicable early termination fee.

Doesn't affect me, because I've only ever purchased unlocked cell phones.

[–] tal 7 points 2 weeks ago* (last edited 2 weeks ago) (4 children)

Trump may have actually lowered the price of eggs -- albeit not of products in general.

So, he just imposed tariffs on Canada and Mexico. Canada and Mexico stated that they would impose agricultural tariffs in response -- not a surprise, as the US is a major agricultural exporter. The list of countertariffed items is not up, but:

https://www.canada.ca/en/department-finance/news/2025/02/canada-announces-155b-tariff-package-in-response-to-unjustified-us-tariffs.html

A full list of these goods will be made available for a 21-day public comment period prior to implementation, and will include products such as passenger vehicles and trucks, including electric vehicles, steel and aluminum products, certain fruits and vegetables, aerospace products, beef, pork, dairy, trucks and buses, recreational vehicles, and recreational boats.

They don't explicitly list eggs, but they do list things adjacent to that, and I can believe that eggs might be on the tariff list.

The US runs a trade surplus in eggs.

https://oec.world/en/profile/bilateral-product/eggs/reporter/usa

2022 exports: $549 million, top partner Canada at $77.4 million

2022 imports, $118 million, top partner Canada at $8.19 million.

Trump's 25% tariffs will tend to reduce the amount of eggs being exported from Canada to the US, which will drive up egg prices in the US.

However, if the Canadian countertariffs -- also 25% -- have eggs on the list, which we don't yet know, they will tend to reduce the amount of eggs being exported from the US to Canada, which is about ten times the amount coming the opposite direction. That will tend to drive down egg prices in the US...and one would expect that effect to dominate the effect from reduced egg exports from Canada to the US.

[–] tal 18 points 2 weeks ago* (last edited 2 weeks ago) (1 children)

reads a few web pages

I don't know about the EU, but it looks like in the US, if Amazon is selling a product directly -- as it once did for all products -- it bears liability. But if it is just acting as an intermediary between a non-Amazon seller and a customer -- kind of like how eBay works -- it doesn't. I assume that in that case, liability is on that seller.

Might be the same sort of situation in the EU.

I wonder if this EU directive just affects Amazon or also places like eBay. Amazon could presumably basically just sell stuff from Amazon in a worst-case scenario, but for places like eBay, I'd think that that'd have a huge impact on their business model.

EDIT: Also, if the product description is an input into liability, which I'd guess might be the case...hmm. So, right now, a non-Amazon seller selling through Amazon can write their product description. But suppose it, I don't know, sold a given product with a description that rendered it unsafe, like selling a box of rat poison as delicious candy. The rat poison itself might be safe if it were sold as rat poison, but not in the context of being sold as food. If Amazon is liable for that description, I'd think that they wouldn't want to permit sellers to write their own descriptions. That seems like it'd have a big impact as to how they operate.

 

cross-posted from: https://lemmings.world/post/3242832

The small but growing curated community for AI image generations that look indistinguishably realistic! Feel free to stop by or share your own generations: !aiphotography@lemmings.world

24
submitted 1 year ago* (last edited 1 year ago) by tal to c/gaming@beehaw.org
 

This was something I started wondering about when I was reading a thread about Star Citizen, and about how space combat flight games were much less-common than they had been at one point, how fans of the genre were hungry for new entrants.

Looking at this list:

https://en.wikipedia.org/wiki/List_of_space_flight_simulation_games#Space_combat_games

...there really were far more games in the genre being released in the late 1990s and early 2000s than there have been recently.

A similar sort of phenomenon occurred for World War II first-person shooters.

https://en.wikipedia.org/wiki/List_of_World_War_II_video_games

Back around the same time period, there was a glut of games in the genre, and they really have fallen off quite a bit.

Whether it's a genre like these two, that hasn't seen many new entrants recently, or a genre that just never grew as much as you'd like, what genre would you like to see more of?

15
submitted 1 year ago* (last edited 1 year ago) by tal to c/imageai@sh.itjust.works
 

cat,white ink,black background, (red eyes:.3), (uncanny wide smile:2)

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

 

(ninja:.1), ice sculpture,colored lighting

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 8, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

 

(barack obama:.5),running,blue,orange,red, by Frank Miller,style of sin city

Steps: 40, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

This is really to showcase another neat phenomenon I've run into -- I didn't spend time trying to find the coolest image I could find.

I really like hard-light, black-and-white pen-and-ink drawings (as, with the above example, Frank Miller did with Sin City). And Stable Diffusion can do a pretty good job of imitating those styles. However, those can be a little intense, very high-contrast, be a bit overwhelming to the viewer.

It looks like, if one adds a few color names to an image, Stable Diffusion winds up starting with the black-and-white art style, but will then fill in limited amounts of color...and does so in reasonable places.

Here's the same prompt without the color terms:

(barack obama:.5),running, by Frank Miller,style of sin city

Steps: 40, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

A few other examples, starting with black-and-white styles, and using the same prompt:

(barack obama:.5),running,blue,orange,red, by Alex Toth

Steps: 40, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

(barack obama:.5),running,blue,orange,red, by Steve Ditko

Steps: 40, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

These aren't ideal images -- it'd probably be better to reduce the "barack obama" weight further so that the more-detailed, photographic appearance doesn't noticeably come out in the final image on the face, something I've observed happening with a number of images of politicians. But they do a pretty good job of demonstrating the effect.

 

noble weasel, rococo

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 0, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

 

I wanted to highlight a feature available in Stable Diffusion (as well as perhaps other generative AIs) -- regional prompting. Midjourney looks like one can do it manually; I don't know about others.

It can be difficult, when generating an image, to specify that it contains multiple people with distinct attributes, because the prompt applies to the whole image. Specify a name, and the prompt affects both people. Making one person is easy, and making twins is easy...but making two distinct people isn't.

Thelsim ran into this in a comment yesterday, where the face of a scared woman was placed on the head of a giant robot.

There are two ways I know of to deal with this. One is inpainting. This gives a great deal of control, but is time-consuming. If one inpaints, one generates an image, then erases part of the image, and then regenerates just that part with a new (potentially different) prompt. The problem with this is that it takes a while, and makes it hard to go back and change something in the original image.

The second approach is to use regional prompting. This permits the image to be divided up, and different prompts applied to only portions of the image.

I'm going to walk through the regional prompting process here, in case anyone else hasn't done it before. For Stable Diffusion, you'll want to install the Regional Prompter extension, in the Extensions tab.

Okay, let's take our first stab at the image:

ursula von der leyen and angela merkel sitting side-by-side, by neal adams

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 11, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, Version: v1.5.1

Well, that didn't work very well. On both women, we've got Angela Merkel's face combined with something like a cross of von der Leyen's and Merkel's hair.

Activate the regional prompter, down at the bottom of the txt2img tab. Check "Use common prompt". click "Visualize and make template". This will show you how you have the image set up to be divided up -- currently, two equal-size boxes split vertically down the image. It'll also give you some text to paste into the prompt box:

ADDCOMM 
ADDCOL 

The text before "ADDCOMM" is the common prompt, that applies to the whole image. The text between ADDCOMM and ADDCOL apply to the left side of the image. The text after ADDCOL applies to the right side of the image.

ursula von der leyen and angela merkel sitting side-by-side, by neal adams ADDCOMM ursula von der leyen ADDCOL angela merkel

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 11, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, RP Active: True, RP Divide mode: Matrix, RP Matrix submode: Horizontal, RP Mask submode: Mask, RP Prompt submode: Prompt, RP Calc Mode: Attention, RP Ratios: "1,1", RP Base Ratios: 0.2, RP Use Base: False, RP Use Common: True, RP Use Ncommon: False, RP Change AND: False, RP LoRA Neg Te Ratios: 0, RP LoRA Neg U Ratios: 0, RP threshold: 0.4, RP LoRA Stop Step: 0, RP LoRA Hires Stop Step: 0, Version: v1.5.1

Doesn't look much different; the right side and the left side each favor one woman a bit, but not by much. Let's let it start with a scene that has any two women sitting side-by-side -- no reason to start with just scenes that have von der Leyen and Merkel already being the people there, and by totally removing Merkel and von der Leyen from the common prompt, that'll prevent Merkel from influencing the left side or von der Leyen the right.

two women sitting side-by-side, by neal adams ADDCOMM ursula von der leyen ADDCOL angela merkel

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 11, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, RP Active: True, RP Divide mode: Matrix, RP Matrix submode: Horizontal, RP Mask submode: Mask, RP Prompt submode: Prompt, RP Calc Mode: Attention, RP Ratios: "1,1", RP Base Ratios: 0.2, RP Use Base: False, RP Use Common: True, RP Use Ncommon: False, RP Change AND: False, RP LoRA Neg Te Ratios: 0, RP LoRA Neg U Ratios: 0, RP threshold: 0.4, RP LoRA Stop Step: 0, RP LoRA Hires Stop Step: 0, Version: v1.5.1

Okay, that's not bad, and now the Neal Adams hand-drawn art style is coming through, but the two are looking suspiciously well-endowed in the breast department, probably because of the model I'm using that's being influenced by images of other women that it's been trained on. Let's turn down the relative strength of the generic "two women" bit. You can do that by putting a term in parentheses, putting a colon and then a strength modifier after it. An unmodified term has a strength of 1, so I'll use .1, only a tenth the strength:

(two women sitting side-by-side:.1), by neal adams ADDCOMM ursula von der leyen ADDCOL angela merkel

Steps: 20, Sampler: Euler a, CFG scale: 7, Seed: 11, Size: 1024x1024, Model hash: ebf42d1fae, Model: realmixXL_v15, Token merging ratio: 0.5, RP Active: True, RP Divide mode: Matrix, RP Matrix submode: Horizontal, RP Mask submode: Mask, RP Prompt submode: Prompt, RP Calc Mode: Attention, RP Ratios: "1,1", RP Base Ratios: 0.2, RP Use Base: False, RP Use Common: True, RP Use Ncommon: False, RP Change AND: False, RP LoRA Neg Te Ratios: 0, RP LoRA Neg U Ratios: 0, RP threshold: 0.4, RP LoRA Stop Step: 0, RP LoRA Hires Stop Step: 0, Version: v1.5.1

And there we have our final image!

view more: ‹ prev next ›