4 ms·

Databases also have advantages: transactions, durable logging, replication, integrated backups, etc. Tom Kyte has some insightful points in this thread: https:

Databases also have advantages: transactions, durable logging, replication, integrated backups, etc. Tom Kyte has some insightful points in this thread: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1011065100346196442 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUE... "Do I want you to keep MY medical stuff in a directory, unsecured, unmanaged, not backed up like the database is - we have no idea if recovery is possible, who accessed it last? Who has access to it." "if this data is valuable to your business, if this data is necessary for your business, if the loss of this data would damage your ability to do business - it has no business NOT being in the database."

Spooky23 12y ago
Absolutely. I didn't say never do it... just that it doesn't make sense to me most of the time. Tom is Mr. Oracle, so I am not shocked that he's a big advocate of using that platform. But I don't like the straw man argument that anything that isn't managed by an Oracle DBA is automatically flawed and unreliable. Give me a break... Robust auditing, backup, professional management, etc can be delivered anywhere. (Or f'ed up on an Oracle platform) That said, it's a business decision -- somebody, somewhere has probably justified putting user home directories on an Oracle database.
twombly 12y ago
Actually yeah I do want to keep MY medial stuff in a directory ; but that doesn't mean that it's unsecured, unmanaged and not backed up. Ultimately all data ends up on the filesystem in one way or another if it's large enough. I would rather have a filesystem that I can trust rather than trying to fix/ignore that layer by building more layers on top of it.
xorcist 12y ago
Relatational databases has their advantages compared with hierarchical filesystems of blobs, but that comment is really completely beside the point. File systems are simpler and backups and replication are really much more straightforward. As anyone who did disaster recovery of Oracle databases can attest to, there are a lot of details to get wrong. It boils down to what data you want to store and what your access patterns look like.
- regularfry 12y ago
  You don't get to avoid backing up the database just because your file contents happen not to be in it. Now you have two different backup jobs not just to run, but to run atomically.
- Spooky23 12y ago
  Great point -- Oracle has a solid capability that is easy to operationally screw up. Database recovery is usually a real shitshow. When you go to other platforms, you need solid process AND deep exterior in whether the database can do what you want. Can MySQL handle the same recovery scenarios that Oracle can? With which storage engines?

Spooky23 12y ago

Absolutely. I didn't say never do it... just that it doesn't make sense to me most of the time. Tom is Mr. Oracle, so I am not shocked that he's a big advocate of using that platform. But I don't like the straw man argument that anything that isn't managed by an Oracle DBA is automatically flawed and unreliable. Give me a break... Robust auditing, backup, professional management, etc can be delivered anywhere. (Or f'ed up on an Oracle platform) That said, it's a business decision -- somebody, somewhere has probably justified putting user home directories on an Oracle database.

twombly 12y ago

Actually yeah I do want to keep MY medial stuff in a directory ; but that doesn't mean that it's unsecured, unmanaged and not backed up. Ultimately all data ends up on the filesystem in one way or another if it's large enough. I would rather have a filesystem that I can trust rather than trying to fix/ignore that layer by building more layers on top of it.

xorcist 12y ago

Relatational databases has their advantages compared with hierarchical filesystems of blobs, but that comment is really completely beside the point. File systems are simpler and backups and replication are really much more straightforward. As anyone who did disaster recovery of Oracle databases can attest to, there are a lot of details to get wrong. It boils down to what data you want to store and what your access patterns look like.

regularfry 12y ago
You don't get to avoid backing up the database just because your file contents happen not to be in it. Now you have two different backup jobs not just to run, but to run atomically.
Spooky23 12y ago
Great point -- Oracle has a solid capability that is easy to operationally screw up. Database recovery is usually a real shitshow. When you go to other platforms, you need solid process AND deep exterior in whether the database can do what you want. Can MySQL handle the same recovery scenarios that Oracle can? With which storage engines?