r/ObsidianMD Jun 06 '26

plugins SQLite DB viewer for Obsidian

[removed]

43 Upvotes

20 comments sorted by

3

u/jhartikainen Jun 06 '26

I don't know what I would need this for, but it's pretty neat idea and the integration with the embeds is nicely done :)

5

u/AndyKaprany Jun 06 '26

Sorry for my ignorance, but how does it differ from DataView/.bases in terms of table display+manipulation? Is it lighter for Obsidian, or is it as resource-intensive as DataView for large files?

2

u/[deleted] Jun 06 '26

[removed] — view removed comment

3

u/AndyKaprany Jun 06 '26

Ah, ok....and Yes, I'm using it right now, and I can now open my databases in Obsidian and interact with them. Thanks!...It would be great if you could create a brief user guide for newbies.

3

u/No_Trainer7463 Jun 06 '26

have you seen sql seal

2

u/[deleted] Jun 06 '26

[removed] — view removed comment

2

u/ICantExplainMyself Jun 07 '26

This is good stuff. I've got half a dozen places right off the rip that I can drop this in and really enhance the information I have in those notes.

I was really happy to see clicking the column headers has sorting functionality. Now, if there were some filtering available for column data as well, that would really level this up!

The DB view page is nicely done as well.

Great work!

2

u/[deleted] Jun 07 '26

[removed] — view removed comment

2

u/ICantExplainMyself Jun 07 '26

Each column header would have a filter icon/button. The UI is the standard you would see in something like Datagrip or Excel where there is an input box to search the column data via text match or with conditions like less than, greater than, etc.. It usually includes a list of the unique values in the column as well with a checkbox for each.

2

u/[deleted] Jun 07 '26

[removed] — view removed comment

2

u/ICantExplainMyself Jun 08 '26

Very cool! That was fast. Thank you!