phrase-tutor-wasp VS flyctl

Hey people, this is a side-project of mine called Phrase Tutor (https://phrasetutor.com).

I whipped it up to help me learn Italian using a method I used way back in high school to faster retain historical facts. It has a pool of 100ish phrases and after you go through them all at least once, it will start prioritising phrases that you had trouble with. This way you are focusing on the toughest phrases more. This is kinda like roulette wheel selection used often with genetic algorithms.

I wanted to blend in when I was in Italy and not speak English all the time. I only had a week, and of course, I built an app to help with that. It was awesome saying "Mi scusi" all the time and at some point, they helped us to find our way when our phones died!

It's built using a full-stack framework I'm also developing called Wasp (http://wasp-lang.dev) and I rebuilt it from Supabase to Wasp when I joined the company.

View the source here

Fly.io is a platform that enables developers to deploy and run their applications close to their users. It leverages a global network of servers to provide low-latency, high-performance hosting solutions. It simplifies the deployment process by offering a powerful CLI and automated workflows, making it easy to deploy applications with minimal hassle. Additionally, Fly.io supports various programming languages and frameworks, including Next.js, making it a versatile choice for modern web development.

With the Wasp CLI, you can deploy the React frontend, Node.js backend (server), and PostgreSQL database generated by the Wasp compiler to Fly.io with a single command.

This is a MVP for Serverless Postgres.

1/ It uses Fly.io[0], which can automatically pause your database after all connections are released (and start it again when new connections join).

2/ It uses Oriole[1], a Postgres extension with experimental support for S3 / Decoupled Storage[2].

3/ It uses Tigris[3], Globally Distributed S3-Compatible Object Storage. Oriole will automatically backup the data to Tigris using background workers.

I wouldn't recommend using this in production, but I think it's in a good spot to provoke some discussion and ideas. You can get it running on your own machine with the steps provided - connecting to a remote Tigris bucket (can also be an AWS S3 bucket).

[0] https://fly.io

[1] https://www.orioledb.com/

[2] Oriole Experiemental s3: https://www.orioledb.com/docs/usage/decoupled-storage

[3] Tigris: https://www.tigrisdata.com/

Fly.io - Very similar to Heroku too, easy to use and support for multiple stacks/languages.

Fly.io is a cloud platform that allows developers to easily deploy scalable applications. In this article, we will introduce how to manage databases effectively in an application using Remix, Prisma, and LiteFS on Fly.io.

Deploying applications can be a complex and time-consuming process. App deployment tools, such as Fly.io, aim to simplify this process by providing a platform for easily deploying and managing applications.

To begin with, you could go with a Platform-as-a-Service (PaaS) provider like Heroku, or Fly for a more seamless experience. You can also do a bit of DevOps: set up a Docker installation on a VPS and deploy your app there.

To begin visit fly.io to create an account. Next install flyctl a command line tool for creating and deploying fly apps. macOS

For frontend deployment, I used Netlify (for the generous free package) and the recommended fly.io for server + database (also cheap package).

Create an account on Fly.io.