I'm beginner in Flutter, Riverpod for the state management and firebase for the authentication. I'm looking to retrieve the logged user's email to pass to my postgres database and retrieve all the user information. In a first time, I just…
I have a query that is taking transactions (buying and selling of items) to calculate the gain/loss when the running total resets back to 0. The fiddle is here: https://www.db-fiddle.com/f/974UVvE6id2rEiBPR78CKx/0 The units of each item can be added and subtracted…
I'm trying to define more than one foreign key in the process table. but I am getting the error that the columns I am trying to define as foreign key are not 'unique value'. For this, I wanted to define…
I'm new to databases and have been considering using a UUID as the primary key in my project, but I read some things which made me interested to learn more about the performance. Currently, I am using the uuid data…
I want to update data using query but when column is not null, it will not update and still use old data. I tried with this query but failed. UPDATE tableA SET column2 = case column2 WHEN NULL THEN to_timestamp('2022-08-09…
I have a requirement where I need to store an IP address in the table on a rails app. The format could be of IPv4 or IPv6. Currently I thought of storing them as 'strings'. But is this a good…
I want to implement efficient pagination in Postgresql (14.5): give me a few rows associated with some a, that come immediately after some b. Unfortunately Index Cond disappears from under the Index Only Scan as soon as I try to…
I have an app which uses AWS Lambda functions to store images in a AWS PostgreSQL RDS as bytea file types. The app is written in javascript and allows users to upload an image (typically small). <input className={style.buttonInputImage} id="logo-file-upload" type="file"…
I am trying to save an array of values in AWS RDS. When I go into the RDS query editor I am able to run this insert without any issues: insert into picture_tags (picture_id, tag_id) values (picId, unnest(ARRAY[tagId1, tagId2])::uuid); (the…
If I run this SQL code in my PostgreSQL database, it works fine: select e.type_id, s.copy_destination || '' FROM ebooks.ebooks e, ebooks.static_text s WHERE e.status_id = 1 But when I add the join, everything goes pear-shaped. So if I run:…