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.

General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

This is a recurring thread in ~games.tabletop where we can talk about board games in a fun way. Feel free to discuss boardgames in any way you want! Each week I add a guiding topic / question, just to help things along:

What's the last game you played?

This is a recurring thread in ~games.tabletop where we can talk about board games in a fun way. Feel free to discuss boardgames in any way you want, but I like to add a bit of a hook each week to spice things up. Here's my hook for this thread:

What's one of your favourite board game and why?

Edit: I made the question a bit less hard to answer - instead of your absolute favourite, pick a favourite, and talk about it.

What are you reading currently? Fiction or non-fiction or poetry, any genre, any language! Tell us what you're reading, and talk about it a bit.

Notes

We're coming up on #30! Exciting!

Previous topics

Previous topics are listed in the wiki.

What are you reading currently? Fiction or non-fiction or poetry, any genre, any language! Tell us what you're reading, and talk about it a bit.

Notes

I'm finally going to update the wiki today, hopefully. FYI.

Previous topics

Previous topics will be ARE listed in the UPDATED wiki!!! as soon as I update it.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

IMO one of the major issues with online debates, arguments and heated discussions is that they often tend to escalate rather steadily over time, and as each side gets more frustrated with the other they also tend to slowly get more personal as well. I am admittedly guilty of falling into this trap occasionally myself too, which has got me thinking about ways that Tildes (the site and the users here) can potentially help deescalate unproductive arguments and allow people to disengage more effectively from them. To this end I thought it might be a good idea to have a brainstorming session regarding that.

To start things off, here are most of the ideas I could find related to this issue that have previously been proposed and are already on Tildes Gitlab (click ▶ to read the full details):

Feel free to voice your support or criticism regarding the above suggestions, offer up ideas to potentially improve them, or even propose your own brand new ideas related to this issue in the comments here as well.

p.s. Once again, the point here is to open up the conversation and get ideas flowing freely, so let's please try to keep things positive, and keep any criticism purely constructive and friendly so as not to discourage people from participating.

Previous Unofficial Weekly Discussions:

Week #1, #2

Other relevant links:
Donate to Tildes - Tildes Gitlab : Issues Board - Tildes Official Docs

What have you been playing lately? Discussion about video games and board games are both welcome. Please don't just make a list of titles, give some thoughts about the game(s) as well.

Sorry, I usually post this on Monday and just realized I didn't do it this week. I'm bad at this and obviously need to add a proper scheduled-posting feature.

I'd love to see a recurring thread here in ~games.tabletop where we can talk about board games in a fun way. Here's my hook for this thread:

List one boardgame that you like, and we will suggest a boardgame that you may also like based on your one selection. Ideally, there will be an explanation for "why" as well.

Edit: I also encourage other people to post suggestions!

I'd love to see a recurring thread here in ~games.tabletop where we can talk about board games in a fun way. Since this is the second in series, my dream has become a reality! Here's my hook for this thread:

If someone were wanting to start creating a collection of board games, what one game would you suggest that they put in their collection, and why? To standardize the question a bit, let's assume that the person is relatively into board gaming already, so it's not "introduce someone to the basics of board games".

What are you reading currently? Fiction or non-fiction, any genre, any language! Tell us what you're reading, and talk about it a bit.

Notes

Hi everyone! I'm @acdw, I'm taking over this thread from @cadadr. This is my first one, and I'm excited for the discussion!

