All Questions
Tagged with postgresql django
8,032
questions
0
votes
0
answers
18
views
I can't open server in 0.0.0.0 instead it is working in 127.0.0.1 in while using Docker , Django and Postgres [duplicate]
I am a newbie to this.
settings.py file is:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql',
'NAME': 'postgres',
'USER': 'postgres',
'PASSWORD':...
-2
votes
0
answers
22
views
what is the default database configuration used in django rest framework while using postgres database [closed]
ImproperlyConfigured at /api/token
settings.DATABASES is improperly configured. Please supply the ENGINE value. Check settings documentation for more details.
Request Method: POST
Request URL: http:...
0
votes
0
answers
42
views
How to Version Control a PostgreSQL Table?
Backend: Python 3.11 and Django 5.0.6
Database: PostgreSQL 15
Our app deals with reporting from the database. We don't store report SQL queries in the codebase; instead, we store them in DB tables. ...
0
votes
1
answer
52
views
Django Postgresql ORM optimisation
I have a PostgreSQL view called view_sales_dashboard - this consists of several millions rows of daily sales data.
In the Django view I want to present a table grouped by the products, with the ...
0
votes
1
answer
63
views
django.db.utils.OperationalError: could not translate host name "postgres.railway.internal"
django.db.utils.OperationalError: could not translate host name "postgres.railway.internal" to address: nodename nor servname provided, or not known
My Django project was working great ...
0
votes
0
answers
45
views
I have been trying to launch an application for about 4 days in Django to Render
System check identified no issues (0 silenced).
Exception in thread django-main-thread:
Traceback (most recent call last):
File "C:\DEV\DJANGO\dealer_project\env\Lib\site-packages\django\db\...
0
votes
0
answers
31
views
UnicodeDecodeError: 'UTF-8' codec can't decode byte 0xb8 in position 57: invalid start byte ERROR when using Django and PostgreSQL [closed]
I'm a newbie developer trying to make a webpage with Django and PostgreSQL db.
I made a project and app and connected with settings.py to PostgreSQL db.
When I run Python manage.py makemigrations, ...
0
votes
0
answers
51
views
Postgresql SELECT optimisation into Django ORM [closed]
Please see below a PostgreSQL SELECT statement. This presently returns around 300k rows, which is the grouped result of several million underlying rows. The dataset is only going to get larger. Using ...
1
vote
1
answer
33
views
What's the workaround for Django/PostgreSQL GeneratedField error
When defining a GeneratedField with PostgreSQL, it is not uncommon to encounter the following error: django.db.utils.ProgrammingError: generation expression is not immutable.
This error is mentioned ...
0
votes
1
answer
40
views
Can’t connect PostgreSQL to my Django App in Azure VM
I am build a django app that I am deploying through a CI/CD pipeline into my Azure VM. I already created a PostgreSQL database. When I deploy my docker container in my VM and try to connect to my ...
0
votes
0
answers
19
views
postgres.fields.JSONField and models.JSONField
I have a model in some django project it has a JSONField in it.
I want to connect to the table of that model from another django project so i copied the model from first django project and move it to ...
0
votes
0
answers
20
views
Error While Running dajngo project server through WSL
I am using Postgres as my db for this project.
My project directory is in my windows system.
Virtual environment was created in both windows and wsl (ubuntu) with all the dependencies.
Postgres-16 and ...
2
votes
1
answer
34
views
What is the fastest way to query for items with an existing foreign key and many-to-many entry in Django?
I have a simple model with a foreign key and a many-to-many relationship:
class Car(models.Model):
uuid = models.UUIDField()
is_red = models.BooleanField()
class Owner(models.Model):
car =...
0
votes
0
answers
25
views
ImproperlyConfigured` Error When Deploying Django to Vercel with Supabase PostgreSQL
I'm currently trying to deploy my Django project to Vercel, using Supabase as the PostgreSQL database provider. I have separated my settings into base.py, development.py, and production.py to manage ...
0
votes
1
answer
25
views
How to use postgres' ARRAY in django orm
In postgresql, I am able to combine two columns into one into an array like so
SELECT id, ARRAY[address,zip] as address_array FROM user
Is there a way to do this using django's orm? Why? I want to be ...