I have a very flat table that is a collection of swimmer names, distances, events (strokes), and times(float). What I would like is to get the only fastest time for each combination of distance and stroke. To be clear, there…
How can I store nested lists in Postgres in way that's easy to use them in my Python program later? I plan to write the lists to the database once and reuse them many times. I've been able to store…
In SQL I have: CREATE TABLE Customer( cust_id INT NOT NULL PRIMARY KEY CHECK (cust_id > 0), full_name TEXT NOT NULL, phone TEXT NOT NULL, address TEXT NOT NULL CHECK (LENGTH(address) >= 3) ); CREATE TABLE "Order"( order_id INT NOT…
There are the following table structures and data: CREATE TABLE t_source_category ( id INT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, label varchar(255) NOT NULL, path varchar(255) NOT NULL, pid INT NOT NULL); INSERT INTO t_source_category (id, label, path, pid)…
I have a simple table in Vercel Postgres: export const sets = createTable("card_table", { id: varchar("id").primaryKey(), info: jsonb("info"), }); I have populated the table with data and would like to do a bulk update. I figured out how to update…
I have string values (filed name: filename) that follow a certain template: filename_this_is_called_Plan_A file_this_is_Plan_A filename2024_this_is_known_as_Plan_A While the strings are all a different length, they all end with _Plan_A, also known as the segment. How can I trim this in PostgreSQL…
Let's say I have a table t, 2 of its columns are A1 and A2. It looks something like this: A1 A2 ID 1,3,6,9,11 3,9 1 2,3,5,7 3 2 ... I want to add a column with the result: A3…
I have created a spring boot application that can connect to the postgresql14 instance (running in my GCP project) when I run the application on my local machine. Setup I used to make it work: Created a postgresql14 instance with…
Original post I want to try out the Apache Arrow Flight SQL Driver for a large OLAP query on a PostgreSQL database. When I run the following example: import adbc_driver_flightsql.dbapi import adbc_driver_manager conn = adbc_driver_flightsql.dbapi.connect('flightsql://username:[email protected]:5432/database') with conn.cursor() as cur: cur.execute("SELECT…
I am designing a website for my company that will have a user log in page that will lead to a customized dashboard. I am currently, using PostgreSQL to store information in the back end of this website. Would I…