How to Use a Postgres Database in Django

[@prettyprinted]

Join my free course on working with the database and models in Django: prettyprinted.com/djangodata

[@ekbergpeter6987]

Do you not reply questions there either?

[@justinyang733]

I'm a TA for a course and your video helped tons of students including myself. Thanks body

[@prettyprinted]

You're welcome! I'm glad I could help.

[@kunduzkossymbayeva1257]

your Django Database Essentials course is so cool! Thank you!!!

[@prettyprinted]

I'm glad you like the course!

[@_Jordo]

Great! Was just doing this earlier today. Going to sleep now but I'll be back to watch the video tomorrow.

[@NipkowDisk]

Thank you very much for posting this video, I just installed Django and since I use PostgreSQL as my standard DB the information you shared will be immensely helpful!! Thanks again!

[@prettyprinted]

You're welcome! I'm glad the video was useful for you.

[@NipkowDisk]

@@prettyprinted I did find that for whatever reason, on my Linux Mint 19.1 Tessa install on my old laptop required two extra steps. First, I needed to install the client-side library libpq-dev which was hinted at in the terminal. Second, I couldn't get psycopg2 to install normally but running "pip install psycopg2-binary" in my virtual environment did the trick. All systems go for now!!

[@Idanmichael2]

Thank you! super helpful and straight to the point

[@elgary9074]

Amazing the best explanation! any recoomendations while running docker compose?

[@fernandoferreira5156]

Great tutorial, greetings from brazil.

[@leetcode_solutions]

Thanks for the tutorial!! Please create a tutorial for DJango with Redis

[@iananeri6255]

Thank you. That was just what i was looking for

[@nnanyereugoemmanuel8327]

Thank you for this... Thank you.

[@luketrop9431]

thanks for the great video

[@mukhammedmusa3886]

Thank you very much! It is a really helpful video.

[@yakimianandrew712]

God Bless you brother

[@kennyaires7131]

Much easier than I thought... thanks once again Anthony!

[@jackiepuppet_5324]

If anyone on macOS is running into 'psycopg2' issues after attempting the initial migration, try doing; pip install psycopg2-binary

[@prettyprinted]

Thanks!

[@erichshan1535]

BRO.. I have been stuck on this bug for 2 days and searched everywhere for a solution. I've done so much to try and fix this and your comment was the fix THANK YOU

[@user-ox1db4pm7w]

Thank you T_T

[@ximafor]

Same problem was on Windows

[@sharvilpednekar5777]

Great Job!

[@Mavalliss]

MAN, OMG GODDAMN THANKS A LOT!!! It's the most simple and VERY VERY useful video for me! Thanks a lot again! I love you))

[@harman8879]

Thanks a lot man...

[@dnasredine]

it's very pedagogy videos about django with postgresql, you go to the essential. Thanks

[@deependrasingh1204]

Ohh man this course is lit🔥🔥

[@Riyaz8980.]

Love you bro

[@TheShash1001]

Needed this.

[@prettyprinted]

Glad it helped.

[@TheSanAnt0ni0]

Every guys named "Anthony" are the best ! :D

[@TheOriginalShadyPencil]

I couldn't stop my self.. Google Anthony Arkwright But this Anthony -- Gotta say man, your videos are awesome!!

[@TheSanAnt0ni0]

@@TheOriginalShadyPencil I didn't precise the best for what. This Anthony Arkwright was the best at killing for sure ^^

[@keshavdutta2963]

Hey, will the admin functionality of inbuilt Django be working with PostgreSQL. I have a doubt so I am asking ??

[@renequinones4607]

thank you much for creating and posting these videos. Many blessings to you.

[@prettyprinted]

I'm glad you like them. Thanks for watching my videos!

[@adrianenriquemorgadoflores9828]

Thanks a lot, very clear and useful. Regards from Chile.

[@abdulghaphor]

Thank you Anthony. You were really helpful. God bless.

[@ericksonsuarezocumarez2785]

Great tutorial man. Thank you so much. I got a question : is it mandatory to install psycopg2 in order tu run postgresql in your django project? honestly haven't tried to do so because there is a project i'm working on that I don't want to ruin. Thank you for the answer in advance man.

[@shefeeknajeeb9064]

Yes, psycopg is a PostgreSQL adapter for the Python programming language

[@PythonCareerCoach]

did you create your admin user and different user accounts ? I am getting and error while creating admin account as "django.contrib.auth.models.DoesNotExist: User matching query does not exist" please help how to create super user to proceed. Excited to learn more. Pls help

[@mundoempresarial4879]

Where can we get the PORT if it doesn´t apear in the URL?

[@michelkant]

Greatly explained!

[@prettyprinted]

Thanks for watching!

[@jobauss]

dude u r awesome, tx!

[@vb3039]

Thank you very math from russian :)

[@minhhieunguyen1311]

I was wondering about this problem but thanks to my friend I understood

[@prettyprinted]

Glad I could help.

[@stevenkijooma2001]

Thanks for the concise video. What tool do you use for running your terminal commands?

[@prettyprinted]

I use Ubuntu on Windows. Thanks for watching!

[@emeraldbright3727]

Thanks, can you share more video on query of database in Django ?

[@prettyprinted]

I have a few videos. Just search 'Django models' on my channel.

[@danilochantez5654]

Great Video. MySql?

[@evans8245]

Bless you man

[@אורןכהן-ב7ד]

