Read from memento database

Richard W.

unread,

Jun 21, 2021, 5:50:41 PM6/21/21

to mementodatabase

How to read from memento database other than locating in entries in the app manually

Bill Crews

unread,

Jun 21, 2021, 8:55:46 PM6/21/21

to Richard W., mementodatabase

OK, I give up. Like what?

You can see the list and the view & edit cards.

You can see the cards view, table view, calendar view, maybe other views.

You can export or sync your library to a Google Sheets file on your Google Drive and view that.

If you use the desktop edition, you can get on it and develop a report using JasperSoft Reports.

I'm probably forgetting something. Well, with some JavaScript programming, you can do almost anything & and it to a file, by email, by HTTP, and other ways. I guess that should cover whatever you might want.

On Mon, Jun 21, 2021, 5:50 PM Richard W. <richardlear...@gmail.com> wrote:

How to read from memento database other than locating in entries in the app manually

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/98d1538e-57ac-4c1e-9d6f-810443b534ffn%40googlegroups.com.

Richard W.

unread,

Jun 22, 2021, 11:27:21 AM6/22/21

to mementodatabase

Sorry, I mean like reading from another app like the way an android app can read from mysql database. For example the tasker plugin allows you to update database record but you can't read from it unless an event happen from within the Mememto database app. Thank you.

Bill Crews

unread,

Jun 22, 2021, 1:44:34 PM6/22/21

to Richard W., mementodatabase

reading from another app like the way an android app can read from mysql database.

How does it do that? Though Memento uses SQLite internally to store & manage database operands, the SQL interface is not exposed to Memento users, and the Memento JavaScript Library provides no functions to do that.

If you know JavaScript, this could become a project for you, as getting the value of each of the fields is certainly supported, you have a rich JavaScript language to use to do things like formatting numbers, dates, strings, etc, including HTML formatting. If you were energetic enough & had the time, you could develop your own report writer or even a SQL interface using the API (I think. Hmmm... 🤔). Also, there's a File object for opening, reading, writing, & closing files, Html, Email, Http, & System objects to access the world outside Memento, etc.

> For example the tasker plugin allows you to update database record but you can't read from it unless an event happen from within the Mememto database app.

That's a good example. The Memento trigger (along with, reminders, actions, dates & times, etc) allows you to capture the event and perform operations. The conversation above is about accessing without triggering events. The Memento System & Intent objects allow some things you can do in Tasker.

Thank you.

On Monday, June 21, 2021 at 8:55:46 PM UTC-4 bill....@gmail.com wrote:
OK, I give up. Like what?

You can see the list and the view & edit cards.
You can see the cards view, table view, calendar view, maybe other views.
You can export or sync your library to a Google Sheets file on your Google Drive and view that.
If you use the desktop edition, you can get on it and develop a report using JasperSoft Reports.
I'm probably forgetting something. Well, with some JavaScript programming, you can do almost anything & and it to a file, by email, by HTTP, and other ways. I guess that should cover whatever you might want.

On Mon, Jun 21, 2021, 5:50 PM Richard W. <richardlear...@gmail.com> wrote:
How to read from memento database other than locating in entries in the app manually
--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/98d1538e-57ac-4c1e-9d6f-810443b534ffn%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/mementodatabase/91ad2f16-d47c-4379-9280-c2df19ae837bn%40googlegroups.com.

Reply all

Reply to author

Forward