Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by memset on Friday October 27, 2023 @02:42PM
(#38042285)
Good to meet you! I hadn't seen graphjson before, I'll check that out. I'm also a fan of tinybird, and I think we have similar goals of wanting to make it easier for people to adopt OLAP.
On the technical side, I've made different design decisions when it comes to ingesting and processing data. For example, after a table is created, you can post new JSON, with different columns, and we ingest it without needing a manual migration step. I also have a different treatment for JSON arrays, where we can split them into multiple Clickhouse rows (rather than using a clickhouse array.)
Philosophically, I think there is a lot of room for open-source software that also has an amazing UI and developer experience. I've been writing OSS for years and basically think this is the best way to build successful developer tools.
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by tbragin on Friday October 27, 2023 @02:48PM
(#38042361)
> Philosophically, I think there is a lot of room for open-source software that also has an amazing UI and developer experience.
+1 to that! Welcome to the ClickHouse community!
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by hawk_ on Friday October 27, 2023 @05:46PM
(#38044430)
I would like to be an OSS dev but how do you pay the bills?
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by mike_d on Friday October 27, 2023 @04:15PM
(#38043350)
> how you see your project differs from GraphJSON (https://www.graphjson.com/) and Tinybird (https://www.tinybird.co/)?
Not OP, but neither of these appear to be open source?
Thank you! Looks really interesting!
I personally agree that real-time OLAP databases have potential to better serve workloads currently in Postgres or cloud data warehouses that need real-time ingest and analytical queries. And simplifying developer experience on top of that, so you don't have to learn about all the details of a powerful database, really speeds up developer velocity.
I'm curious, how you see your project differs from GraphJSON (https://www.graphjson.com/) and Tinybird (https://www.tinybird.co/)?
Congratulations again on the launch!