alihan/rqlite-distributed-sql
1
0
Fork 0
mirror of https://github.com/rqlite/rqlite.git synced 2022-10-30 02:37:32 +03:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
rqlite-distributed-sql/DOC/FOREIGN_KEY_CONSTRAINTS.md
Philip O'Toole 63b40ec3e8 Correct typo
2021-08-12 12:40:54 -04:00

552 B
Raw Permalink Blame History

Foreign Key Constraints

Since SQLite does not enforce foreign key constraints by default, neither does rqlite. However you can enable foreign key constraints in rqlite via the command line option -fk=true. Setting this command line will enable Foreign Key constraints on all connections that rqlite makes to the underlying SQLite database.

Issuing the PRAGMA foreign_keys = boolean command usually results in unpredictable behaviour, since rqlite doesn't offer connection-level control of the underlying SQLite database. It is not recommended.