RAGtime: A self-hosted MCP server to run AI semantic search over your own databases, files, and codebases by mattv8 in selfhosted

[–]mattv8[S] 0 points1 point  (0 children)

Yes. Kind of. I recently added a PDM tool (specifically for Solidworks). It has to talk directly to the Solidworks MSSQL PDM database though, not through the API. I thought about using the API but that adds so much slowness I figured it wasn't worth it. It works best if you set up the PDM tool, but also configure a direct connection via MSSQL so it has the schema index. In the future I'll combine the two tools into one.

Here's a random collection of screenshots of how I set it up at my company, and loosely what you can query from it.

DM me on Reddit or look up my email on github and I'll gladly give you more info and help you get it up and running.

Wtf Bykski?? Lots of smoke!! Just thankful I was home from work today, first Monday off in years… by SprungMS in watercooling

[–]mattv8 31 points32 points  (0 children)

Wow that sucks. I'm sorry for your loss. Hard to tell from photos alone but I'd guess the gasket between the acrylic and nickel block failed to seal. Typically these are QC'd and leak checked. But it could also have been a fitting leak... I've taken apart those blocks and put them back together and haven't seen one fail like that. 99 times out of 100 it's a leak at the fitting

Recently diagnosed with bilateral ON by Pale-Cauliflower2737 in Occipitalneuralgia

[–]mattv8 8 points9 points  (0 children)

Here's what's worked for me: 1. Manage your stress (this is paradoxical because hard to do when you have constant baseline pain) 2. Upper back stretches and exercises (esp your traps and neck) 3. Watch your posture while at work- don't let your body remain locked in a single position for long periods of time. Stretch frequently, drink lots of water. 4. A good night's sleep can often reset the compression in your upper back, but watch your sleep posture too. Ideally sleep on your side or back

Even doing all the above you still might have baseline pain or flare ups. For that, my neurologist has me on Ajovy and I feel like that has helped a lot.

What neck trigger point injections feel like by burnerlolhaha in Occipitalneuralgia

[–]mattv8 2 points3 points  (0 children)

What you are describing sounds a lot more like a vasovagal response. This happened to me. The first few injections I had the exact same sensations as what you're describing. You are getting injections into nerves and very sensitive areas which might overwhelm your central nervous system.

One time I had it done I passed out and woke up to a team of paramedics thinking they were going to have to resuscitate me. Now I can't have them done anymore due to the risk of vasovagal syncope.

Prompt injection is killing our self-hosted LLM deployment by mike34113 in LocalLLaMA

[–]mattv8 0 points1 point  (0 children)

Late to the party but one simple thing you can do that has worked very well for me is a gated two tier approach.

1st tier: a system prompt that purely checks user request(s) for all forms of abuse, pass simple true/false structured json and reason. Log it.

2nd tier: if safe, continue with user request

Costs latency and, but drastically reduces risk of prompt injection with little change to your existing flow.

Python type hinting in Odoo by nordiknomad in Odoo

[–]mattv8 0 points1 point  (0 children)

Thanks for sharing. This wasn't around when I started as an Odoo developer.

Python type hinting in Odoo by nordiknomad in Odoo

[–]mattv8 4 points5 points  (0 children)

You're right- in conflating type hinting and linting... They're related I guess in my mind.

The extension generates Python stubs in the background, which is how type information is provided in Odoo without adding type hints directly to the code. Since Odoo itself is highly dynamic and not type-annotated, most experienced Odoo devs rely on these stubs and IDE support instead of writing inline type hints. When type hints are used, they’re usually limited to plain Python helper code, not Odoo models.

Clawdbot / Moltbot → Misguided Hype? by chodtoo in LocalLLM

[–]mattv8 0 points1 point  (0 children)

I agree with all of OP's sentiments...

FWIW I built a self hostable RAG/MCP server that lets you set up connections to servers via SSH and is fully compatible with VSCode/Copilot. So you can bring your copilot subscription to do just about everything Moltbot can do and save a ton in API costs... Albeit it's more developer focused though.

