Query Pandas Data Frames Using SQL
Online Practices for SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Connect to Databases Using pyodbc in Python
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 …
Tips on MS SQL Server
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
-
convert: 106 - dd mon yyyy, 101 - mm/dd/yyyy
Tips on dbeaver
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Links
General Tips
- Standalone dbeaver can install some eclipse plugins.
Vim Keybindings
You can install vrapper as vim keybindings on dbeaver.
-
Help -> Install Software
-
Add vrapper repository http://vrapper …