Apache Calcite Reviews

PostgreSQL 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

PostgreSQL mentions (16)

• Convert insert mutation to upsert

  In this quick post, we’ll walk through implementing an Upsert operation in Hasura using PostgreSQL and GraphQL. - Source: dev.to / 8 months ago

• Perfect Elixir: Environment Setup

  I’m on MacOS and erlang.org, elixir-lang.org, and postgresql.org all suggest installation via Homebrew, which is a very popular package manager for MacOS. - Source: dev.to / about 1 year ago

• Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

  According to the documentation, crate sqlx is implemented in Rust, and it's database agnostic: it supports PostgreSQL, MySQL, SQLite, and MSSQL. - Source: dev.to / over 1 year ago

• Really tired. Is PostgreSQL even runnable in Windows 10? pgAdmin4 stucks at Loading whatever I try.

  Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the postgresql.org package. Source: almost 2 years ago

• Why SQL is right for Infrastructure Management

  SQL immediately stands out here because it was designed for making relational algebra, the other side of the Entity-Relationship model, accessible. There are likely more people who know SQL than any programming language (for IaC) or data format you could choose to represent your cloud infrastructure. Many non-programmers know it, as well, such as data scientists, business analysts, accountants, etc, and there is... - Source: dev.to / about 2 years ago