## On This Day...
```dataview
LIST
FROM "DevLog/log"
WHERE dateformat(file.day, "MM-dd") = dateformat(this.file.day, "MM-dd")
```
---
## Notes Created Today
```dataview
TABLE created, updated as modified, tags, type, status
FROM "DevLog" AND !"DevLog/log"
WHERE contains(dateformat(file.ctime, "YYYY-MM-dd"), dateformat(this.file.day, "YYYY-MM-dd"))
```
---
[[DevLog/log/2021-04-22|2021-04-22]] <== <button class="date_button_today">Today</button> ==> [[DevLog/log/2021-04-25|2021-04-25]]
- [[tsql]]
- Databases can live in a single `.db` file
- queries have to end with a `;`
- The syntax is similar to other SQL's but it of course has it differences and functionalities that it lacks
- Cant seem to find a way to do a string split cross apply with SQLite to take a single column with a string of values comma separated to split them then cross apply them to list and then filter/aggregate them.
- This is making me rely more of more tables in the relational model v.s. robust functions.
## Current ER diagram looking like this:
```mermaid
erDiagram
PERSON }|--|| LOCATION : "Lives In"
PERSON }|--o{ SUBJECT : Studies
PERSON ||--o{ TAGS : Has
PERSON }|--o| PROFESSION : "Works As"
PERSON }|--|| CONNECTION : Met
```
- csv
- clojure
- looked at clojure a little bit but immediately decided against looking into it further since apparently it's meant to run on a JVM or java Virtual Machine.
- I have no intention of looking into Java right now so that was a quick foray into the weird looking syntax of Clojure. maybe something like lisp/elisp for emacs will be more interesting and applicable for me.
- markdown markdown hyperlinks when separated by declaration and definition, they can be re-used!
```markdown
[link text][1]
[1]: https://www.bryanjenks.dev
[but I can also re-use the link here!][1]
And this will work all throughout a markdown document
```
- CompTIA A+ Core2 1002 completed [this udemy course](https://www.udemy.com/course/comptia-220-1002-exam/) to prep for the exam.
- [[git]] Found [this GREAT graphical walkthrough tool](https://learngitbranching.js.org/) for learning git