Doctrine 1

SQLite3 *does* support foreign keys

Details

  • Type: Improvement Improvement
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.2.1
  • Fix Version/s: None
  • Component/s: Connection, Relations
  • Labels:
    None
  • Environment:
    SQLite 3

Description

SQLite3 from 3.6.19 does natively support foreign keys. Older versions do read and ignore foreign key declarations - and tools exist to read the schema from a sqlite3 db and create "foreign key triggers"

Not including foreign key declarations in table DDL seems rather odd, if not a bug

  1. File
    diff
    25/Jan/10 7:48 AM
    2 kB
    Hans-Peter Oeri

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Jonathan H. Wage added a comment -

I don't think we can add this to 1.2.2 because instantly turning on this support for people already using sqlite might break existing code. Moving it to 1.3 milestone.

Show
Jonathan H. Wage added a comment - I don't think we can add this to 1.2.2 because instantly turning on this support for people already using sqlite might break existing code. Moving it to 1.3 milestone.
Hide
Permalink
Jonathan H. Wage added a comment -

The version 3.6.19 is pretty new, we should avoid version specific features. Maybe in the future once this version has established itself we can consider adding support for this. Anyways, sqlite is not really a recommended production rdbms.

Show
Jonathan H. Wage added a comment - The version 3.6.19 is pretty new, we should avoid version specific features. Maybe in the future once this version has established itself we can consider adding support for this. Anyways, sqlite is not really a recommended production rdbms.

People

  • Assignee:
    Jonathan H. Wage
    Reporter:
    Hans-Peter Oeri
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: