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?

I'm currently building an MVP for a startup, solo. We've got Postgres pulling triple duty as the go-to database for all normal relational data, a vector database with pgvector, and a job queue (With the magic of SELECT ... FROM "Jobs" WHERE ... FOR UPDATE SKIP LOCKED LIMIT 1). Every time I go out looking for solutions to problems it feels like the world really wants me to get a dedicated vector store or to use Redis as a job queue.

Back when I was a Rails developer a good majority of the ActiveJob implementers used Redis. Now that I'm doing NodeJS the go-to is Bull which can only serialize jobs to Redis. They back this with claims that I can scale to thousands of jobs per second! I have to assume this theoretical throughput benefit from using Redis is utilized by 0.01% of apps running Bull.

So I ended up implementing a very simple system. Bull wouldn't have been a good fit anyway as we have both Python and Typescript async workers, so a simple system that I fully understand is more useful at the moment. I'm curious who else shares my philosophy.

Edit: I'll try to remember to update everyone in a year with the real world consequences of my design choices.

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?

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?

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?

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?

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?

Just for a moment, forget all of the technical pros and cons, the static typing, just-in-time compilation, operator overloading, object orientation to the max...

Is there a programming language that you've just found to be... fun?

Is there one that you'd pick above all else for personal or company projects, if you had your druthers, because you would simply be so excited to use it?

And then, is there something missing in that "fun" language that's preventing it from actually becoming a reality (i.e. small community, lack of libraries, maintenance ended in the 80s, etc.)?

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?

Have any of you tried out fossil as an alternative to git? I have been using it for about a week, and I think I am in love. I have used git for years, since having some sort of source control is absolutely essential in programming. But I never liked git or felt comfortable using it. Within a week of messing with fossil, I feel like I understand it and can use it without a guide or external tools. It also has an issue tracker, forums, and a wiki built in.

Fossil Versus Git

I recommend reading all of that, especially section 2.5. Their description of cathedral style development lines up much more closely to everything I have worked on than git's bazaar style. Another thing I love is the ability to have the same repo open in multiple different folders at the same time. Basically everything about fossil lines up much more closely with what I think a source control program should be, at least for my use.

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?

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?

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?

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?

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?

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?

I'm looking to get a new laptop for when I want to go work at a coffee shop or something.

I have seen the Framework laptops and like the idea of a modular computer you can upgrade or repair.

I'm a little hesitant though. The last laptop I tried was to buy a Pinebook a year or two ago. I got it, turned it on once and it worked fine, but then after that it would just get a black screen when I powered it on. Some posts online indicated that it might be because the memory card wasn't seated properly and it might fix the problem to reseat it. But the tiny screws on the bottom were really tight and I ended up stripping one of them while trying to open it up, so now I just have a laptop I've used once collecting dust.

I want to make sure I have an easier experience with my next computer. Can anyone attest to the reliability of the Framework 13?

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?

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?

Hey all, I'm interested in going down the rabbit hole with Ubiquiti equipment or other manufacturers, more specifically with access points, routers, and a switch. I want to ween off my ISP-supplied all-in-one equipment as their newer hardware limits basic features such as port forwarding, and I'm interested in re-enabling my self-hosted software. Wi-Fi standards have been moving pretty quickly, as have hardware. What setups do you have established in your homes?

I don't really have a budget in mind, and have a 2.5GbE port I'd like to utilize for media consumption over LAN.

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?

Between "enshittification" and my general admiration for hobbyist websites, I have felt more and more pressed to learn how to make the websites I want to see and offer it at low cost. At the same time, people usually have to maintain their day jobs and development expenses. I am curious how easy or difficult it is for people to do. (Also, I guess please share your small website if you'd like)

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?

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?

I am a pretty big fan of the PCMR Battle station posts where everyone shares their computers and desk setups. I have never seen one here so I figured I would start one!

Here is my desk, three 32" monitors (two facing the desk, one facing my living room on the back ). I primarily use my lower monitor and have background stuff on the upper (spotify, torrent client, youtube, podcasts, winamp, twitch, discord, etc etc). I have a bunch of old Xbox360 controllers and enjoy playing PC games on the couch on my rear monitor (as well as streaming obviously). The rear monitor also has a firestick and my only source of sound (other than my headset) is an Amazon Echo (which also controls my living room lights). The PC is a prebuilt from iBUYPOWER, it was my first time buying a prebuilt (I was hesitant to do so) and the only reason I did was because I was wanting to build a new rig right as crypto mining was driving up the cost of everything and I was able to get a great deal on this one. So far it has performed great. I still have two RAM slots open so I think that is the next thing I am gonna do.

I built my last computer in 2008 so I was way overdue for a new one and my S.O. has informed me I went a little overboard =)

9200 i7-8700K 6-Core 3.7 GHz | Liquid Cooled | Z370 Motherboard| GeForce GTX 1070 | 16GB DDR4| 1TB HDD | 240GB SSD |

Lets see what you guys have!

EDIT: sorry for the low picture quality, my cell phone is garbage.

EDIT2: forgot to include a screenshot

It's the same background on all three, but the taskbar is basic on the two secondary (and icons are only on the main). And if anyone was confused about the random monitor hanging off of the back of my desk this kinda shows it better.

I'm a little late on this, admittedly. $dayjob is requiring us all to set up a pair of YubiKeys, and I'm using them for the first time and my mind is a little blown.

I was seeing articles about "passkeys" all summer, not really grokking what they were talking about, clinging to my usernames and passwords and 2FA codes coming out of 1Password, etc.

