What should an office self host? reddit / selfhosted ---------------------------------------------------------------------- pak-ma-ndryshe · 2023-11-27 22:46 More interested in file storage, project management, time rapporting, client acquisition etc. What else would you add? ---------------------------------------------------------------------- Door_Vegetable · 2023-11-27 23:13 What exactly does this office do? Without knowing it’s like asking how long is a piece of string. ---------------------------------------------------------------------- DrunkOnKnight · 2023-11-27 23:16 I run a small business and I recommend PaperlessNGX. Great way to organize invoices, receipts, P&Ls and so on. Plus OCR makes it really easy to grab lines of a document and put things into spreadsheets. For spreadsheets control I recommend Grita. Open source community sadly doesn’t have anything quite like tableau. But Grita is the closest I’ve found, for doing things like data cleaning, and visualization. ---------------------------------------------------------------------- digi_dev_047 · 2023-11-27 23:28 Can’t find anything called Grita, was it a typo? I would love to check it out ---------------------------------------------------------------------- d-cent · 2023-11-27 23:39 Nothing if it can't afford to pay for a person to maintain it. ---------------------------------------------------------------------- Naive_Cockroach_5215 · 2023-11-28 00:08 Obviously it's not an office where they bake cookies and brownies for a living..... username checks out ---------------------------------------------------------------------- DrunkOnKnight · 2023-11-28 00:15 Oops yea, Grist https://www.getgrist.com ---------------------------------------------------------------------- Disastrous-Account10 · 2023-11-28 00:16 I work for a crowd that only does foss or what ever we can build ourselves PABX is done locally File servers of course, Asset management and tracking built in house Time and attendance built in house Generator management Mail server for outbound mails Projects board Several internal websites ---------------------------------------------------------------------- user01401 · 2023-11-28 00:37 Put LibreOffice on all the desktops and GnuCash is a great highly customizable accounting program. ---------------------------------------------------------------------- Door_Vegetable · 2023-11-28 00:54 How’d you come to that conclusion? Project board could be used for managing teams, file storage for storing previous brownie baking data. Looking for clients and building rapport with potential clients is also required for a food business. ---------------------------------------------------------------------- vnagornyy · 2023-11-28 01:08 You can self-host Nextcloud and enable many of its apps to get what you need: file sharing, office suite and collaboration, chat and video conferencing, project management, wikis, and much more. Switched from Google Workspace in September. Very happy. ---------------------------------------------------------------------- SagaciousZed · 2023-11-28 01:18 Have you used Apache Superset? I've whipped that out once for creating visiting and that was the closest thing I found to Tableau. ---------------------------------------------------------------------- from-nibly · 2023-11-28 03:47 Your business should focus on what makes it special. Printers don't make banks special so they should NOT make their own printers. Anything except what makes your business special is a DISTRACTION, that especially means software. Buy anything that is even remotely like a printer. Conversely if there is something that makes your business special, YOU must do it yourself. If that means self hosting some open source thing it ALSO means you need to become maintainers of that open source thing. Own the things you need to be good at outsource EVERYTHING ELSE, no exceptions. Here's a really gray example to drive this home Let's say there's some part of your business that needs to print invoices on paper that's as thick as blue jeans. You look and look and look and no one sells printers that print on that kind of paper. You have two options, 1. Realize that it's probably dumb that you are trying to print on paper that thick and change your business to deal with regular paper, or 2. Decide that that's what makes your business special and start manufacturing printers. ---------------------------------------------------------------------- from-nibly · 2023-11-28 03:55 To drive this home even further. Most print shops don't even make their own printers. Their process, turnaround time, customer service, heck maybe even their location is what makes their business special. ---------------------------------------------------------------------- MRobi83 · 2023-11-28 04:02 Grocy to manage ingredient inventory. Mealie to store recipes... Wanna start a bakery with me? 😂 ---------------------------------------------------------------------- [deleted] · 2023-11-28 05:32 [removed] ---------------------------------------------------------------------- umairshariff23 · 2023-11-28 06:00 Have you tried metabase? I've setup a couple of dashboards and I've liked it so far ---------------------------------------------------------------------- DrunkOnKnight · 2023-11-28 07:19 Holy crap this somehow flew under my radar. Spinning it tomorrow to give a try, thanks! ---------------------------------------------------------------------- DrunkOnKnight · 2023-11-28 07:22 Never heard of this one either, think I’m gonna spin this one up as well. I’ve got years worth of data I can feed these things so I’ll probably play around with each and do a write up on things I like and don’t like about each. ---------------------------------------------------------------------- Imdibs · 2023-11-28 09:16 i use Nextcloud for file storage and project management, it's been solid for time reporting and client acquisition too. might be worth checking out for your office! ---------------------------------------------------------------------- Simplixt · 2023-11-28 11:31 Ask your IT-Guy. If you don't have one, you shouldn't selfhost at all as a company. ---------------------------------------------------------------------- CaffeinatedTech · 2023-11-28 12:24 Whatever you do, make sure your backups are solid. Consider it while you make decisions on what software, and services to use. "I'm going to set up nextcloud today, how am I going to back that shit up?" ---------------------------------------------------------------------- umairshariff23 · 2023-11-28 15:06 I'd appreciate it if you could share that writeup here! Meanwhile, here's a [dashboard](http://metabase.dragons- den.zone/public/dashboard/0c2cdffc-df0e-4a9c-867b-3595a1169096) I created last weekend using metabase ---------------------------------------------------------------------- SillyLilBear · 2023-11-28 15:10 Do you know what the limitations of this is when using free self hosted option? I currently use MetaBase but I was looking for something with more features. ---------------------------------------------------------------------- SillyLilBear · 2023-11-28 15:10 Metabase is good, but it is pretty simple. ---------------------------------------------------------------------- SagaciousZed · 2023-11-28 16:04 I'm not sure what you mean by limitation? Limitations compared to what? It's Apache Foundation software, so the self hosted version is the full software. As far as I know, Apache doesn't even offer a managed hosting solution. There are third-party managed service providers but I can't tell you what those providers added. When running everything locally, you will probably want your own database such as PostgreSQL or Apache Druid, etc. For data processing Apache Spark, etc. So hardware wise, I found this to be fairly heavy.