Skip to content
HomeVideosBooksBlogs
AllTop postsTopics
Podcasts
HistoryListsWatch laterLiked videosFollowing

The videos, books, blogs and podcasts Hacker News keeps recommending, all in one place.

VideosBooksBlogsPodcastsAboutPrivacySettings

Data from Hacker News, HackerTube, HackerBooks, HackerBlogs and Open Library. Credits · Not affiliated with Y Combinator.

HomeVideosBooksBlogsPodcasts
Ctrl K
    P

    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.

    Visit blogHN submissions
    DatabasesData & Visualization
    What HN says

    HN links it for practical SQL performance posts, like counting distinct values faster, and the company posts job listings and discusses competing analytics tools.

    Stats for nerds
    24HN people shared it
    58linked in comments
    480story points
    Oct 2015last shared
    2012people per year2015

    Top posts on HN

    1. 1
      Use SQL subqueries to count distinct 50x faster
      4 people · 311 points · first shared 2014 · 98 comments on HN
    2. 2
      Count distinct performance compared on top 4 SQL databases
      4 people · 37 points · first shared 2014 · 7 comments on HN
    3. 3
      Show HN: The Lazy Analyst's Guide to Faster SQL
      1 person · 18 points · first shared 2015 · 6 comments on HN
    4. 4
      Show HN: The Lazy Analyst's Guide to Amazon Redshift
      2 people · 11 points · first shared 2015 · Discussion on HN
    5. 5
      SQL reporting tool with beautiful visualizations
      7 people · 9 points · first shared 2012 · Discussion on HN
    6. 6
      HyperLogLog in Pure SQL
      1 person · 9 points · first shared 2014 · Discussion on HN
    7. 7
      The Lazy Analyst's Guide to Postgres JSON
      2 people · 6 points · first shared 2015 · Discussion on HN
    8. 8
      10 Rules for a Better SQL Schema
      2 people · 6 points · first shared 2015 · Discussion on HN
    9. 9
      4 Reasons Not to Use MySQL for Analysis
      2 people · 6 points · first shared 2015 · Discussion on HN
    10. 10
      Pimping your psql
      1 person · 5 points · first shared 2014 · Discussion on HN

    What HN people wrote when they linked it

    • jonbishopJun 2015

      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.

    • hglaserMay 2014

      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.

    • noelherrickApr 2015

      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-server-and-oracle.html

    • mopatchesSep 2015

      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 hello@periscope.io

    • krohlingNov 2012

      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/

    • liscovichOct 2015

      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.

    Related

    Citus Data Blogcitusdata.com224 people

    Citus Unforks from PostgreSQL, Goes Open Source

    Citus Data Blog
    Company · last shared 2026
    Percona Blogpercona.com327 people

    UUIDs are popular, but bad for performance (2019)

    Percona Blog
    Company · last shared 2026
    Crunchy Data Blogcrunchydata.com187 people

    Learn Postgres at the Playground – Postgres compiled to WASM running in browser

    Crunchy Data Blog
    Company · last shared 2026
    Timescale Blogblog.timescale.com95 people

    How percentile approximation works and why it's more useful than averages

    Timescale Blog
    Company · last shared 2022
    pganalyze Blogpganalyze.com54 people

    Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

    pganalyze Blog
    Company · last shared 2026
    Treasure Data Blogblog.treasuredata.com17 people

    Distributed Logging Architecture in the Container Era

    Treasure Data Blog
    Company · last shared 2020
    PlanetScale Blogplanetscale.com211 people

    Generics can make your Go code slower

    PlanetScale Blog
    Company · last shared 2026
    2ndQuadrant Blogblog.2ndquadrant.com99 people

    Data Loss at GitLab

    2ndQuadrant Blog
    Company · last shared 2025