4 ms·
Fair enough, but you can also have a schemaless store by using JSON fields in PostgreSQL or MySQL.
by goldmab 15y ago
Fair enough, but you can also have a schemaless store by using JSON fields in PostgreSQL or MySQL.
- deoxxa 15y agoThat's not an unfair comparison at all - indexing the data in a JSON blob is entirely possible and practical.
- einhverfr 15y agoWhat you want to index regarding a large text file and what indexes you can create and use may be different.
- angelbob 15y agoNot indexably. But you can do a hideous many-tables-per-real-table thing where each field gets a tall thin table in PostGRES or MySQL, do a lot of joins to get your data, and index the fields in that. It's not as awful as it sounds, performance-wise. It is as awful as it sounds in terms of maintainability, of course.
- joevandyk 15y agoYou can index hstore fields in PostgreSQL.