Hi all, first post so hope I do it right.

I just read the Tasker post and thought I'd post a question/request here about it.

On my old Samsung S21 I wrote a simple Tasker script that detected a change in volume on one of the sliders, eg Media, and then adjusted the others, IE System, Notification and Call, to match with a little check, ie %VOLM neq %VOLR.

It worked fine in my Samsung but goes all over the place on my new Pixel!

Has anyone else seen this or can post something that works on Pixels? Or maybe my scripts need some work!

The trigger is variable set, IE VOLM, and the actions are to set the other 3 volumes to VOLM if they are not already set to that. And I have 4 of those, one for each variable.

And advice appreciated!

This is a recurring post to discuss programming or other technical projects that we've been working on. Tell us about one of your recent projects, either at work or personal projects. What's interesting about it? Are you having trouble with anything?

For those who are new to Tildes:
This site has quite a number of wiki pages which are maintained by volunteers (except the ~tildes.official wiki pages, which are the official documentation). Many of these community pages are now out of date, so it's a good time for people to poke around and make some changes.
For more information, including how to gain wiki editing privileges, see the announcement post from 2019.

A bit of advertising:
For those who don't know, I have been maintaining the Customizing Tildes page since 2020. It is the official successor of the Awesome Tildes project and has numerous suggestions for improving the Tildes experience using userscripts, userstyles, and uBlock Origin's filtering capabilities. Feel free to drop a message if there's something that needs to be added to the wiki.

The Actual Problem

Changes to the wiki are no longer syncing with the GitLab repository. The last commit on GitLab is from 2021!

It's been another week and I thought – if there's not too much protest – we could all talk about what we've been playing again.

Personally I got in the one game of Hegemony at three players. I've played it twice before at two, and adding the third player really took the tension up a notch.

I played as the proletariat, which I think is the simplest class to play. Once again played no strikes or demonstrations, so I really think I might be missing a concept as it never seemed like a worthwhile pursuit. But it's really hard to predict how pulling any particular string in this game will resolve, so I think I'd just go for it in a subsequent game to see what happens.

The capitalists, like in previous games, started very weak but by the last few rounds were raking in the points. I managed a very narrow victory of four or five points over the capitalists. Middle class, who had to take a loan mid-game, never really recovered and were twenty points behind. Fun game, I can see why it's popular.

So what have you all managed to get played this week?

I'm a HUGE lifestyle sim player. I've played Animal Crossing since Wild World came out on the DS. I've put waaaay too much time into the Sims. Stardew Valley is my absolute favorite farming sim.

I just decided to buy Kingdoms and Castles Complete Edition because it's on sale. What other games should I check out? I have a Switch and Mac ecosystem for my games.

What's a guaranteed hit, not everyone's favorite, but anyone can enjoy? (i.e. maybe not 9 or 10, but no ratings below a 6)

Shawshank redemption is my #1 pick. Others up there i think would be the Sandlot & The prestige.

I was told by the overlords that this was the way to ask permission to hear you! I wanna share, discover, and enjoy your personal music. I’ll add myself and some other projects to the bottom of this post, but I truly only want to hear you.

https://jlawson.bandcamp.com/album/visions

https://jeakams.bandcamp.com/

https://on.soundcloud.com/VkPckGcot1Xt9mjA7

Much love,
Jeakams

Current Library: built in sqlite
Current db: sqlite (but will have access to Snowflake soon for option 1 below)

Wondering if anyone here has some advise or a good place to learn about dealing with databases with Python. I know SQL fairly well for pulling data and simple updates, but running into potential performance issues the way I've been doing it. Here are 2 examples.

1. Dealing with Pandas dataframes. I'm doing some reconciliation between a couple of different datasources. I do not have a primary key to work with. I have some very specific matching criteria to determine a match (5 columns specifically - customer, date, contract, product, quantity). The matching process is all built within Python. Is there a good way to do the database commits with updates/inserts en masse vs. line by line? I've looked into upsert (or inserts with clause to update with existing data), but pretty much all examples I've seen rely on primary keys (which I don't have since the data has 5 columns I'm matching on).

2. Dealing with JSON files which have multiple layers of related data. My database is built in such a way that I have a table for header information, line level detail, then third level with specific references assigned to the line level detail. As with a lot of transactional type databases there can be multiple references per line, multiple lines per header. I'm currently looping through the JSON file starting with the header information to create the primary key, then going to the line level detail to create a primary key for the line, but also include the foreign key for the header and also with the reference data. Before inserting I'm doing a lookup to see if the data already exists and then updating if it does or inserting a new record if it doesn't. This works fine, but is slow taking several seconds for maybe 100 inserts in total. While not a big deal since it's for a low volume of sales. I'd rather learn best practice and do this properly with commits/transactions vs inserting an updating each record individually within the ability to rollback should an error occur.

