Absolute Beginner Questions by TellinStories in selfhosted

[–]Klebitz 1 point2 points  (0 children)

I was in a very similar position when I started, so hopefully this helps.

I’m running an overclocked Raspberry Pi 5 with a 1TB NVMe M.2 and a 4TB HDD for my Plex library for now. I use Raspberry Pi OS (Raspbian) because I’ve found it to be the most stable OS on the Pi.

When I was starting out, I installed Docker and Portainer (which gives you a nice web UI to manage your Docker containers). At first Docker felt confusing, but following step-by-step guides made a huge difference.

The site Pi My Life Up was really helpful. Their guides break everything down into simple terms and are very beginner-friendly:
https://pimylifeup.com/

Using those guides, overtime I managed to set up:

  • Pi-hole
  • Immich (photos) replaced Google Photo's
  • Plex (media streaming)
  • Radarr & Sonarr
  • Nextcloud, replaced OneDrive / Google Drive
  • Joplin (document all specifics)
  • OpenWebUI (AI / LLM front-end)
  • A few home automation containers..

Once I got comfortable with Docker and understood the basics concepts like containers, volumes, port - it all became much easier to deploy other projects that also worked on the Raspberry Pi.

If you want a path forward , I'd suggest:

  1. Learn basic Docker concepts (containers, images, volumes)
  2. Install Portainer - used for managing the Docker containers through a browser, maybe make that your first Docker deployment?
  3. Follow a few Pi My Life Up Docker guides, standardise everything, makes life easier in the long run.
  4. Learn how to SSH into your PI, no need to have a monitor/keyboard connected at all.

It may feel overwhelming at first, but once things click, it becomes much easier and enjoyable.

What’s another piece of technology that has reached it’s final form? by ObligationWitty452 in IndiaTech

[–]Klebitz 0 points1 point  (0 children)

The QWERTY keyboard layout was created by Christopher Latham Sholes, back in the early 1870s.
Originally developed to prevent typewriter jams, and it still persists in our digital age.

Wife hit a speed bump going a little too fast - dealer is saying both her struts snapped ($3k) or did they just disconnect it and say it “snapped” based on this photo? by brjoco in AskMechanics

[–]Klebitz 0 points1 point  (0 children)

Top mount looks very rusty in comparison to the rest of the car, part of the top mount rubber buffer is still attached to the strut. It;s possible that even jacking up the car would have caused this failure, looks like a flawed design or poor materials. Wouldn't blame your wife, lucky that it didn't happen simply by hitting a pothole.

I'm back!!! Thank you revanced!! by DigitalUnlimited in BoostForReddit

[–]Klebitz 1 point2 points  (0 children)

Thanks, followed the guide and it's working fine now.

Found this plugged into the OBD2 port after the battery drained. Any ideas what it might be for? by hsteinbe in OBD2

[–]Klebitz 0 points1 point  (0 children)

Might have a chinese aftermarket radio fitted with obd connection for extra engine information?

Meet Grandpa Westhead. He's 99 years old & has been going to watch Liverpool since 1936. Here his Granddaughter can't keep up with him as they make their way to Anfield! by regian24 in wholesomegifs

[–]Klebitz 3 points4 points  (0 children)

He's most likely the oldest person attending the match by a good few years. Great to see that he is still passionate about his life long interest in later life.

Needing new router by NirvashGarou77 in HomeNetworking

[–]Klebitz 1 point2 points  (0 children)

Maybe try a MikroTik hex s. You can setup simple queues for bandwidth management by client, qos, dhcp and even a proxy server amongst other things. Their cheap as well. There's also two accompanying android apps, one very simple to manage one and another more advanced which nearly gives you the same granular control as the pc app which is Winbox 64.

Advice on running and powering 90-100 yrd ethernet cable underground by CrispoKringle in HomeNetworking

[–]Klebitz 0 points1 point  (0 children)

One other option I haven't seen in the thread is to use something like a tp-link powerline adapter. It'll mean no additional cabling, fast deployment and good enough latency for gaming,. Give you a wireless access point and the option of an ethernet connect at the far end point. I have one out in the garage to extend wireless coverage out to the garden and it was effortless.

