In the following scenario, there are 3 tables in a PostgreSQL database (tables and values are simplified for clarity). I am trying to get the following values: sum of the amounts for records (101, 102, 103) in the parent table…
I have two different AWS servers for RDS instances. I want to restore db from one server to another, but can't since the backup is created on another server(which it belongs to). What is the best way to do this?…
I have been reading a bit about tries, and how they are a good structure for typeahead designs. Aside from the trie, you usually also have a key/value pair for nodes and pre-computed top-n suggestions to improve response times. Usually,…
The following is my Prisma Schema for 3 models --> User, Cart and Item. model User { id String @id @default(auto()) @map("_id") @db.ObjectId name String email String @unique hashedPassword String isAdmin Boolean @default(false) cart Cart? } model Cart { id…
I am working on a system using JPA where Entity 'Events' are associated with Entity 'Groups' and each Group has five boolean columns (Group1, Group2...) indicating their attendance status for an event. Now, I need to enhance the system by…
i have a table like bellow in postgres start_at end_at 17/1/2023 15/3/2023 i want to split this like bellow start_at end_at 17/1/2023 31/1/2023 01/2/2023 28/2/2023 1/3/2023 15/3/2023 I have tried generate series of postgres but not able to generate desire…
I have two tables similar to this example (simplified for clarity): parent: | id | name | amount | year | ---------------------------------------- | 101 | Henry | 300 | 2020 | ---------------------------------------- | 102 | Carol | 100 | 2020…
What is the better way to insert a very large data into PostgreSQL Table? OS: Ubuntu 22.04 LTS DB: PostgreSQL 14 Framework: Python 3.11 Django For now I am using insert into statement of 100,000 rows at a time. It…
I have a table named user_activity. user_id book_id event_type_id 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 2 1 1 3 1 event_type_id represents "User has viewed the book". I want to…
I am currently working on a Laravel project and encountering an issue with Eloquent relationships. I have two models, User and Post, and I'm trying to establish a one-to-many relationship between them. However, I'm facing issues when trying to retrieve…