I'm looking for some games I can play with my team at work as part of our next team building event. We're 7 people, so finding a game that can seat everyone is challenging (and we don't want to split tables in this case).

My favorite board game is 7 wonders, which obviously is perfect except for the fact that it's pretty rules heavy and my team is mostly not boardgamers, so will probably be overwhelmed.

Cards against Humanity was also mentioned but is probably not PG enough for a work event.

What would you play?

I am really struggling without r/selfhosted. I truly believe it is, by far, the best community for self-hosters that I have come across. What I am missing most of all is, whenever I search for questions to self-hosting problems - especially for smaller projects - the answers are nearly always found within posts on that sub.

At least with things like programming, there is stackoverflow and a bunch of other small communities.

I'm going to end up going to Discord to find my solutions, which is the next big community. But it means having to go on there and ask the question (that has probably been asked hundreds of times before), rather than just searching the issue.

Personally I find it annoying when someone watermarks their photos, but I have a hard time justifying that annoyance when, not only are they entitled to attempt preventing people from stealing their work, they are entitled to do whatever the hell they want, categorically.

I’d love to hear your thoughts and experience with the topic, especially if it helps me understand and be more accepting of photographers who watermark or digitally sign their work.

I'm currently stuck in a hospital waiting room for probably the rest of the day, so brought my tablet along in the hopes of still being able to get a bit of work done. Plan was to use Termux to ssh into my home computer, but realized too late that this tablet's ssh key hasn't been authorized yet (it's pretty new), so that's a no-go.

Does anyone have recommendations for a good VPS host that charges only for the time you're using it? The day could still be salvaged if I could get into a fresh linux box that can run docker. The only pay-as-you-go VPS I've ever used is Amazon EC2, which is fine, but I'm hoping there are better options that are a little less cumbersome to spin up and tear down.

Many of us listen to whatever music strikes our mood, but there are some out there who, in addition to mood, listen to and appreciate music in focused listening projects. It could be a discography of an artist you want to finish, or it could be listening to all the top 10 albums from each year. There's really no end to the listening projects we get ourselves involved in. I'd like to open a discussion about this.

I've been involved in a number of listening/appreciation projects over the years. For example, even though half the year hasn't elapsed, I've already finished my 2023 Listening Challenge, in which I listened to 50 albums on a variety of criteria.

Right now I'm discog diving some of my favorite artists, and the experience has really opened my ears to the lesser-known avenues of exploration. I've completed so many already, satisfying my urge to always be doing something goal-oriented. Right now, for example, I'm listening to The Musings of Miles as part of my Miles Davis discog dive.

So what are you into project-wise? Please share your experiences!

eBooks and eBook readers feel a little stagnant at the moment. No significant increases in tech, the storefronts are stagnant and locked down with DRM, and it just isn't really an exciting field.

That said, I love my Kindle Paperwhite because it lets me get English books for cheaper (I live in Japan) and it lets me carry them around.

Do you use an eBook reader? Do you read eBooks on a standard tablet or phone? Or are you married to paper?

So while megathreads are a thing, I think we can really benefit from making them more prominent. Because right now there are two topics about the Titan submersible on my front page (and two more if I go to the second page), multiple surveys about movies, and at least one new thread per day about the current reddit fiasco. It's getting a bit cluttered.

So my proposal: make megathreads more prominent.

• Give designated megathreads a colored border or some other simple decoration to make them grab the eye and stand out.
• Pin some megathreads so they show at the top of their respective tildes, especially if they relate to ongoing or developing events. I don't think this is necessary for all megathreads like recurring ones, but it will help cut down clutter. (Note: I did check, and this is indeed on Gitlab. Deimos left a comment three years ago that code was made, just hadn't been merged into Tildes yet due to not being needed at the time.)
• A little more advanced: for ongoing events, maybe have some way that multiple people can edit a post with updates on new developments or links. That way even if the original poster is offline when some big event happens, someone can update it or add new links.
  • Related to above: have a pinned comment on such megathreads to help collect links and such. This would probably be the ideal editable comment rather than the original post.
• To help cut down on the survey threads that typically just ask for lists without much discourse (e.g. "favorite X movie"): Have recurring survey megathreads asking the most common such questions, possibly each week or every other week
  • You could either cycle through different questions each time (particularly in movies where you can just go through the different genres), or just collate the most common questions
  • Also, have a list somewhere of previous times a question has been asked, and then have a "cool down" period before a question can be asked again. Maybe a wiki-style list that people can edit and add links to previous threads?

Of these suggestions, I think the first two would be the most effective and also the simplest to implement. Adding some visual indicator for a megathread would be a simple CSS change, and apparently the code already exists for pinning threads. Just a couple thoughts!

The original IBM 360 had a 24-bit address space.

https://en.wikipedia.org/wiki/IBM_System/360

