MASTER Obsidian's Powerful DATABASE FOLDER Plugin - Step by Step
Вставка
- Опубліковано 10 лип 2024
- #obsidian #tutorial #plugins
Thanks for watching, and I hope you enjoyed this step-by-step guide for Obisidan's Database Folder plugin.
⬇️ DOWNLOADS
FREE Obsidian templates and starter vault: store.sascha-kasper.com/?tags...
⏱ TIMESTAMPS
00:00 === WHAT'S HAPPENING? ===
00:12 === WHAT WE NEED ===
00:44 === DB FROM SCRATCH ===
01:51 Basic database settings
02:36 Basic columns
03:06 Template for DB entries
03:25 Create a new DB entry
03:49 Add columns
04:55 Configuring columns
06:28 Organizing the DB and notes
07:00 Tags as data source
07:12 Dataview as data source
07:46 Inline fields as columns
08:19 Filter and sort
08:57 === DB FROM NOTES ===
09:35 Pagination
09:45 Refining the data source
10:26 === PLUGIN SETTINGS ===
10:52 Folder structure
11:10 Remove fields from metadata
11:23 Default metadata columns
11:52 Inline fields options
12:04 Rows related settings
12:13 Database footer
12:57 Editing engine
13:06 Automations
13:13 Embedded media
13:24 CSV I/O
13:31 Helpers
13:40 Developer tools
13:46 === DATABASE SETTINGS ===
14:01 Database sources
15:10 Grouping
15:35 Remove fields
15:41 Columns template
15:55 Use all fields
16:12 Font size
16:19 Date and time formats
16:28 Automations
16:33 === COLUMNS MENU ===
16:41 Add columns
16:54 Default metadata columns
17:02 File name
17:09 Created and modified dates
17:23 File tasks
17:34 File inlinks and outlinks
17:50 File tags
18:07 === COLUMN TYPES ===
18:18 Calendar column
18:32 Calendar time column
18:41 Formula column
18:54 Relation and rollup columns
19:42 === COLUMN SETTINGS ===
19:56 Header menu
20:14 Column ID
20:39 Inline field
20:52 Style
21:03 Tags and select columns
21:18 There is more
🌐 FIND ME ONLINE
Twitter: / skasper
LinkedIn: / saschakasper
Blog: sascha-kasper.com
Pinterest: / leanproduct
Facebook: profile.php?...
Substack: skasper.substack.com
All links: linktr.ee/skasper
📚 USEFUL LINKS
DB Folder documentation: rafaelgb.github.io/obsidian-d...
💶 LIVELIHOOD
☕ I know you cannot support all the creators you like. Maybe next time you can, you want to buy me a coffee at ko-fi.com/skasper. I appreciate your help.
🔗 Some of the above are affiliate links which means I will earn a small commission on any purchases at no additional cost to you. I use all of these things, and I am happy to recommend them.
👍 THANK YOU
I hope you found this useful. Thanks for watching.
obsidian database folder plugin,obsidian dataview,obsidian plugins,obsidian tutorial,how to use obsidian,obsidian database folder,obsidian db folder plugin,personal knowledge management,obsidian notes,database folder plugin,obsidian tips,obsidian,obsidian plugin tutorial,obsidian app - Навчання та стиль
😢 Missing Notion's database functionality in #Obsidian?
😕 Struggling with making the DB Folder Plugin work?
This step-by-step guide
✅ includes practical examples
✅ explains every single setting
⏲ in ~20 minutes.
Download FREE Obsidian templates and my demo vault at store.sascha-kasper.com/?tags=obsidian
This is slick. I was holding off using Obsidian, until now…
Happy to hear that - welcome to the community.
Why am I finding your channel just now.
This is beyond helpful. Simply wow.
Thank you - much appreciated!
This could be on a full feature course. So much value❤
Thank you - that's very kind of you!
@@leanproductivity also very true
Fantastic video. Thank you!
Thank you, too, for taking the time to let me know. I appreciate it!
Very helpful! Thanks!
I'm glad you think so. Thank you for your kind feedback.
Great and useful video ! Thanks for your work ❤
Thank you - I really enjoy making these videos - although I am still figuring out quite a few things. Feedback like yours is really motivating.
wie immer, einfach großartig!
Danke! Ich bemühe mich 😊
I love this video. Best yet! Thank you.
Wow, thank you! Glad you liked it.
@@leanproductivity If you have 2 databases that relate to each other, do they need to have separate folders?
Great Video and helped me a lot
Thank you - I think that's really every content creator's favorite feedback. I appreciate it.
Very useful for me, thank you.
You are welcome! I am happy to hear that. Thank you for taking the time to let me know.
Thank you!
You're welcome!
thanks very cool
Glad you liked it! Thank you.
谢谢,非常全面!
感谢您的善意反馈。我很高兴您觉得有帮助。
I hope this is correctly translated. Thank you.
@@leanproductivity 非常准确😄
00:00 === WHAT'S HAPPENING? ===
00:12 === WHAT WE NEED ===
00:44 === DB FROM SCRATCH ===
01:51 Basic database settings
02:36 Basic columns
03:06 Template for DB entries
03:25 Create a new DB entry
03:49 Add columns
04:55 Configuring columns
06:28 Organizing the DB and notes
07:00 Tags as data source
07:12 Dataview as data source
07:46 Inline fields as columns
08:19 Filter and sort
08:57 === DB FROM NOTES ===
09:35 Pagination
09:45 Refining the data source
10:26 === PLUGIN SETTINGS ===
10:52 Folder structure
11:10 Remove fields from metadata
11:23 Default metadata columns
11:52 Inline fields options
12:04 Rows related settings
12:13 Database footer
12:57 Editing engine
13:06 Automations
13:13 Embedded media
13:24 CSV I/O
13:31 Helpers
13:40 Developer tools
13:46 === DATABASE SETTINGS ===
14:01 Database sources
15:10 Grouping
15:35 Remove fields
15:41 Columns template
15:55 Use all fields
16:12 Font size
16:19 Date and time formats
16:28 Automations
16:33 === COLUMNS MENU ===
16:41 Add columns
16:54 Default metadata columns
17:02 File name
17:09 Created and modified dates
17:23 File tasks
17:34 File inlinks and outlinks
17:50 File tags
18:07 === COLUMN TYPES ===
18:18 Calendar column
18:32 Calendar time column
18:41 Formula column
18:54 Relation and rollup columns
19:42 === COLUMN SETTINGS ===
19:56 Header menu
20:14 Column ID
20:39 Inline field
20:52 Style
21:03 Tags and select columns
21:18 There is more
Thanks, but do the timestamps in the description not work?
@@leanproductivity I commented out the timestamps because I'm too lazy to click the more button
@@aljustiet 😂 I can relate to that.
This is a really good video. Moves at a good pace, detailed but not too detailed. Thank you! Quick question - I'd like to create a simple client database, and then create links/relationships b/w records, eg: Client A knows Client B etc... And then show that in Graph view. Is that possible? I'm new to Obsidian. Thanks!
Thank you for your kind words. Yes, it is possible. The easiest way is to add the link directly from one note to another. Say you have 2 notes called "Client A" and "Client B" respectively. Open the "Client A" note and type [[Client B]]. This will create a link to the "Client B" note which will also be displayed in the graph view.
As soon as you start typing "[[Cli", Obsidian will suggest all notes matching this string (e.g., Client C, Client D, etc.).
Thank you for this great introduction into DB Folder!
Currently I'm trying to figure out witch plugins to use in combination.
I'm using Kanban (together with MetaEdit) , MetaData Menu, Projects and now DB Folder . Now I wonder, how this one plays together with the other ones.
Any suggestions on this question?
I am happy you find it helpful - and thank you for your nice feedback.
Personally, I like to use Canvas in combination with the metadata menu plugin and the projects plugin. I actually published a list of my personal top 10 plugins recently. It's here, ICYMI: ua-cam.com/video/pr-_PL9yCEk/v-deo.html
But there is really no definitive answer. It all depends on what you need and how you like to work. That's what makes Obsidian so great, imo.
If you want to kickstart - or just play around with - Obsidian, I also provide a free demo vault: store.sascha-kasper.com/?tags=obsidian.
Have fun!
More vids about obsidian pls
Sure thing! The next one will drop this week. Make sure to get notified 😉
Thanks for the video! What are the main advantages of this plug-in compared to the actual MS Excel? Thank you.
I think these two things cannot be compared as they serve very different purposes. The main difference is probably that the DB Folder plugin lets you query your notes inside Obsidian and display/edit their metadata while Excel is completely detached from Obsidian.
While you can do basic calculations with the DB Folder plugin, it will (probably) never be as powerful as Excel in this respect.
What is rollup and relation for in column types?
Check at 18:54 in the video: ua-cam.com/video/lIuZAik1jPM/v-deo.html
Btw, all time stamps are in the video description. I hope this helps.
Is there a reason that the fields I create do not go to the properties part of the note? They go to the main body with ": :." This happens even if the field is already present in properties. Kind of strange
Please check the plugin settings. There is a section "Inline fields options", containing an item "Enable inline fields as default". Probably, this is active. If you deactivate it, the fields should be added to the frontmatter instead of the note.
Thanks for the tutorial! I keep getting an error when trying to add columns to my database. The column looks like it gets added, but once I exit it disappears and says something about there's no yaml present. Do you have any idea what might be happening? Thank you
You are welcome. I tried to reproduce this problem but without success. I suggest checking the Obsidian Forum (forum.obsidian.md/) or their Discord server. People there are very knowledgeable and happy to help.
I appreciate you taking the time to help out. I tried the forums as well as Reddit to no avail. Ended up reinstalling the plugin and it started working fine. Gotta love computers lol @@leanproductivity
Great Explanation. I like your structured style. 😊
This plugin seems to make it easy to build complex queries. Much easier than trying to do the same thing using Dataview.
Still I somehow lean towards Dataview, because other UA-camrs complained about the speed of DB Folder, when dealing with a large number of notes. 😅
What is your experience with the performance?
First, thank you for your feedback - I am still figuring this whole UA-cam thing out, and any input helps me to make better videos for you guys.
I did experience some performance issues when the pagination size was set to more than 100 entries. If I keep it below that, it works decently fast, and filtering lets me get to what I need very quickly. Also, using a dataview query as a source for the DB, also helps. But yes, 'native' dataview is certainly faster.
Personally, I use both. I like that the DB folder plugin lets you interact with the results directly (e.g., changing/adding/removing frontmatter fields for multiple notes at once).
So - as always - it depends on the use case 😊.
@@leanproductivity Changing multiple Metadata-Fields at the same time sounds really useful. So I might reconsider this plugin since I don’t know how to manage that in any other way… Thank you 🙏🏻☺️
PS: Ich hab die Sprache gewechselt (im Gegensatz zu meinem vorletzten Kommentar), weil es so für die meisten Leute leichter ist die Kommentare zu überfliegen. Nicht wundern 😂)
@@leanproductivity "I like that the DB folder plugin lets you interact with the results directly (e.g., changing/adding/removing frontmatter fields for multiple notes at once)."
- I'd tried to find a way to that -- you can do it with the Projects plugin -- but apart from Removing, I can't figure out how to create or update properties in bulk? I tried CNTRL+CURSOR DOWN in the column, etc.
Any ideas?
Danke sehr
@@0tt0fl0tt Yes, that's a really useful feature for managing frontmatter on multiple notes.
So you don't know? Well, thanks for hearting me, I guess...
When you showed in your video what Database Folder is capable of, I couldn't help but think "Wow - I think I might even be possible to JUST use Database Folder, and use it for what I presently use QuickAdd for, and what people in general use Metadata Menu for."
What is your take on that?
Which functions of Metadata Menu can, and which can't be replace with Database Folder?
(Limited to things I want to do with notes that I use inside of Database folder.)
(Based on your custom CRM video, I would guess that you would always choose to use Metadata menu - but then of course in your case, you already have *that* learning curve behind you :) )
I think if you only work with notes that are in a DB folder and use Templater, you may not necessarily need the Metadata Menu plugin. Frankly, I never considered or tried it - so I cannot really provide a detailed gap analysis between those two. Personally, I have too many notes and note types outside of DB folders, so I prefer to manage my frontmatter structure with Metadata Menu and fill it with Templater as far as possible.
For me, that's part of what makes Obsidian so useful - having the option to adapt it to one's individual needs.
Thank you for this interesting question, though.
@@leanproductivity I have given it a try, and it seems to work fine. I don't even need templater, I just need a template.
My thinking was this:
It makes me feel better if I know right from the start, that everything to do with the properties of the notes displayed inside my DB Folder, will be dealt with throgh DB Folder, and DB Folder alone.
Since DB folder gives me the option to both add properties to the notes displayed in the table (which only takes effect when I enter a value), and delete properties from notes displayed in the table, it kind of gives me all I need. (I didn't try renaming yet.)
In this way, I am sure that templater or Metadata Menu don't do something with those notes I don't want them to do.
This might be rookie way of thinking, so let's see how this goes. (Do you see a problem with this thinking?)
Not at all. If it works for you, that's great. There is no "one-size-fits-all" thinking with Obsidian.
how did you show the book covers please tell me😢
Hi. This is part of the "Book Search" plugin. Together with the other metadata about a book, it finds the cover. By default, it's a link to an online image. But you can change it to download them locally in the plugin settings (i.imgur.com/0UAkDrm.png). The rest is just a matter of embedding the image with a string in the template:
![[{{author}} - {{title}}.jpg|150]]
I hope this helps. Good luck.
@@leanproductivity thx a lot❤️
After installing this plugin there are immediately things that bug me. Titles have center text-alignment with no possible way to change it. Text doesnt wrap so and I cant edit the width of columns. This plugin has a long way to go to come close to Notion in terms of database management
Fair enough. I am looking forward to future versions of it, too.
does Obsidian work with PostgreSQL?
I suppose it depends on what you want to do. Apparently, there is a plugin for sending metadata from Obsidian to PostgreSQL: nat-arslan.github.io/posts/Obsidian-PostgreSQL-Python/#:~:text=There%20is%20an%20Obsidian%20plugin%20which%20makes%20it,metadata%20%28YAML%29%20of%20each%20file%20to%20PostgreSQL%20database.
Do I win a prize for being your 1,000th subscriber? ;-)
I'm not in a position to hand out prizes, but if there is a specific topic that you are interested in and I can make a meaningful video out of it, I will be happy to dedicate it to you 😊.
Other than that, you can bask in the warming glow of helping a fledgling UA-cam creator. Thank you for your subscription!
no thanks. Closed source I think ?DuckDB is the future,.
Entirely up to you, my friend. It is great to have the possibility to choose what works best for either of us.
Jesus Christ people need to learn how to use pauses. This was exasperating.