sqlglot VS taichi

This is probably referring to "zero changes to your driver code" and not "zero changes to the SQL you send over this driver".

Translating between SQL dialects is notoriously hard and attempts to translate [1] are working in 95% of cases. But the last 5% would require 5x amount of work. That's because "SQL dialect" also includes weird edge cases of type inference of things like COALESCE(5, FALSE) and emulation of system catalogs (pg_catalog, information_schema).

[1] https://github.com/tobymao/sqlglot

Recommend checking out https://github.com/tobymao/sqlglot if you are interested in this capability for other SQL dialects

Tools like this are helpful for:

- Rendering SQL in a consistent way, eg for snapshot testing

sqlglot – Python SQL Parser and Transpiler

In the project we used Python lib networkx and a DiGraph object (Direct Graph). To detect a table reference in a Query, we use sqlglot, a SQL parser (among other things) that works well with Bigquery.

Cool! Is this built with sqlglot[1] on the back end?

[1] https://github.com/tobymao/sqlglot

Wanted to give sqlglot a shoutout as it saved me a ton of time.

taichi – Productive, portable, and performant GPU programming in Python

ETH Zurich is using it for their physics sim courses, University of Utah is using it for simulations (SIGGRAPH 2022), OPPO (they make smart devices running Android), Kuaishou uses it for liquid and gas simulation on GPUs. Lots of GPU accelerated sim stuff.

https://www.taichi-lang.org/

https://www.researchgate.net/publication/337118128_Taichi_a_...

https://github.com/taichi-dev/taichi

Check our the realease note (https://github.com/taichi-dev/taichi/releases) for more improvements.

I've recently started using Taichi (https://taichi-lang.org/) for numerical codes and the fact it doesn't try to trick you into thinking it's numpy is a nice "feature". ;)

Taichi v1.4.0 is released! See what's new: - Taichi AOT, along with a native Taichi Runtime library: Native applications can now load compiled AOT modules and launch Taichi kernels without a Python interpreter. - Taichi ndarray: An array object that holds contiguous multi-dimensional data to allow easy data exchange with external libraries. - Dynamic index: Use variable indices whenever necessary on all backends without affecting the performance of those matrices with only constant indices. See deprecation and more improvements in the release note.

Oh, then if you're not already tied to any particular VFX software, I might as well recommend Taichi again.

It's an upgrade of a basic version. See changes to the source code here: https://github.com/taichi-dev/taichi/pull/6851