Microprocessors of the golden age of home computing (Apple ][, TRS-80, Commodore 64, CP/M machines based on the 8080 and Z80) usually had a 16-bit address space, the 8086/8088 was a bit of an exception because it had a segmentation scheme to access 1 MB. (People thought it was awkward but I liked programming it in assembly language and Turbo Pascal) I remember the PDP-11 minicomputer having a 16-bit address space for user programs as well, the machine as a whole could be a lot bigger but an individual logged into it had access to a virtual "home computer" that ran BASIC and all.

24-bit was a natural evolution and by the late 1980s you started to see 24-bit chips like the 80286 (PC AT) the 65C816 (Apple IIgs, Ninteno SNES), the eZ80 and such. Even the bigger AVR8 processors (I love AVR8 assembly) can have more than 64kb of program memory (flash, read-only in operation) so they use 24-bit addresses for program memory.

In my mind we never saw a product of this generation that really took advantage of the address space, the 80286 in particular was called "brain damaged" by Bill Gates and operating systems struggled to exploit it. My take is that most of the chips of that generation were flawed in one way or another and were pretty quickly washed away by 32-bit machines when they became affordable in the early 1990s.

For an example of the difficulties, there is this project to make a retrocomputer that is a bit better than anything we had in the 1980s,

https://www.youtube.com/watch?v=0oYcu43N-lw

they are using the 65C816 but not taking advantage of the 24-bit nature. Instead there is a simple bank switching scheme which I think they thought would be easier to program and probably faster. The 65C816 just doesn't have enough registers and addressing modes for it to be really easy to work with far pointers.

So my question is, if I am a hobbyist who wants to revive the 24-bit generation and I want to have easy access to a 16MB address space, is there some CPU better that doesn't suck? I'd be happy with a CPU that doesn't have virtual memory or other facilities for an advanced operating system (write everything in "real mode") but something that supports an OS would be interesting too. Any ideas?

Suddenly, inventory mostly works. NPCs sit on chairs (!!!) but also move and fight worth a damn. There's less lag. The game hasn't crashed for me 2 days in a row! I've run more missions than I ever have!

It can't last, right? I just jinxed it?

What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

A little indie game made by three people is currently the 11th most played game on steam.
64k players playing at the time of writing, just 10k behind Activision's Modern Warfare 2.

Anyone else having a great time in BattleBit?

Any stage actors, agents, designers, directors, managers, playwrights, producers, stage managers, etc. in the house?

What are you working on right now? How's it going?

Sincerely,
A fellow theatre person

I haven't seen a post talking about or sharing pets on Tildes yet. My pets are a huge part of my life, and I'm sure others are the same way. Tell their stories, and post some pictures!

Lily was my wife and I's first pet. We got her at an adoption event, and she was a wonderful animal. Unfortunately, she did not like getting a lot less attention when we had kids. It got to the point where we gave her up to a new home because she was violent with our children. She needed lots of attention, and we couldn't do that for her, she found an only-cat home and is much happier.

Solo was our second pet, and the old man of the house, being now 10 years old with FIV. My MIL fed the neighborhood cats before they moved, and we noticed this guy in terrible condition. He had no chip, and it looks like no home for a while. My wife originally said we would keep him until he got better, then we would put him up for adoption. Instead, we decided to keep him. At night he comes upstairs and lays on me before bed, purring heavily. Best anti-anxiety medicine ever!

Aurora is our newest addition to our family. She's a total goofball and brings joy and silliness to our home. even though she's a Husky, she doesn't "talk" much, but all the other melodrama is still there. She always wants to hold my hand as a sign of affection, and wants all the love all the time, just like she gives. She helps me stick to my running regiment being my running buddy, and has done noticeable wonders for my mental health, something both my parents and siblings have told me.

I have been a product designer and experience architect since before “UX” even meant anything.

I’ve never wanted for work, and I’ve always been confident in my skills as a leader both on the product and business strategy side.

But especially recently, I’ve started to feel some tremors I’ve never felt before:

1. A massive amount of young talent has flooded the industry via UX programs and boot camps - and much of them are quite talented!
2. Layoffs have further upped the available workers
3. AI and Automation have made good designers even more efficient, and even inexperienced designers can now move at the speed of light.

I also have some personal situations at play:

1. I took the last few years to launch and grow my own product business - scaling that eventually to an exit. So I’ve been out of the “product designer” game a bit - as I’ve been immersed in everything that comes with being a founder and startup growth.
2. I now have a family - I can’t grind as hard as I used to.

All this gives me some qualms about the ability to find work in the future.

With an industry now flooded in talent, and AI that commodifies and democratizes UI design - making it easier than ever to spit out good design - is there job security for product designers the next few years?

What does that look like? How will pay be affected? Where will the opportunity be?

I just recently joined Tildes (absolutely loving it so far, by the way) and also recently left Reddit.

r/Tasker will probably be the hardest for me to let go of since I'm an avid Tasker fan/user, so I'm just trying to gauge the audience for that type of discussion and topics here on Tildes.

I'm not as big of a power user in phone automation as I would like to become but I'm fairly savvy and am learning more all the time.