Does one of these options support both SQL based and REST interfaces with TSV and JSON output with little user setup<span></span>? I&#39;m thinking of your typical Ubuntu/Mac/Windows user with the ability to import TSV data into a spreadsheet. <br><div><br>On Tuesday, June 9, 2015, Dario Taraborelli &lt;<a href="mailto:dtaraborelli@wikimedia.org">dtaraborelli@wikimedia.org</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I too would love to understand if RestBASE can become our default solution for this kind of data-intensive APIs. Can you guys briefly explain what kind of queries and aggregations would be problematic if we were to go with Cassandra?<br>
<br>
&gt; On Jun 9, 2015, at 8:39 AM, Oliver Keyes &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;okeyes@wikimedia.org&#39;)">okeyes@wikimedia.org</a>&gt; wrote:<br>
&gt;<br>
&gt; Remember that (as things currently stand) putting the thing on labs<br>
&gt; means meta-analytics (&quot;how are the cubes being used?&quot;) being a pain in<br>
&gt; the backside to integrate with our existing storage solutions.<br>
&gt;<br>
&gt; On 8 June 2015 at 22:52, Dan Andreescu &lt;<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;dandreescu@wikimedia.org&#39;)">dandreescu@wikimedia.org</a>&gt; wrote:<br>
&gt;&gt;&gt; As always, I&#39;d recommend that we go with tech we are familiar with --<br>
&gt;&gt;&gt; mysql or cassandra. We have a cassandra committer on staff who would be able<br>
&gt;&gt;&gt; to answer these questions in detail.<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; WMF uses PostGRES for some things, no?  Or is that is just in labs?<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Since this data is meant to be fully public and queryable in any way, we<br>
&gt;&gt; could put it in the PostgreSQL instance on labs.  We should check with labs<br>
&gt;&gt; folks, perhaps horse trade some hardware, but I think that would be a<br>
&gt;&gt; splendid solution.<br>
&gt;&gt;<br>
&gt;&gt; However, and I&#39;m trying to understate this in case people are not familiar<br>
&gt;&gt; with my hyperbolic style, I&#39;d rather drink Bud Lite Lime than use MySQL for<br>
&gt;&gt; this.  MySQL is suited for a lot of things, but analytics is not one of<br>
&gt;&gt; them.<br>
&gt;&gt;<br>
&gt;&gt; p.s. I will never drink Bud Lite Lime.  Like, never.<br>
&gt;&gt;<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Analytics mailing list<br>
&gt;&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;Analytics@lists.wikimedia.org&#39;)">Analytics@lists.wikimedia.org</a><br>
&gt;&gt; <a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
&gt;&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; --<br>
&gt; Oliver Keyes<br>
&gt; Research Analyst<br>
&gt; Wikimedia Foundation<br>
&gt;<br>
&gt; _______________________________________________<br>
&gt; Analytics mailing list<br>
&gt; <a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;Analytics@lists.wikimedia.org&#39;)">Analytics@lists.wikimedia.org</a><br>
&gt; <a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br>
<br>
_______________________________________________<br>
Analytics mailing list<br>
<a href="javascript:;" onclick="_e(event, &#39;cvml&#39;, &#39;Analytics@lists.wikimedia.org&#39;)">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
</blockquote></div>