Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Which one to use postgres vs. sqlx

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Trino

Trino is a distributed SQL query engine for big data. It is formerly known as PrestoSQL.

ZetaSQL

ZetaSQL is a customized SQL dialect, along with parser and analyzer, that Google …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. Apache Arrow Flight is the future protocol for querying Databases! It use columnar data and leverages Apache Arrow to avoid unnecessary copy of data, which makes it able to query large …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Apache Arrow & JDBC

Xoriant Open Source Contribution to Apache Arrow – JDBC Adapter

arrow-jdbc

arrow-memory

References

• https://www.youtube.com/watch?v=OLsXlKb_XRQ

• It’s Time to Replace ODBC & JDBC

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

The limit clause (or the method DataFrame.limit if you are using Spark) is a better alternative if randomness is not critical.

PostgreSQL

SELECT id from table TABLESAMPLE BERNOULLI(10) WHERE …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

SQL translation is a great tool that transalte any SQL statement(s) to a different dialetc using the JOOQ Parser.