News for hackers. Stuff that matters.

A comment on Internal Versus External BLOBs in SQLite. Parent comment

Re:Internal Versus External BLOBs in SQLite by xorcist on Saturday December 27, 2014 @05:11AM (#8802227)
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.

[ Parent | on HN ]
Re:Internal Versus External BLOBs in SQLite by Spooky23 on Saturday December 27, 2014 @01:31PM (#8803418)
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?

[ Parent | on HN ]
Re:Internal Versus External BLOBs in SQLite by regularfry on Saturday December 27, 2014 @09:30AM (#8802631)
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.
[ Parent | on HN ]