Apache Calcite Reviews

Apache Cassandra Reviews

Apache Calcite mentions (12)

• Data diffs: Algorithms for explaining what changed in a dataset (2022)

  > Make diff work on more than just SQLite. Another way of doing this that I've been wanting to do for a while is to implement the DIFF operator in Apache Calcite[0]. Using Calcite, DIFF could be implemented as rewrite rules to generate the appropriate SQL to be directly executed against the database or the DIFF operator can be implemented outside of the database (which the original paper shows is more efficient).... - Source: Hacker News / almost 2 years ago

• How to manipulate SQL string programmatically?

  Use a SQL Parser like sqlglot or Apache Calcite to compile user's query into an AST. Source: about 2 years ago

• Parsing SQL

  One parser I think deserves a mention is the one from Apache Calcite[0]. Calcite does more than parsing, there are a number of users who pick up Calcite just for the parser. While the default parser attempts to adhere strictly to the SQL standard, of interest is also the Babel parser, which aims to be as permissive as possible in accepting different dialects of SQL. Disclaimer: I am on the PMC of Apache Calcite,... - Source: Hacker News / over 2 years ago

• Semantic Diff for SQL

  Apache Calcite can do this, though it's not a beginner-friendly task: https://calcite.apache.org/. - Source: Hacker News / almost 3 years ago

• OctoSQL allows you to join data from different sources using SQL

  You should look at Apache Calcite[0]. Like OctoSQL, you can join data from different data sources. It's also relatively easy to add your own data sources ("adapters" in Calcite lingo) and rules to efficiently query those sources. Calcite already has adapters that do things like read from HTML tables over HTTP, files on your file system, running processes, etc. This is in addition to connecting to a bunch of... - Source: Hacker News / almost 3 years ago

Apache Cassandra mentions (44)

• Why You Shouldn’t Invest In Vector Databases?

  In fact, even in the absence of these commercial databases, users can effortlessly install PostgreSQL and leverage its built-in pgvector functionality for vector search. PostgreSQL stands as the benchmark in the realm of open-source databases, offering comprehensive support across various domains of database management. It excels in transaction processing (e.g., CockroachDB), online analytics (e.g., DuckDB),... - Source: dev.to / 16 days ago

• Data integrity in Ably Pub/Sub

  All messages are persisted durably for two minutes, but Pub/Sub channels can be configured to persist messages for longer periods of time using the persisted messages feature. Persisted messages are additionally written to Cassandra. Multiple copies of the message are stored in a quorum of globally-distributed Cassandra nodes. - Source: dev.to / 6 months ago

• Which Database is Perfect for You? A Comprehensive Guide to MySQL, PostgreSQL, NoSQL, and More

  Cassandra is a highly scalable, distributed NoSQL database designed to handle large amounts of data across many commodity servers without a single point of failure. - Source: dev.to / 11 months ago

• Consistent Hashing: An Overview and Implementation in Golang

  Distributed storage Distributed storage systems like Cassandra, DynamoDB, and Voldemort also use consistent hashing. In these systems, data is partitioned across many servers. Consistent hashing is used to map data to the servers that store the data. When new servers are added or removed, consistent hashing minimizes the amount of data that needs to be remapped to different servers. - Source: dev.to / about 1 year ago

• Understanding SQL vs. NoSQL Databases: A Beginner's Guide

  On the other hand, NoSQL databases are non-relational databases. They store data in flexible, JSON-like documents, key-value pairs, or wide-column stores. Examples include MongoDB, Couchbase, and Cassandra. - Source: dev.to / about 1 year ago