pmm VS Joplin

For ongoing monitoring of query performance, I use Percona Monitoring & Management - it's query log provides an easy way to spot frequent queries that may need optimizing.

I cannot recommend PMM highly enough - it's free. You'll get a ton of insight into your DB's bottlenecks, and can use it to validate changes made.

I use the free, open-source tool Percona Monitoring and Management (PMM) for monitoring and graphing.

i don't know if this is an idiom or not but at my workplace each go repo has a separate tools/ directory, which only has 3 files `tools.go` , `go.mod` and `go.sum` https://github.com/percona/pmm/tree/main/tools

Curious what monitoring solution you've used that's both plug-and-play and in IaC. And in any case, nothing stops you (I like this approach, actually) from running your monitoring solution in K8s. For DBs in particular, I'm a huge fan of PMM, which is a set of extremely thorough Grafana dashboards atop VictoriaMetrics, with some discovery tooling.

Percona Monitoring and Management - Open Source tool has backups included

https://www.percona.com/software/database-tools/percona-moni...

(Percona Founder so kind of biased)

Our next project is Percona Monitoring and Management (PMM). This project is supported by Artem Gavrilov, Backend Software Engineer, and Nurlan Moldomurov, Full-Stack Engineer. PMM is a great project to contribute to during Hacktoberfest. There are minor and easy-to-do issues in Github; it is not necessary to register them in Jira. These contributions are welcome if you have any good ideas, want to improve something or simplify some process. Send your PR; the maintainers will review it as soon as possible. We also have advanced issues if you want to go for more advanced tasks.

I've had great success with using Joplin for this, with Syncthing as a sync backend. Works well across OSes; I use it on Linux, macOS, Windows and Android.

https://joplinapp.org/

The tools to manipulate SQL aren't that bad, no.

But rather than having a self explanatory markdown & flat file, now I have to start learning about the schema & making specific tools (in my preferred language) for manipulating Joplin's schema.

Suddenly I'm digging through 20 different technic specs to decode what data is where, how it works, and what I can do to it. Want to edit history? This is the best help you'll get, pray it's adequately technical to expedite you to your purpose: https://github.com/laurent22/joplin/blob/dev/readme/dev/spec...

As I began with, I struggle to imagine anything that generates anywhere near as much user agency as flat files and markdown. Having boring common data & systems lets me apply portable skills I already have, rather than having to skill up in some particular product's own ecosystem.

Joplin is a good open source option too, feels more like the original Evernote in terms of UI/UX https://github.com/laurent22/joplin/

Joplin, an open source, extendable, Markdown-based hierarchical note-taking app: https://joplinapp.org/

It lets you choose a synchronization backend, offers applications for every major desktop and mobile OS (also has a terminal version). You can create notebooks and subnotebooks to organize your notes. You can also add tags for better search experience. I created notebooks for specific domains (work-related, home improvement, etc.) and also keep a "temp" for quick notes and W.I.P. snippets.

Its only con that it uses Electron on desktop which causes relatively slow start of the application.

done