Any interest in a personal "useful forum macros" collection tool?

[griffman]

@Zabobon

I'm not familiar with SQLITE3 databases.

I wrote a long series about sqlite3 and Keyboard Maestro a while back:

Using sqlite3 databases with KM macros: Part 1

Overall objective This series is designed to help those looking to use sqlite3 databases with their Keyboard Maestro macros. It assumes minimal to no knowledge of sqlite3, and I'll do my best to clearly explain things as I go. If you have questions, please ask and I'll do my best to clarify. By the end of the series, you'll hopefully have a functional Keyboard Maestro macro that creates a database, and then interacts with that database to read data, change data, add data, etc. With the knowled…

The beauty of using sqlite3 is that it's included in macOS, and Apple uses it extensively in their apps, so it's unlikely to vanish any time soon.

@Zabobon

Can the location of the database be changed to a location chosen by the user, such as a location on Dropbox?

Yes, you can set their storage location (depending on how the macro is written; check out my Quick Web Search macro as an example of one that lets you specify a storage location.

But no, not on dropbox. sqlite3 is not written with multiple simultaneous access from networked machines in mind. It uses a file locking mechanism that doesn't work across a network, amongst other issues.

I don't think I want to try to address synching, given the complexities involved. But it wouldn't be hard to write a macro that made sure the database was quit on other Macs, then copied the current file from one Mac to others. But syncing changes and keeping them current both directions? Not something I'm even going to attempt :).

-rob.