it doesn't work, error message: "\django\db\backends\postgresql\base.py", line 29, in raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e) django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: DLL load failed while importing _psycopg: The specified module could not be found."

[@daviidon]

What technologies did you use to create your course website? Did you do everything from the ground up?

[@OHOTOLEable]

There is a Chrome Ext. called Wappalyzer which shows technologies being used

[@prettyprinted]

I use a service called Teachable.com. It's built with Ruby on Rails and Angular.

[@what-the-code]

What is difference between migrate and migrations command?

[@josephblessingh2384]

Is Psycopg2 needed/ not needed? What is it used for?

[@prettyprinted]

Yeah, Django uses it to interface with the Postgres database. You don't need to deal with it directly, just have it installed and Django will handle the rest.

[@josephblessingh2384]

@@prettyprinted So I have to put psycopg2 in my settings.url? Because you haven't put it in your video but everyone on stack overflow tells to put it

[@M1L3Y]

@@josephblessingh2384 You don't need to add psycopg2 to URLs. Just pip install, and your ready to go. Don't forget to optimise PostgreSQL's configuration for Django. ALTER ROLE myprojectuser SET client_encoding TO 'utf8'; ALTER ROLE myprojectuser SET default_transaction_isolation TO 'read committed'; ALTER ROLE myprojectuser SET timezone TO 'UTC'; More info here. docs.djangoproject.com/en/1.9/ref/databases/#optimizing-postgresql-s-configuration

[@fayzulsuleiman672]

Hey everyone, i’m trying to migrate postgres but it’s tell me that it was can’t find postgres and i should use the pre-installed rdbms

[@TamilPuzhavan]

hi i need one help on this i created some differnet on similar to this model how to insert a data in postgresql by using I created a table and multitennat also

[@fairxz28]

thank you !

[@prettyprinted]

You're welcome! Thanks for watching.

[@sharifahmed1925]

What if you'd like to create a Django app using tables from a DB where the tables already exist? I'd like to create a dashboard using Django at work. Currently we export data from SQL Server onto Excel to create reports, but using a dashboard we could definitely automate this!

[@prettyprinted]

This might help you: docs.djangoproject.com/en/2.2/howto/legacy-databases/

[@igorkomarov6607]

U are the best, than U

[@prettyprinted]

Thanks for watching!

[@surbhilodha3797]

visual studio code is reading settings.py-tpl as txt file. pls help

[@mohammedhegdah]

Am having an error, is the server running on host 'localhost' and accepting tcpip connections on port 5432. Please help

[@mkhnuser]

Man, it is so abstract issue.

[@arshiaariannejad9639]

How can i connect my pgadmin to my elephantsql?

[@sightseeer1349]

I get ImproperlyConfigured: Error loading psycopg2 module error when migrating. I installed it with pip and I am not using a virtual environment. Does anybody has a clue what could solve it?

[@sightseeer1349]

okay nevermind, I have to install pip stuff with python -m pip install blabla instead of pip install blabla sorry for the waste of time for everyone reading this.

[@sanagull116]

Where did you write python manage.py migrate? mean in which CLI

[@prettyprinted]

I use Ubuntu on Windows.

[@arenmkhoyan]

thanc you

[@prettyprinted]

You're welcome.

[@fabian-manzano]

that is great but i am getting error: relation "django_session" does not exist

[@spdev3230]

Hi sir, can I reuqest a tutorial for django multi tenancy with postgresql? Please help

[@prettyprinted]

I'll see what I can do. Thanks for the idea.

[@brotherx6205]

Is there a way to migrate an existing SQLite database to Postgres in Django without deleting all of the data in it?

[@prettyprinted]

You have to export from SQLite and then import to Postgres. Once all the data has been moved, you can update the configuration in your Django app. Maybe this will help: www.quora.com/What-is-the-best-way-to-copy-my-SQLite-database-to-PostgreSQL-so-I-can-deploy-it-to-Heroku

[@JonesDTaylor]

What if we don't use that elephantsql ?? how to get username and all ???

[@prettyprinted]

It completely depends on what you're using. You'll have to find where that information is.

[@DebabrataPatnaik]

It has changed from django.db.backends.postgresql to django.db.backends.postgresql_psycopg2 for postgres. Please confirm if there are any better bacends for Maria DB.

[@prettyprinted]

You should be able to use the mysql connector for Maria DB.

[@robertg2285]

A+

[@protegous]

What’s the difference between adding “simple” and “simple.apps.SimpleConfig” to INSTALLED_APPS?

[@prettyprinted]

It really just depends on how the app is designed. I would consult the documentation.

[@dhakshintechi9896]

Bro make videos on fb,twitter login api with django

[@prettyprinted]

I'll cover that eventually.

[@madusan1]

By rights, after entering in the port number, it should have a comma... Not critical but best practices

[@prettyprinted]

Thanks!

[@shirleychan5649]

this does not look like postgres model in your model.py?

[@prettyprinted]

How so? The only difference is Django prepends your model name with the app name when creating the table.

[@shirleychan5649]

I'm so sorry, I'm new to django and I misunderstood, I got clarification and it makes sense to me now :)

[@zhomart3953]

3:14 what you open?

[@protegous]

terminal of the IDE

[@Halfrican4111]

you should of just showed us functionality with a local database. This was pretty much useless. But I dunno anything that's why I came to this tutorial. maybe you can only setup postgres database by going to some cookie cutter website and copy and pasting in information. I expected information on the actual database setup locally and how to manipulate data from a self contained environment. This video seemed kinda lazy.