4 ms·
If you like Redshift, you really should look at BitYota (http://www.bityota.com/ http://www.bityota.com/). Launched the same day at the AWS Re:invent show as R
by mwexler 13y ago
If you like Redshift, you really should look at BitYota (http://www.bityota.com/ http://www.bityota.com/). Launched the same day at the AWS Re:invent show as Redshift, it provides much of the performance of Redshift with much more customization, as well as a more rounded set of SQL extensions (including SQL-2003 OLAP functions and UDFs in multiple languages).
I don't work for them, but they make a good product.
- binarydud 13y agoOne of the big advantages of redshift is the postgres protocol compatibility. Which means I don't have to rewrite code to connect to redshift and run queries. It seems that BitYota wants me to run queries via json. Really? Why would I lock my code into using something like that?
- mwexler 13y agoI think you are misreading the Bityota pages. On the contrary, you CAN run queries with JSON... but you can also just pass in regular SQL statements. I guess Postgres direct protocol is handy; I find that ODBC covers many of my needs, so I haven't actually looked at Bityota as a Postgres drop-in. Might be worth playing with what Bityota offers; Postgres is awesome but sometimes makes you bend over backwards to do things that are easier in other systems. Paraccel/Redshift has some good extensions, but sometimes there are better ways to do things.