News for hackers. Stuff that matters.
Re:Internal Versus External BLOBs in SQLite by electrum on Friday December 26, 2014 @09:05PM (#8801357)
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_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."

Re:Internal Versus External BLOBs in SQLite by Spooky23 on Friday December 26, 2014 @09:39PM (#8801450)
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.

Re:Internal Versus External BLOBs in SQLite by twombly on Saturday December 27, 2014 @03:21AM (#8802062)
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.
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.

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?

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.