7 ms·
Meh. If the backing store is not SQL, why would a SaaS provide a (much harder to implement) SQL layer with all its standards (92, 99, 2003) and quirks instead o
by mping 8y ago
Meh. If the backing store is not SQL, why would a SaaS provide a (much harder to implement) SQL layer with all its standards (92, 99, 2003) and quirks instead of writing a (probably) much simpler custom query language?
- jaggederest 8y agoI think what he's asking is that people allow a flat file export, which you would have to map and import yourself. This seems reasonable to me. And I agree. I wasn't involved in writing NRQL but statistics queries at New Relic during my time were already approaching turing completeness, so it was just a matter of time. Timeseries data in particular really doesn't map well to SQL at all, sadly, as a SQL fan working with a lot of timeseries data over the decade+ now.
- nemothekid 8y ago>I think what he's asking is that people allow a flat file export, I don't get this though. If you want to export your data as some flat file, why use MixPanel at all? Just store the events in your own database and query it yourself. Why pay the cost of both solutions?
- threeseed 8y agoSome companies do allow flat file export. Others don't because sometimes it's not that simple to fetch all of the data to give you with one click. Many of these companies are just rolling up the metrics in some online database and hiding the original files away in cold storage.
- BerislavLopac 8y agoWhy does it have to be either SQL or a custom language anyway? We have developed many generic query languages for various different structures [0]. [0] https://en.wikipedia.org/wiki/Query_language https://en.wikipedia.org/wiki/Query_language