dokku-postgres VS Dokku

# setup plugin sudo dokku plugin:install https://github.com/dokku/dokku-postgres.git # create a new database for our app dokku postgres:create bitwarden # link the postgres service to the app, DATABASE_URL will be attached to the ENV variables automatically. dokku postgres:link bitwarden bitwarden

# For PostgresSQL $ sudo dokku plugin:install https://github.com/dokku/dokku-postgres.git postgres $ dokku postgres:create app-name-db $ dokku postgres:link app-name-db app-name # For MongoDB $ sudo dokku plugin:install https://github.com/dokku/dokku-mongo.git mongo $ dokku mongo:create app-name-db $ dokku mongo:link app-name-db app-name

root@vps17825:~# sudo dokku plugin:install https://github.com/dokku/dokku-postgres.git postgres -----> Cloning plugin repo https://github.com/dokku/dokku-postgres.git to /var/lib/dokku/plugins/available/postgres Cloning into 'postgres'... remote: Enumerating objects: 2356, done. remote: Counting objects: 100% (417/417), done. remote: Compressing objects: 100% (276/276), done. remote: Total 2356 (delta 244), reused 267 (delta 118), pack-reused 1939 Receiving objects: 100% (2356/2356), 483.24 KiB | 3.48 MiB/s, done. Resolving deltas: 100% (1580/1580), done. -----> Plugin postgres enabled Adding user dokku to group adm Starting nginx (via systemctl): nginx.service. 14.1: Pulling from library/postgres 5eb5b503b376: Pull complete daa0467a6c48: Pull complete 7cf625de49ef: Pull complete bb8afcc973b2: Pull complete c74bf40d29ee: Pull complete 2ceaf201bb22: Pull complete 1255f255c0eb: Pull complete d27501cd0cca: Pull complete ff5b6d09a5d0: Pull complete f635aec27645: Pull complete a165c6729250: Pull complete b0aa4f86b611: Pull complete 9efc4664d9d2: Pull complete Digest: sha256:3162a6ead070474b27289f09eac4c865e75f93847a2d7098f718ee5a721637c4 Status: Downloaded newer image for postgres:14.1 docker.io/library/postgres:14.1 1.31.1-uclibc: Pulling from library/busybox 76df9210b28c: Pull complete Digest: sha256:cd421f41ebaab52ae1ac91a8391ddbd094595264c6e689954b79b3d24ea52f88 Status: Downloaded newer image for busybox:1.31.1-uclibc docker.io/library/busybox:1.31.1-uclibc 0.3.3: Pulling from dokku/ambassador aad63a933944: Pull complete 2888dfab2eb5: Pull complete 51ccf60e0642: Pull complete Digest: sha256:87c0214e190e7f6975953027157a8933701596b4b864ff66dd3cc3f6ead5c38d Status: Downloaded newer image for dokku/ambassador:0.3.3 docker.io/dokku/ambassador:0.3.3 0.10.3: Pulling from dokku/s3backup aad63a933944: Already exists 6654c5b7b2dc: Pull complete 26abcd9faf98: Pull complete d1a36cd3ba61: Pull complete 9517d44e685b: Pull complete 32e8b2c4797f: Pull complete Digest: sha256:3651f8ef12000206df55fec8ad4860d6f26b2b5af1308c0e2358253641626024 Status: Downloaded newer image for dokku/s3backup:0.10.3 docker.io/dokku/s3backup:0.10.3 0.4.3: Pulling from dokku/wait aad63a933944: Already exists 3409ea528c35: Pull complete 88e35d065209: Pull complete Digest: sha256:5eb9da766abdd5e8cedbde9870acd4b54c1c7e63e72c99e338b009d06f808f04 Status: Downloaded newer image for dokku/wait:0.4.3 docker.io/dokku/wait:0.4.3 -----> Priming bash-completion cache root@vps17825:~#

# on the Dokku host # install the postgres plugin # plugin installation requires root, hence the user change sudo dokku plugin:install https://github.com/dokku/dokku-postgres.git # create a postgres service dokku postgres:create hello-world-database # on the Dokku host # each official datastore offers a `link` method to link a service to any application dokku postgres:link hello-world-database hello-world

The link links to documenation for the postgres for dokku plugin where you can find some commands. To create a database in dokku:

If you want to dig into it anyways, Dokku is an interesting mention. They provide an Open Source PaaS that you can install on your server to simplify self hosting containers.

When I came across Coolify, I thought of giving it a try. I am aware of Dokku, but I never really tried it because it doesn't have a UI. I work primarily as a UI developer, so having a nice UI to work with is a plus for me.

I run all my projects on Dokku. It’s a sweet spot for me between a barebones VPS with Docker Compose and something a lot more complicated like k8s. Dokku comes with a bunch of solid plugins for databases that handle backups and such. Zero downtime deploys, TLS cert management, reverse proxies, all out of the box. It’s simple enough to understand in a weekend and has been quietly maintained for many years. The only downside is it’s meant mostly for single server deployments, but I’ve never needed another server so far.

https://dokku.com/

Yeah there are a bunch of selfhostable things:

Caprover (https://caprover.com/)

Dokku (https://github.com/dokku/dokku)

But people still choose Netlify and Vercel for ease of use I think.

Maybe we need something that's just Netlify. The closest I've seen to the "right" UX is Ness:

https://ness.sh

The modern iteration of these tools has taken the developer experience learnings from the Platform as a Service (PaaS) category, and will bring them to your own VM, giving you your own personal PaaS. Example of this include Dokku, Coolify, Caprover, Cloud66 and many more!

Based on the fact that your ideal is to have a similar experience to heroku than managing your own server setting up reverse proxies take a look at these options:

1) https://dokku.com - lets you turn your light sail instance basically into heroku

2) https://render.com

3) https://fly.io

4) If you have aws credits this is their heroku equivalent: https://aws.amazon.com/elasticbeanstalk

above is not what I do but would be the options I would pursue if I understand your preference and requirement correctly.

All in all, I really recommend trying out Dokku if you are a developer interested in hosting your own projects. It makes it super easy to get everything you need to get up and running without having to worry about the specifics. And the price is impossible to beat!

The installation instructions are on the frontpage of our site. Thats basically all you need to do to install Dokku. As far as using it, we have a simplified tutorial here.

Dokku is a lightweight and open-source PaaS platform that simplifies application deployment by leveraging Docker. With Dokku, developers can easily push their applications using Git, allowing Dokku to build and run them in isolated containers. Its CLI-only approach and plugin architecture make it highly extensible. Dokku's modular plugins enable features like database integration, Let's Encrypt SSL certificates, and automated Slack notifications, giving developers flexibility and control over their PaaS environment.