I have a database backup from where I would like to get all revision for a course, then for its lessons and for each lessons the chapters. The revision of a course was easy enough: SELECT * FROM wp_posts WHERE…
def update_database(self, results): try: length = len(self.unique_ids) update_data = [(self.unique_ids[i], results[i]) for i in range(length)] query = """ UPDATE public.post_data AS p SET content = t.content FROM (VALUES %s) AS t (unique_id, content) WHERE p.unique_id = t.unique_id; """ template =…
let's suppose there are 1 million documents in a collection, each document need to have some tags corresponding to it, should i be storing these tags in the form or array or in the form of object having boolean values?…
I am using NiFi to load data from database A in json record format and want to insert json record into a json column of a table in database B. A => ExecuteSQLRecord => [jsonRow,...] => [?] => B.table(data json)…
I have an asp.net (version 8) webapi project that I have set up to work with docker. I have the container that runs my API and a volume where I put my database. It works and I'm able to run…
I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a recipe finder app. I started by creating a new database, then creating a table and then…
Im having this error when trying to connect to the database: [auth][cause]: error: password authentication failed for user "user" But i can connect to pgadmin normaly with the same credentials so I dont undertand whats going on. docker-compose.yaml services: postgres:…
I have 2 queries which give count of cases based upon a condition Query 1: Select count(unique c.caseid) as New_cases from caseinfo c where (c.crtdate between TO_DATE('2024/07/08') AND TO_DATE('2024/07/11')) and c.channel is not null; Query 2: Select count(unique c.caseid) as…
I'm trying to use CYCLE detection in PostgreSQL to avoid circular nesting of groups but cannot figure it out. I have the following PostgreSQL 16 table: CREATE TABLE groups ( id serial PRIMARY KEY, name text NOT NULL ); INSERT…
I have a question. I have the following scheme CREATE TABLE 'redirect3' ( id INT, short_url_id INT, browser SYMBOL capacity 256 CACHE, platform SYMBOL capacity 256 CACHE, os SYMBOL capacity 256 CACHE, referrer_domain VARCHAR, country SYMBOL capacity 256 CACHE, language…