Opened 14 years ago
Last modified 5 years ago
#14204 closed New feature
Take advantage of (newish) SQLite support for FK constraints — at Version 8
| Reported by: | Ramiro Morales | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | sqlite, foreign key |
| Cc: | me@…, Simon Charette | Triage Stage: | Accepted |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
SQLite3 3.6.19 from Oct 14 2009 adds support for enforcing these constraints. See http://www.sqlite.org/foreignkeys.html
Creating this ticket to track this feature, with an initial implementation patch to get feedback. Will also open a django-dev thread.
Change History (9)
by , 14 years ago
| Attachment: | 14204-sqlite-fk-constraints.diff added |
|---|
comment:2 by , 14 years ago
| Triage Stage: | Unreviewed → Accepted |
|---|
Accepted on principle; however, we need to be clear on the backwards compatibility consequences of this change. In particular, I'm concerned about automatically enabling "PRAGMA foreign_keys" just because the feature is available.
comment:3 by , 14 years ago
| Summary: | Take advantage of (newish) SQLlite support for FK constraints → Take advantage of (newish) SQLite support for FK constraints |
|---|
This is the django-dev mailing list thread: http://groups.google.com/group/django-developers/browse_thread/thread/fcda59f4ae21a6fd
comment:4 by , 13 years ago
| Keywords: | sqlite foreign key added |
|---|---|
| Severity: | → Normal |
| Type: | → New feature |
comment:8 by , 10 years ago
| Description: | modified (diff) |
|---|
Note:
See TracTickets
for help on using tickets.
First implementation