News for hackers. Stuff that matters.
Re:SQLite small blob storage: 35% Faster Than the Filesystem by Klathmon on Wednesday June 14, 2017 @08:24AM (#14552184)
I figured there was something massively annoying with it.

I'm hoping that PostgreSQL can try to tackle this use-case somehow because it's so damn common and 99% of the time the solution that is used completely throws out all the guarantees that the database gives you.

Re:SQLite small blob storage: 35% Faster Than the Filesystem by _jal on Wednesday June 14, 2017 @11:33AM (#14553460)
I'm not sure there's a non-annoying way to bridge the problem. The semantics are just so different that there's a lot of friction that needs to be handled somewhere. (What does O_DIRECT mean in this context? What happens when someone decides to store files that are never normally closed?)

In some ways, the problem mirrors OR mappers. A lot of common cases can be handled, but there are always situations where you're confronted with the fact that relational logic just doesn't map cleanly to OO (or hierarchic storage).

Re:SQLite small blob storage: 35% Faster Than the Filesystem by rusanu on Wednesday June 14, 2017 @02:07PM (#14554684)
Since you mention the OR impedance mismatch problem, I have to link to The Vietnam of CS article: http://blogs.tedneward.com/post/the-vietnam-of-computer-scie...