When I work on sql queries I usually start with a base query and edit as I go depending on the requirements, sometimes running the query and debugging. However, after being in a sql interview it seems like this approach doesn’t work the best for interviews as I frequently go down the wrong path before correcting myself, and especially not in situations where I can’t actually run intermediate queries.

What’s a good approach for working out a sql query in a structured way?

reddit permalink

Hello, I recently got interested in statistics and wanted to read some books that would give me a good introduction to it.

I'm not looking for a book that goes more technical and teaches me about the different techniques, but I was hoping to find some book that talks about maybe what exactly is valid data, etc... more like meta-statistics? or more philosophical statistics?

I hope my question makes sense...

Thanks

reddit permalink

"CATMA
Computer Assisted Text Markup and Analysis"

allows content analysis, qualitative, quantitative, etc

And switching from init.vim to init.lua

Nicely explained, going over both basics and some more intermediate ideas of switching to lua

example of a lua statusline for neovim with explanation

https://elianiva.my.id/post/neovim-lua-statusline

"There are plenty of reasons why people who DO have the knowledge would not admit to it. By asking, you're asking for more than what you think you're asking.

You're asking people to take responsibility. You're questioning people's confidence in their abilities. You're also unnecessarily walling other people out. I often answer questions related to languages or libraries I have never used, because the answers are (in a programmer kind of way) common sense."

Qualitative data analysis for text, images, audio, video. Cross platform. Python 3.6 or newer and PyQt5. - ccbogel/QualCoder

An interesting zettelkasten approach that strives to be editor-agnostic, plain-text, and adaptible.

Its main draw seems to be the automatic creation of a zettel heteronomy, html publication, and extensive plugin possibilities.

github repo here

nvim plugin here