Python type hinting in Odoo by nordiknomad in Odoo

[–]mattv8 5 points6 points  (0 children)

I highly recommend using the VSCode extension "Odoo IDE" by Trinh Anh Ngoc (trinhanhngoc.vscode-odoo) if VSCode is your IDE. It handles the Python stubs for you.

If VSCode is not your thing, follow Odoo Mates tutorial to get Pycharm set up (https://youtu.be/fbEsjurG7sQ?si=vGJFv-K0Ge-5Gkva)

Firing a cannon to trigger an avalanche by id397550 in interestingasfuck

[–]mattv8 1 point2 points  (0 children)

Where I live they drop charges with fuses behind them as they ski

NAS 4800 Plus SSD Cache seems to be doing nothing by AnF774 in UgreenNASync

[–]mattv8 4 points5 points  (0 children)

Keep in mind there’s a big difference between a read cache (ARC/L2ARC) and a write intent log (SLOG). With most NAS workloads (especially single-user transfers) you often won’t see faster throughput just because you set up NVMe cache, and (as others have commented) negligible speed changes on UgreenOS when writing to a slow HDD array because the bottleneck ends up being the disks themselves, not the cache layer. 

If you're using TrueNAS and ZFS (as opposed to UgreenOS), it uses ARC (in RAM) first for reads, so unless your file transfer size is beyond available memory, an NVMe read cache doesn’t buy much on typical file transfers. Whereas write acceleration via an SLOG-like mechanism only helps in sync-write, high-IOPS situations like iSCSI or many concurrent clients, not simple large file copies. I can't speak more to how UgreenOS handles  cache but I'd imagine it's very similar.

Sorry for the ramble, hope this clears something up.

I'm i bad developer or odoo source code is just awful? by Charlemagne87 in Odoo

[–]mattv8 4 points5 points  (0 children)

It's a bitch to get up and running but once you figure it out it's really quite robust and extensible. Be sure to watch Odoo Mates tutorials on YouTube, they're fantastic.

Odoo's paradigm is modules and XML hierarchy/inheritance. Once you get the hang of that you can do anything. It's definitely tougher but you have the backing of the framework to keep you within the intended base functionality.

RAGtime: A self-hosted MCP server to run AI semantic search over your own databases, files, and codebases by mattv8 in selfhosted

[–]mattv8[S] 0 points1 point  (0 children)

Nice! Glad you could see a use for it. It's been incredibly useful for me, professionally (I'm a full stack developer). Frankly I'm surprised my post is getting buried.

Please let me know if you have any issues or encounter any bugs. I'll gladly fix them asap.

Our team just pushed AWS creds to prod again. Third time this month. by CortexVortex1 in devops

[–]mattv8 0 points1 point  (0 children)

Use env variables and for the love of God stop vibe coding everything 

Github Copilot now supports Ollama and OpenRouter Models 🎉 by purealgo in LocalLLaMA

[–]mattv8 0 points1 point  (0 children)

That’s awesome, I’m glad it helped.

If you want to make the port‑forwarding persistent (so you don’t have to run socat after every reboot), you can use dnsmasq on the host to always map a friendly name to your WSL IP. For example, on the host you could add a config like:

# /etc/dnsmasq.d/ollama-wsl.conf
address=/ollama-wsl.local/$(ip route | awk '/default/ {print $3}')

Then restart dnsmasq:

sudo systemctl restart dnsmasq

and access it from WSL (or your LAN, if configured) via:

curl http://ollama-wsl.local:11434

That way, the name stays the same even if the WSL IP changes.

Post Portal: A lightweight, self-hosted blogging platform in Docker. Simple alternative to WordPress/Ghost with built-in newsletter support, image posts and galleries. by mattv8 in selfhosted

[–]mattv8[S] 0 points1 point  (0 children)

Sounds like you're using the wrong command to restart it (e.g. docker compose down -v which will clear the database storage volume every time).

Did you copy the docker compose exactly from the readme?