|
|
|
|
|
by Annatar
3715 days ago
|
|
One should never store binary data inside of a database, because those are either difficult or impossible to index properly, consume inordinate amounts of space, and can bring a RDBMS to a grind. Store the files in a filesystem
and store the paths to the files in the database. Refrain from using database engines which cannot provide instantaneous atomicity, consistency, isolation, and durability. If you do not, you will experience data corruption and thus availability issues, possibly of both transient and silent nature. Refrain from using databases which do not provide ANSI SQL, as you will eventually need the SQL data manipulation mechanism, which is consistent. To avoid the managed hosting penalty, you can start with SQLite, and do the replication and clustering within your application. For capitalizing on RDBMS capabilities, use PostreSQL Citus or Oracle RAC. Stay away from MySQL, as it silently corrupts data and has no OS authentication, making it difficult to automatically deploy. |
|