I'm developing a Spring Boot application with a PostgreSQL database. Within this application, I've implemented the functionality to create bots. Here's a glimpse of my Bot entity: @Data @Entity @Table(name = "bots") @NoArgsConstructor @AllArgsConstructor @Builder public class Bot { @Id…
I'm building a very simple profanity filter in a chat app. I know they are notoriously difficult to implement properly, but I just want something quick and simple that is better than nothing at all. I have a profanities table…
Below is a small code of parsing a json array into a table in a database: CREATE TEMPORARY TABLE json_import (doc json) ON COMMIT DROP; INSERT INTO json_import (doc) VALUES( '[ { "cli_nk": 1, "effective_from_date": "2021-01-18", "effective_to_date": "", "user_dml_type_code": "U",…
I have two tables and three queries. I want to count the number of rows in one table, the number of different rows in the second table and then Order by the average of the three. I tried using UNION…
I created person table, then inserted 2 rows into it as shown below: CREATE TABLE person ( id INT, name VARCHAR(20), age INT ); INSERT INTO person (id, name, age) VALUES (1, 'John', 27), (2, 'David', 32); Then with an…
I have these SQL queries: EXPLAIN ANALYZE SELECT * , ( SELECT COUNT(*) FROM orders WHERE orders.customer_id = customers.id ) as orders_count FROM customers LIMIT 10 The execution plan for this query: EXPLAIN ANALYZE SELECT * , ( SELECT COUNT(*)…
This query below is running but I would like to add this extra condition; run this query only if there is data in the table STAGE.LAB.DATA. I tried CASE and IF THEN, but I can't get it to work. Please…
In PostgreSQL, I have a table with some settings the user can make. In that table there is also a "global" user that takes place if the user doesn't have any settings for them. This query returns the settings for…
I have table in MySQL and I am trying to filter the data from ColA and count the instances of a result in ColB while still getting all matching rows TABLE Name: CityCityStuff ColA ColB ColC CityA CityB Other Stuff…
Hi I am working in Postgres. I have below code DO $$ DECLARE item integer; begin item:=5; DROP TABLE IF EXISTS temp_data; CREATE temp TABLE temp_data AS select current_timestamp + interval '1 day' as op; END $$; select * from…