Obie  Rowe

Obie Rowe

1620057633

How to Migrate Local PostgreSQL Database to AWS RDS

In this video we are going to see how to Migrate local PostgreSQL database to AWS-RDS So this is the 3rd video of MEAN stack deployment architecture for aws

In the last video we have seen that how to deploy nodejs REST APIs to aws Lambda function

So this video is only about AWS-RDS services

RDS has free-tier option with 20GB of storage and 20GB of backup so basically we are going to get RDS service free for one year.

So before starting this video we need pgAdmin

pgAdmin is a database management tool.

so we will use this tool to connect to local postgres databse as well as for Remote Database Service
https://www.pgadmin.org/download/

#postgresql #database #aws

What is GEEK

Buddha Community

How to Migrate Local PostgreSQL Database to AWS RDS
Obie  Rowe

Obie Rowe

1620057633

How to Migrate Local PostgreSQL Database to AWS RDS

In this video we are going to see how to Migrate local PostgreSQL database to AWS-RDS So this is the 3rd video of MEAN stack deployment architecture for aws

In the last video we have seen that how to deploy nodejs REST APIs to aws Lambda function

So this video is only about AWS-RDS services

RDS has free-tier option with 20GB of storage and 20GB of backup so basically we are going to get RDS service free for one year.

So before starting this video we need pgAdmin

pgAdmin is a database management tool.

so we will use this tool to connect to local postgres databse as well as for Remote Database Service
https://www.pgadmin.org/download/

#postgresql #database #aws

Migrating your on-premises SQL databases to AWS RDS SQL Server using AWS DMS

There are multiple ways to deploy the databases in the AWS RDS SQL Server. Suppose you want to migrate your on-premises SQL Server database to AWS managed relational database service and you have a critical application and require minimal (almost zero) downtime. For this purpose, you can use the AWS Database Migration Service (AWS DMS) in a combination of SQL Server native backups.

You can use the on-premises SQL Server as a source database; however, for demonstration of the steps, I will use the SQL Server on EC2 instance.

#aws #aws rds #aws dms #sql databases

Split Native Databases Backup and Restore for AWS RDS SQL Server

In this article, we will explore how to split native backup and restore for AWS RDS SQL Server from the AWS S3 bucket.

Introduction

We can deploy SQL Server in Amazon Web Services (AWS) cloud infrastructure using the following ways.

  • AWS Managed RDS SQL Server
  • Customer Managed SQL Server

In the below table, we can see a high-level comparison between EC2 and RDS SQL.

high-level comparison between EC2 and RDS SQL

#aws #aws rds #backup and restore #aws rds sql server #aws s3

Ruth  Nabimanya

Ruth Nabimanya

1621312680

Amazon‌ ‌RDS‌ ‌Proxy:‌ ‌Taming‌ ‌DB‌ ‌Connections

Most developers find databases difficult to scale. There are a lot of frameworks that can run on multiple pods⁠—or even multiple clusters⁠—to handle more load. Some frameworks even support advanced load balancing and caching.

Still, when a spike beyond what the framework can handle happens, the database is almost always the first process to fail. It’s a horror story that every developer has experienced at least once. And it always happens at the most important moment⁠—such as during an important flash sale.

Taming database load management isn’t an easy task, but Amazon Relational Database Service (RDS) has been doing a great job at it. Amazon RDS Proxy though extends the features you can use to manage database connections to a whole new level.

#aws #blog #databases #amazon rds #aws iam #database security #rds #rds proxy

Django-allauth: A simple Boilerplate to Setup Authentication

Django-Authentication 

A simple Boilerplate to Setup Authentication using Django-allauth, with a custom template for login and registration using django-crispy-forms.

Getting Started

Prerequisites

  • Python 3.8.6 or higher

Project setup

# clone the repo
$ git clone https://github.com/yezz123/Django-Authentication

# move to the project folder
$ cd Django-Authentication

Creating virtual environment

  • Create a virtual environment for this project:
# creating pipenv environment for python 3
$ virtualenv venv

# activating the pipenv environment
$ cd venv/bin #windows environment you activate from Scripts folder

# if you have multiple python 3 versions installed then
$ source ./activate

Configured Enviromment

Environment variables

SECRET_KEY = #random string
DEBUG = #True or False
ALLOWED_HOSTS = #localhost
DATABASE_NAME = #database name (You can just use the default if you want to use SQLite)
DATABASE_USER = #database user for postgres
DATABASE_PASSWORD = #database password for postgres
DATABASE_HOST = #database host for postgres
DATABASE_PORT = #database port for postgres
ACCOUNT_EMAIL_VERIFICATION = #mandatory or optional
EMAIL_BACKEND = #email backend
EMAIL_HOST = #email host
EMAIL_HOST_PASSWORD = #email host password
EMAIL_USE_TLS = # if your email use tls
EMAIL_PORT = #email port

change all the environment variables in the .env.sample and don't forget to rename it to .env.

Run the project

After Setup the environment, you can run the project using the Makefile provided in the project folder.

help:
 @echo "Targets:"
 @echo "    make install" #install requirements
 @echo "    make makemigrations" #prepare migrations
 @echo "    make migrations" #migrate database
 @echo "    make createsuperuser" #create superuser
 @echo "    make run_server" #run the server
 @echo "    make lint" #lint the code using black
 @echo "    make test" #run the tests using Pytest

Preconfigured Packages

Includes preconfigured packages to kick start Django-Authentication by just setting appropriate configuration.

PackageUsage
django-allauthIntegrated set of Django applications addressing authentication, registration, account management as well as 3rd party (social) account authentication.
django-crispy-formsdjango-crispy-forms provides you with a crispy filter and {% crispy %} tag that will let you control the rendering behavior of your Django forms in a very elegant and DRY way.

Contributing

  • Django-Authentication is a simple project, so you can contribute to it by just adding your code to the project to improve it.
  • If you have any questions, please feel free to open an issue or create a pull request.

Download Details:
Author: yezz123
Source Code: https://github.com/yezz123/Django-Authentication
License: MIT License

#django #python