Thanks for responding! I am curious about splitting your log into per day files. How would you go about finding a specific SQL query that you used last month, but don't remember the exact day? Is there a way in Obsidian to combine all days into a single view? Or would you search for files with SQL queries (e.g., notes with both "select" and "from")?
Obsidian works with what is called a vault, i.e. a project folder. You can then search for text across all the notes in a vault. No need to remember the date.
In addition to that, you can work with hash tags inside the notes and then filter files based on tags, e.g. #sql-query or so.