-
18 votes
-
Fortnightly Programming Q&A Thread
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...
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?
1 vote -
The world depends on this government warehouse's collection of strange Standard Reference Materials. They're not cheap.
1 vote -
Hacking a weird TV censoring device
3 votes -
How long would society last during a total grid collapse?
4 votes -
WebTV returns with custom server emulating 1999 experience
6 votes -
The Third Place
10 votes -
Helsinki is tapping an unexpected source of energy to heat its homes – cold water extracted from deep in the Baltic Sea
6 votes -
Why build a diving board twice the Olympic height?
4 votes -
Tildes Pop-Up Game Event: Ludonostalgia!
Pop-Up Event: Ludonostalgia! Task: Replay an old, favorite game that you haven't played in a long, long time. Tell us about how your playthrough now compares to your memories of the game. Time...
Pop-Up Event: Ludonostalgia!
Task: Replay an old, favorite game that you haven't played in a long, long time. Tell us about how your playthrough now compares to your memories of the game.
Time Period:
This weekend! (November 10-14)
Update: Ludonostalgia is extending its hours through November 21st!Uh, what is this exactly?
Its me, kfwyre, trying out yet another post type on Tildes and seeing how it goes.
In the past I've done a "Backlog Burner" event that was a full month. It was a lot to commit to, and it ended up feeling like it lost steam -- too long for its own good.
I still like the root of that idea though -- people playing games with a specific purpose or focus. Something like a "Book Club" for games, but with a common theme instead of a common title, so people are free to choose what they personally like.
Thus, a "Pop-Up": a quick, short event that identifies a common focus that people can participate in together and doesn't require too much commitment. Basically, something unexpectedly fun to do for a week or a weekend.
If this kind of thing takes, I'd love to see it happen in other communities: ~movies, ~anime, ~music, etc. I'd also love it if other people did their own "pop-ups" on a whim, rather than it being seen as something that's "mine" to post.
That's jumping the gun a bit though -- this one is a sort of test to see if this sort of thing even has any legs in the first place.
Oh, and "Ludonostalgia" is a made up pretentious word -- because every good Pop-Up needs an iconic name.
14 votes -
AI’s new frontier: Connecting grieving loved ones with the deceased
7 votes -
Greta Thunberg Foundation has donated £158,000 to cover legal costs of indigenous people in Sweden's Arctic as they battle a British mining company
6 votes -
Mormonism and the rise and fall of mutual aid
3 votes -
What have you been eating, drinking, and cooking?
What food and drinks have you been enjoying (or not enjoying) recently? Have you cooked or created anything interesting? Tell us about it!
7 votes -
Bed Habits - One insomniac’s descent into the world of sleep research to understand what screens before bed are doing to our brains
4 votes -
Qatar World Cup
4 votes -
OKSolar: Improving on Solarized using the OKLab perceptual colorspace
9 votes -
The return of James Cameron, box office king
5 votes -
Ghost – Spillways (2022)
1 vote -
Midweek Movie Free Talk
Have you watched any movies recently you want to discuss? Any films you want to recommend or are hyped about? Feel free to discuss anything here. Please just try to provide fair warning of...
Have you watched any movies recently you want to discuss? Any films you want to recommend or are hyped about? Feel free to discuss anything here.
Please just try to provide fair warning of spoilers if you can.
8 votes -
Johnny vs. Sonic Frontiers
3 votes -
A guide to Norway's Trøndelag – this year's European Region of Gastronomy
4 votes -
We bought HD movies on cassette tape and they're amazing!
7 votes -
Remote Access that's safe and not a scary nightmare
My child (who does not live with me) has a PC. He's pretty good at sorting problems out for himself, but he sometimes needs extra help. We've tried doing this over phone and video calls, and it's...
My child (who does not live with me) has a PC. He's pretty good at sorting problems out for himself, but he sometimes needs extra help. We've tried doing this over phone and video calls, and it's an unfun experience for both of us.
Is there a remote access software that would fit our needs? I want to be able to connect to his computer over the Internet and have some level of control when he's logged into his account. I'd need to be able to open files, I wouldn't have to be able to save them. He's using Windows 11. I think he's using the home version. I'm using Windows 10 Pro. We both have reasonably good Internet speed.
8 votes -
'Power Rangers' Jason David Frank dead by suicide at 49
10 votes -
Megalopolis: How coastal west Africa will shape the coming century
8 votes -
‘Tár’ wins Golden Frog at EnergaCamerimage
3 votes -
First Aid Kit – Palomino (2022)
1 vote -
How Brendan Fraser made it all the way back
8 votes -
Boxplot - Human Again (2022)
1 vote -
What are you reading these days?
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.
9 votes -
World Cup 2022: How to watch the matches online and on TV
6 votes -
Finland to start building 200km long border fence with Russia next year – estimated to cost a total of 380 million euros and be completed by 2026
7 votes -
Visualizing the layers of the TCP/IP model
3 votes -
ROBLOX_OOF.mp3
19 votes -
Finnish astronomers acquitted in defamation case related to protesting harassment – astrophysicist Christian Ott argued protests cost him postdoc position
5 votes -
Who has served the most time? Ex cons rank themselves
5 votes -
How do seatbelts work?
2 votes -
How Jell-O lost its spot as America's favorite dessert
5 votes -
Elizabeth Holmes gets more than eleven years for Theranos scam
8 votes -
How Qatar bought the World Cup
5 votes -
Valve's gambling problem
13 votes -
An idea how to monetize social software
I wrote the following as a Twitter thread first but I think this idea could work for Reddit/Tildes/Mastadon and would love to know what you folks think of it. Here is how I would monetize a social...
I wrote the following as a Twitter thread first but I think this idea could work for Reddit/Tildes/Mastadon and would love to know what you folks think of it.
Here is how I would monetize a social network that could work for Twitter.
First of all, don’t charge your most valuable users - the power users that create the content for you. Instead focus on the users that get more value from your system - the consumers of the content.
The idea is simple - introduce a small time delay before content gets seen from the time it is published. For example, on Twitter it could be 1 minute. On Reddit it could be 10 minutes.
Paid subscribers would have no delay. Importantly - lift the delay for the users that generate a lot of views.
You can do revenue share with your content creators in proportion to how much time paid subscribers spent on their content.
And you can also identify your most valuable audience - the paid subscribers. This will help prioritize content moderation decisions, identify abuse, and prioritize appeals.
The delay would allow you to prioritize which content needs to be indexed instantly (ie from creators that paid subscribers are following) and which you can process on a best effort basis - saving on production costs.
You can gift subscriptions to your friends and family.
7 votes -
Hilma af Klint's family criticises the NFT sale of the artist's sacred paintings – digital drop contradicts the artist's will and goes against her artistic intentions
6 votes -
Fans paid to attend World Cup by Qatar have daily allowance cancelled
6 votes -
Sweden finds explosive traces at Nord Stream blast sites, confirms sabotage
7 votes -
King Charles: Foie gras banned at royal residences
6 votes -
Anna of the North – Red Light (2022)
2 votes -
What have you been listening to this week?
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...
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.
4 votes -
The Wonderful Wizard of Oz
6 votes