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
- 23 Comments
ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Help me figure out the way to scale laterally?English
2·5 months agoIt 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
7·5 months agoId 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
3·5 months agoThose 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·5 months agoThis was a pretty good demo of hugo, a static site generator: https://youtu.be/MX4yy1dTVYg
ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•What else should I self-host?English
6·5 months agoWhat 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/
I like your version better
Atlanta. Dyac 🤦♂️
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?
I actually didn’t know that. I would mouse over and look at the url.
Atlanta!!! Here’s a random video i haven’t watched about it. The Atlanta doubles your spear throwing range https://youtu.be/YT_s1CEAhkA
I haven’t used that, but I did rent a pocket wifi while on a trip once. It worked really well.
ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•Kubernetes storage backendsEnglish
2·6 months agoOne 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
4·6 months agoI’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
ragingHungryPanda@lemmy.zipto
Selfhosted@lemmy.world•The hidden cost of self-hostingEnglish
2·6 months agoI 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
ragingHungryPanda@lemmy.zipto
RPGMemes @ttrpg.network•Car Talk with Martok: Naturally Won
1·6 months agoYaaaaay more Car Talk!


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.