Changes between Version 4 and Version 5 of UserDocs/SQLite
- Timestamp:
- Feb 7, 2018, 4:28:21 AM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UserDocs/SQLite
v4 v5 10 10 11 11 12 The "[...] locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS [...]."([https://www.sqlite.org/faq.html#q5 SQLite FAQ]) See also [https://www.sqlite.org/lang_altertable.html SQLite Documentation].12 The "[...] locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS [...]."([https://www.sqlite.org/faq.html#q5 SQLite FAQ]) 13 13 14 14 15 15 == Delete and Change Column Names 16 "SQLite has limited ALTER TABLE support that you can use to add a column to the end of a table or to change the name of a table. If you want to make more complex changes in the structure of a table, you will have to recreate the table." ([https://www.sqlite.org/faq.html#q11 SQLite FAQ]) 16 "SQLite has limited ALTER TABLE support that you can use to add a column to the end of a table or to change the name of a table. If you want to make more complex changes in the structure of a table, you will have to recreate the table." ([https://www.sqlite.org/faq.html#q11 SQLite FAQ]) See also [https://www.sqlite.org/lang_altertable.html SQLite Documentation]. 17 17 18 18 == Delete and Change Names of Tables