4 ms·

> SQL was not then, and is still not now, a very good blob or document storage system. Yet, there seemed to be no alternative to SQL for durability, short of re

• pixelmonkey 5y ago
  (Author here.) I cleared this up a bit on a past thread. I was using "SQL" here as a shorthand for "SQL RDMBSes", not quite "SQL the language". https://news.ycombinator.com/item?id=9670379 https://news.ycombinator.com/item?id=9670379 Also, SQL RDBMSes have changed in the intervening ~7 years. For example, PostgreSQL now has a native JSON data type[1] and many functions for working with JSON blob storage[2]. Lucene still handles unstructured text indexing and search use cases in a more direct way, however, and is still a magical analytical engine when wielded in the right way. [1]: https://www.postgresql.org/docs/current/datatype-json.html https://www.postgresql.org/docs/current/datatype-json.html [2]: https://www.postgresql.org/docs/9.5/functions-json.html https://www.postgresql.org/docs/9.5/functions-json.html