You could use any SQL database to create a few tables, insert some data, and do queries, while ignoring anything vendor-specific. But Postgres has a lot of other features and many extensions. What do you recommend checking out beyond the basics?

I've used a lot of databases, but it's been many years, so I assume things have changed quite a bit. I skimmed a few PostgreSQL release notes and learned that there's now a MERGE statement that looks pretty handy. (It's standard SQL.) And from Neon's list of supported extensions, the plv8 extension caught my eye. It would let me write stored procedures in JavaScript. Does anyone use that? Do you use stored procedures at all?

I wonder what Tildes uses?

(To keep discussion organized, please write about one feature per top-level comment.)

What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)

Feel free to give recs or discuss anything about each others' listening habits.

You can make a chart if you use last.fm:

http://www.tapmusic.net/lastfm/

Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.

I’m building a house and will have ample opportunity to walk with the builder to specify outlets, cat 6, and coax runs and locations. What sorts of little things do you wish you had done in your house or would be useful?

I plan to run cat 6 from mostly every room (some in multiple locations) to the office where my servers will be. I will also be running a few runs of cat 6 out to the shop for future connectivity out there. Anything else that might be useful?

The previous introductions thread was only a few days ago, but it's getting pretty long and we expect more people. So here's another one!

This is a place for new users to post an introduction with a few fun facts about themselves. You will find the post box at the bottom the page. Maybe say hi to someone else you see while scrolling down?

If you like, you can also write something about yourself in your profile. See "Edit your user bio" on the settings page. Anyone who clicks on your username will see it in your profile. (It appears on the right side of the page.)

You can find out more about how to use Tildes in this topic: New users: Ask your questions about Tildes here!

I have lost my r/finch community, and am feeling curious to see if there are any folks here who also find apps can be helpful for their mental health.

I struggle with anxiety and am processing a lot of grief, and may or may not have ADHD (I am in the process of getting tested, but it takes a while). My experiences with therapy are a bit mixed, so I am currently going down the route of trying to DIY my wellness a little. Starting simple with things like, sleep more, try to focus on drinking enough, go out in nature, switching off podcasts and phones and reading more. It's actually helped me, bit by bit.

One of my 'tools' is an app called finch, a virtual pet that encourages you to set goals, check in how you are feeling, journal, do mindful breathing and such. I tried many things and this app is the one that stuck and actually works.

Just wanted to ask, do any others here use wellness apps? And have they worked for you? Which do you recommend?

Just to be clear, I mean apps that work as a stand alone solution, rather than apps like 'better help' which ultimately just connect you to a therapist. Although Better Help has its uses too!

I personally cannot stand playing vanilla minecraft anymore and always play modded, recently ive been playing through Create: Astral and its so much fun. I love the steampunk factories of create and even though im terrible at automating its still so much fun to just mess around. I was wondering if anybody else has any other favorite modpacks they've been playing recently.

We all have that one special movie that makes other people raise their eyebrows. Maybe it’s a movie they just don’t get, maybe it’s super campy, or maybe it really is bad but it still owns some real estate in your heart for your own reasons.

Mine is the obscure ‘Saturday the 14th Strikes Back’. It truly is awful. It has nothing to do with its horror parody prequel, the acting is uneven, the story is unmoored - but it’s zany. Lots of unexpected absurdities. I won’t force this movie on anyone, but it was a regular comfort rental for me back in the day.

So, what’s yours?

I am co-admin of a small Discord group (currently 5 members; we like to keep it up around 7-9) that is dedicated to enthusiastic, interactive accountability, support, task management, habit tracking, yada ... all that good stuff. Atomic Habits is one of our popular guiding stars.

And, yeah, we've lost a couple of members recently, and we're looking to invite a few new people to the group.

This is an active group. We expect people to contribute (at least) daily, both regarding their own efforts, and in helping/supporting others in their efforts. One of the things we try to emphasize is providing active support and feedback to others, rather than just posting our own goals and efforts ... this is one of the areas where we feel that "traditional" accountability buddies/groups fail.

Drop me a DM if you're interested, and we can discuss details.

Edit: Thanks for the replies. I think we have enough "new blood" for now. If you're still interested, just keep an eye out for another invite post in a few months, when membership starts to flag.

Just interested in how people's smart homes are set up and how they enjoy things or what they may dislike/wish was changed.

Alexa? HomeKit? Google? A mix? Other?
Glitches?
Any complex or otherwise unique use cases you've set up?

