Create a user defined table type and use that as a parameter. I’m not sure what the postgres name of that is.
User formerly known as raginghungrypanda@lemm.ee
- 0 posts
- 17 comments
- ragingHungryPanda@lemmy.ziptoProgramming@programming.dev•Cursed knowledge we have learned as a result of building Immich that we wish we never knew.11 months
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Help me figure out the way to scale laterally?English
11 monthsIt sounds like you’re diving right in. If you go that route, one thing I found was that Ceph wants to work with while drives only, not partitions. I switched to using longhorn so I could take advantage of all of my storage without throwing any away
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Help me figure out the way to scale laterally?English
11 monthsId say don’t go down the distributed software route just yet. An option is to keep the NAS and set up a new computer with your router or whatever handling dns to it for services. You should be able to use NAS storage over the network. It’ll be slower, but let’s say you put your database on the big one, then it shouldn’t be so bad since you’ll just make database calls to it.
There are a lot of options. I’m currently learning kubernetes and all that stuff is a big learning curve, so avoid that stuff.
My thoughts: you can do some simple dns load balancing between the two servers at whatever level is handling that. Set up a database on the storage server and let the new computer communicate to it over the network.
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Is there anything like a self-hosted version of medium of substack ?English
1 yearThose are the built in templates, what you add is your markdown for your post. You’re not actually adding that. It isn’t quite click to save, but it’s similar. Write freely may be the closest bet for free
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Is there anything like a self-hosted version of medium of substack ?English
1 yearThis was a pretty good demo of hugo, a static site generator: https://youtu.be/MX4yy1dTVYg
What about AdGuard home, set your router to use your server as a DNS and get local network dns with adblocking?
I got 10/28, but I was crying after the 7th question
You’re running these commands on the same machine as yunohost, right, not from another computer?
To add: (I’m just going down the checklist here https://developers.cloudflare.com/cloudflare-one/connections/connect-networks/)
- Can you show us that cloudflared is actually running. I wanna see it
- Does your firewall allow the connection
Here’s the troubleshooting page
https://developers.cloudflare.com/cloudflare-one/connections/connect-networks/troubleshoot-tunnels/-
Have you gotten to the authentication step?
-
What do the logs say?
https://developers.cloudflare.com/cloudflare-one/connections/connect-networks/troubleshoot-tunnels/diag-logs/
Wait, failure to connect to local host? That’s your own computer, whatever endpoint isn’t going through cloud flare. Most apps respond to ports 80/443. You need to either route those to your computer, or in docker route whatever port you want it on to your app. If you have just one app/website, you can do 80/443 universally to the app. If you have more than one, route them to a reverse proxy that can take a domain or sub-domain name and route them to the ports your apps are on.
But yeah, you really need to provide more info.
What’s your environment? What’s your config, setup, etc?
One thing I recently found out is that ceph wants whole drives. I could not get it to work with partitions. I got it to work with longhorn, though I’m still setting things up.
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•What is a self-hosted small LLM actually good for (<= 3B)English
1 yearI’ve run a few models that I could on my GPU. I don’t think the smaller models are really good enough. They can do stuff, sure, but to get anything out of it, I think you need the larger models.
They can be used for basic things, though. There are coder specific models you can look at. Deepseek and qwen coder are some popular ones
I didn’t move shit haha. Dumped OneDrive onto the Nas and mounted it for next cloud, I didn’t even clean out the photos, which I copied into immich. I did move some ebooks, but that was very few things that I have
- 1 year
I used to. I once turned a laptop into a Windows media server just to host movies and music for the house. That was fun
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•First server: Buying hardware in a developing countryEnglish
1 yearAnything that fits the socket and has the IO and form factor that you need is fine
- ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•First server: Buying hardware in a developing countryEnglish
1 yearYou may be overestimating your requirements a bit. For video, all you need is something with a transcoder and it could handle at least one stream. If this is just for you, it’ll be idle most of the time. As long as the hard drives have good reviews, it’ll be fine.
What you listed sounds good. I have my entire family’s files and photos (with some duplicates that i never removed) and it comes out to less than 1TB.
I think your idea sounds fine. An old PC will do fine.

Based on old memories since I’ve been working in mongo lately, after making the UDT on the db side, you make a data table that has the same name, namespace (ie dbo/public), and the same schema as the UDT (better if that could be generated) and populate it in code. Then you execute the db query with the UDT type as a parameter.
This is better for a few reasons, including not building up a string, but also having the same text means that each query didn’t need to be re-parsed and can reuse execution plans. If the query text isn’t an exact match, it gets that whole pipeline each time.