I want to quickly scan a chat conversation - in close to real time - and detect any food names that are in it. I've got a database of 400K foods or so, so the trivial solution of just using…
I have three tables that are linked together. I have stuff table, that has a foreign key to users, that has a foreign key to companies (SQL code of the table and a diagram are at the bottom of the…
I am trying to create an alert in Google Cloud Monitoring that runs a custom count query on a Cloud SQL database (postgresql) and returns the result. Eg.: SELECT count(*) FROM your_table WHERE [field] IS NULL OR LTRIM(RTRIM([field])) = ''…
In my PostgreSQL 14.8 database I have a table named orders that looks as follows: CREATE TABLE orders ( user_id int , order_id int , order_date date , quantity int , revenue float , product text ); INSERT INTO orders…
I demonstrate the issue with the following simple table. (The actual table and JSON document have a lot more fields.) CREATE table contact ( id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR, lastname VARCHAR, birthday timestamp with…
I have the next table Product Plant Store Text Week Date Stock 123456 A123 Z12 HelloWorld 1 2001-01-01 20 123456 A123 Z12 HelloWorld 2 2001-01-08 -15 123456 A123 Z12 HelloWorld 3 2001-01-16 -20 789123 B345 123 HelloWorld1 1 2001-01-01 10…
There are multiple solutions online but they all use 'CREATE TABLE' and 'INSERT' in their solutions. I only have read access. So how to print all table names and row count in a schema? If possible how to print column…
I am trying to connect to a dockerized Postgres from Python. However, I have not managed to make it work the way I believe it should work. As I am just a beginner with Docker, I used first used the…
I need some help writing a subquery. I have columns where I need to take a percentage of a population but based on some other column. state pop column_a nyc 10 1 ny 15 1 nyc 20 0 ny 25…
This is the query that I am executing const jobs = await this.prisma.$executeRaw` SELECT name FROM jobs WHERE status = 'ACTIVE'`; but instead of getting the results that macth this query I only get a number, so the type of…