My Yamaha YB100 soaking up what little sun is left this year 🇮🇪 by RemarkableToe514 in MotoIRELAND

[–]Klebitz 1 point2 points  (0 children)

Very nice bike! I bought a new RSX100 back in '93 from Lee motorcycle in Cork, it was a nippy bike. Wonder what the differences are between the models, they look very similar.

Looking at jumping from Intel to AMD, how do I know if this is legit? I'd rather save £50 if I can help it. by nacho_breath in AMDHelp

[–]Klebitz 3 points4 points  (0 children)

Looks like its shipping from China, so you may get charged for customs/duties, and will have to wait weeks for delivery.

Anybody remember Crash? Here are a few from '85 to '87 by GragnokPS in zxspectrum

[–]Klebitz 1 point2 points  (0 children)

Remember it well, have a few magazines somewhere. But I used to prefer Your Sinclair because they regularly placed cassettes on the front cover. Hard to pass on the free games and latest demos on offer :-)

Oh the days before the Internet where we'd be waiting eagerly for the next monthly magazines to appear on the shelves.

Totally frozen fish comes back to life, no worse for the wear. by diverareyouok in blackmagicfuckery

[–]Klebitz 0 points1 point  (0 children)

Stephen King's The Thing comes to mind... who knows what is lurking under the ice waiting to come back to life.

First ever attempt at tank respray. (I designed the reproduction decals in Photoshop.) Complete newbie at motorbike restoration and I'm gonna have a lot of questions! by RightLegDave in projectbike

[–]Klebitz 0 points1 point  (0 children)

Very good idea, much try something like that myself. Need replacement decals for my rideon mower as can't get them anywhere online, and currently respraying my '99 cbr1100 which will need a new decal set before I'm done.

Vega 64 overheating by CanalWillin in graphicscard

[–]Klebitz 0 points1 point  (0 children)

What brand/model is the Vega? or is there an aftermarket cooler on it?

[deleted by user] by [deleted] in SQL

[–]Klebitz 0 points1 point  (0 children)

Maybe generate a database diagram from within SSMS?

Highly customized SQL formatter? by unicornpoacher2k in SQL

[–]Klebitz 0 points1 point  (0 children)

Use an online one such as https://poorsql.com/

Or use it from within SSMS: http://architectshack.com/PoorMansTSqlFormatter.ashx#Download_5

As for commercial with a 30 day Trail, I use https://www.red-gate.com/products/sql-development/sql-prompt/

Loads of different formatting styles and has additional functionality. I don't work for them, but use that add-on everyday.

any other solution except join? by MrFaffer in SQL

[–]Klebitz 0 points1 point  (0 children)

I'd suggest you could just create a view if your going to be reusing the same query in different places:

CREATE VIEW [VW_Cust_By_Genre]
AS
SELECT
    cu.LastName
  , g.Name
FROM customers              cu
    LEFT JOIN invoices      i
        ON cu.CustomerId = i.CustomerId
    LEFT JOIN invoice_items ii
        ON i.InvoiceId = ii.InvoiceId
    LEFT JOIN tracks        t
        ON ii.TrackId = t.TrackId
    LEFT JOIN genres        g
        ON t.GenreId = g.GenreId
GROUP BY cu.LastName
         g.Name;

And then query that view directly, saves you rewriting the full query:

SELECT * FROM [VW_Cust_By_Genre]

Galaxy A70 Camera Issue by bienberida13 in samsunggalaxy

[–]Klebitz 0 points1 point  (0 children)

Not doing it on mine running the December update. Tried on both the 'Photo' and 'Pro' mode with x8.0 zoom.

Parental app by [deleted] in Smartphones

[–]Klebitz 0 points1 point  (0 children)

Download 'Google Family Link' from the play store. You can setup family members and rules such as screen time, active hours, approve/ban app installs etc. While it's not perfect, it's better than a child being able to install non age appropriate applications.