Top all-time · #20744
SILOTA SQL Updates
Company blog · silota.com/site-search-blogprogrammingdata
SILOTA SQL Updates is the company blog at silota.com, writing about programming and data. Since 2014, 3 different Hacker News readers have linked it 13 times. It has a working feed you can follow.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
HN readers link this site for SQL recipes, such as a z-score calculation in SQL. One commenter cited it as an example in a discussion about data infrastructure.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
A sophisticated platform with a modern SQL editor, interactive dashboards, and seamless sharing with your entire team.
What Hacker News says?
Good feedback. Still iterating on the messaging – at this stage, we are still figuring out how to describe the product. When you begin incorporating ES into your application, roughly you’d be thinking about: 1. Figuring out the structure of your data and translating that into ES’s mapping 2. Learning the query syntax (the ES docs assume you already know Lucene, not usually the case.) 3. Setup an ingest workflow and…
Comment linking /docs/api/ecommerce-product-search-example/
on “Elasticsearch – the definitive guide”Submitted Your REST API should come with a client as a story · 107 points
HN discussionMy biggest difficulty with the documentation is the lack of examples and a logical layout. That's why at our company (we do hosted ES), we decided to invest in a new documentation portal ala Stripe: http://www.silota.com/docs/api/ Hope you find that useful. Any feedback is appreciated!
Comment linking /docs/api/
on “Elasticsearch – the definitive guide”Submitted Top 3 qualities of a REST API as a story · 6 points
HN discussionDon’t worry, I’m having my battles convincing my clients (both business and DS/DEs) that this is a viable paradigm. Here’s a nice-looking z-value recipe by Silota that I just googled up: http://www.silota.com/docs/recipes/sql-z-score.html
Comment linking /docs/recipes/sql-z-score.html
on “Ask HN: How do I improve our data infrastructure?”Submitted Querying JSON (JSONB) Data Types in PostgreSQL as a story · 5 points
HN discussionGoing on a tangent here: this benchmark highlights the difficulty of sorting in general. Sorts are necessary for computing percentiles (such as the median.) In practical applications, an approximate algorithm such as t-digest should suffice. You can return results in seconds as opposed to "chest thumping" benchmarks to prove a point. :) I wrote a post on this: http://www.silota.com/site-search-blog/approximate-media…
Comment linking /site-search-blog/approximate-median-computation-big-data/
on “Spark Breaks Previous Large-Scale Sort Record”Submitted Some ways to index data into Elasticsearch from your database as a story · 3 points
HN discussionSubmitted Frequently Asked Questions about REST APIs as a story · 3 points
HN discussionSubmitted Computing the Median on Big Data, Approximately as a story · 2 points
HN discussionSubmitted Dealing with downtime: read-only mode as a story · 1 points
HN discussionSubmitted Why we wrote our own custom query parser as a story · 1 points
HN discussionSubmitted Where are the Linux distributions of web frameworks? as a story · 1 points
HN discussion