created: 2024-12-09 05:24 tags: - daily-notes

Monday, December 09, 2024

<< Timestamps/2024/12-December/2024-12-08-Sunday|Yesterday | Timestamps/2024/12-December/2024-12-10-Tuesday|Tomorrow >>

🎯 Goal

• [x] Create a Note Django Model that can be used to upload my daily update notes to the BigBrain App in the DIMMiN App so users can see my daily updates

🌟 Results

• Decided to use the BigBrain App to host the different Digital Gardens for my different projects
• Established Django Models to represent different Notes, Vaults, and LinkedNotes.

🌱 Next Time

• Figure out how to extract data from my Obsidian notes and load them into my Digital Garden within my BigBrain App.

📝 Notes

As I get closer to my start date for the WGU MSDADS, I want to have some way to share my Master's progress to my site. There are really two different ways I can do this:

1. Through the Blog App, where each daily note is a Post Django Model and
2. Through the BigBrain App, where each daily note is a new Note Django Model

I asked ChatGPT what it thought and it mentioned that the BigBrain App may be a better fit for this information which works fine enough for me.

I may want to explicitly create a Note Django Model or collection of Django Models to represent a Vault. There's also the good idea of writing some kind of Django Management Command or Bash script to sync notes after each day. I'll also need some way to render the Markdown files themselves within my Django App. I think I'll use django-markdownx.

I decided on using a structure with 3 additional Django Models - Vaults, Notes, and LinkedNotes. Vaults are high-level collections of notes organized under the same umbrella. Notes contain the actual information / content about the topic, and LinkedNotes represent the connections between different notes.

I created the necessary Django Models, applied Database Migrations, and created a few sample entries for Vaults and Notes. Then, I decided to check them out in the Local Version of my PostgreSQL database. I was able to get the names of all my database tables with:

SELECT tablename 
FROM pg_tables 
WHERE schemaname = 'public';

Which allowed me to query the new models I added in. The next step would be to establish some way to take the Obsidian notes that I have and extract the data from them to populate these different fields. I could also establish a publishing workflow based on these Django Bulk Uploads and automate the process going forward (maybe triggering a script only when a new daily note has been created in the vault that I'm tracking).

Additionally, there's an error where the uniqueness is enforced at the Note level, not at the Note Vault combined level.

Notes created today

List FROM "" WHERE file.cday = date("2024-12-09") SORT file.ctime asc

Notes last touched today

List FROM "" WHERE file.mday = date("2024-12-09") SORT file.mtime asc

(Template referenced from Dann Berg, can be found here)