First, let's add some actual context: I'm basically trying to decide on a new laptop. I don't know how quickly this falls into the "then it doesn't really matter" category, but the laptops I'm most interested in either have AMD Ryzen or Intel Core processors. In addition, a general Internet search yields results that basically come down to "well, they're similar but also very different depending on xyz factors."

So this si where I turn to y'all. I know things in egneral about computers and laptops, but getting into the guts is not an area I know too much about. Also, I live outside the US, and the two main brands I'm looking into are Asus and Lenovo. Also, and this is the part where I know a bunch of you are going to groan or otherwise be disgusted, I'm intending to just run the default Windows OS that will come with it... and then try to uninstall a bunch of stuff. Something like Linux is far too complicated for my meager understanding.

As for what I intend to use it for? Just general purpose- lots of internet browsing, watching a bunch of video files I have (I already have a preferred video player), and playing the occasional game or two... but it's definitely not any sort of gaming laptop usage.

Also, with what I'm going for, it's going to be Ryzen 5 vs core i5. Which of these is better to go with, based on the above information?

two promising options I found from some quick googling were Grist and EtherCalc

of the two, Grist looks more compelling (I like the tech stack of Python+SQLite more than JS+Redis) but I'm open to any other suggestions as well.

the specific use case I have in mind to start out with is planning ratios for a Factorio megabase (sort of a local, homegrown version of tools like the Kirk McDonald calculator). if that works out well I'd also like to play around with doing household budgeting and finances with it.

if it matters: I'd be running this on Linux (NixOS); on an x86 box with plenty of headroom so I don't have any particular resource constraints; and I have an existing Postgres database server if that's an option for the backend

I've read nice things about Amazon's S3. There are some compatible implementations from other major vendors like Google and Cloudflare. There are projects that automatically back up and replicate a sqlite database using S3. Some people have backed up Google Photos to S3.

But I've never used any of them. What would be a good way to get started? Amazon or another vendor? (And does this make sense at all?)

I'll start by saying that there's nothing wrong with how VirtualHere functions. I have used it for a couple years on my nvidia shield while streaming games from my pc and it's perfect for what I need. The problem I have encountered is that I'm no longer using the shield and have transitioned my entire setup to use a raspberry pi 4 instead because the shields wifi becoming more unstable with every update nvidia pushes.

I would love to continue just using VirtualHere, but I've just learned that the developer does not allow a license transfer for any reason so my $50 license is completely useless now that the shield is gone. Knowing that the license is non-transferable makes me unlikely to ever spend money on it again because I cannot guarantee how long these devices will last and $50 is far too steep for a single device private use license on any software. My primary use case is with a moonlight/sunshine setup which can handle the controller inputs just fine after a little bit of input file tinkering.

The things I absolutely cannot figure out how to make work without VirtualHere is a Dolphin bar that is used for Wii/WiiU games and the gamecube controller to usb adapters. I've seen people mention using usbip, but I haven't been able to find any reasonable explanation or documentation on how to actually use usbip without fully configuring it every time the device reboots.

I'm not against the idea of a more manual setup. I just need something that once it's configured will allow passthrough of any usb device from a raspberry pi to a windows machine and not charge me a fortune every time I need to swap hardware in the future. I'd be willing to pay for similar software if it was a little more reasonably priced for what I'm doing.

Hi everyone — I am trying to get a job in web development after a decade in a mostly unrelated field.

I am looking for ideas and tips to create a portfolio to send with applications. All of the websites I worked on ages ago have been taken offline or redesigned by someone else. I do have a website I created for my music, but it’s just vanilla HTML. I also have a personal website which is really the only thing I have to show.

I know HTML/CSS quite well, but that’s basically it. I’ve worked with WordPress for years but only just recently began learning enough PHP to do anything custom. I don’t really know Javascript much at all.

I have quite a few paid courses through Udemy for all these different areas but even as I have completed them, I don’t feel confident in knowledge of the different languages. These courses nearly always come with projects that the students create with the instructor. Should I use these as part of my portfolio? For some reason I never felt right doing that, since I didn’t build it myself.

So I guess I’m curious (if any of you are web developers) if you have suggestions for how to fill out a portfolio without any previous work examples.

Side note: I wasn’t sure how to word the title or my question particularly well so please edit it more clearly, Those Who Can Edit.

edit: thank you to everyone who took the time to reply to this. it’s all been very helpful and i appreciate everyone’s input immensely!

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?

Yesterday I recorded myself setting up PhotoPrism on an old laptop to document the journey. Everything went pretty smoothly which was great. In the past, I've used several different mainstream providers which ended up not working for me:

• Google Photos (been trying to move away from Google products for a while)
• One Drive (I'm not sure if this is widespread but my connection to One Drive servers are so slow. This is super evident right now as I'm trying to pull all my photos from it and it's taking forever)
• iCloud (This works pretty well but it doesn't feel great when I'm on my non-Apple devices)

I'm pretty excited to have local hardware running flexible software to host my things. I still need to figure out how I want to expose the computer so I have access to it away from home (I'm thinking of using Cloudflare Tunnel?).

