Query and manipulate the Supabase PostgreSQL database. Use for SELECT, INSERT, UPDATE, DELETE operations.
Execute SQL queries against the icl-sail Supabase database.
The database connection URL is stored in .env as DATABASE_URL. Load it before running queries:
source .env && psql "$DATABASE_URL" -c "YOUR_QUERY"
competition - Competition configurations (id, name, host, announcements, flags)team - Team information (~51 rows)race - Race results (~309 rows)admin - Admin users (~21 rows)flight - Flight information (~9 rows)halfflight - Half flight data (~13 rows)feedback - User feedback (~1 row)When the user provides $ARGUMENTS:
List all tables:
source .env && psql "$DATABASE_URL" -c "\dt public.*"
Query with nice formatting:
source .env && psql "$DATABASE_URL" -c "SELECT * FROM competition;"
Describe a table:
source .env && psql "$DATABASE_URL" -c "\d+ public.competition"
Spring Boot中的JPA/Hibernate模式,用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。