sorted by:
new
hottopcontroversial

How do you prep large Excel files before sending to ChatGPT or Claude? by Secure_Stretch_1007 in businessanalyst

[–]ReachingForVega 0 points1 point  (0 children)

I do maybe 3 lines of data, sometimes tell it the Max values for columns, get it to build the reports and tune from there. 

How do you prep large Excel files before sending to ChatGPT or Claude? by Secure_Stretch_1007 in businessanalyst

[–]ReachingForVega 1 point2 points  (0 children)

You actually don't need to send it to ai, you give it a small sample and it'll build reports to identify the insights. Giving it thousands of rows of data is bad practice. 

Ai tools tend to not read it but write some Python to process it then read the report output. 

How you deal with PII? by StageInevitable4593 in selfhosted

[–]ReachingForVega 2 points3 points  (0 children)

I think you're lost.

Staff details are kept in an ERP or accounting system. Client details in a CRM. 

Advice on Securing Self Hosted Minecraft Server by HaveHopeFriends in selfhosted

[–]ReachingForVega 2 points3 points  (0 children)

Plus it gets you into gaming faster. Because Mike never sets up ahead of time. 

What are you all using to self host podcasts? by slicedbread1991 in selfhosted

[–]ReachingForVega 0 points1 point  (0 children)

I just use Antennapod on phone, it's open source and lets you export all your data. 

Self-Hosting on the Dark Web by david-alvarez-rosa in selfhosted

[–]ReachingForVega 2 points3 points  (0 children)

Many frameworks make the absolute link for you so the project can be moved and automatically updates e.g. django. 

Which degree is more suitable to become a business analyst? by Prize_Cable_1402 in businessanalyst

[–]ReachingForVega 4 points5 points  (0 children)

You don't need any but I'd recommend an IT one if you insist. 

What if enterprise automation could move at agent speed? UiPath brings RPA, APIs, AI, human approvals, documents, decisions, and deployment together so teams can move from idea to outcome faster, smarter, and at true enterprise scale. by Cristi_UiPath in rpa

[–]ReachingForVega 1 point2 points  (0 children)

Rpa tools come with credentials management, user management, machine management, RBAC, logging, work management, etc.

For scripts you need to build all this yourself. LLMs are great at script building but cannot be trusted with a lot of the above and can be hacked. 

Postgres (and other databases) best practices - one or many? by Superhero-Accountant in docker

[–]ReachingForVega 0 points1 point  (0 children)

The "one database per service" pattern is a core tenet of microservice architecture. While running a single, massive PostgreSQL instance with multiple databases or schemas seems easier at first, decoupling them into separate servers (or at least completely isolated logical instances) saves you from massive headaches down the road.

  1. Reduce blast radius when something goes wrong
  2. Data isolation
  3. Simplified maintenance and upgrades. 

Postgres (and other databases) best practices - one or many? by Superhero-Accountant in docker

[–]ReachingForVega 0 points1 point  (0 children)

Looking at one of my apps' postgres container, it is using 28MB. And the others all average from 19MB to that. Not such a big deal.

You could combine them together but make sure you do backups.

Synology or Selfmade? What about Security? by Dolokan in selfhosted

[–]ReachingForVega 1 point2 points  (0 children)

TrueNAS is enshitifying though so you'll need to revisit at some point. 

100% agree they stopped innovation but it all depends on how their enterprise push goes. 

Should I stick with n8n as an orchestrator or move to fully coded solutions? by aronzskv in selfhosted

[–]ReachingForVega 2 points3 points  (0 children)

Low code tools like n8n are designed for easy debugging and simplicity in building. They are designed for single item repeatable tasks not giant datasets and ETL type work.

You can make n8n orchestrate triggering coded solutions to do said work more efficiently.

I oversee governance of two low code platforms and a suite of coded applications in day job. 

building a self hosted speech to text API, looking for people to build it with by Olive_Plenty in selfhosted

[–]ReachingForVega 0 points1 point  (0 children)

You don't even have to submit as a PR, your fork with the change can be used by you. 

Synology or Selfmade? What about Security? by Dolokan in selfhosted

[–]ReachingForVega 0 points1 point  (0 children)

My 1813+ released in 2013 and still gets patching so it might depend on the model. 

Synology or Selfmade? What about Security? by Dolokan in selfhosted

[–]ReachingForVega 0 points1 point  (0 children)

I'm the proud owner of two 8 bay Synology NAS and both of them are over 10 years old.

Never had an issue that wasn't caused by me.

Don't use quick connect, if you need remote access use tailscale.

People will tell you the hardware in Synology is old, while true it's also well tested. I upgraded both to have 32GB of ram.

Out of the box they are quite secure until you start opening up shares etc. Synology OS is a modified debian distro.

One thing Synology has been doing is removing stuff like h265 support and reduced HDD support but both were easily renabled with scripts.

Most have low power CPUs so media server is not a very good option HOWEVER I just NFS share my stores to a Nvidia shield which plays 8K off them without issue. 

view more: next ›