I just set it up on a few accounts today, initially as an additional 2FA source, but when I set them on GitHub, I saw for the first time how exactly they are used instead of the username and password and 2FA combo to log in, and it seems incredible to me!

For long-time YubiKey users: what are some cool things in the ecosystem that you would recommend looking at?

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?

I have been going over services for which I pay monthly in my business. I have 17 clients where I do unattended cloud backups as well as doing a backup that I hold onto myself. Overall I backup around 4TB of data. I'm looking at possibly changing cloud services as the one I currently use has progressively increased their fees. I understand the need to pay for a good, reliable service as it reflects upon myself , my business and the service I provide but feel there are more competitive companies out there.

None of this is for personal use and many cloud services are just that, personal use. These are all server (Windows and Linux) use cases.

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

Self-hosting has been a rabbit hole of wonder that I've explored and delved into over these past few months. I'm curious to hear what others use it for, what apps they love, and their rationale for doing so?

I'll go first.

First, in terms of rationale, this is a wonderful article that I think is worth checking out that encapsulates much my of ethos about pursuing self-hosting.

https://kylechayka.substack.com/p/essay-the-digital-death-of-collecting

The TL;DR is that we no longer have control over the things that we 'own' digitally for these massive cloud companies. For instance the songs / artists you listen to on Spotify may suddenly and unexpectedly become unavailable, certain things (most recently podcasts) may be forced upon you in unpleasant ways. Having complete control of your digital data is a very liberating feeling.

In terms of apps:

Hyperbackup - I use a synology NAS, so hyperbackup has been wonderful and use both external HD's and a cloud interface to create encrypted backups of everything which gives me peace of mind.

Plex - One of my most used apps, being able to stream anything remotely has been a dream. Plexamp has given me back control of my music library in a way I never thought I would have.

Tautulli - Great for more informatics on my plex usage

Calibre / Calibreweb - Phenomenal for keeping track of my book collections

PiHole - Ads be gone!

*Arr apps - Specifically Sonarr/Prowlarr/Radarr, really like Overseerr for an interface tying everything together

Daily Notes - A clean interface for keeping regular notes

Some things that I'm not currently self-hosting but would love to hear if others are using alternatives...

Instapaper - I know there are a few similar FOSS apps out there but haven't found one as convenient and well laid out

TickTick - To do app, but similarly haven't found a FOSS alternative that was as robust and nice to use

OneNote

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.)

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?

Hoping we can get some discussion on self hosting setups throughout the community and help anyone who may be interested with common setups and finding interesting software.

Hardware
Currently running everything on a Dell 7050 SFF (intel i5-7500 and 16GB RAM) which suits my needs perfectly. Had used an older SFF before (i forget which) and a cheap older model mac mini (2012 I think) for self hosting before, but those were not the right choice as I didn't properly understand what hardware encoding was at the time. The i5-7500 handles all the media I have when transcoding is needed. Only thing it can't do is AV1, but my setup avoids those anyway.

Operating System
Distro Hopping habits are hard to break and that "itch" unfortunately carry over to the server. Currently running Ubuntu 22.04 LTS for a few months now, but feeling like a change is needed soon. I've used Ubuntu, Debian, and Fedora for servers before and they each have their own little problems that make me eventually switch. I am considering maybe doing a Proxmox setup so I can spin up a VM whenever that itch comes, but not sure if they added complexity is worth it in the long run.

Software
Yay, the best part! My self hosting stack has changed a ton over the years. Everything in my stack is in a docker container through a set of badly written compose files (planning on redoing things, cleaning things up, making things consistent, etc.). I'll just do a rundown of everything with a brief description of what it is:

• Plex Gives me a Netflix like streaming experience at home. Currently working on shifting things over to JellyFin as Plex is starting to grow increasingly buggy for me.
• Sonarr Automatically tracks and downloads all my shows. I have two instances of this running, one for normal tv shows and another for anime
• Radarr Automatically tracks and downloads all my movies.
• Prowlarr Sowers the high seas for what Sonarr and Radarr are looking for and gives them the "linux iso".
• rdt-client Probably different to most peoples setups. I use a debrid service (not sure why people call them that), to download my "linux iso's" for me and I do a direct download from them. Much quicker and no torrenting traffic on my end. Also it's also cheaper than paying for a VPN usually.
• File Browser A good web ui for managing files
• Nginx Proxy Manager Is a reverse proxy for all of my services and gives me HTTPS for everything. Gets rid of the annoying browser warnings.
• Tailscale The most recent addition to my setup. Allows me to access my network anywhere. Similar to a VPN (I know it uses wireguard under the hood), but does a lot of magic for you and just makes everything work and connect together, its really cool.
• Adguard Home Gives me a local DNS server that does DNS level ad blocking. Never given me problems and it works well, but I am thinking of reducing the complexity of my setup and removing it. There tons of DNS servers out there that can do the same thing and I don't mind trusting a few of them (like quad9 or mullvad dns).
• Watchtower It monitors all my docker containers and keeps them up-to-date. If a new version is out, it will automatically download the latest version and restart the container and delete the old container version. I know its not the best idea, but its only cause a break 1 time with 1 container in the couple years I've run this setup.
• Homepage Literally the homepage for all my services. I've tried a lot of different ones and Homepage is easily the best. Simple, but powerful to configure.

Keen eyes may have noticed the lack of backup software. I'll get around to that, eventually.

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?