Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Tips on AstroNvim
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
LSP
Use the command :LspInstall to open the prompt
to select a LSP to install for the current file type.
References
Universal Blue Atomic Linux Distributions
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
Universal Blue is a manufacturing process that focuses on community-driven sharing of best practices via automation to make awesome desktop and server operating systems (based on Fedora Atomic distributions).
I've built …
Tips on Web Browsers
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
AI-centric Browsers
Headless Browsers
Tips on Gemini
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
General Tips
- Google Gemini saves conversations and apps you built so that you can revisit them later. Notice that prompts (conversations) are also saved into the directory "My Drive/Google AI …
Ignore Nulls in the Analytical Window Function Lead in SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
The analytical window function lead
does not support ignoring NULL values.
One workaround is to to use the analytical window fucntion first_value
which supports ignoring NULL values.
first_value(my_col IGNORE NULLS …