1

Ciao, alternativa a Power BI / Qlik / SAP Analytics per chi non vuole mandare i dati aziendali nel cloud. Lagotto BI: BI self-hosted per PMI manifatturiere con ERP MSSQL. Installi in azienda, i dati restano in azienda. FREE sempre gratuito. PRO gratis in beta. https://lake8.dev/early-access ๐Ÿ•

2

Ciao a tutti.

Ho fatto un BI self-hosted per le PMI italiane che usano gestionali MSSQL. Si chiama Lagotto BI.

Il problema che risolve: i dati sono nel gestionale ma non si riescono a vedere in modo autonomo. Ogni analisi richiede il consulente o un export Excel.

Lagotto BI si connette al gestionale in sola lettura, sincronizza ogni 5 minuti su MariaDB interno, e mostra dashboard interattive. Nessun dato esce dall'azienda.

Stack: FastAPI + Vue3 + MariaDB. Self-hosted, licenza FREE sempre gratuita.

White paper tecnico con architettura e screenshot reali: Lagotto BI

Early Access aperto, 10 slot: lake8.dev/early-access ๐Ÿ•

[-] Tommy2970@feddit.it 5 points 2 weeks ago

Ciao, messaggio ricevuto. La prossima volta preparerรฒ il post appositamente per te. Se mi mandi le specifiche IEEE ti prometto che farรฒ del mio meglio per rispettarle. Buona serata.

[-] Tommy2970@feddit.it 4 points 2 weeks ago

Deal! Work hard, find truffles, get tortellini con burro e tartufo. Best salary package in the industry. ๐Ÿ˜€

[-] Tommy2970@feddit.it 8 points 2 weeks ago

He's a Lagotto Romagnolo โ€” a breed selected for centuries specifically for truffle hunting. It's literally in his DNA. Training starts as a puppy: you hide small pieces of truffle in the garden and let him find them. Now the only way to make him truly happy is to let him run free in the woods โ€” and you run behind him ๐Ÿ˜„ When he finds one, he expects a proper reward. I'm from Bologna, so his payment is a tortellino per truffle. Fair trade. ๐Ÿ˜

[-] Tommy2970@feddit.it 4 points 2 weeks ago

My dog and I [โ€ฆ]โ€ is proper English grammar.

Itโ€™s impolite for you to be first in the list of beings. โ€œMe is 100% realโ€ is wrong, itโ€™s โ€œI am [โ€ฆ]โ€ Your AI needs a grammar upgrade. ๐Ÿ˜‰ thk :-) Grammar noted and appreciated! My dog and I are 100% real. BASIC would have caught that error, but he was busy finding truffles. :-)

[-] Tommy2970@feddit.it 6 points 2 weeks ago

Ah, yeah, we donโ€™t like Google here either. Ciao! At this rate I'll have to rewrite everything in carrier pigeons. :-)

[-] Tommy2970@feddit.it 6 points 2 weeks ago

Ciao! I'm Italian โ€” my English is not exactly my strongest skill. But if AI-assisted translation bothers you, I can always switch to Google Translate ๐Ÿ˜Š Hope that's reassuring enough.

[-] Tommy2970@feddit.it 12 points 2 weeks ago

This is BASIC โ€” my Lagotto Romagnolo. Official lake8.dev mascot and uptime monitor. He also finds truffles. ๐Ÿ˜

[-] Tommy2970@feddit.it 9 points 2 weeks ago

Ciao! I'm Italian ๐Ÿ‡ฎ๐Ÿ‡น โ€” my English is very "pasta asciutta" level. I use AI to help me write without saying something cosmically wrong. Sorry for that. But me and my dog are 100% real. ๐Ÿ•

[-] Tommy2970@feddit.it 11 points 2 weeks ago

Here's my "cloud infrastructure" Air conditioning โ€” NO Sterile environment โ€” NO Dedicated server room โ€” NO Enterprise-grade monitoring โ€” is BASIC (BASIC is my Lagotto Romagnolo. He checks uptime personally.)

[-] Tommy2970@feddit.it 7 points 2 weeks ago

You're completely right, and thank you for saying it directly. Let me try again in plain English: I run a small software company from home. Instead of paying โ‚ฌ50-100/month for hosting, email, and analytics services, I built everything on a โ‚ฌ60 Raspberry Pi computer sitting next to my router. What's actually running on it:

The website you're reading about (like any website, just hosted at home instead of on AWS) Email โ€” when someone writes to info@lake8.dev, it lands on that Pi Analytics โ€” that world map showing where visitors come from

That's it. Three things, one small computer, zero monthly fees. There's also a green angle that rarely gets mentioned: the entire setup draws around 3-4W idle โ€” less than a LED light bulb. A data center rack serving the same traffic would consume orders of magnitude more. Self-hosting at this scale isn't just cheaper, it's genuinely lighter on the planet. The complexity you're seeing is real โ€” it took months to set up and I have 20+ years of experience. I'm not going to pretend it's for everyone. It isn't. But that's also why I built Lagotto BI โ€” our actual product โ€” which does the opposite: takes complex business data and makes it readable for people who just want to understand their business, not manage servers. So yes, "software house" is my small business. The Pi is just how I run the infrastructure behind it without paying cloud prices forever. Thanks for the honest feedback โ€” it's genuinely useful. thk :-)

[-] Tommy2970@feddit.it 7 points 2 weeks ago
[-] Tommy2970@feddit.it 5 points 2 weeks ago

Inbound: sender โ†’ port 587 โ†’ Postfix โ†’ Dovecot โ†’ Roundcube Outbound: Postfix โ†’ Brevo relay โ†’ recipient Thk

241

A few months ago I decided to self-host everything for my software house instead of paying for cloud infrastructure. Here's what's running on a Raspberry Pi 4B (4GB) at home:

Astro static site + nginx Full mail stack (Postfix + Dovecot + Roundcube) in Docker MariaDB with automated backups GoAccess analytics with custom Python bot/human separation Dynamic IP blocklist generated at every deploy Certbot managed on a separate Orange Pi Zero 3 (HAProxy + SSL termination)

The Orange Pi Zero 3 as a dedicated HAProxy node was the best โ‚ฌ25 I spent โ€” SSL overhead completely offloaded from the Pi, all subdomains routed through one config, clean network separation between "what faces the internet" and "what runs the services." Storage: all boards boot from SSD via USB3. No SD cards in production. The ISP situation: Eolo wireless, 20Mbps down / 100Mbps upload. Yes, upload is 5x download. For a web server that's actually ideal. Real stress test โ€” June 22, 2026 A post on r/italy hit 20k views in 24 hours. Numbers that day:

555 human visitors (vs ~180 daily average) 151 unique IPs 72.2% return rate 9.98 MB bandwidth 0 downtime 0 errors in the mail stack

PageSpeed from Google's infrastructure:

Desktop: Performance 100 / SEO 100 Mobile: Performance 97 / SEO 100

No CDN. No Cloudflare. No edge nodes. Just nginx on a Pi. The honest limitations:

Single point of failure โ€” yes, if the Pi dies the site goes down Mail deliverability on residential ISP is hard (Brevo relay helps) No redundancy โ€” we run backups, not replicas

All traffic data is live and public: stats.lake8.dev/geo.html Happy to answer questions on any part of the stack.

view more: next โ€บ

Tommy2970

joined 2 weeks ago