45-Minute Deep Dive: Mastering SQLite for Production Servers!


Hey everyone, Phil here! In this video, I’m going to show you how to use SQLite3 in a production environment with Ruby on Rails. We’ll go through the complete setup, from configuring your app to deploying it on an Ubuntu cloud server using Capistrano. Plus, I’ll cover how to back up your SQLite3 database to cloud storage, ensuring your data is always safe. Whether you’re a seasoned developer or just starting out, this guide will help you get your Rails app up and running smoothly with SQLite3. Don’t forget to like, subscribe, and hit the bell for more tutorials!

Chapters:
00:00 Introduction
01:55 Setting Up Your Rails App
10:55 Creating an Ubuntu Cloud Server
13:00 Create a Repo and Push to it
14:50 Configuring the Ubuntu Cloud Server
24:50 Deploying Your App with Capistrano
39:00 Advanced
40:05 Backing Up SQLite3 to Cloud Storage
46:40 Conclusion

Let’s dive in!

** Gist **
Get the Gist with all my scripts to set up an Ubuntu 22 machine to run Rails here:
https://bit.ly/u22-ror

** Substack **
Subscribe to my Substack here: https://philonrails.substack.com
There will be a post in there that has my Notion Page of notes

Some people online just talk – I just do. One of my major SaaS products out there is Zonmaster.com (https://public.zonmaster.com) THE AutoResponder and Customer Management tool for Amazon Sellers. Join over 17,000 other Amazon Sellers and sign up today!

Looking for great hosting? I’ve been using DigitalOcean for 9 years and they have never let me down. Amazing.
Check them out here https://m.do.co/c/f1c6edf8597f and get $100(!!!) free credits towards the cost of servers.

#techEntrepreneur #entrepreneurship #softwareDevelopment


Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.