#foreignkey — Public Fediverse posts on home.social

PrecisionSQL @[email protected] · 2026-03-29 · 15:40 UTC

One DELETE Cascades To 3.5 MILLION Rows?!

PRODUCTION APOCALYPSE! Deleted ONE user and CASCADE deleted 3.5 MILLION rows across 4 tables! Orders, payments, everything GONE! This is the scariest SQL behavior! Watch this nightmare!

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss #sqlfails #massdeletion #sqlshorts #databasedisaster #sqlwtf #cascadenightmare

https://www.youtube.com/watch?v=pE_OMbOia_w

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss

PrecisionSQL @[email protected] · 2026-03-29 · 15:40 UTC

One DELETE Cascades To 3.5 MILLION Rows?!

PRODUCTION APOCALYPSE! Deleted ONE user and CASCADE deleted 3.5 MILLION rows across 4 tables! Orders, payments, everything GONE! This is the scariest SQL behavior! Watch this nightmare!

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss #sqlfails #massdeletion #sqlshorts #databasedisaster #sqlwtf #cascadenightmare

https://www.youtube.com/watch?v=pE_OMbOia_w

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss

PrecisionSQL @[email protected] · 2026-03-29 · 15:40 UTC

One DELETE Cascades To 3.5 MILLION Rows?!

PRODUCTION APOCALYPSE! Deleted ONE user and CASCADE deleted 3.5 MILLION rows across 4 tables! Orders, payments, everything GONE! This is the scariest SQL behavior! Watch this nightmare!

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss #sqlfails #massdeletion #sqlshorts #databasedisaster #sqlwtf #cascadenightmare

https://www.youtube.com/watch?v=pE_OMbOia_w

#sql #sqldisaster #cascadedelete #foreignkey #productionbug #dataloss

MTBeeSQL @[email protected] · 2026-02-09 · 05:18 UTC

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

#dt260208 #sql #primarykey #foreignkey #sqlite

MTBeeSQL @[email protected] · 2026-02-09 · 05:18 UTC

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

#dt260208 #sql #primarykey #foreignkey #sqlite

MTBeeSQL @[email protected] · 2026-02-09 · 05:18 UTC

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

#dt260208 #sql #primarykey #foreignkey #sqlite

MTBeeSQL @[email protected] · 2026-02-09 · 05:18 UTC

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

#sqlite #foreignkey #primarykey #sql #dt260208

MTBeeSQL @[email protected] · 2026-02-09 · 05:18 UTC

# #dt260208
# #sql
# #primarykey
# #foreignkey
# #SQLite

I had chatgpt refactor the bookbiz database schema (from PracticalSQL book 2nd ed). It added primary and foreign keys. I then had it refactor for SQLite specifically.

https://chatgpt.com/share/69894b9c-b944-8008-b758-b283987b4086

...

Highlights:

1. SQLite-Idiomatic Schema (Clean Rewrite)
Global settings (critical in SQLite)
PRAGMA foreign_keys = ON;
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;

#dt260208 #sql #primarykey #foreignkey #sqlite

Python Job Support @[email protected] · 2024-10-22 · 21:56 UTC

DBMSKeys #SuperKey #CandidateKey #PrimaryKey #ForeignKey #AlternateKey #CompositeKey #Keys in DBMS This video ... source

https://quadexcel.com/wp/keys-in-dbms-super-key-candidate-key-primary-key-foreign-key-dbms-lect-14-shanu-kuttan-hindi/

#superkey #candidatekey #primarykey #foreignkey #alternatekey #compositekey

derwaro :tux: :python: @derwaro · 2024-06-26 · 19:45 UTC

Spent hours today looking for the following: I have a #Flask app with #sqlalchemy. I use #flaskadmin for a big part of functionality.
I need to pass a custom query for a select field that is a #foreignkey between Table A and table B. I try to accomplish that while being in the list view (the table view) for all entries in Table A, where each record has a foreignkey from Table B to only show those records in the select field for the foreignkey that are B.active==true.Is there a way to do this?

#flask #sqlalchemy #flaskadmin #foreignkey

derwaro :tux: :python: @[email protected] · 2024-06-26 · 19:45 UTC

Spent hours today looking for the following: I have a #Flask app with #sqlalchemy. I use #flaskadmin for a big part of functionality.
I need to pass a custom query for a select field that is a #foreignkey between Table A and table B. I try to accomplish that while being in the list view (the table view) for all entries in Table A, where each record has a foreignkey from Table B to only show those records in the select field for the foreignkey that are B.active==true.Is there a way to do this?