What are you reading and what's next on your list? Are you enjoying it or just trying to get to the next book you want to read?

I'm almost finished with Columbine by Dave Cullen. It's an in depth look into what led up to the massacre, the aftermath, and how it could have been avoided. It's a well written book and sadly still very relevant today. I would recommend it to any true crime enthusiast.

Next up is either Mindhunter by John Douglas & Mark Olshaker or Children of Dune by Frank Herbert. I've been in a true crime phase for the last year, but I'm also trying to finish the entire (original) Dune series.

So let's be real, a lot of dubs don't live up to the original. Stuff gets lost in translation, the actors aren't as good, for some reason they choose a guy who sounds like he's 10 to voice the teenage protagonist (coughanothercough). A lot of people prefer subs for that reason.

But sometimes, sometimes the dubs throw out the original script and go all-in on the hamminess for gag dubs, and by god they can be amazing.

The golden example: the Ghost Stories dub. They got a generic ghost hunting anime that they knew wouldn't sell that well in western markets, and thus gave the English distributors free reign on changing the script. Every episode is like an Abridged series, and so politically incorrect but so amazing for it. The voice actors are very obviously having a blast with all the ad-libbing going on, you can see them developing the characters themselves and loving it.

So what other amazing gag and parody dubs do you guys know of?

I love shoegaze. Nowadays, I am a bit out of the genre and scene but hearing shoegaze always makes me happy.

My first introduction to the genre was through Lowtide. They are an Australian trio (originally quartet) that were inspired by the classics like Slowdive. "Held" was the first ever shoegaze song I remember hearing a/o loving. Their self-titled album is one of my favourites of all time, and I have it on vinyl!

Of course, the landmark shoegaze album remember by many is Loveless by my bloody valentine. Great album, noisy asf and has awesome songs like "Only Shallow" ,"To Here Knows When", "Blown a Wish", "Sometimes", "Soon", "I Only Said". There are many other bands out there that deserve recognition, like Show Me Mary with "A Dream" from their self-titled EP.

So yeah. Post some of your shoegaze picks, if you love shoegaze.

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!

In light of our 4th 5th^ish? anniversary here, I believe it is time for another thread on those beloved furry/scaly/feathered friends we all know and are beholden to.

So fellow Tilderinos, share your pets! Photos! Stories! Antics! Attitudes! How they've changed your life! How you've changed theirs!

Inspired by this thread

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?

I love hearing about obscure or forgotten films that people are passionate about. I was in a thread on Reddit, IIRC, and someone mentioned The Man From Earth. I just watched it for the first time and I can see its appeal.

I'm sure you have more than one. For me, a couple of favorites off the top of my head are Wristcutters: A Love Story and Wings of Desire. And some old timey classics that I rarely hear mentioned anymore are I Know Where I'm Going and The Lady Eve.

When talking about adding new features to tildes, many people talk about adding more ways to customize your profile, since right now we only have the username and the user bio. The most common way other sites do this is by having profile pictures, but considering tildes is text based that wouldn't work out well.
Another way of doing this would be signatures. Not only would that distinguish tildes from reddit and HN, but it would be text based and look ok on the tildes layout. But what do you guys think? Would it be neccessary?

Edit: u/TooFewColours said this and i think it seems good. I've also heard about allowing your username to be a certain font:

I'd be opposed to profile pictures, but maybe simply being able to choose a single colour that decorates your profile page in a simple way would be a cute addition. Given the colours in the logo, I think it would be on-brand.

I've got a small collection of equipment. I've been really cautious about buying more. There are a few things I regret buying.

1. A series of knives that were good enough, but actually garbage, rather than just spending £30 on a victorinox or similar.

2. A garlic thing which looks cool but is hard to use. Garlic crusher by Royal VKB

And I was wondering, are there any bits of kit that you thought were going to be great but which ended up in the back of a cupboard or drawer?

Hello everyone. I am an avid gamer but I allocate my playtime very differently from most other players. I prefer to spend my time playing very short(typcially under 30 mins) games created for game jams(limited time themed game development events) on itch.io.

Here is example of what a set of game jam entries looks like.

Many of these games are only about 15 minutes long so it is possible to play and review many of them per week. My question to you guys is that given the short nature of most of these experiences, is there at least mild interest in posts about these games and if so would it be better to post a weekly thread where I focus on a specific gamejam and review some of the games and encourage other users to join in and review some more of the games or should I focus on posting direct links to the best games I find when I sifting through these collections.

I’m am excited to share this area of gaming that people don’t talk about much and I would love to hear peoples thoughts on the subject.

