action-doctl VS Appwrite

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.

If you haven't tried Appwrite, make sure you give it a spin. It's a open source backend that packs authentication, databases, storage, serverless functions, and all kinds of utilities in a neat API. Appwrite can be self-hosted, or you can use Appwrite Cloud starting with a generous free plan.

What is Appwrite? Appwrite is an open-source backend server that abstracts the complexity of backend development, allowing developers to focus on building their applications. It provides a wide range of services including databases, storage, functions, and authentication, all designed to work seamlessly together. This integration simplifies the development process, reducing the need for extensive configuration and integration work.

Appwrite is an open source BaaS platform that provides services like serverless functions, serverless databases, user authentication, and messaging. Since its release, it has quickly become a popular choice for building websites and applications.

Appwrite for user management, databases, and serverless functions

Appwrite: Open-source backend server for web and mobile developers.

Today, this ecosystem is going strong with new providers like Hasura, AppWrite and Supabase powering millions of projects. There are a few reasons people choose this style of hosting, especially if they are more comfortable with frontend development. BaaS lets them set up a database in a secure way, expose some business logic on top of the data, and connect via a dev-friendly SDK from their app or website code to save data easily. These modern tools build a blend of managed database with curated plugins such as authentication, great admin dashboards, and function as a service type capability - all in one package, and often offered as a integrated hosted service.

View on GitHub

Joins - see Future of Queries - MariaDB supports json joins, so definitely possible!

Wow, looks nice! I almost felt like I could understand Bitcoins code xD

Could you do Appwrite? https://github.com/appwrite/appwrite

I'm not affiliated to them, just wanted to get started hacking it.