Obsidian database folder plugin
Вставка
- Опубліковано 30 лип 2024
- The Aesthetics have been updated to V1 now! (looks better than in the video 😁)
Check out the plugin roadmap: github.com/users/RafaelGB/pro...
🧠Obsidian Course: dannyhatcher.com/obsidian-onb...
📜 Zotero Template: danny-hatcher.ck.page/000f0d749b
💰 Vault Templates: dannyhatcher.com/obsidian-onb...
📙 Public Notes: publish.obsidian.md/danny-hat...
🗣 Discord: / discord
🌐 Website: www.dannyhatcher.com
🚨 Second Channel: / @danny.hatcher
📚 USEFUL BLOGS:
✍ Daily notes template: dannyhatcher.com/how-to-link-...
✍ Dataview for beginners: dannyhatcher.com/obsidian-dat...
✍ Git backup: dannyhatcher.com/obsidian-git...
✅ CONNECT WITH ME:
Twitter - / dannyhatcher
Instagram - / danny.hatcher
LinkedIn - / dannyhatcher
Web call - dannyhatcher.com/contact/
TIMESTAMPS:
0:00 My Use
0:19 Setup
0:47 DB Folder page
2:10 DB Property types
5:25 Adding/changing properties
7:10 DB Settings
9:30 Templates in the database
10:10 Database folders
12:40 Database sorts and filters
15:23 Formula property
🛠TOOLS I USE:
👉 OBSIDIAN: obsidian.md/
👉 ZOTERO: www.zotero.org/
👉 MORGEN: morgen.so/?ref=dannyhatcher
👉TUBEBUDDY: www.tubebuddy.com/dannyhatcher
👉 EPIDEMIC SOUND: www.epidemicsound.com/referra...
#dannyhatcher
nice tutorial! May I use your video as a front page readme? Could be a nice introduction for the users 😊
We will continue to improve the plugin with feedback from the community
I am happy with that. The more eyes on the plugin, the more help you may get to get some of those enhancements up and running.
I added a date property and it was removing existing properties from individual files whenever I add a date. Not great.
@@StevenMichels it should only adjust the property file matching the I'd.
@@DannyHatcherTech It made changes to the existing tags--that is, deleting them--but only in the files that I attempted to attach a date to.
It is brilliant plugin! Thank you!
It is a pity that this plugin does not allow you to create inline field names consisting of two or more words without underscores.
If two such names with underscores are written on two lines in a row, all the text between the two underscores will appear italic.
Dude! xD One of the best explainer video I've ever seen. You get *straight* to it and add bits of humor here and there. Wellll done
OMG!! Thank you sooooo much! It is an amazing tutorial. I did not know why the property was not working well when I added tags to it directly rather than inside the settings. No one explained it as good as you did!
It's a promising plugin. I hope the developer work on the aesthetics of the plugin someday soon 😶
They did a couple hours before the release of this video. Top line of my description 😁
Outstanding video! I love this plugin and you've done a splendid job explaining it.
That is great to hear! With the recent updates this plugin is just getting better and better.
Database Folder is amazing! Thank you for the introduction
It has come so much further since this video
I'm excited to dig into this, thanks for the vid!
It is a great plugin 😁
I don't know whether I'm more excited by finding this plugin or by the out of this world good pacing of your video.
Thanks 😁
Pacing is very subjective with videos. I am glad you liked it 👍
Thank you Danny. Just what was needed before I dig into this plugin.
Awesome! Let me know your thoughts.
AWESOME! Thanks for sharing and keep it up Danny!!
Thanks for watching!
This is exactly what I’ve been looking for today! Thank you!
Glad I could help 😁
Dang, this is an awesome plugin! Also, great video!
fantastic plugin,really benefit from it.Thank you Danny
You're very welcome!
perfect video
you mentioned everything + all small things that a person like me would never find out myself
thank you man 🎉🎉🎉🎉
There have been updates since this with more to come so it is worth looking at the changelog in the Github repo aswell 😁
@@DannyHatcherTech man that was fast,
I wasn't expecting comment reply from the UA-cam channel owner this fast😅😅
I WILL check the github repository
@@sajjadabouei6721 aha, I reply when I see the message 😁
Danny, this is amazing! I'm still using notion for these things. In my head I am already going through a plan on how much effort it would take to migrate my 8 or so notion spaces 😅 I am starting to think maybe I don't migrate anything and just start using obsidian as primary app and migrate only things I need at the moment
Had the same problem with migrating my Notion stuff, I’d suggest migrating all the things that would benefit from Obsidian’s linking ability ! Focusing on notes, tasks are less of a priority
I personally only moved things from Notion if/when I needed them.
@@DannyHatcherTech one thing that I found hard to replicate in obsidian is image formatting. For example in notion I can drag & drop multiple images next to each other into columns, and adjust each image's size just with the mouse. Do you deal with that in obsidian? I think I tried image in editor plugin which is the most popular but I didn't find it to be useful for my purpose so for now I need to type " | 500" after each image's markdown link to adjust the size which is cumbersome
@@FlamencoDeniz Most of the images I use in Obsidian are screen shots of videos, or image imports from zotero highlights.
There is no need for me to put them in columns or resize them as most of the time I summarize it all into a working note.
This makes Obsidian so powerful now! I’ll stick with ClickUp for task management but I think I’m 100% done with Notion now 😳
Yeah Notion is in my rear view!
When this plugins is up and running with more support other systems maybe challenged 😳
Amazing explanation! Thanks a lot!
🧡
i decided to shift from notion to obsidian , and this viedeo help alot in this decision , thank yoy alot for this such a great video
Same, this seems to be the only major feature I needed to fully replace notion with obsidian.
Thanks to your detailed video, I found some mistakes in the documentation. Thank you for helping me notice them.
Always happy to help.
I am sure this video will become outdated soon with the updates but it is a starting point 😁
@@DannyHatcherTech You can always make another video when enough new major features are released
@@imedgh6928 Very true.
Nice vid!!
🧡🧡
Very interesting and useful! Thank you!
Recent updates have made this plugin even better
@@DannyHatcherTech and it's also now integrated with Obsidian Projects plugin :) Both together they are a game changer! :)
AGREED!
Really helpful, thank you so much! I also want to know what the fomula is used for counting days left.
The days left formula is just the days between now and the due date 😁
Amazing plugin and very well explained, thanks for sharing!
Quick question: Is there any option to filter the included/queried notes by text/string they contain? (i.e. somewhat similar to the native query function of Obsidian)
I've so far found out that Dataview can't do it, unless we're working with DataviewJS (which I so far try to avoid getting into). If the tables of this plugin are made with DataviewJS, there should be the possibility. I'm playing with it now (Database Folders that is) but haven't found a way to get done what I'm describing above.
Any insights or ideas?
You can filter file front matter by any way you want.
That is the column information.
Contains is part of the filter options.
Danny excellent video as usual! Forgive me if you covered this but is one able to add an attachment? Say one has a jpeg of a receipt & then wants to add it (or multiple) in the database.
I didn't cover it here. You can add attachments in the text property, best to make it inline aswell 😁
Is there any way to make relational database like Notion? eg. there is an employee database and there is an assets database. They can be linked such that I can see which employee has which asset.
Yes, using the relation property or adding a link in a text property.
Thanks for this video, very interesting. I have one question, how is the performance? I can see on the plugin page it mentions it is using react, where one of the benefits of obsidian vs notion is that notion can get clunky. Do you find that performance is ok with this with big databases and on mobile?
The performance was fine but I have stopped using it recently so can't be sure.
great！
Thanks!
Happy to help 😁
What a great tutorial man, one of the best I've seen about this great plugin. I'm having an issue that may be you know how to solve: in your video the fonts of the columns with type "Tags" and "Select" are way smaller and easy to read that the ones I'm getting. My tags and select columns have the same font size than the rest of the text (for example the tittle of the file). I tried to change the font size from the global settings but it changes all the fonts (the issue still persist). How did you set that small fonts for "tags" and "select" columns tipe only?
I know there have quite a few changes to the plugin since this video, and as I have stopped using it I am not sure unfortunately - and I don't want to give you poor advice.
Maybe look at the Obsidian discord.
@@DannyHatcherTech Thanks man, do you find another plugin that can do the work better than this one?. I'm interested in your opinion
@@stoictrader7432 I use metadata menu instead - I have a video on that aswell 😁
Impressive!
One of my favorite plugins!
One of the reasons I like Notion is the ability to do nested tables. A table within another table within anither table for PKM. Are you able to do that with this plugin?
Notion has inline database views.
So a page has a database in it. This plugin is a view database rather than an inline view.
You can create inline views with dataview if want.
As Obsidian is faster and more flexible i dont use inline database as they dont give me all i want but we all ha e our preferences. 😁
Please tell me what to do with this error. I have enabled moving files according to status.
"Error while removing empty folders: path is aa directory: rm returned EISDIR (is a directory)
I dont know error codes but my guess is the folder location has something to do with it.
Discord maybe a vetter place to talk.
Is there a way to remove the automatic underlining of the text (file column) when shown on the table? I have looked at older videos, and it just seems that before it didnt exist, at least not for the actual files (it did for external urls), but now there seems to be no option to not have that underlined. Am I missing something?
Sorry I am not sure. I stopped using this plugin. My guess is that CSS would work but I am not sure.
@@DannyHatcherTech Have you found something you prefer, or do you simply not need it any more?
@@tullochgorum6323 dataview + metadata menu does all I need.
Databases and the Taskmanager are the reason I‘m trying to build my system in Obsidian now, without them I just couldn’t do it 😂
One question that popped up when I created a few databases is:
Is it possible to fill in the columns from the page itself?
My usecases: Daily Notes
I want to be able to view important things that happened that day in the database view.
So I created a column called „highlights“, but it seems I have to go outside of my daily note and into the database itself to fill it in?
I saw that you changed the text inside the columns from the actual note, but that was only after you already put in some text already via the database right?
The database is a page that looks at other pages.
It uses dataview so frontmatter information and inline information.
If you make an inline property eg highligh:: text
You can show the highlight text in the database.
I think that is what you mean.
@@DannyHatcherTech I think it might be. I‘ll try it out tomorrow :)
You show that the information in the database for a note is stored as YAML entries in the frontmatter. Is there a way to store the database information for a notes as tags anywhere (other than in the frontmatter) or at a specific location (e.g., after a headding) in the file? If, so how to set up a database to do that instead?
that is called inline information. at the moment it is specific to the dataview plugin. In the settings of the columns you can make the information inline
Is it possible to make the filter panel always visible?
When I switch between files and the database, the filter panel is hidden and I need to turn it on forcibly
I dont rhink so, but I havent used the plugin in a while
Thanks for the great tutorial. Is there a way to show a file has been recently updated... more like the latest modify is greater than the last modify date or created date (if it has not been updated before)
I think the last modified would do that, but I could be wrong
@@DannyHatcherTech Thanks, will try that out
well done
😁🧡
Great video as always! If I may ask, what is the formula for remaining days? 🤔 Thanks!
It isn't quite right yet as it uses timestamps but here you go: ${row.Deadline.diffNow("days").toFormat("d")} days left
@@DannyHatcherTech oh I see! Thanks for sharing it 😉🙏
@@DannyHatcherTech Wow! Thank you very much! The tip that saved me another hour :) Didn't see diffNow() method in Luxon documentation :)
Is it possible to use Rollap/Relations between two different databases? Didn't find it myself
Yes, it is a new feature. I have a shorts video about it 😁
thx
as warning to everyone trying the plugin. ALWAYS make backups of the vault before even installing it and then everytime you change the columns if you have the one setting ticked that removes the field from the files too.
also the plugin doesn't like nested lists like
key:
key2:
- value 1
- value 2
key3:
- vaule 3
if you have things like that it changes it into the "object" writing style with key: {[key: [value 1, value2]}, {key: value}]} or something similar (not sure on the exact syntax). so it can change your existing metadata in a way that you don't want.
Very true 👍 thanks for adding that in 😁
i tested it again. this time it didn't change the way the nested lists where written inside the note but they still weren't rendered correctly inside the table. the LaTeX of the formulas was not rendered out and it looked like this:
{"AC_Power_Var":{"Active":["$P=U\\cdot I\\cdot cos\\varphi$","$P=S\\cdot cos\\varphi$","$P=\\frac{Q}{tan\\varphi}$","$P=\\sqrt{S^{2}-Q^{2}}$"],"Reactive":[
and so on. (copied out of the field it shows.) the funny thing is that it is putting \ before the \ of the latex syntax. but it isn't how it is written inside the note.
conclusion DB folder still hates nested fields.
the problem is that i use a nested field because the sub fields have all different names but i want to have the formulas all inside one column.
so i put all formulas into a main "formulas" field and have the first sub field the name of the formula and then a 2nd deep sub field for each variable. and in that is then the formula.
so i can't just rewrite this structure so that i have no sub fields because then each formula would need it's own column or i would need to write a VERY long choose() header for each formula table.
@@dovos8572 thanks for the update. I would reach out in the repo of the plugin for Rafael to look at.
@@DannyHatcherTech i read through some closed and open issues and it seems to be known and a bigger problem with the workings in the background. he has it so far that it is changing the nested data correctly without needing to change it into the object writing style.
or something like that.
database in obsidian is a pain in the butt. it's nothing like notion you have to customize and create everything from beginning to end as web developer I don't have that much time so is there any alternative app I can use for database or is there any alternative way in obsidian?
I use dataview and metadata menu in Obsidian.
There are loads of other apps.
Is there way to add links in the metdata?. Something like status: [[2_InProgress]]. Im not understanding which property type I should use for this as Text gives me garbled values
if you want to add links I would use the relation property type
@@DannyHatcherTech Thanks for the quick reply. With Relation the column looks good but values can't be added by directly clicking the column. In settings of the column it says it can only be realted to Other Databases
@@AmanKumar-st9mq Yes. You link files to other files through databases. If you want a simple way to add links use a text property and make it inline
Hi thank you ! Can we embed and view the database in a file ?
Yes, but it doesn't work as well at the moment.
I have seen a tutorial for this database to track daily habits but all my daily notes are not in order so it's difficult to have an overview how long you have been consistent with certain habits.
There are lots of ways to track habits. Getting a sort correct could be done using a date property if the file name isn't working for you.
Thank you very much for such an informative video
It is a pity that this plugin does not allow you to create inline field names consisting of two or more words without underscores.
If two such names with underscores are written on two lines in a row, all the text between the two underscores will appear italic.
That is not the fault of the plugin, but a feature of the markdown files.
It is the same reason you can't have tags with seporated words and need to be connected by a symbol like -
ooo this is clever
I am loving it!
13:00 Is it possible to filter it in Alphabetical order? If so, How?
Not sure sorry.
hi, i would like to combine this plugin with projects.
So i need to have the date format like that : YYYY-MM-DD
that 's why i specify it in the parameters of dbfolder (configuration about editing engine)
Still, in the yaml, format date looks always like :
2023-02-19T00:00:00.000+01:00
what can i do to have a format like 2023-02-19 ?
thank you very much
I don't use either of those plugins anymore but my guess is that the syntax in the settings needs to be the same.
@@DannyHatcherTech thank you. Why dont you use these plugins anymore ?
@@harounlee208 Having a dataview query in a canvas is easier to navigate for me.
I also use metadata menu for YAML editing
I have a genuine question and would like a genuine answer: what is the advantage of using this over excel? I'm happy to be convinced.
Simple query searches with links to files is where Obsidian tables excel. I use metadata menu now.
Excel is still far better for spreadsheet like calculaitons!
Does anyone know how to reveal hidden column?
Go to the settings and toggle them on. Should be at the top right.
thank u i'am from iraq :)))))))
How you open tab (Hot key) - Test 1 on 2:05 minutes?
I clicked on the file name.
ctrl + click for a new tab.
You could also click on the row number for more options like rename etc.
Hotkeys are slowly being added with newer updates.
@@DannyHatcherTech ctrl + click - tab open right side? Very convenient when tab Test 1 - open right side.
Sorry, what's the difference between "database folder" plugin and "dataview" plugin?
database folder use dataview to work. Database folder gives you a view, dataview gives you a query block.
Notion databases felt like the last thing it really did better than Obsidian.
This killed Notion for me now.
Notion databases still have more features but this plugin is certainly closing the gap.
The "Git backup" link in the description is broken.
I will take a look and fix it 😁
Amazing that this is possible!
Can we make one of these dataview tables that covers pages/notes from multiple databases?
This plugin uses dataviee for the searching.
Dbfolder is basically an addon to dataviee for ease of use.
So yes, kind off 😁
@@DannyHatcherTech Alright
Sounds like I should research the options for dataviee multiple database support
@@utica2burn it depends what you want to do.
Imo dataview + metadata menu does the job
@@DannyHatcherTech I don't know yet if it makes sense for me to use multiple databases, might actually just be one database with a good folder structure.
I'm all new, and was just curious if these tables were limited to one particular database
@@utica2burn ah I see.
Think of a database as a folder search 😁😁
👍👍👍👍👍👍
😁🧡
How do I get that community plugin database?
Go to settings community plugins, then search for database folder.
@@DannyHatcherTech But where's the plugin database?
@@calorion If you are asking how to create a database, there is a button that is added to the ribbon (left side) when the plugin is enabled.
You could also go into the command palette and create one from there.
@@DannyHatcherTech No, I mean the database of community plugins that you demonstrate in the video.
@@calorion oh, that is in the settings, community plugins and then browse.
Am i right that this has basically allowed Obsidian to emulate Notion database tables?!? Because if so, wow.
Yes this does most of it. I use metadata menu + dataview to give more options.
Only understandable at half speed
Everyone has there preference 😁
hello thanx for good information i have a question that would be great if you answer
so i have a image property and in front of that property i put thd image link in the attachmet folder like this
---
image: [[imageone.png]]
---
and i want to have a column in DBfolder that showes that image but it showes the link to that image i tried adding ! to the image property so its like this
image: ![[imageone.png]]
and this works but can i make it that i dont use that "!" and it still work
I stopped using this plugin so am not sure now sorry.
27 is also MY Lucky Number!!
How did I not know this 👀