Memento Database: Difference between revisions

{{Stamp|2016-12-06|4.1.0|1.0.7}}

 

'''Memento Database''' is a database management software tool for mobile devices (Android) and personal computers (Microsoft Windows, Linux, Apple Macintosh). Elements of a user's database — [[Library|'''''libraries''''']] and associated files — may be synchronized across these [[#Platforms|'''''platforms''''']] via an available cloud service. Libraries also may be [[Sync with Google Sheets|'''''synchronized with Google Sheets spreadsheets stored on the user's Google Drive''''']] to enable the user's data to be manipulated or analyzed by either tool, as needed. [[Importing and exporting CSV files|'''''Import/export from/to comma-delimited (CSV) files''''']] enables coordinated use with external applications, like Microsoft Excel.

Memento was first implemented on the Android platform for smartphones and tablets, and Android continues to be a prime platform for Memento. The Mobile Edition operates off locally stored data that may or may not be synchronized to the Memento Cloud.

Users using Microsoft Windows, Linux, or Apple Macintosh use the Memento Desktop Edition to work with data stored in the Memento Cloud. Data and files are synchronized with mobile platforms through the Cloud.

There is, however, a '''[[JavaScript field|JavaScript field type]]''' that can be used for scripting or calculation of a field value. JavaScript may also be used to '''[[Triggers|perform functions at various junctures in the handling of a library entry]]'''. For a full description of the language, read '''[https://developer.mozilla.org/docs/Web/JavaScript here]'''. The implementation is based on [https://www.mozilla.org/rhino/ '''the Rhino library'''].

Memento also includes a proprietary syntax for users to define an expression for a '''[[Calculation field]]'''. It is simpler and easier to learn than JavaScript and is generally more convenient to use, when scripting requirements are minimal.

* Storing entries with custom [[Field|'''''fields''''']]

* Sorting, grouping, and filtering entries by any fields

* Displaying data in the form of a list, table, on a map, or in a calendar

* [[Sync with Google Sheets|'''''Synchronization with Google Sheets''''']]

* [[Cloud storage and Teamwork|'''''Teamwork''''']], by providing access to libraries to other users

* Dozens of [[Field Type|'''''types of fields''''']], including text, integer, real, boolean, date/time, rating, checkboxes, radio buttons, currency, image, signature, file, audio, contact, [[calculation field|'''''calculation''''']], '''''[[JavaScript]]''''', Google Maps coordinates, and others

* '''''[[Importing and exporting CSV files]]''''', permitting interoperation with popular programs like Microsoft Excel

* '''''[[Library protection]]''''' (encrypt entries using AES-128)

* '''''[[Charts]]''''': Pie, Line, Bar, Columns, Area, Scatter, Stepped Area

* Mass calculations ([[Library|'''aggregation''']]): sum, maximum, minimum, average

* Backing up and restoring data

* Searching entries in libraries by barcode

[[Category:Overview]]