Periscope Data Blog
periscope.io · Company blog · on HN since 2012
The Periscope Data blog covers SQL analytics, with tips on query performance, Redshift, Postgres, and schema design from a data analysis vendor.
What HN saysHN links it for practical SQL performance posts, like counting distinct values faster, and the company posts job listings and discusses competing analytics tools.
24HN people shared it
8linked it in comments
58stories submitted
480story points
11 years agolast shared
2012people per year2026
Most-shared posts
- 1SQL reporting tool with beautiful visualizations7 people · 9 points · first shared 2012 · discussion on HN
- 2Use SQL subqueries to count distinct 50x faster4 people · 311 points · first shared 2014 · 98 comments on HN
- 3Count distinct performance compared on top 4 SQL databases4 people · 37 points · first shared 2014 · 7 comments on HN
- 4Show HN: The Lazy Analyst's Guide to Amazon Redshift2 people · 11 points · first shared 2015 · discussion on HN
- 54 Reasons Not to Use MySQL for Analysis2 people · 6 points · first shared 2015 · discussion on HN
- 6The Lazy Analyst's Guide to Postgres JSON2 people · 6 points · first shared 2015 · discussion on HN
- 710 Rules for a Better SQL Schema2 people · 6 points · first shared 2015 · discussion on HN
- 8Building Your Own User Analytics System in SQL2 people · 3 points · first shared 2015 · discussion on HN
- 9SQL for Marketers2 people · 3 points · first shared 2014 · discussion on HN
- 10Reuse Calculations in the Same Query with Lateral Joins2 people · 3 points · first shared 2015 · discussion on HN
- 11Predicting Exponential Growth With SQL2 people · 3 points · first shared 2014 · discussion on HN
- 12Data obsessed engineer2 people · first shared 2014
- 13Show HN: The Lazy Analyst's Guide to Faster SQL1 people · 18 points · first shared 2015 · 6 comments on HN
- 14HyperLogLog in Pure SQL1 people · 9 points · first shared 2014 · discussion on HN
- 15Pimping your psql1 people · 5 points · first shared 2014 · discussion on HN
What HN people wrote when they linked it
mopatches · 2015-09-01
Periscope | San Francisco, ONSITE | Customer Support Specialist (SQL), Full Stack Engineer (Ruby, Go, CoffeeScript, Java) | https://www.periscope.io/
We make SQL data analysis really fast! Our customers build and share dashboards around their companies after querying tens of billions of rows in seconds.
Our best feature is the way we support our customers. Many of them have said that our chat support is "the best customer support they've ever had".
If you are excited to join our team of 10 and help continue this awesome tradition, we'd love to meet you!
Email us at [email protected]
hglaser · 2014-05-03
This looks very cool. My company (http://periscope.io) is just now getting to the point of putting documentation online, and -- surprise! -- it's a huge pain and products in this space all seem mediocre.
One deal-breaker for me is that it has to feel like it's on my website. This means templates are not enough: I need full CSS customizability (statuspage.io does a good job with this) or iframe ability. The lack of a great, fully customizable product in this space is why I am currently fucking around with Markdown pages.
It's certainly fair to charge a lot more than you're apparently charging in order to get this customizability -- needing it probably predicts a real business that cares about its brand. (If knol.io becomes a big business I bet you'll end up charging a lot more in general.)
Anyway, awesome job with this! Looks like a great product solving a real problem.
jonbishop · 2015-06-23
Hey Zack, it’s probably a good idea to disclose that you work at Looker if you’re going to talk about them on HN. https://www.linkedin.com/profile/view?id=145490726
I run marketing for Periscope. Like Chartio, you guys have a great product. We routinely send people your way when they have more business user needs and aren’t a good fit for Periscope.
For those evaluating tools like Periscope/Looker/Chartio:
Whereas Looker focuses on business users, we’ve built Periscope around serving SQL analysts better than anyone else.
If you don't have someone who knows SQL on your team, Looker (or Chartio) is probably a better fit. (though I should mention that some customers have learned SQL through our customer support :)
We’re focused on the SQL analysts who are building dashboards and running reports, day in, day out. With that said, every one of our customers has employees who don’t know SQL, but need to dive into their data. So we’ve built a ton of features to make this easy as well.
If you want to find out more, visit https://www.periscope.io. If Periscope looks like a good fit, sign up and we'll get you set up with a free trial.
liscovich · 2015-10-07
Looker (http://www.looker.com), Periscope (http://www.periscope.io), Mode Analytics (http://www.modeanalytics.com), and Chart.io (http://www.chart.io) should probably be even more worried than Tableau.
jabo · 2015-03-26
I've been seeing ads for an analytics app called periscope: https://www.periscope.io. For a second, I thought it was them before clicking through. Poor periscope.io.
noelherrick · 2015-04-24
I've seen a surprising amount of companies with a stack of Java/Linux for the application and SQL Server/Windows for the database. Just look at Indeed.com's job posting if you don't believe me[1]. If SQL Server was on Linux, they'd switch in a minute.
RDBMSes that you pay for are still able to out perform free, community-developed systems [2]. I've done work on both the DBA and the developer side on Postgres, MySQL, and SQL Server, and I can tell you that if platform and cost were never an issue, I'd choose the latter every time.
[1] http://www.indeed.com/jobs?q=Java+SQL+Server
[2] https://www.periscope.io/blog/count-distinct-in-mysql-postgres-sql-ser…
ahmed1490 · 2014-01-25
Similar example and simplier explanation for noobs. :)
Was on HN yesterday.
https://periscope.io/blog/use-subqueries-to-count-distinct-50x-faster.…
krohling · 2012-11-30
The companies:
Pericope: http://www.periscope.io/
FreedomCP: http://www.freedomcp.com/
Kinnek: http://www.kinnek.com/
Boomtrain: http://www.boomtrain.com/
Tray: http://www.tray.io/
Circl: http://www.joincircl.com/
ScaleGrid: http://www.scalegrid.net/
Buyou: http://www.buyouapp.com/
cisimple: http://www.cisimple.com
Shop2: http://www.shop2.com/
UpCounsel: http://www.upcounsel.com/
Storefront: http://www.storefront.is/