5 ms·
Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more inf
by cwyers 11y ago
Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that.
Also, none of those queries will work on MySQL.
- ekns 11y agoI recognize the syntax in "date_trunc('day', created_at)::date as day,", namely the cast "::date", as PostgreSQL syntax. Could be something else as well but I've only seen it with PostgreSQL.
- fidget 11y agoIt's redshift, based on the contents of previous blogs.
- ModernSQL 11y agoThe examples are either PostgreSQL or Amazon Redshift (which is based on the same syntax).
- bsg75 11y agoPostgreSQL or its derivatives. The code would work on most engines that support CTEs, with some changes to the type casting syntax. Thus most except MySQL.
- jpitz 11y agoThey support Postgres, Microsoft SQL Server, Redshift, and Oracle I believe.
- frik 11y agoIs it just me or is Periscope allergic to showing the "Pricing" page? (SaaS anti-pattern) Or is it free? The blog content is good though
- stingraycharles 11y agoYou can get a free trial, but it's most definitely not free (on the contrary, the price is a lot higher than i would've expected).
- Artemis2 11y agoIt's not extremely expensive, but it's clearly aimed at enterprise-level companies and not at small businesses.
- numlocked 11y agoI won't blow it by sharing the pricing they quoted me, but I thought it was pretty reasonable. That said, I do have one major gripe with their sales process: Their free trial lasts 7 days. There is no way a company can evaluate a completely new BI system in a week. I begged and pleaded and they would not extend the trial. I'm not just saying this, but I really really do think we would have bought it if we could have had 30 days. I just can't build enough organizational momentum to spend money on a new system in 7 days.
- hglaser 11y agoSorry about that! Just sent you an email.
- hglaser 11y agoPeriscope Data cofounder here. I wouldn't say we're "allergic" necessarily. ;) Like a lot of startups, we're very young and haven't gotten around to building out the website as much as we'd like to. `jplitz and `ajones are right. As of now we support MySQL, Postgres, Amazon Redshift, Vertica, SQL Server, Oracle, MemSQL, Sybase, Exasol and Google BigQuery. We add more all the time.
- mistermann 11y agoShouldn't be too much work to copy/paste that onto the website, should we expect to see it there soon? :)
- rubyfan 11y agoThe examples worked well in Hive also. I've never used Periscope but have followed and read the blog for a while. Always great content.