The Problem We have a relational table where we store user activity. A query like the following takes 77 seconds! FROM "site_activity" WHERE ( NOT "site_activity"."is_deleted" AND "site_activity"."user_id" = 68812389 AND NOT ( "site_activity"."kind" IN ( 'updated', 'duplicated', 'reapplied' )…
I am working on a forum like website where I have to query list of categories along with its latest post in the given category. These are the table schemas create table forum_posts ( forum_post_id text not null unique, forum_post_name…
I would like to have some insight into what is the best way to go to show images from assets and imagePicked images (stored in db) in the same gridView? I am using a Photo model class with different variables…
Basically my shirt e-commerce website won't redirect to my html website. Whenever I try to click on the virtual try on button next to the shirt, it doesn't redirect me to the page instead it just loads and refreshes the…
I have 2 tables with a foreign key. I have to get the counts of all the records in right table and the threshold value of max ts in right table. TABLE alarm column Datatype id PK name varchar TABLE…
I need to return value in preference order, if the value starts with a it should be returned first, if it does not exist we return the value which starts with b. SELECT value FROM table one WHERE value LIKE…
I'm working with a few large row count tables with a commonly named column (table_id). I now intend to add an index to this column in each table. One or two of these tables use up 10x more space than…
I am designing a database for a web project in which I am trying to collect users' emotional feelings toward art collections. A hybrid dual list on the website allows users to select three options from 12 options and then…
I want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…
I have the following records that were created_at: 2022-11-13 14:24:02.651809 2022-11-13 15:00:43.878400 2022-11-13 16:33:18.710288 2022-11-13 18:22:59.220246 2022-11-13 18:50:59.719803 2022-11-15 20:33:19.099264 2022-11-16 15:42:51.285751 2022-11-16 15:46:28.196001 2022-11-16 16:06:31.873187 2022-11-16 16:47:32.071435 2022-11-16 19:05:38.288788 When I run: SELECT DATE_TRUNC('day', CAST(forms.created_at AS DATE) AT TIME…