Rockset Blog

rockset.com · Company blog · on HN since 2018

Rockset's company blog covers its real-time search and analytics database, RocksDB use, SQL query planning, and vector search.

What HN saysHN commenters recall its comparison page with some mockery, and discuss vendor risk after OpenAI acquired the company. Staff also posted product announcements.
34HN people shared it
18linked it in comments
60stories submitted
544story points
2 years agolast shared
2018people per year2026

Most-shared posts

  1. 1
    Rockset – Serverless search and analytics engine
    5 people · 112 points · first shared 2019 · 30 comments on HN
  2. 2
  3. 3
    OpenAI Acquires Rockset
    3 people · 4 points · first shared 2024 · discussion on HN
  4. 4
    How to Run SQL on PDF Files
    2 people · 88 points · first shared 2019 · 33 comments on HN
  5. 5
    SQL Query Planning for Operational Analytics
    2 people · 7 points · first shared 2019 · 1 comments on HN
  6. 6
  7. 7
  8. 8
    We Use RocksDB at Rockset
    2 people · 3 points · first shared 2019 · discussion on HN
  9. 9
  10. 10
    From schemaless ingest to SQL queries
    2 people · 1 points · first shared 2019 · discussion on HN
  11. 11
    Real time analytics comparison
    2 people · first shared 2024
  12. 12
    Dynamic Typing in SQL
    1 people · 97 points · first shared 2018 · 24 comments on HN
  13. 13
    Running Fast SQL on DynamoDB Tables
    1 people · 40 points · first shared 2019 · 10 comments on HN
  14. 14
    How to Do Data Science Using SQL on Raw JSON
    1 people · 23 points · first shared 2019 · discussion on HN
  15. 15
    Optimizing Aggregations in Sql Query Execution
    1 people · 21 points · first shared 2019 · discussion on HN

What HN people wrote when they linked it

