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

1. A volatile table persistents in the duration of the connection that creates it while a CTE is only accessible by the query following it. That is the scope of CTE is …

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

LeetCode - Database

SQL Exercises, Practice, Solution

SQLBolt

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

pyodbc only supports qmark

https://github.com/mkleehammer/pyodbc/wiki

Unicode Converter Buffer Overflow

This issues arises in Python3 but not Python2, so the simplest way is to use Python2 if …

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

1. convert: 106 - dd mon yyyy, 101 - mm/dd/yyyy

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

Links

• dbeaver Homepage

General Tips

1. Standalone dbeaver can install some eclipse plugins.

Vim Keybindings

You can install vrapper as vim keybindings on dbeaver.

1. Help -> Install Software

2. Add vrapper repository http://vrapper …

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

https://www.quora.com/Spark-vs-Redshift-Should-I-be-using-both-for-big-data-Which-is-better

Performance

https://dbseer.com/benchmark-comparison-spark-sql-redshift-cluster/

Redshift vs …