-
81 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?
4 votes -
What’s a value that you hold but also struggle to live up to?
The original title I conceived of for this was “How are you your own hypocrite?” but I didn’t like that it came across as negative and judgmental. Nevertheless, you can use that as a jumping off...
The original title I conceived of for this was “How are you your own hypocrite?” but I didn’t like that it came across as negative and judgmental. Nevertheless, you can use that as a jumping off point for what I’m trying to get at.
I think we all have ideals and beliefs and values that we simultaneously hold but also fail to meet on a regular basis. I also think these can be hard to identify. We all like to think that we’re consistent individuals and, when something is out of alignment, we often find very good reasons or explanations for why that is. Sometimes those can be valid, but sometimes they’re really just motivated reasoning aimed at keeping a sense of internal consistency in ourselves.
I’m interested in people exploring the inconsistent areas of themselves (it’s been something I’ve been thinking a lot about lately), but I think to do that this topic needs to be a space where people can be open, honest, and vulnerable.
Please do not jump on someone for the inconsistencies they share or for their failure to meet certain standards. Please do not use this as an opportunity to get in arguments with others.
The whole point of the thread is to explore difficult areas rather than judge them. If people feel that they will have to be pressured to defend themselves in doing so, they simply won’t comment and the whole thought experiment will be for moot. Think of this as a shared space for thoughtful self-reflection and commiseration rather than a battleground.
84 votes -
Who is likely to believe in conspiracy theories?
35 votes -
Gorilla Tuning of Rexburg, Idaho, pleads guilty to criminal conspiracy to violate the Clean Air Act, will pay $1 million in criminal fines, while its owner faces up to two years in jail
30 votes -
Which games have you been playing this week? (to 29th August)
Sorry Tabletiddles, couple of days late with the thread as I've been busy on the bank holiday weekend here in UK. What boardgames have you all been playing this week? Please share your...
Sorry Tabletiddles, couple of days late with the thread as I've been busy on the bank holiday weekend here in UK.
What boardgames have you all been playing this week? Please share your experiences,.no matter what you've been playing.
7 votes -
Air pollution greatest global threat to human health, says benchmark study
8 votes -
Widening US highways doesn't fix traffic. So why do we keep doing it?
84 votes -
A warning to employers that US NLRB labor agency has changed the rules governing formation of unions to be easier for workers and harder for employers to oppose
41 votes -
Jude's in south Seattle is trying to make a worker-owned restaurant work
27 votes -
Ukraine is becoming a country of traumatised people (Polish, translation in comments)
25 votes -
Zoom CEO reportedly tells staff: Workers can't build trust or collaborate... on Zoom
52 votes -
It’s not just ‘The Blind Side.’ In Hollywood, the ‘white savior’ won’t go quietly.
22 votes -
Bobbi Gibb: The Boston Marathon pioneer who raced a lie that women couldn't run marathons
7 votes -
Saudi Arabia: Brother of prominent UK based scholar sentenced to death over tweets
12 votes -
What is your framework for back of the envelope/ MVP style software design?
I suspect many don’t write anything down and do this largely by intuition/experience but I want to tease out some ideas. when it comes to describing and designing a system from a blank piece of...
I suspect many don’t write anything down and do this largely by intuition/experience but I want to tease out some ideas.
when it comes to describing and designing a system from a blank piece of paper, what are the parameters you think of?
I’m thinking napkin sketch level of software design.
So things like:
Number of users, are they concurrent users, what load dimensions there are (disk IO, network IO etc.), target platform (everything is a web app these days), how do you design/visualise the data model?Any decisions or constraints that impact what and how you build a proof of concept / MVP? How do you document this? How do you test it against the finished software?
7 votes -
Tesla braces for its first trial involving Autopilot US fatality
35 votes -
How to save tomato seeds
25 votes -
Are there any new shows available like Patriot Act or The Daily Show?
I've recently been watching the old episodes of Patriot act, and it occured to me that since we cut the cord with regular cable I have no clue if there is a contemporary analog for that show....
I've recently been watching the old episodes of Patriot act, and it occured to me that since we cut the cord with regular cable I have no clue if there is a contemporary analog for that show. Basically, a left leaning, comedic news and current events show that tends toward actually doing it's homework on the topics covered would be awesome.
17 votes -
Mom’s Meals discloses data breach impacting 1.2 million people
17 votes -
Holger Rune refused to blame his court allocation for his shock defeat to Roberto Carballes Baena in the first round of the US Open
4 votes -
Ugly numbers from Microsoft and ChatGPT reveal that AI demand is already shrinking
91 votes -
Retired US country singer tries clearing ‘vagrancy problem’ with his low-flying helicopter
20 votes -
Why you should divide your life into semesters, even when you’re not in school
19 votes -
Do you know Tildes-like websites in languages other than English?
I'm looking for places with the same UX and pace of conversations as Tildes, but used by other-than-English language speakers. I know some Lemmy websites, but their UI isn't what I'm looking for.
23 votes -
Sign up to get Cody for free
8 votes -
Weekly megathread for news/updates/discussion of Russian invasion of Ukraine - August 17
This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic,...
This thread is posted weekly on Thursday - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.
If you'd like to help support Ukraine, please visit the official site at https://help.gov.ua/ - an official portal for those who want to provide humanitarian or financial assistance to people of Ukraine, businesses or the government at the times of resistance against the Russian aggression.
35 votes -
France says Niger's junta has 'no authority' to ask ambassador to leave - other articles report Niger's government has cut off water to French embassy
16 votes -
US President Joe Biden is still trying to forgive student debt in ‘a very direct confrontation’ with US Supreme Court, expert says
59 votes -
Women working in Antarctica say they were left to fend for themselves against sexual harassers
50 votes -
Looking for beta testers for my Tildes.net iOS app!
Happy Friday everyone! I'm making a post to see if anyone wants to beta test my Tildes.net iOS app Backtick. Background I've been wanting to create a Reddit app for quite a while, and just when I...
Happy Friday everyone! I'm making a post to see if anyone wants to beta test my Tildes.net iOS app Backtick.
Background
I've been wanting to create a Reddit app for quite a while, and just when I got started, the API change chaos happened. Thankfully, I remembered signing up for Tildes.net a few years ago and decided to pivot to make an app for this site instead! The app is still a work in progress, but I believe releasing early and getting as many eyes on it during development results in a better end product (and it's more fun for me 😊).
Features
Here are the current features of Backtick:
- Light mode/dark mode
- Login to Tildes.net (suports 2FA)
- Front page feed with sorting support
- View, vote, and comment on posts
- Reply and vote on comments
- Collapse comments
- View notifications
- Full markdown rendering
- Text-to-speech for posts and comments
Here is a video demo of the app in its current state (updated for v1.8.1): https://youtube.com/shorts/iukQJyJbtw8?feature=share
I know there missing features, but as I mentioned before, I would love to get as many people in as early as possible to help shape Backtick's future.
Testing
If you're interested in testing the app as I continue to work on it during my free time you will need:
- An iOS 16 device
- TestFlight (Apple's testing app)
You can access the beta here: https://testflight.apple.com/join/gNH18NE9. If you have any issues please DM me your Apple ID email and I will send you an invite manually.
Thanks, everyone! Have a great weekend.
- AshEdit:
Getting some great feedback! I'll be tracking bugs and potential features here if anyone is curious: https://chatter-brick-3d3.notion.site/Backtick-Tracker-888150b641ae4c0ab39dc0345783bc50?pvs=4Edit2:
I created the Discord server to help facilitate better collaboration with those who wish to be more involved. It will be a place for discussion around potential features, bugs, and general chat. I will still be taking in feedback via TestFlight and Tildes.net, so it's perfectly fine if you don't want to join.
Join here: https://discord.gg/aah7nkfpBY194 votes -
Atari 2600+ announced
41 votes -
Which OS to pick for my first home server?
Edit: I've just purchased an Unraid license. I'll give it a go and it may not turn out well, but for the time being, the question is settled. I appreciate everyone for providing insightful and...
Edit: I've just purchased an Unraid license. I'll give it a go and it may not turn out well, but for the time being, the question is settled. I appreciate everyone for providing insightful and informative answers!
Hey everyone,
I've recently bought myself a NUC (NUC11TNHi3) that I intend to run as a home server, using many of my external USB drives as the storage.
My use case is very narrow. I'll use it as a Plex server and seed/leech torrents with it.
I've never built a home server like this before (I did dabble with it on a RPi, but that was just for PiHole), so I've never had to research what operating systems are available to me. After some research, I narrowed it down to two options.
-
Windows
This option is the most straightforward given that it's the system I'm familiar with the most. My use case is also very narrow, so I could set everything up in a couple of hours. All I'd have to do is install Plex server, a torrent client, exposing them to the outside world with port forwarding or Tailscale (never used it before but seems easy enough), and share my external USB drives locally so that I can access them using my regular desktop computer at home. The downside of this is that Windows can be finicky. I'd also prefer to have my drives pooled under a single drive. A cursory research suggests that Windows can do this as well, but not in a way that inspires confidence. -
Unraid
I hadn't heard about this since last week, but it seems like a nice option. It costs money, it's proprietary, and I'd likely have to reformat all my NTFS drives to be able to use it but I was wondering if this would be the best long term solution. The learning curve will be there. Arrays, cache drives, share drives etc. are terms I'm not familiar with (though I can guess what purpose they serve) so it will be more time consuming to set things up properly. But given how narrow my use case is, as elegant a solution as it seems, is it necessary? I'm only considering this because seems like this is the best purpose built OS in the market right now.
Some clarifications:
-
I'm sure someone will suggest a Linux distro. I have used Fedora as my main OS for a couple of years and I was quite happy with it, however I could never wrap my head around the Linux permissions structure, which Plex is awful with, as it creates its own user and look for drives under that user. I must have spent hours and hours to make Plex read my external drives properly before, but I've never managed to make it do so without some sort of hacky way and I don't want to do that with my home server. I don't want to have any doubts that things can go wrong. I want something that just works. (If only Synology had a capable device that could handle multiple simultaneous 4K transcodings. I'd have just throw my money at them instead of buying a NUC.)
-
My use case will remain narrow. Maybe way down the road I can automate stuff with Sonarr or Radarr or stuff like that, but I don't think I'll ever consume enough recently released stuff to justify it. One thing is for certain, I'm never going to host my password server, feed reader, or something like that on this device.
That's about it. What should I do?
Given that I'm a novice is this area, I'd be all ears to listen any other related or unrelated advice for someone who's just starting to build their first home server.
Thank you in advance.
27 votes -
-
Perfectly reproducible, verified Go toolchains
11 votes -
Boston University - Study finds CTE in 40% of athletes who died before thirty
15 votes -
In a rare win, a migrant worker sued his bosses in Singapore. And won
22 votes -
Walt Disney Pictures VFX workers move to unionize
50 votes -
Recommend your favorite incremental mobile games, please
Hey all, hope everyone is well today and staying cool! Lately I've been very interested in incremental mobile games, and also idle games. I'm not 100% on the terminology, but for whatever reason...
Hey all, hope everyone is well today and staying cool!
Lately I've been very interested in incremental mobile games, and also idle games. I'm not 100% on the terminology, but for whatever reason I've found myself enjoying games that simply make me wait. It's odd, I know, but I think it's related to a recent personal decision to distance myself from online apps; an oxymoron, I'm aware.
Anyway! Recommend your favorite incremental/idle apps please. I'm currently enjoying:
-
Kittens Game
-
Tiny Tower
-
Pocket Trains
And.. that's it! If you have any recommendations yourself, let me know. Thanks in advance, and have a wonderful day.
PS: bonus points for outer space! I swear there's a space trading game that was mostly text-based, but the title escapes me.
PPS: Android!
26 votes -
-
Anyone know of any raw, long-form footage from a writer's room?
I'm very interested in the inner-workings of a writer's room. I have seen glimpses in "making of" documentaries, but I don't feel that they show much of the actual process. I'd love to see more...
I'm very interested in the inner-workings of a writer's room. I have seen glimpses in "making of" documentaries, but I don't feel that they show much of the actual process.
I'd love to see more about how the sausage is made. Bonus points if it's a beloved, popular tv show or movie. I feel like I would be most interested in seeing the best of the best at work.
23 votes -
Former US President Donald Trump pleads not guilty to classified documents charges
75 votes -
Titan Quest II | Announcement trailer
32 votes -
The strange, secretive world of North Korean science fiction
29 votes -
US federal judge to hear arguments on Mark Meadows’ request to move Georgia election case from state court to federal court
12 votes -
Today is US National Cinema Day! What are you going to go see for $4?
14 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 -
Ferris Bueller: The sitcom | Forgotten Failures
9 votes -
What is narcissism? Science confronts a widely misunderstood phenomenon
24 votes -
The Baťa Skyscraper in Zlín, Czechia is a landmark of architecture. And inside it, the office of Jan Antonín Baťa... is an elevator.
13 votes -
Messaging programs: which is better privacy - browser versions or dedicated apps?
I use Slack, WhatsApp, Discord and Facebook's Messenger. On my computers, rather than installing dedicated apps, I've always just used these services' browser versions. It allows me to block ads...
I use Slack, WhatsApp, Discord and Facebook's Messenger. On my computers, rather than installing dedicated apps, I've always just used these services' browser versions. It allows me to block ads with my browser's ad blocker and modify the UIs with other extensions that I use.
But in terms of privacy — and more specifically, in terms of what the service has access to outside of their own walled gardens — is there a difference between using these services through a browser or their dedicated apps? I use both Windows and Mac computers, if that makes a difference. My browser of choice is Firefox and I run the services in their own containers.
On my phone, I just use the provided apps and get notifications that way. I am well aware that most of these protocols are not great for privacy to begin with, but I'm not currently looking for other messaging systems.
21 votes -
Foreskin reclaimers: The ‘intactivists’ fighting infant male circumcision
27 votes