Next up is finding software to stream videos to my TV so I can start getting rid of some streaming services.

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?

Just wanted to put this out there as a little PSA in case it's helpful: if you want a cloud server but don't wanna pay anything, Oracle's Free Tier is a life saver. Discovered it a year ago and couldn't be happier I did, since I'd never pay for cloud computing otherwise 😭.

Quick Specs:

For free you get:

• 24/7 uptime
• 200gb of storage space
• 24GB of RAM
• 4 OCPUs
• 4 Gbps Bandwidth

That's been more than enough for me and honestly feels too good to be true. Some things I've done with this:

• Minecraft Server
• Radarr/Sonarr Plex Setup
• I'd like to make my own backup solution as well!

If anyone has any other ideas for cool projects I could self host, please do tell I'm curious what else I could do :)

Here's a nice website for comparing between a lot of different computational notebooks, such as Jupyter, Google Colab, and Observable. (And popularized by Mathematica, though spreadsheets sort of count.)

I'm wondering what computational notebook software other people have used and how you like it? I will make top-level posts for some that I used.

I have two Macbook Airs that don't work. One is a A1932 (bad motherboard) and the other is a A2337 (I think a bad screen - it's cracked). Is it possible to take the motherboard from the 2337 and use it in the case of the 1932 (connected to that screen)? I understand the 1932 is an Intel Chipset and the 2337 is an M1 chipset, but would that really matter for what I'd like to do?

I recently looked around at VPS pricing on DigitialOcean, Linode and Vultr. Everything seems much higher than I'd expect - way over the inflation rate. It looks like a 2 core 8GB VPS is being priced between $45 and $60 per month. Maybe I don't remember correctly but I recall being able to get 2 core VMs around $20 a few years ago!

Background: Bitwise operators are operators that perform conditional operations at the binary level. These operators are bitwise AND &, bitwise OR |, bitwise XOR ^, and bitwise NOT ~, not to be confused with their logical operator counterparts, i.e. &&, ||, !=, and ! respectively.

Specifically, these operations take the binary values of the left- and right-hand terms and perform the conditional operation on each matching bit position between both values.

For instance, 3 | 4 takes the binary value 010 from 2 and 100 from 4. From left to right, we compare 0 || 1, 1 || 0, and 0 || 0 to get 110 as the resulting binary. This produces the integer value 6.

Goal: Your challenge is to implement one or more of these bitwise operators without using the native operators provided to you by your language of choice. Logical operators are allowed, however. These operators should work on integer values. These operators will likely take on the form of a function or method that accepts two arguments.

Bonus challenges:

• Implement all of the operators.
• Don't use any native binary conversion utilities.
• Whether or not you implement all operators, write your code in such a way that allows for good code reusability.
• For statically typed languages, handle integers of different types (e.g. int vs. uint).

Edit: Minor correction for the sake of accuracy, courtesy of @teaearlgraycold.

From what I can tell, this is a pretty hot debate in the open-source world. I've spent the last ~5 years or so investing into learning UNIX systems, particularly Linux. I just came across an article expounding the glories of OpenBSD as a system, and it made some valid points. Generally though, I don't want to dive deeper than I have to into learning new platforms for the sake of it. I do want to arrive at the simplest possible configuration for a digital system, and that involves choosing the best possible foundation. It should be noted that I am looking for a system that is effective as a personal computer / internet browser as well as a general purpose server.

For users of OpenBSD - What's your usecase? why did you switch? What did you miss? What did you appreciate?

For users of Linux who have tried other kernels - what was your experience? Was it worth trying? Why did you switch back?

I tried to use Gnus to set up some rss feeds about a year ago, and I became more than frustrated: I was actually confused.

So here are a couple questions I don't even understand where to ask or whether they're relevant or being asked in the right way:

Are most newsgroups mirrored? And along those lines, is there one particular newsgroup server that would be sufficient for most users?

Can I post to a newsgroup in the same way I would post to a mailing list: send an email somewhere? Where do I send that?

What even is NNTP? Someone literally sent me the spec for the protocol, but I don't think they actually wanted to be helpful: I felt like they were putting me down and intentionally not answering while giving the appearance of being helpful. Is it actually something I need to understand to use Gnus effectively?

If you're familiar with newsgroups, I would surely appreciate your knowledge.

Howdy Tildes wizards.

I decided to have a looksy at Stable Diffusion on my local computer (Manjaro, AMD 7500x CPU, 32GB) using Easy Diffusion. I've gotten my head around the basics and grabbed MidJourney V4 LLM, and now I'm learning how to prompt.

So far I've generated some cool cyberpunk cyborg things, landscapes, etc. One of the things I wanted to use Stable Diffusion for is generating silhouettes. Sounds weird, I know, but they're great to use with decal and vinyl printing for my wife's business.

Any ideas on ways to do silhouette generation?

Next is, what's good to read to learn about model types and what all of the settings really do?

I'm ordering a GPU (3060) to improve the horrendous render times, so don't worry about the under powered rig, I'm still in toy mode.

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?