• 1 Post
  • 21 Comments
Joined 1 year ago
cake
Cake day: June 11th, 2023

help-circle
  • The Lemmy app we are using on our phones needs to download content from Lemmy so it can be displayed to us. Lemmy might just have one big file full of links, but that’s annoying to have to write code to handle. Or it might have a folder full of files where each file is a post, but that’s also a bit annoying to write code to manage.

    It (probably) uses a local SQLite database to store all of the cached posts.

    Conceptually, a database is just a place to store things, just like a big text file. The database just handles a lot of the grunt work for you and makes it easier to search, organize, and filter the data.

    So anywhere there is data, there could be a database.


  • I see you got your answer, but I’m adding on for anyone else that comes across this.

    For me, I learned the most when I had a disposable and replaceable system. When I was dual booted I was too scared to touch anything in case it fucked everything up. Once I started poking round on a Pi, LiveUSB, etc it was a lot easier to learn because I could always restart.

    Id start there with something like Mint or Ubuntu. Then set it up in a way where you can easily replace your OS so you can reset it often and fuck around. Then just learn as you go.



  • It really isnt bad. I do most of my computer at home so I really only need a small cloud box to pipe things through when needed.

    And I could reduce the B2 price a lot with some deduping of my data, but that’s an ongoing and painfully slow process since I was too reckless with my local backups in the past, so $7 to avoid that process is worth it.

    And for electric I suspect it’s pretty low. I’m running 3 raspberry pi, a 4 bay NAS, and one micro PC and I live in an area with pretty cheap electric already. I think my gaming machine probably takes more power in a few hours than the rest of the system does in a day.










  • That’s a shame. I didn’t realize it was that locked down. Ive had a lot of terrible routers but all the ones I remember allowed me at least a port forward.

    I think OP can accomplish some of the same result if he can get a cheap VPS to connect through (have the laptop Wireguard to the VPS, then have a proxy on the VPS forward to the laptop over the VPN, but that’s probably not worth the hassle for a starter project unfortunately.


  • With most consumer wifi networks you can usually enable port forwarding. That would let you access services from anywhere.

    Personally I would set up a Wireguard VPN server on the laptop and enable port forwarding only for the Wireguard port. This will let you access your laptop from anywhere, and it will protect you by limiting your attack surface (basically you only need to have a device Wireguard connection and you don’t need to worry as much about securing every other service you want to run).

    Then I’d set up dynamic DNS with any DNS provider so you don’t need to keep track of a changing IP.

    Then you can install whatever services you want on the laptop and you’ll be able to access them from anywhere by connecting to the Wireguard VPN. It does mean you can’t easily let a friend access a service on your laptop, but the tradeoff is you don’t have to worry as much about security while you’re learning.