Django Tutorial - Migrate from SQLite to PostgreSQL #19

Показать описание

Welcome everyone to part 19 of the web development in Python with Django. PostgreSQL is an open-source Object-Relational Database Management System (ORDBMS) that supports most of the SQL standards and features, including foreign keys, transactions, etc.

The database comes with many features that help developers build applications but also help administrators protect data regardless of the dataset's size.

This community-driven database server is free to use, secure, reliable, and scalable. It powers dynamic websites and applications at NASA, Apple, Spotify, Reddit, and other famous companies.

As programmers, we often work on different projects depending on our level of expertise. When we were in the learning stage, we worked with an application like a "step-by-step tutorial" that didn't need a heavy database mechanism to store task records. But as we move forward, the projects we work on change over time. We will need to create a production-ready project requiring a database structure at some point.

Typically, a primary Django project ships with an SQLite database as the default. Although this is the default database, Django supports other databases such as PostgreSQL, Oracle, MySQL, and more.

This tutorial will focus on PostgreSQL and how we can implement it on Django projects. PostgreSQL has many features that help developers build applications but also help administrators protect data, no matter how big or small the dataset is.

#django #programming #educational #technology #web #website

Рекомендации по теме

Комментарии

Things I always have issues, when setting a brand new VPS, are detailed here; like authorizing by password.
Personally, I use docker for local development. But I learned for first time how to dump and restore a backup of my database using django.
Simple wow! thank you!

tatemo_labs

wow😊.
This is indeed amazing, I didn't make use of vultr yet I got same outcome using postgresql.
Thanks Boss for this rich content.

jpcodes

Fantastic course. Just want to share my noob two cents here. I find it easier to register a ssh key with the vultr site first. Then build your server and add that ssh key to your server config. Then you won't have to enter a password when you ssh in.

paulbrugger

Django Tutorial - Migrate from SQLite to PostgreSQL #19

Django Tutorial #7 - Migrations

#18 Django tutorials | Re-Migration

5. Models and Migrations in Django - In Depth Tutorial about Django Migrations

#17 Django tutorials | Models and Migrations

Learn How to Migrate Default Migration in Django | Django Tutorials

Django - What are migrations - actually? Introduction to migrations and the Django database

Django Models & Migrations Made Easy: Master SQL Migrations | Django Tutorial #9

Django Migrations explained | makemigrations vs migrate | Django Tutorial

How to Ignore Django Migration Files in Git: A Step-by-Step Guide

Django Tutorial - Setup, Installation and Page Navigation

Python Django Tutorial: Full-Featured Web App Part 5 - Database and Migrations

Django from Scratch - Complete Tutorial Series

Python Django Full Course for Beginners | Complete All-in-One Tutorial | 3 Hours

Django PostgreSQL Migration from SQLite

Django Migration File Anatomy | Django Migrations | Shaping Database Schemas

14 - INSTALLED_APPS & Migrations - Python & Django 3.2 Tutorial Series

Python Django Tutorial: Full-Featured Web App Part 2 - Applications and Routes

Django Models, Relationships, and Migrations Explained - 3 - Full Stack Django App

Python Django Tutorial for Beginners

Django Fake Migrations | Django Migrations | Shaping Database Schemas

🔴 Django SQLite to MySQL DB: Zero Data Loss | Change Django Datbase | 2024

Learn Django in 20 Minutes!!

Pro Django - Tutorial 1 - Project Structure, Poetry, Makefile, and Settings Management

Django Migrations: Pitfalls and Solutions with Benjamin Zagorsky - DjangoCon US 2022