Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove SQLite foreign key enforcement code #12151

Closed
bricelam opened this issue May 26, 2018 · 5 comments
Closed

Remove SQLite foreign key enforcement code #12151

bricelam opened this issue May 26, 2018 · 5 comments
Assignees
Labels
breaking-change closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Milestone

Comments

@bricelam
Copy link
Contributor

I believe it's enabled by default in e_sqlite3. We should investigate and remove our code in 3.0

@ajcvickers
Copy link
Member

Note: if we decide not to do this for 3.0, then we should look again at #13054

@bricelam
Copy link
Contributor Author

Need to discuss our options...

Library DEFAULT_FOREIGN_KEYS
e_sqlite3
iOS
sqlcipher
winsqlite3
sqlite3

@bricelam bricelam removed this from the 3.0.0 milestone Nov 13, 2018
@ajcvickers
Copy link
Member

Tentative decision from triage: change to reference a different bundle. This means that there will be a consistent experience across all platforms, but the version already installed on the device may not be used by default.

@ajcvickers ajcvickers modified the milestones: 2.2.0, 3.0.0 Nov 14, 2018
@bricelam
Copy link
Contributor Author

@ericsink Any words of caution? We’re planning on switching to SQLitePCLRaw.bundle_e_sqlite3 in 3.0.

@ericsink
Copy link

No caution from me. In my experience, using the system SQLite in a cross-platform situation causes nothing but trouble (and, admittedly, smaller binary size).

FWIW, if you were to peer into my repo right now, you would see that I have recently made some changes to the way e_sqlite3 builds are done and managed. I moved the builds out into a separate repo and made a number of improvements. This includes an attempted fix for the load_extension problem you were having with the spatial library. And an update to SQLite 3.25.x.

This work needs more testing before I release it, and I had to set it aside 2-3 weeks ago to deal with something else, but I expect my schedule flexibility to return soon and allow me to get a new release published in the next couple weeks.

@bricelam bricelam added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Feb 5, 2019
bricelam added a commit that referenced this issue Feb 7, 2019
Switches from bundle_green to bundle_e_sqlite3. This makes iOS and macOS more consistent.

Removes PRAGMA foreign_keys code from EF. Foreign keys are enabled by default in e_sqlite3. Add ForeignKeys=True to your connection string if otherwise needed.

Fixes #12151
@ajcvickers ajcvickers modified the milestones: 3.0.0, 3.0.0-preview3 Feb 22, 2019
@ajcvickers ajcvickers modified the milestones: 3.0.0-preview3, 3.0.0 Nov 11, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
breaking-change closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-enhancement
Projects
None yet
Development

No branches or pull requests

3 participants