Edit: The first thread is up

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?

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?

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

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.

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?

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?

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

My absolute favorite sub even before getting defaulted was writingprompts. Basically people posted a prompt to spark an idea, and everyone would type up little stories. It's be cool to see some stories here so if you guys wanna try it, let's make Top Level Replies restricted to prompts, Second Level Replies the stories, and Third nested can just be the comments.

I'll post a prompt to get started, and a reply (I emailed these to myself back in 2015 so I don't have the username on hand). Don't be shy! And for any non-prompt replies just post a reply to the comment I made below for just that.

^{PS: Luna_Lovewell if you somehow find this please come back and write just a few more :]}

Here, I am asking you to talk about the sports you love. They may be either obscure or popular and well-known. What is their place in your life? Have you practiced those sports, or are you simply a fan and an expectator? What people don't get about the sport you love? What are some common misconceptions you would like to dispel? How would you convince someone to learn more about those sports?

Here's something I want to try, a sort of here's an idea thread for things you want to write down or think that are a good idea, but have no intention of exploring. All top level posts should be similar to shower thoughts in spontaneity, but allow you to further explore them should you choose to. Effectively, it's an Adopt a Thought!

I'm new to tildes and thought I'd start a topic about frugality, as it's something constantly on my mind. (hopefully ~life is the right place, apologies in advance if not!) I try to look at spending a few ways; cost, environmental impact, and time. The time is important, because some frugal tips take up so much time that they end up not being very frugal in the long run. So here are some of the things I've done or started doing in the past few years to try and bring our monthly budget down without giving up much.

Started using Flipp, Ibotta and Flash Food.

These three apps aren't going to save you a ton but enough to make a difference without much effort. Flipp uses your location to gather all the circular ads for stores near you so you can compare prices on items more efficiently. Ibotta is a rebate app that is quick and easy, just claim anything you might buy and once you hit 20 bucks you can redeem for gift cards or cash. The key is to only buy things if it ends up being cheaper than the option you normally buy, or stuff you buy already. Flash Food is a new favorite and isn't everywhere but can be really beneficial for produce particularly. Participating stores list items that are overstock or near expiration for significant discounts. You buy right on the app, and head to the the flash food station in the store to pick them up. Mine is by the self checkouts, there's a big freezer with the logo stationed there. They have huge produce boxes often for only 5 bucks! The assortment of goods will vary by store and time of day so I check every so often if I know I'll be near or going grocery shopping anyways.

*If you don't have flash food, there's another called Too Good To Go, It's not in my area so I can't say how useful it is. However, it works similarly for stores but also includes restaurants.

Switched to a double edged safety razor

with a bit of practice, they are just as easy to use as a cartridge razor. The best part is after the initial cost they are CHEAP and you aren't throwing away plastic cartridges anymore.

Vacuum Sealer and Deep Freezer

I slept on a vacuum sealer for far too long, theses keep frozen goods better for so long without worry of freezer burn. Combine that with Flash Food, and you can really save without much effort.

Switched to a Menstrual Cup

I did this many years ago and never looked back. I will be upfront and say that it isn't going to be for everyone, we are all shaped different! However there are many more options for reusable products these days if a cup just doesn't work (discs, cloth pads, and period panties to name a few.) I have endometriosis and I'm a heavy bleeder so this has easily saved me thousands in disposable costs and worked better for me anyhow.

Gardening

This one is tough because it's easy to go over board with costs, but if you get creative with containers and boxes, buy loads of dirt instead of bags, and start from seed indoors and it can be a pretty cheap way to have fresh produce. Add in the vacuum sealer or canning and you can make it even more worth the time. To go with that, I collect rainwater. This is dependent on your local regs of course so find that out first!

Instead of going out to dinner with friends, host pot lucks instead.

This saves everyone money, you still get to see your buds and have a super nice meal. Throw in some board games and it's sure to be a good evening and only cost you the price of a dish.

Rotate your streaming services and other subscriptions

You can't watch them all at once, so why pay for them all the time? I'm sure they are all about to make it harder to share following in Netflix's footsteps so it's a good time to sit down and look at what you are paying for and what you are actually using. You'd be surprised how easy it is to shave off some costs.

Eliminate single use items where you can

I've already touched on this, but things like paper towels, paper plates, plastic storage bags etc add up if you are using them frequently. There are so many things that fill our landfills just for convenience and you are paying for the privilege! There are so many great reusable items these days, it's become more affordable for upfront costs. Coffee pods, makeup wipes, razors, swiffers, bottled water -- it's never ending and all cost more than their frugal alternatives. For instance, I drink tea and switched to a reusable diffuser and loose leaf as well as using an electric kettle instead of turning on the stove or microwave using much less energy and the used tea is good compost and breaks down faster than the bagged variety.

Use your dishwasher

It seems silly, and obviously not everyone has one, but a relatively newer dishwasher is going to use a lot less water than handwashing and it disinfects better.

Feeling like you need that decor item? Try moving decor around instead

You should be deep cleaning your home anyways, and if things feel stale and you are itching to spend try moving things around instead. You'll often find that you are just bored with the current layout of things. So while cleaning, switch it up!

Keep inventory of your freezer

Deep freezers are easy to lose things in, or forget are in there when you go shopping. I use a notes app shared with my husband with a list of stuff in the freezer so we don't buy things we already have and it's easier to figure out a meal at a glance at the list.

At least try to fix or mend things instead of buying new

It's certainly not feasible with some things anymore, and sometimes it ends up being more expensive but it never hurt to take a second look at something before rebuying. Mending clothing, buying a cheap part etc can save you some money and keep things out of the landfill.

I'm excited to read any ideas you guys have. My next venture is going to be meal prepping, so any tips for that would be extra awesome!

I've realized recently how much of a throughline music documentaries and behind-the-scenes features have been in my life. Like watching whatever VH1 "Behind the Music" was on or watching Prodigy's "Electronic Punks" VHS for the umpteenth time.

What music docs have you really enjoyed historically or recently?

I've been working my way through Hip Hop Evolution on Netflix and it has been a real joy re-familiarizing myself with 90s and aughts hip hop and diving deeper into the 70s and 80s. I feel like they've done a really good job covering the history and the context for the different styles emerging.

Sound City details the history of the prolific LA studio where many well-known rock artists have recorded. There is a palpable reverence for analog recording and the Neve Electronics 8028 mixing console specifically. I thought it was interesting to learn about and hear from the different bands about their experiences there.

I'm guessing most people have seen Peter Jackson's recent one, Get Back, so for something more obscure... if you're a Depeche Mode fan there's a series of short docs on YouTube, one for each album up through Exciter I think. Really cool history on the band and the process of creating each album, cut together from interviews with the band members as well as many of their team and recording collaborators.

Hey guys, anyone else into keyboards? Would love to hear about what you use or experiment with, I've only been into the hobby a few months so I am still pretty new. I'd love to hear your guys set up and what got you into it, how it's evolved.

Currently rocking a Keychron Q2 (65%) with Tecsee purple panda switches and Drop MT3 Cyber keycaps - Co piloting this is a KBDcrafts Addams numpad with their s2 engine switches.

I do also have a keychron Q8 (Alice) in transit - I plan to swap the switches to the KBD s2 engine switches as I am really liking them on the numpad. I ordered this model because my carpal tunnel issues are what awoke me to the mechanical keyboard world, the alice layout isn't perfect but better than standard for ergos it looks like.

Early on in the hobby I was convinced I'd be a tactile switch guy, but the s2 engine switches really changed my mind on liking linear, eager to try a full board with them.

This got rambly, but would love to hear from others into the hobby!

Always curious what others peoples finances look like, what they use to manage it, etc.

Do you use budgeting software? Do you follow a certain "method" to achieve your financial goals? How strict are you with your budget? Do you automate your retirement investments/contributions?

I originally asked this three years ago and got some great responses. Now that we have a lot more users active here and we're living three years in the future, I'd love to ask it again and see what comes up!

I'm interested in hearing about games that exist off the main map of gaming: games that I can't buy from any of the common storefronts and games that aren't easily playable through an emulator.

Examples of things I'm interested in hearing about:

• Long-forgotten abandonware
• Homebrew games for consoles
• Romhacks
• Legally dubious fan-games
• Total conversion mods
• ARGs
• Web games (not ones on sites like Kongregate/GameJolt though)
• Independently distributed games (that you can't get through, say, itch.io)
• Games for systems that aren't currently emulatable
• Games that have been removed from distribution
• Games with servers or content that are no longer operational
• Anything else you think fits the question, really

Tell me about the game(s) you know of and what makes them noteworthy.

One of my favorite subreddits was about the show "The Leftovers". I don't know anyone in real life that has watched it and seeing what people thought while watching the show / after their first watch was great.

So, has anyone here seen the show and what are your thoughts about it?