Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [supabase]

6 questions
2
votes
2 answers

Merging information from multiple rows into one row

I have three tables event, person and event_person_map event: id integer PRIMARY KEY event_name text event_date date person: id integer PRIMARY KEY full_name text email_address text event_person_map: id integer PRIMARY KEY person_id integer…
Lugoom485
  • 45
  • 6
0
votes
0 answers

Is it possible to create a table in Supabase programmatically using the Python client?

I would like to create a table on Supabase programmatically. Is this possible? Using this code: from supabase_client import supabase # SQL statements to create tables sql_create_tables = """--sql CREATE TABLE IF NOT EXISTS biomarker ( name…
Paul Razvan Berg
  • 101
  • 2
0
votes
0 answers

Preventing Race Conditions with SERIALIZABLE Isolation in Supabase for High-Concurrency Updates

Question: I'm working with Supabase/PostgreSQL in a Next.js application and need to ensure that an is_processing flag is updated only once per user, even if multiple requests are sent in parallel. The goal is to prevent any duplicate operations by…
Obaid Aqeel
  • 101
0
votes
1 answer

Postgres trigger with after and on row appears to not run after writing to row

I have the following two tables: CREATE TABLE qanda.group_questions ( id uuid DEFAULT gen_random_uuid() NOT NULL, category_id uuid NULL, business_model_id int4 NULL, industry_id int4 NULL, business_structure_id int4 NULL, …
Magick
  • 111
  • 1
  • 5
0
votes
1 answer

Debug RPC Function Creation in Supabase

I'm pretty new to database stuff. I'm using Supabase to create an application where I keep track of the number of likes on certain items ('clicks'). I want to filter items either by the date the likes were added, or by certain categories the items…
Rob
  • 3
  • 4
0
votes
1 answer

Seeking Guidance on Migrating MySQL/MariaDB Data to Supabase

I find myself facing a challenge, and I'm reaching out for some guidance. My current project involves a rebuild for a client, and we're considering adopting the Supabase stack. However, our existing MySQL database houses a substantial amount of…
Mathew Agustin Bella
  • 101
  • 1