Django 5.2 支援 composite primary key
看到 Django 5.2 的公告，裡面列出了比較重大的改變，其中一個注意到的是支援 Composite (Compound) Primary Key 了：「Django 5.2 released」，完整的 release notes 則是在「Django 5.2 release notes」這邊可以看到。 就是因為這些 ORM library 不支援 compsite primary key，所以才會有 best (?) practice 要求每個表格都要有 primary key，而且是單一欄位... 大家應該都習以為常了，怎麼會突然在 2025 年才想要支援？ …
#composite #compound #database #db #django #library #orm #pk #PrimaryKey #rdbms
IBM i Database RowID: Unique Record Identification in AS400
Master IBM i Database RowID for robust data management! Learn reliable methods for unique record identification using primary keys & other strategies. Avoid pitfalls of using RRN. #IBMiDatabase #DB2fori #AS400data #UniqueRecordID #Primarykey #DataManagement
https://tech-champion.com/database/db2luw/ibm-i-database-rowid-unique-record-identification-in-as400/
Composite Primary Keys: When Simplicity Trumps Complexity in Database Design
Optimizing database design: Single vs. composite primary keys. For smaller databases, a single, auto-incrementing primary key often offers superior performance & maintainability. Simplicity trumps complexity! Composite primary keys add complexity to updates & queries. #DatabaseDesign #PrimaryKey #CompositeKey #SQL #DatabaseOptimization #Performance
https://tech-champion.com/database/db2luw/composite-primary-keys-when-simplicity-trumps-complexity-in-database-design/
Q: What sits between you and your Data? A: Identifiers! Read: #URI #LinkedData #PrimaryKey #ForeignKey #ODBC #NewSQL
Keys in DBMS | Super Key| Candidate Key| Primary Key| Foreign Key |DBMS Lect 14| Shanu Kuttan |Hindi
DBMSKeys #SuperKey #CandidateKey #PrimaryKey #ForeignKey #AlternateKey #CompositeKey #Keys in DBMS This video ... source
https://andrewlock.net/generating-sortable-guids-using-newid/ - #PrimaryKey: auto-incrementing int or Guid? What about #NewId? It's sortable-ish. Great post @andrewlock.
😂 😂
(via @akretschmer) #primarykey #database #geekjokes #geekhumour #geekhumor #databasehumour #postgres #postgresql
I love it when an #RDB #database sports a #primaryKey in one table that doesn't have a corresponding column anywhere else. That's just great #dataModeling right there.
I love it when an #RDB #database sports a #primaryKey in one table that doesn't have a corresponding column anywhere else. That's just great #dataModeling right there.
