[sgarland]

I get the appeal, but am also horrified at the “let’s pipe scripts to bash with sudo,” and the lack of visibility into what the DB is doing.

I am a huge proponent of running your own, but along with that comes a responsibility to know what you’re doing. If you don’t know how to harden a Linux box on your own, frankly you have no business hosting anything on it. Spin up a VM and learn from your mistakes first. Similarly, I maintain that if you don’t know how to administer and tune an RDBMS, you shouldn’t be using it for anything that matters.

If you think this sounds like gate-keeping, I’d ask you to re-read what I wrote. I think you have a responsibility to others who are relying on your skills to know what you’re doing, or at the very least, understand enough about their fundamentals to know how to reverse mistakes.

[hunvreus]

I have a draft ARCHITECTURE.md file in the repo: https://github.com/hunvreus/devpush/blob/main/ARCHITECTURE.m...

I'm also working on adding manual steps so that folks who prefer to deploy the app themselves can do so.

I initially had the app deployed with Terraform + Ansible, but rewrote it as a bash script as I thought it'd be lower friction.

[sgarland]

Thanks for this. I want to clarify something: the “you” in my post was directed at users of a product like this, not you, the creator.

Re: lower friction, you’re probably correct, though that also brings with it concerns like those that I posted. While installing Terraform and Ansible isn’t difficult, it might keep people away who have no interest in any form of systems administration, and so we come full circle again.

[hunvreus]

That's all good.

And this is definitely more targeted at programmers who just want to deploy their app and may have limited interest in DevOps/sysadmin/servers.

[dmoose]

I agree with this point completely and have been maintaining at least a few linux servers for many years now. However, I never feel completely comfortable about it because it is not my primary responsibility and I know the target is always moving. If you have any good resources to recommend for current best practices I'm sure they would be useful for me as well as anyone deploying this kind of tool.

[hshdhdhehd]

Doing all that on your own server is fun and not too hard IMO. Like if you can learn React this is orders of magnitude easier but perhaps way more boring or beneath people?

I mean for DB I run a prod mariadb on hetzner and it is arguably easier to install and setup than say things most devs use, say vscode. Had to tune a couple of things (number of allowed connections for a user) but lots of good docs out there to help.

[h33t-l4x0r]

Or better yet just have AI go over it, because who has the cognitive bandwidth to audit every FOSS project on top of everything else they have to get to today

[sgarland]

This does not solve the problem of knowing what you’re doing. If anything it makes it worse, because you think you understand it.