I was looking to update fields on a row in PostgreSQL only if the fields were null. Otherwise I would overwrite what's already in the row. My update looks as simple as this: UPDATE public.people SET flag=$flag, name=$name, surname=$surname WHERE…
I'm compiling a database of decently sized documents (anywhere from 20 to 500 characters), and I would like to be able to very quickly (under 1s) search through them. I started with around 100k rows worth of data, and now…
I have a table in Postgres with the following schema: create table if not exists cars ( id bigserial not null, tyre_code varchar(8) ); The tyre_code in the table should ideally not be more than 8 characters in length. But,…
Is it possible to display the image? The CategoryName was able to display fine, but the CategoryImage displayed as array of byte <asp:Repeater ID="Repeater1" runat="server"> <ItemTemplate> <%#Eval("CategoryImage")%> <%#Eval("CategoryName")%> </ItemTemplate> </asp:Repeater> SqlDataReader dtrImage = cmdSelect.ExecuteReader(); Repeater1.DataSource = dtrImage; Repeater1.DataBind(); Output: Animal…
I have a Postgres table like: id | value | category 0 | 10 | a 1 | 11 | b 2 | 50 | b 3 | 20 | a and I want the following (where the expression in…
I have a table like below which contains temperature data for the last 6 months. It takes about 30-40 readings of temperature in an hour. 'time' is in epoch milliseconds. time temperature 1678270897857 25 1678270777712 30 1678270657548 38 1678270537402 27…
I'm currently calculating 'fizziness' which is equal to volume * fizzyfactor / 100. However, the values become very long floats. I want to round them to one decimal point. When typecasting with numeric, it still has the same output. Why?…
I have two tables with a one-to-many relationship that looks something like this: CREATE TABLE products ( id UUID PRIMARY KEY, name TEXT ); CREATE TABLE product_variations ( id UUID PRIMARY KEY, product_id UUID REFERENCES products, attribute1 TEXT, attribute2 TEXT,…
I have a table named sales_data where I have 3 columns (id int, udf varchar(20), date_of_sale datetime). I'm trying to find weekday for the column date_of_sale by adjusting the time to 6 hours, now I have to update the column…
I’m currently building a todo application with Flutter. Currently my structure looks like this: users/{userid}/projects/{projectid}/tasks/(all the tasks) (1) But I've also come up with the following idea. (2) users/{userid}/projects/{projectid} users/{userid}/tasks/{taskid} // All tasks hold a reference to the projectid Is…