dokku-postgres VS action-doctl

# 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:

I would highly recommend DigitalOcean (https://www.digitalocean.com/) - they started with a simple VPS offering but have expanded over time. I've been using them since 2015 and they are highly reliable, communicative about any maintenance requiring downtime and transparent about pricing.

Feel free to check them out. If you want I can send you my referral link

DigitalOcean is a cloud infrastructure provider catering to developers, offering scalable virtual servers, storage solutions, networking services, and managed Kubernetes clusters. It simplifies application deployment, management, and scaling through its intuitive user interface and CLI (doctl), allowing developers to efficiently utilize cloud resources for their projects.

In this guide, we'll leverage the strengths of Neon serverless Postgres to establish a PostgREST API on DigitalOcean. With PostgREST, a PostgreSQL database is turned into a RESTful API.

A VM is the original “hosting” product of the cloud era. Over the last 20 years, VM providers have come and gone, as have enterprise virtualization solutions such as VMware. Today you can do this somewhere like OVHcloud, Hetzner or DigitalOcean, which took over the “server” market from the early 2000’s. Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft's Azure also offer VMs, at a less competitive price. In their case, the VMs are either a building block for other services or the value is in the ecosystem. See the section on public cloud below for more.

Every website or web application you have ever come across on the internet contains code deployed there by someone like you (or by aliens; I can't tell the extent of their involvement at this time) and for you as a web/software developer, knowing how to deploy your code to the streets of the internet via a remote server such as cloud servers is an invaluable skill to have today. There are several decent hosting services around that enable you to properly and securely host your website or web app such as Digital Ocean, Heroku, Vercel (mostly for front-end apps) and chief amongst them, Amazon Web Services (AWS).

Hacktoberfest is a month long celebration during October each year. 2023 is the ten year anniversary of the event and I'm excited that something like this still runs. Hacktoberfest is spearheaded by Digital Ocean. This year, ILLA and Appwrite have joined as the presenting partners.

Next, head over to DigitalOcean’s website and click Sign Up if don’t have an account, or Login if you already have one. I choose to Sign up with GitHub

Hacktoberfest, started by DigitalOcean, is celebrating its 10th anniversary this year 🥳 It is an annual event that celebrates open-source software development by having developers actively contribute to open-source projects. As of last year alone, there were over 147,000 participants.