Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
IDE for SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Jupyter / JupyterLab
I personally prefer to query databases using a Jupyter/lab notebook. The reason is that results of queries are persisted in the notebook for future reference and sharing.
dbeaver …
IDE for Rust
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Visual Studio Code
-
The rust-analyzer extension seems to be a good option.
-
Rust extenstion (rust-lang.rust) is another posssible extension for Rust but does not work as well as rust-analyzer .
RustRover …
The NeoVim Plugin for Visual Studio Code
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
https://github.com/asvetliakov/vscode-neovim
Installation
-
Install NeoVim 0.5+ using icon.
icon nvim -ic --ppa
-
Install the NeoVim plugin from the extension market in VSCode or Code Server.
-
Set the …
Visual Studio Code Server
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Advanced Tips
--link (beta) Securely bind code-server via Coder Cloud with the passed name. You'll get a URL like https://myname.coder-cloud.com at which you can easily access your code-server …
General Tips on SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Performance
-
Avoid implicit data convertion! This might cause full table scan which hurts performance badly. For more discussions, please refer to 一条垃圾SQL,把 64 核 CPU 快 …