Introduction to Python Course

I am using postgres on Mac. I have a database up and running. I want to use it with Flask (SQL Alch… Read more How To Set Database_url Environment Variable For Postgres Mac Terminal?

I am trying to migrate a DB from sqlite to postgresql...so I typed: sudo -u postgres psql postgres=… Read more Postgresql: Fatal: Password Authentication Failed For User "douglas"

I am having problems with a python program that I wrote. It is actually plpython3u. I am running … Read more Python Not Calling External Program

I am developing an app together with a partner. I do the database part (PostgreSQL), my partner imp… Read more Make Sqlalchemy Commit Instead Of Rollback After A Select Query

So currently when I execute SELECT query and retrieve data I have to get results like this: connect… Read more Psycopg2 Use Column Names Instead Of Column Number To Get Row Data

Can you help me decipher this rather esoteric error? Everything's fine when I fire up the appli… Read more 'invalid Input Syntax For Type Inet' Db Error In Django App With Postgres And Gunicorn+nginx As Reverse Proxy

I'm a beginner at python. We use this code to execute SQL commands. cur.execute('INSERT INT… Read more Prepared Statements Using Psycopg

Right now i am able to connect to the url api and my database. I am trying to insert data from the … Read more Targeting Specific Values From Json Api And Inserting Into Postgresql, Using Python

First off, I am new to django. I am trying to use GeoLite(GeoIP2) datasets in my POSTGIS database i… Read more Configuring A Postgresql Postgis Database

I've added a field to the main Django 'User' model, by inserting a User.add_to_class() … Read more Python South Not Picking Up Changes Made In Add_to_class() Method

I have an SQLAlchemy session in a script. The script is running for a long time, and it only fetche… Read more Sqlalchemy Long Running Script: User Was Holding A Relation Lock For Too Long

I'm relatively new to Python, extremely new to Django and Heroku, and also rather new to workin… Read more Error When Attempting To Install Django-toolkit Within A Python Virtualenv

What my settings.py for DB looks like: ALLOWED_HOSTS = ['*'] DATABASES = { 'defaul… Read more Psycopg2.errors.insufficientprivilege: Permission Denied For Relation Django_migrations

I got the following code from How do I get a raw, compiled SQL query from a SQLAlchemy expression? … Read more Python 2.7 To Python 3.4 Error Unsupported Operand Type(s) For %: 'bytes' And 'dict'

How can I structure this sqlalchemy query so that it does the right thing? I've given everythin… Read more Sqlalchemy: Subquery In From Must Have An Alias

I have installed PostgreSQL Server 9.6.0 and Python 3.4.2 on Windows 2012 R2 Server. I copied plpyt… Read more Error During: Create Extension Plpython3u; On Postgresql 9.6.0

I get the following error when I try to deploy my latest version to Heroku: could not connect to se… Read more Heroku Django: Operational Error Connection Refused

The problem In PostgreSQL, checking whether a field is in a given list is done using the IN operato… Read more Sqlalchemy: Check If A Given Value Is In A List

So here's my problem: I created a heroku app that is working as expected, although when the app… Read more Added Database Records Are Deleted After Restarting App (heroku/sqlalchemy)

I setup an app in Ubuntu 14.04 on AWS -> NGINX -> UWSGI -> DJANGO APP. The app runs comple… Read more Django App Under Uwsgi Failing To Start When Using Postgresql Database