Top all-time · #2430
Chartio
Company blog · chartio.com/blog · on HN as thingsilearneddatabusiness
Chartio is the company blog at chartio.com, writing about data and business. Since 2012, 31 different Hacker News readers have linked it 84 times, most often “Chartio is acquired by Atlassian and shutting down”. The last post was in 2021, but the archive is still widely read.
Too few sampled comments (16) to say how often HN recommends it.?
Why HN links it
HN readers link Chartio's blog and learning pages for SQL tutorials, charting guides such as the violin plot explainer, and data analysis write-ups like the H-1B visa data post.
Summarised by Claude from a sample of 16 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Chartio’s cloud-based business intelligence and analytics solution enables everyone to analyze their data from their business applications.
Most-linked posts?
- Chartio is acquired by Atlassian and shutting down3 people · 3 mentions · first linked 2015-11-02
- Show HN: Interactive PostgreSQL Tutorial2 people · 5 mentions · first linked 2018-03-08
- Show HN: Visual SQL2 people · 3 mentions · first linked 2020-03-11
- Off the Charts: An Interview with Riley Newman, Head of Analytics at Airbnb2 people · 2 mentions · first linked 2013-09-26
- /2 people · 2 mentions · first linked 2015-04-03
- CSV as a Data Source2 people · 2 mentions · first linked 2013-08-01
- Information Dashboard Design, 2nd Edition2 people · 2 mentions · first linked 2013-08-09
What Hacker News says?
I wrote this interactive SQL tutorial (you can write SQL in the page, and it tells you if you're right or not) last year! Always looking for feedback: https://chartio.com/learn/sql/
Comment linking /learn/sql/
on “SQL: One of the most valuable skills”Submitted Show HN: Visual SQL as a story · 512 points
HN discussionAwesome work Kao!! Earlier this year I launched a similar interactive SQL tutorial with similar goals. https://chartio.com/learn/sql/ With the writeup on why i made it here: https://medium.com/@__dave/why-i-wrote-yet-another-sql-tutor... Do let me know if there's any collaboration we could do!
Comment linking /learn/sql/
on “Show HN: Select Star SQL, an interactive SQL book”Submitted We need new data books, so we started one: Cloud Data Management as a story · 270 points
HN discussionHere are some other SQL Learning resources I have collected in my note taking TiddlyWiki (mostly from HN itself). Interactive SQL Tutorials : ▪ Chartio Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ ▪ Select STAR SQL - https://selectstarsql.com/ ▪ SQL Bolt - Learn SQL with simple, interactive exercises - https://sqlbolt.com/ ▪ SQL Window functions - https://www.windowfunctions.com/ ▪ PostgreSQL…
Comment linking /learn/sql/
on “Show HN: SQL Police Department – Learn SQL while solving crimes”Submitted Information Dashboard Design, 2nd Edition as a story · 196 points
HN discussionWe do compete very directly with Tableau and are often used along side it as well. In the article I explain a lot of what's different about it from other BI products like Tableau. The main things are - it's way more flexible as a visual language, and through a lot of prototypes and user tests has shown 80% of business users can write significant queries on their first try. As for an established service - Chartio's b…
Comment linking /customers/
on “Show HN: Visual SQL”Submitted The Data Behind H-1B Visas as a story · 120 points
HN discussionIt's free to download on dataschool.com. I agree on the gap and that's why we wrote this book. We launched that on HN here 5 months ago https://chartio.com/blog/cloud-data-management-book-launch/
Comment linking /blog/cloud-data-management-book-launch/
on “Show HN: Visual SQL”Submitted An Interview with Kevin Novak, Data Scientist at Uber as a story · 85 points
HN discussionWe do have a reverse SSH tunnel connection https://chartio.com/docs/data-sources/tunnel-connection/
Comment linking /docs/data-sources/tunnel-connection/
on “Show HN: Visual SQL”Submitted CSV as a Data Source as a story · 74 points
HN discussionSo the agile world of data we're looking to bring about is one where your DAO or marts, are still regular schemas - not just flat tables or cubes. So the developer teams would be creating these mart schemas, and then business users could be doing much of their own self-serve exploration and visualization with Visual SQL. I wrote about some of these modern architecture approaches here https://chartio.com/blog/cloud-d…
Comment linking /blog/cloud-data-management-book-launch/
on “Show HN: Visual SQL”Submitted An Interview with John Foreman, Chief Data Scientist at MailChimp as a story · 52 points
HN discussionYes we are! No plans to go on-prem yet but security is obviously a giant focus and necessity https://chartio.com/product/security/
Comment linking /product/security/
on “Show HN: Visual SQL”Submitted An Interview with Riley Newman, Head of Analytics at Airbnb as a story · 41 points
HN discussionYup - if you grab columns from multiple different connected tables (or schemas) the join will happen automatically for you and can be adjusted to different paths. This is actually a really hard problem, especially since 70% of datasources these days don't have foreign key information and we have to detect that automatically. We also have the ability to with our visual language join data from multiple different queri…
Comment linking /docs/visual-sql/merge-queries/
on “Show HN: Visual SQL”Submitted Watsi Analysis: SaaS Economics Are the Future of Charity as a story · 36 points
HN discussionDave, founder of Chartio here. We're so excited to launch what we call Visual SQL today. It's been a lot of work based on customer feedback and extensive prototyping and user testing. If you'd rather skip the story attached here you can also check out our product walkthrough video or give it a spin yourself here: https://chartio.com/product/visual-sql/
Comment linking /product/visual-sql/
on “Show HN: Visual SQL”Submitted Mining The Data Behind Toy Safety as a story · 30 points
HN discussionIf you're already doing engineering work you may be able to just go get a job focusing on data - if you're upfront about wanting to learn. I've found most people have learned the skills on the job. Besides the books mentioned I commonly recommend these resources DataCamp.com has some great courses Tableau has some great online education - many people learned BI from them Many free resources for getting started with…
Comment linking /learn/data-analytics/distinguishing-data-roles/
on “Ask HN: What does your BI stack look like?”Submitted Chartio (YC S10) now supports Salesforce data as a story · 23 points
HN discussionI've had similar thoughts to the title, but my ideas were more around improving the ease of use/writing. 1. A cleaner universal more natural syntax for analytics: I love writing python as it is to me such a cleaner syntax than C or Java. We could do the same for SQL and make something that feels more natural. Turning a common query like > SELECT count(*), TO_CHAR(created_at, 'YYYY-MM-DD') FROM Accounts GROUP BY TO_C…
Comment linking /blog/why-we-made-sql-visual-and-how-we-finally-did-it/
on “We Can Do Better Than SQL”Submitted Introducing the Chartio Data Pipeline as a story · 21 points
HN discussionSome other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ Select STAR SQL - https://selectstarsql.com/ SQL Bolt - https://sqlbolt.com/ - Learn SQL with simple, interactive exercises SQL Window functions - https://www.windowfunctions.com/ PostgreSQL Exercises - https://pgexercises.com/ SQL Zoo…
Comment linking /learn/sql/
on “Show HN: SQL Trainer – Learn SQL by doing live data exercises”Submitted Chartio acquired by Atlassian, shutting down March 1, 2022 as a story · 20 points
HN discussionI've been fairly productive especially in the first few months of lockdown. 1. Chart based commenting system for Chartio https://chartio.com/blog/charts-worth-commenting-on/ 2. Helping the https://howwefeel.org team with their data and dashboards https://how-we-feel-chartio.herokuapp.com/the-how-we-feel-pr... 3. A number of hydroponic experiments including with lettuce https://img.chartio.com/nOueDAy2 and even tryin…
Comment linking /blog/cloud-data-management-book-launch/
on “Ask HN: What did you make during lockdown?”Submitted The Data Behind Online Activism on Change.org as a story · 19 points
HN discussionThis just looks full of Ads .. more detailed Analytical analysis is here - https://chartio.com/blog/2013/09/the-data-behind-h1b-visas
Comment linking /blog/2013/09/the-data-behind-h1b-visas
on “Database of all H1B petitions by company”Submitted Now Supporting Microsoft Azure and SQL Server as a story · 18 points
HN discussion