If anyone has any suggestions about how to run this thread, please feel free to PM me (I don't want to clog up this thread with suggestions). If there's enough messages, I'll start a thread to discuss them publicly.

Previous topics

Previous topics are listed in the wiki.

An experiment I've been thinking about lately: a (recurring?) Q&A thread! Ask any questions about programming, answer other users' questions, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

Meta questions:

• Should I turn this into a recurring thread?
• If yes, should it be a weekly or a monthly thing?
• Should DBA and SysAdmin questions be allowed or should someone else make a separate recurring thread for these?

Despite me still being a little distracted thanks to WoW Classic and somewhat absent from Tildes lately as a result, since it's been a few weeks since the last Unofficial Weekly Discussion topic, I wanted to make sure to get one posted this week. And since it's been a while, I wanted to try something a bit more lighthearted and fun than usual to get things flowing again. So here it is:

What is your most "thinking outside the box", "pie in the sky" and/or "out there" idea for Tildes?

It doesn't matter whether you think it's really a good idea or not, it will work or not, it would ultimately have a net positive or negative effect, or how impossible it might be to implement; Let's just get the creative juices flowing and start throwing out our "craziest" ideas for the site!

p.s. Once again, let's please try to keep things positive, and keep any criticism purely constructive and friendly so as not to discourage people from participating.

Previous Unofficial Weekly Discussions:

Week #1, #2, #3

Other relevant links:
Donate to Tildes - Tildes Gitlab : Issues Board - Tildes Official Docs

Hi everyone! It's been a long time since last programming challenge ^list, and here's a nice one I've encountered.

If you search for something like 7km to AU, you'll get your answer. But how is it done? I don't think they hardcoded all 23 units of distance and every conversion factor between them.

If you were programming a conversion system - how would you do it?

First of all, you have input in format that you can specify, for example something like this:

meter kilometer 1000
mile kilometer 1.609344
second minute 60
...

Then you should be able answer queries. For example 7 mile meter should convert 7 miles to meters, which is 11265.41.

Can you design an algorithm that will convert any unit into any other unit?

Edit: Some conversion rates I extracted from wikipedia:

ångström
0.1nm
astronomical unit
149597870700m
attometre
0.000000000000000001m
barleycorn
8.4m
bohr
0.00846
cable length (imperial)
185.3184m
cable length
185.2m
cable length (US)
219.456m
chain (Gunters)
20.11684m
cubit
0.5m
ell
1.143m
fathom
1.8288m
femtometre
0.00000000000001m
fermi
0.00000000000001m
finger
0.022225m
finger (cloth)
0.1143m
foot (Benoit)
0.304799735m
foot (Cape) (H)
0.314858m
foot (Clarke's) (H)
0.3047972654m
foot (Indian) (H)
0.304799514m
foot,metric
0.31622776602m
foot,metric (long)
0.3m
foot,metric (short)
0.30m
foot (International)
0.3048m
foot (Sear's) (H)
0.30479947m
foot (US Survey)
0.304800610
french
0.0003m
furlong
201.168m
hand
0.1016m
inch
0.0254m
league
4828m
light-day
25902068371200m
light-hour
107925284880m
light-minute
17987547480
light-second
299792458m
light-year
31557600light-second
line
0.002116m
link (Gunter's)
0.2011684m
link (Ramsden's; Engineer's)
0.3048m
metre
1m
m
1metre
km
1000m
mickey
0.000127
micrometre
0.000001
mil; thou
0.0000254
mil
10km
mile (geographical)
6082foot (International)
quarter
0.2286m
rod
5.0292m
rope
6.096m
shaku
0.303 0303m
span (H)
0.2286m
stick (H)
0.0508m
toise
1.949 0363m
twip
1.76310
yard
0.9144m

Have you watched any movies recently you want to discuss? Any movies that you'd like to recommend or are hyped about? Feel free to discuss anything here!

Spoilers are okay, just give fair warning so people who care about them can participate too.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

What are you reading currently? Fiction or non-fiction, any genre, any language! Tell us what you're reading, and talk about it a bit.

Notes

Sorry this is posted so late! I would've posted it tomorrow, even, but I'm working all day so I won't have the chance. I'll make sure and bump this thread Sunday, so we can talk about our reading. I'll set an alarm for next time!

Previous topics

Previous topics will be listed in the wiki as soon as I update it.

Have you watched any movies recently you want to discuss? Any movies that you'd like to recommend or are hyped about? Feel free to discuss anything here!

Spoilers are okay, just give fair warning so people who care about them can participate too.

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.

Sorry, I was away last week and didn't post this, so it's been a couple of weeks now since the last one.

So, what have you been playing lately? Discussion about video games and board games are both welcome. Please don't just make a list of titles, give some thoughts about the game(s) as well.

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.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

Thanks to @dubteedub for doing this up until now, let's bring em back :)

Have you watched any movies recently you want to discuss? Any movies that you'd like to recommend or are hyped about? Feel free to discuss anything here!

Spoilers are okay, just give fair warning so people who care about them can participate too.

it's creative thread time, gamers. here you can share/provide updates on some of the projects that you're working on. they can be of any kind--digital, physical, work related, passion project, whatever. pretty straightforward, i think.

november thread • february thread • march thread • april thread • may thread • june thread • july thread

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

I started this last week, and plan to continue posting this topic weekly.

So, what have you been playing lately? Discussion about video games and board games are both welcome. Please don't just make a list of titles, give some thoughts about the game(s) as well.

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.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

Here's a list of a things that came out in this past week, up through Friday. Of course, there's no way to be completely comprehensive with this and we avoided including things where information was too lacking, so feel free to bring up anything that isn't on here that you think is worth mentioning. Beyond that, if you have any thoughts of any of these albums, it would be great to hear them :)

Notes:
If you spot any mistakes, let us know.
Parental Advisory version of all albums linked, so expect NSFW.

Ugly God - Bumps & Bruises | Deluxe edition linked.

Thanks to @Cleb, @cfabbro, and @Bauke!

Inspired by @Lawrencium265's suggestion from a few days ago on advanced topic tag filtering:

After the discussion the other day on expanding groups into sub groups I had an idea about topic tags, advanced tag filtering rules. The main argument against sub groups is that it would sequester people away from each other. By allowing more advanced tag rules you could subscribe to topics that you're interested in, but further filter those if they include topics you don't like or allow certain threads that would get filtered out unless they contain a tag you are interested in or are within a certain group. I think this would attract different people to threads that wouldn't normally be and allow more diverse discussion and insight. So instead of having gaming.tabletop you would use the tabletop tag under gaming and those who are not interested in it can filter it out and those who are solely interested in it can subscribe to it, and then if a topic gets tagged in an unrelated group that you otherwise wouldn't be interested inyou will know about. This also has the side benefit if preventing cross posting or duplicates.

I have decided that the topic of this week's unofficial discussion is going to be on the Tildes topic tag system. But rather than make it specifically on topic tag filtering and that idea in particular, I figured we could open the discussion up a bit more and have a community brainstorming session on the topic tag system in general. I.e. Anything related to tag browsing, tag filtering, tag organization/standardization, etc.

Feel free to comment on any of the open "topic tag" related issues on Tildes Gitlab that pique your interest and you would like to discuss more in depth, propose your own new ideas related to topic tags, or even just spitball.

The point here is to open up the conversation and get ideas flowing freely, so with that in mind, let's please try to keep things positive, and keep any criticism purely constructive and friendly so as not to discourage people from participating.

Previous Unofficial Weekly Discussions:

Week - #1

Other relevant links:
Donate to Tildes - Tildes Gitlab : Issues Board - Tildes Official Docs

Here's a list of a things that came out in this past week, up through Friday. Of course, there's no way to be completely comprehensive with this and we avoided including things where information was too lacking, so feel free to mention anything that isn't on here that you think is worth mentioning. Beyond that, if you have any thoughts of any of these albums, it would be great to hear them :)

Notes:
If you spot any mistakes, let us know.
Parental Advisory version of all albums linked, so expect NSFW.

Channel Tres - Black Moses | EP isn't due until Aug 16, linked single instead
Flume & Reo Cragun - Quits | Song.link says "Single" but it's the EP
Tennis System - Lovesick | No song.link yet, album not due until Sept 6, linked bandcamp single instead
Volbeat - Rewind, Replay, Rebound | "Deluxe" album linked

Thanks to @Cleb, @Bauke, and @cfabbro!

What are you reading currently? Fiction or non-fiction, any genre, any language! Tell us what you're reading, and talk a bit about it.

Notes

First of all, I'm again having to post the topic earlier b/c travel. Sorry.

Seconly, big news! It's already been almost a year that we do these threads! It's been a beautiful time for me, but I've decided that the time has come that I pass the torch on to another Tildista to post and manage these threads. I posted a topic on ~tildes declaring my decision; we held a vote and elected @acdw as the new maintainer of these threads. This is the last one of these topics that I'll post; from the next thread on @acdw will be taking over. FWIW, I'll stay around and comment on these threads when I can.

Hey @acdw, hope you'll have a great time doing this! Good luck!

Previous topics

Previous topics are listed in the wiki.

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.

after a month sabbatical, we're back. this is pretty straightforward, i think: vent your experiences or things you need to get off your chest/share whatever you've found helps you mentally/etc.

resources that might also be of some benefit to people:

• there is, as always, the invaluable list of country hotlines maintained by /r/SuicideWatch
• https://findtreatment.samhsa.gov/ ("an online source of information for persons seeking treatment facilities in the United States or U.S. Territories for substance abuse/addiction and/or mental health problems")
• https://therapists.psychologytoday.com/rms/ (probably one of the best resources for finding a therapist)
• https://psychiatrists.psychologytoday.com/rms (ditto, with finding a psychiatrist)
• https://www.nimh.nih.gov/health/topics/index.shtml (covers some of the major mental disorders, their symptoms and treatments, and general topics like that)
• https://www.mentalhealth.gov/what-to-look-for (what symptoms to look for for major mental disorders)
• https://suicidepreventionlifeline.org/help-yourself/ (US specific, but also covers ways you can help yourself and a bunch of ways to seek treatment or support)
• there's also some stuff over at /r/SWResources that might be worth checking out which is consistently updated.

and here is the june thread if you'd like to reference/update us on something you mentioned there.

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.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

What are you reading currently? Fiction or non-fiction, any genre, any language! Tell us what you're reading, and talk a bit about it.

Notes

• Sorry for posting late this time round. I had an intense week, and was basically too lazy to post yesterday.

• I will not include a list of past topics in the topic text anymore, given it is redundant with the listing in the wiki. Below you'll find a link to the relevant section in the relevant wiki page instead. If you think this is a bad change, PM me about it; if a lot of you don't like it I might end up reverting this.

• Have a nice weekend!

Previous topics

Previous topics are listed in the wiki.

Since @Deimos has stated he will likely not be restarting the tradition of the Official Daily Tildes Discussions, which is something I and a number of other users greatly enjoyed and miss, I have decided to attempt to take on the responsibility of continuing them unofficially (with his blessing). And since these are not official (so won't be in ~tildes.official, which everyone is subscribed to and probably shouldn't unsubscribe from), I will only be doing them weekly instead of daily, and we now have topic tag filtering (so unofficial weekly discussion can be filtered out), hopefully the people who found the official daily discussions annoying can more easily ignore/hide these unofficial ones.

With the explanation out of the way, on to the topic for this week:

Suggestions/ideas/concerns for future unofficial weekly discussions

I thought it would be appropriate to have the first one of these be a bit of an open-ended, meta-meta discussion on the future of these topics. And to kick things off:

• What would everyone here like to see discussed in these topics in the future? Are there any particular site features (planned, suggested or theoretical), policies (tagging, moderation, etc), or other meta issues/subjects you would like to be the topic in future discussions?

• What would you like us to try to achieve with these discussions? Should we have any specific goals in mind, or should they just be fun brainstorming/theory-crafting/naval-gazing sessions?

• Does anyone have any suggestions for me with regards to how I should handle these discussions? Is there anyone out there who would like to help me with these in some capacity going forwards?

• Does anyone have any concerns regarding these unofficial discussions, and if so, can you think of any ways we can try to address them?

The floor is open, and I am all ears. :)

Tildes Official Docs : Donate to Tildes | Tildes Gitlab : Issues Board

We're sorting out our process for these to be more efficient, so hopefully we won't be missing weeks anymore. Sorry again about that.

Here's a list of a things that came out in this past week, up through Friday. Of course, there's no way to be completely comprehensive with this and we avoided including things where information was too lacking, so feel free to mention anything that isn't on here that you think is worth mentioning. Beyond that, if you have any thoughts of any of these albums, it would be great to hear them :)

Notes:
If you spot any mistakes, let us know.
Parental Advisory version of all albums linked, so expect NSFW.

Thank you to @Cleb, @cfabbro, and @Bauke!

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.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

it's that time of the month again, now hopefully aided by the changes in sort which will give this thread a bit of a longer half-life. here you can share/provide updates on some of the projects that you're working on. they can be of any kind--digital, physical, work related, passion project, whatever. pretty straightforward, i think.

november thread • february thread • march thread • april thread • may thread • june thread

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.

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.

If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!

What are you reading currently? Fiction or non-fiction, any genre, any language! Tell us what you're reading, and talk a bit about it.

Past weeks

Week #1 · Week #2 · Week #3 · Week #4 · Week #5 · Week #6 · Week #7 · Week #8 · Week #9 · Week #10 · Week #11 · Week #12 · Week #13 · Week #14 · Week #15 · Week #16 · Week #17 · Week #18 · Week #19 · Week #20 · Week #21 · Week #22