I am encountering an issue while attempting to connect to a PostgreSQL Pgpool server using Entity Framework Core. The setup involves the utilization of the Postgresql HA Helm Chart by Bitnami, which sets up a high-availability PostgreSQL cluster. The intended…
I have created a simple flask authentication I have deployed it on render The app runs fine locally But when in the deployed app, the check_password_hash always returns false I use mysql on my local machine and the code works…
I'm fairly new to Docker and I am trying to create a project with it and Django. My version of Django is 4.2 and I use the latest versions of PostgreSQL and Docker. So I created a docker-compose.yml file with…
I have a query that gets some data, for example: select type_of_client from table1; type_of_client -------------- restaurant bar cinema ... And I would like to use these results into a jsonb element, for example: select count(*) from table2 where fields->>'restaurant'…
Is it possible to force a SELECT statement on a table to include columns from that table in a WHERE clause, in Postgres? For example, given a table T with columns c1 and c2 can I force a SELECT on…
I would like to update values in one postgres table from values in another postgres table, but I would like to update only values which NEED to be updated - ie if a value is already correct, leave it alone…
Is there a way to optimise the .count() function on a queryset in Django? I have a large table, which I have indexed, however the count function is still incredibly slow. I am using the Django Rest Framework Datatables package,…
I have created a table using the flask db migrate method. Below is how my model is class MutualFundsDataTest(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) Name = db.Column(db.Text, nullable=False) MF_Code = db.Column(db.Text, nullable=False) Scheme_Code_Direct = db.Column(db.Text, nullable=True) Scheme_Code_Regular = db.Column(db.Text, nullable=True)…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
I have one database model, let's say ModelA: class ModelA(models.Model): field_1 = models.ManyToManyField( "core.ModelB", blank=True ) user = models.ForeignKey("core.User", on_delete=models.CASCADE) type = models.CharField(choices=ModelATypes.choices) The field_1 of ModelA is a many to many field that references ModelB. class ModelB(models.Model): uid =…