johnsolitario · 2023-04-18
Hello HN! I'm John Solitario, a product manager at Rockset (https://rockset.com/). We've seen an interest in vector search and vector databases increase over the past several months, so we added native support for vector embeddings, operations, and distance functions, alongside our real-time analytics capabilities. Check out the blog post I wrote to learn more: https://rockset.com/blog/introducing-vector-search-on-rockset/. I would love to hear your feedback in terms of support, performance, and ergonomics, and I'd like learn more about your experiences productionizing applications with vector search.
Merick · 2024-06-21
I'll always remember Rockset for their ridiculous comparison page: https://rockset.com/real-time-analytics-comparison/ Maybe they should rename it to their migration options page. Or maybe I'll just ask ChatGPT what the best alternative is... Still, pretty useful stuff, but it also feels like Rockset had been moving a little too slowly in recent years, but congrats to them on finding a new home.
jkm2010 · 2023-05-04
Hey HN! I'm Julie on the product team at Rockset (https://rockset.com/). We wanted to share the results of an open-source streaming ingest benchmark we ran on Rockset and Elasticsearch. We evaluated Rockset and Elasticsearch ingestion performance on throughput and data latency at the 95th and 99th percentile, given that both databases are used for production search and analytics applications that require predictable performance. The blog (https://rockset.com/blog/benchmark-elasticsearch-rockset-streaming-dat… walks through the benchmark framework, configuration and results. We're looking to better support search and analytics on high-velocity streaming data and would welcome feedback/requirements that you have for your applications.
searchableguy · 2020-09-06
They are probably using proprietary tools for mongo such as rockset: https://rockset.com/ Someone pointed that out to me when I answered a question dismissing mongo.
hodgesrm · 2024-06-23
> I'd love to hear from someone with expertise in vendor onboarding and business continuity risk: how do vendor contracts typically protect customers in situations like this? The short answer: they generally don't, unless you negotiate for it. I run a company and dealing with this kind of situation (or better still anticipating it) is part of my job. The Rockset situation generally falls under "termination for convenience" where a party of the contract terminates for reasons other than cause, e.g., bankruptcy or the other party violating contract terms. Taking the Rockset TOS as an instructive example, it covers customer's termination for convenience in Section 15.2. [0] However, there's nothing about Rockset terminating for convenience. Normally this ambiguity could cause legal problems for the vendor, but Rockset added a 'get out of jail free card' in Section 2. They can just change the ToS. > 2. Changes to Agreement or Services. Rockset may update this Agreement at any time, in its sole discretion. If Rockset does so, it will let Customer know either by posting the updated Agreement on the Site or through other communications. If Customer continues to use the Services after Rockset has posted updated Agreement, Customer agrees to be bound by the updated Agreement. Because the Services are evolving over time, Rockset may change or discontinue all or any part of the Services, at any time and without notice, at its sole discretion. I am not a lawyer but (a) this is an…
samsquire · 2022-12-04
Thank you Eatonphil for writing this. I agree that I would love to see more of this kind and quality this kind of article of technical subjects. https://blog.jcoglan.com/2017/02/12/the-myers-diff-algorithm-part-1/ https://keleshev.com/abstract-syntax-tree-an-example-in-c/ I don't want to add more work to people who are already working more than everyone else. But when you write software or code that is truly good, I want people to write lots of examples and descriptions of their mental model and how to think of the software. I'm still trying to understand what the difference between a poller and an awaiter in Rust async. I use Flask because I find Flask easier to understand than Django. There's even a simple example on the Flask homepage. But Django has a very large tutorial which still doesn't really explain how each component fits together. I don't understand the mental model behind Django but I do with Flask. For example, I'm still trying to understand C++ coroutines. And I have some code that kind of works and some code someone provided on Stackoverflow I cannot get to work with GCC. There's not large amounts of documentation on C++ coroutines. I see people post fascinating awesome GitHub projects and have sparse README.md and no screenshots The code doesnt speak for itself. You can write the perfect code at a company and that code never flourishes because nobody wrote about it. Or you can write the perfect code at home but it doesn't get used. I would rather…
supernihil · 2020-04-14
previous mention: https://news.ycombinator.com/item?id=13698965 why mention again: we have reached v 9.0.0 and so much has happened in the meantime (check history here: https://github.com/trustpilot/python-lambdarest/blob/master/HISTORY.md… * 15 contributors over time and battle-tested in production since 2017 * python 3.6+ only * flask like routing decorator * supports aws Application Load Balancer and "normal" api gateway * supports query_params, body_params and path_params * (still) uses jsonschema for validation * supports Lambda authorization scopes * lambdarest strictly does routing/handling and doesn't interfer with deploying * low amount of code lines: 1 file, 346 lines * uses poetry for packaging two tutorials have been published by users over the years: * http://www.devgrok.com/2019/03/create-private-microservice-using.html * https://rockset.com/blog/building-a-serverless-microservice-using-rock… We are very friendly and love cooperating, come join us! :-) . small example: from lambdarest import lambda_handler @lambda_handler.handle("get", path="/foo/<int:id>/") def my_own_get(event, id): return {"my-id": id}
foxish · 2019-04-11
Hi yingw787, I work on the product team at Rockset. Thanks for your thoughts! I'll try and answer your questions below. - The different file formats get indexed and turn into a Rockset specific format which ensures that irrespective of the file type you get excellent performance for your SQL queries. This also means you can JOIN data from different sources (containing files in different formats) using SQL irrespective of the source formats. - Depending on the complexity of the SQL queries, the latency can range from low tens of milliseconds to a few seconds. Since we index ALL the fields in several ways, if we're able to use our indices to accelerate the query (which is almost always the case), it will likely be in the 10-200 milliseconds range for a wide range of analytical queries. Look out for some numbers in the future. - Data cleaning is something we facilitate through the use of our delete/update records API that lets you mutate the index and remove/update the records that you consider to be containing bad data. Since Rockset supports schemaless ingest (https://rockset.com/blog/from-schemaless-ingest-to-smart-schema-enabli… error documents don't really break anything and you can work around them by writing a query that ignores them. We are interested in providing visibility into the data so that you can quickly detect issues with the data and fix them. - Rockset has a REST API, clients in different programming languages…
NicoJuicy · 2024-07-11
Elastic search has snapshots ( iso deligation) and is cheaper/faster. Cognitive has no backups out of the box. Ps. ES has an SQLish language that makes it easier: https://rockset.com/articles/elasticsearch-sql/
preetamjinka · 2024-06-21
According to [0] the acquisition has already been completed. [0] https://rockset.com/blog/openai-acquires-rockset/
tylerhannan · 2024-06-21
A database is core to your infrastructure...finding out your database is going away is a horrifying situation. Finding out that the time you have to migrate is a few months. Agh. As others will say, there are options. Rockset helpfully posts links to a bunch of comparisons on their website, and these alternatives include ClickHouse, Elasticsearch, Druid, etc.. https://rockset.com/real-time-analytics-comparison/ I'm inherently biased (as a member of the ClickHouse team). But do check ClickHouse out. You can always come hang out in our Slack (clickhouse.com/slack) and, of course, the combination of hosted ClickHouse (clickhouse.com/cloud) and the open-source (github.com/clickhouse) may add a bit of comfort when your vendor up and disappears via acquisition.
lolinder · 2024-06-21
To anyone else who may be confused like I was: Rockset will, in fact, "gradually transition current customers off Rockset". The OpenAI announcement linked above doesn't say so, but the Rockset announcement does: https://rockset.com/blog/openai-acquires-rockset/ Month-to-month users been given until September 30, which is a very short amount of time for a major infrastructure transition. Enterprise users are given a vague "talk to your account manager" answer: https://docs.rockset.com/documentation/docs/faq In other words, the above isn't just FUD from a competitor, there legitimately are going to be a lot of frantic refugees in the coming months.
munchor · 2023-04-09
Yeah, that’s interesting. I think both SingleStoreDB and Rockset have come up with solutions to this problem (by separating the compute). But I understand that most database providers do not have a mechanism for the analytics people to not bring down the app accidentally. [1]: https://www.singlestore.com/blog/distributed-sql-workspaces-power-mode… [2]: https://www.rockset.com/blog/introducing-compute-compute-separation/
tomhallett · 2022-08-23
100% agreed. TIL that mysql uses RocksDB under the hood. Here's another example of a realtime database which uses RocksDB under the hood: https://rockset.com/blog/how-we-use-rocksdb-at-rockset/
innagadadavida · 2022-04-19
Throwing another new entrant to this space - rockset. https://rockset.com/blog/rockset-beats-clickhouse-druid-star-schema-be… Will be interesting to read actual customer stories instead of these benchmarks.
voltagex_ · 2019-02-22
https://rockset.com/pricing/ - free tier looks pretty good but I'm not sure I'd be comfortable uploading bills and other documents here.
canadi · 2018-06-02
Rockset | Senior Software Engineer, Lead Front-end Engineer | San Mateo, CA | Onsite | Full time At Rockset we are building the next generation of cloud-native data infrastructure. Our team includes founding members of RocksDB, Hadoop Distributed File System, Facebook's search engine (Unicorn) and social graph serving engine (TAO). We are backed by Greylock Partners and Sequoia Capital. We are building our infrastructure on top of Kubernetes on AWS, and are using systems like RocksDB, Kafka, Zookeeper, gRPC and Terraform. Most of our codebase is in C++ and Java. Open Roles: https://rockset.com/careers (also links to a page where you can apply)

Keyboard shortcuts

/Search
j kNext / previous blog
EnterOpen selected blog
vVisit the blog site
fFollow / unfollow
lSwitch grid / list view
dSwitch dark mode
g hHome
g pTop posts
g tTopics
g fFollowing
g lLiked
g yHistory
g qFAQ
EscBack / close