I tried to register here the other day with my preferred username, which was taken, so I replaced an S with a 5 as I've done in the past. Now I realize that might have been a bit deceptive - someone reading my comment might think it's coming from the other user or vice-versa, and I don't want to be that guy. What's the vibe here about that? Should I invite myself under a new name once I'm approved for invitations, or keep this username? I'd just DM the other user if that was an option on tildes.

edit: Thanks, all! I'll keep it until/unless the other user feels strongly about it.

Bit of an odd question but one I'm becoming a little self conscious of.

I posted a thread earlier today on ~LGBT asking people to share their experiences of coming out. Because it's a somewhat sensitive topic and sharing your experiences can be a little vulnerable I've been taking part and interacting with everyone who's shared their experience.

Im being sure to try and actually contribute, bring my perspective and continue the conversation, and importantly thank people for being open about something that can be difficult.

My problem is that I worry that this is a habit I'm bringing over from Reddit that's perhaps not suitable for Tildes, but I'm not sure?

I generally see it as a good thing when an OP takes active part in a discussion they started, but maybe it's more of a hindrance here?

I'm not sure how I feel, and I'd like to get the opinions of other regular users on what would be appropriate?

Edit: I should specify and make it clear in my case I'm talking about actively replying to most or all top level comments. Not necessarily replies but still a fair number. I worry about crossing a line into just contributing to noise.

Hey all,

I will admit, one thing I will miss about the other site is having the strong simracing community. Have any other sim racers made the jump?

I told myself I wouldn’t buy another F1 game (hell, I partially got a PC to keep F1 22 alive with mods), but F1 23 looks like it’s a huge step better. Maybe that will be my last F1 game, lol.

Otherwise, I find myself really only playing Assetto Corsa. I know other games are better at one thing or another, but AC just seems to have the best all-around. I play single player almost exclusively, so I want a decent AI and also be able to race everywhere they do IRL. For example, I hear the indycars are better in Automobilista 2, but AC has all the track mods, and I’m honestly having fun using AI apps to fix any kind of AI dumbness that occurs. Same with WEC- AC probably isn’t the best physics, but I have all the cars and the tracks.

Any other sim racers here?

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!