DB Browser for SQLite
SQLiteStudio
DBeaver
sqlite-gui
TablePlus
Valentina Studio
HeidiSQL
DbGate
Obsidian
Notion
Logseq
Joplin
Roam Research
Evernote
Bear
Standard Notes
ObsidianPerhaps you know someone who swears by Obsidian, it may seem like a cult of overly devoted people for how passionate they are, but it's not without reason
I've been using Obsidian for over 3 years, at a point in my life when I felt I had to handle too much information and I felt like grasping water not being able to remember everything I wanted, language learning, programming, accounting, university, daily tasks. A friend recommended it to me next to Notion (of which he is a passionate cultist priest) and I reluctantly picked it and fell in love almost immediately.
Obsidian seems very simple, like a notepad with folder interface, similar to Sublime Text, but the ability to link files together in a Wiki style allows you to organize ideas in any way you want, one file may lead to a dozen or more ideas that are related
If you want to do something specific, Obsidian has a plethora of community created plugins that expand the functionality, in my case, I use obsidian to organize my classes both as a teacher and as a student, using local databases, calendars, dictionaries, slides, vector graphic drawings, excel-like tables, Anki connection, podcasts, and more
I've been using Obsidian for more than a year. It's been great. I think it offer a great balance of control, flexibility and extensibility. What is more, you own your own data, that's been a must-have feature for me. I just can't imagine putting all my knowledge into something that I don't have control over.
I think two of the most popular alternatives that people consider are Logseq and Roam Research. Although Logseq is a bit different, it's considered compatible with Obsidian. Supposedly, you can use them with a shared database (files. Both use simple text files for storage). I tried that once, a few months ago. It worked, yet it messed up a bit my Obsidian files ¯_(ツ)_/¯.
Based on our record, Obsidian should be more popular than DB Browser for SQLite. It has been mentiond 1523 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Open DB Browser for SQLite, choose Open Database, and pick the file you just downloaded. You should see a list of tables down the left: Album, Artist, Customer, Employee, Genre, Invoice, InvoiceLine, MediaType, Playlist, PlaylistTrack, Track. Eleven of them. - Source: dev.to / 30 days ago
> https://sqlitebrowser.org/ sqlitebrowser.org is cool but it's not the sort of developer tools I'm talking about. As I clarify in the side notes, I'm talking for a formatter, linter, LSP, not an IDE. > https://sqlite.org/syntax.html As I replied to some other comment, I'm very aware that there is a syntax diagram but that really only tells half the story. If you actually look at those diagrams into detail, or you... - Source: Hacker News / 5 months ago
> I’ve long been puzzled that no one has invested in building a really good developer experience for it. https://sqlitebrowser.org/ > Unfortunately, unlike many other languages, what > SQLite has no formal specification describing how it should be parsed. https://sqlite.org/syntax.html. - Source: Hacker News / 5 months ago
Next, the database we’re going to use will need to be created. I’m going to do this with DB Browser for SQLite. Once installed, just go to ‘New Database’, browse to the location you want to create it at (just a handy place within the project folder is fine), choose a name and hit Save. An empty DB is created. - Source: dev.to / 10 months ago
Because it a GUI that uses Mac-specific UI libraries that aren't available on Linux and Windows? While the database stuff works on Linux and Windows, building UIs for the 3 platforms is very different, unless you use some cross platform wrapper layer. Which isn't the purpose of this one. You might want sqlitebrowser[1] if you're looking for something like that. [1]:https://sqlitebrowser.org. - Source: Hacker News / about 1 year ago
Inline preview, usually called WYSIWYG. Obsidian's Live Preview mode hides the syntax except where the cursor is. Obsidian is a far better personal knowledge base than anything else on this page, with backlinks, a graph and years of plugins, and if that is what you need the question of what its editor is called does not matter much. - Source: dev.to / 15 days ago
The stack is all open source: Obsidian, GBrain, Horizon, PGLite, and a couple of small Python scripts for the state machine and quality gates. None of the interesting parts are proprietary — the interesting part is the discipline. - Source: dev.to / 21 days ago
Obsidian is a note-taking app that stores everything as Plain markdown files. It lets you organize and structure your notes in a Flexible way, and because the files are plain text on disk, anything that can Read a directory can read your notes, including an AI agent. - Source: dev.to / about 1 month ago
Install Obsidian: Download the client from obsidian.md and create a local Vault — just a local folder. - Source: dev.to / 2 months ago
Obsidian (https://obsidian.md/) Honestly its not huge and most are probably obvious, but those are what I immediately install on my machines. - Source: Hacker News / 3 months ago
SQLiteStudio - SQLiteStudio is a cross-platform SQLite database manager
Notion - All-in-one workspace. One tool for your whole team. Write, plan, and get organized.
DBeaver - DBeaver - Universal Database Manager and SQL Client.
Logseq - Logseq is a local-first, non-linear, outliner notebook for organizing and sharing your personal knowledge base.
sqlite-gui - Minimalist SQLite GUI admin tool for Windows
Joplin - Joplin is a free, open source note taking and to-do application, which can handle a large number of notes organised into notebooks. The notes are searchable, tagged and modified either from the applications directly or from your own text editor.