Skip to content

Latest commit

 

History

History
11 lines (10 loc) · 575 Bytes

2003.md

File metadata and controls

11 lines (10 loc) · 575 Bytes

Files Are Not SQL Data Types

Resources outside the database are not managed by the database:

It's common for programmers to be unequivocal that we should always store files external to the database. Files don't obey DELETE, transaction isolation, rollback, or work well with database backup tools. They do not obey SQL access privileges and are not SQL data types. Resources outside the database are not managed by the database. You should consider storing blobs inside the database instead of in external files. You can save the contents of a BLOB column to a file.