Memento Database
Seminal Wiki
This wiki is under initial development. During this time, you can expect it to be pretty accurate as far as it goes, but then it will just stop, perhaps with red links indicating pages yet to be written.
Though the existing User Manual and FAQ have been mostly subsumed within the wiki, they are the last previous documentation available for Memento and should still be referenced while the wiki is still taking shape. When their content is completely subsumed within the wiki, they will become obsolete.
Read more about this wiki.
Quick index
Overviews
To start at the beginning, read Memento Overview below.
Read Library Overview about Memento's primary data structure.
The Field Overview will get you started on the elements of data structure within libraries.
Stay tuned for articles about Memento and its use.
Specifications
Begin with User Interface for descriptions of screens, cards, menus, buttons, dialogs, etc. Stay tuned for more.
Field Type is perhaps the most popular specification page.
Wiki Page Categories
Every wiki page is in at least one category. You can see the page's categories at the very bottom of each page. To see a list of all wiki pages by their categories (similar to a site map), see the Category:Memento page.
Memento Database
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 — libraries and associated files — may be synchronized across these platforms via an available cloud service. Libraries also may be 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. Import/export from/to comma-delimited (CSV) files enables coordinated use with external applications, like Microsoft Excel.
Data libraries may be linked, allowing any number of libraries to work together to form a database and provide a solution.
All data can be stored in the Memento Cloud. All such libraries, photos, and files are synchronized automatically between the cloud and local copies on Android devices. Users can provide access to their data to other users, enabling teamwork use.
Targeted users & use cases
Memento's goals include serving:
- the casual, perhaps single-library user
- who just wants to throw up a grocery list or recipe repository
- the intermediate user
- who might want to have some related libraries tracking some activities
- the power user
- who might be pushing the boundaries in certain areas, like scripting, complex data structure, retail or barcode solutions, media solutions, contact applications, product catalogs, charting, or others
- the organizational user
- who might need teamwork collaboration, cross-platform compatibility, cloud storage & coordination, library protection, and others
Memento's online catalog of user templates contains thousands of predefined, ready-to-use libraries to use directly or serve as a starting place. It also gives users the opportunity to familiarize themselves with a large number of ways to use Memento to provide solutions.
Platforms
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.
Programming languages
In general, no knowledge of programming languages is required to use Memento.
There is, however, a JavaScript field type that can be used for scripting or calculation of a field value. For a full description of the language, see here. The implementation is based on the Rhino library.
Memento is implemented using the Java 8 language. If you have esoteric questions about field value limits, arithmetic operation details, etc, you could reference the Java 8 documentation, (but I don't recommend it).
Primary data structures
User data is stored in Memento in Fields making up Entries within a Library. See Terminology to see how this relates to other database technologies and tools. A collection of libraries is called a Group. A collection of fields within a Library structure is called a Page. When data is entered into fields, an Entry is created, so while a library's structure is made up of fields, the library itself is made up of entries.
Essential features
- Storing entries with custom 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
- Synchronization with Google Sheets
- Teamwork, by providing access to libraries to other users
- Access to data from several Android devices and from laptop and desktop computers; users can work with the same libraries on their phones, tablets, and PCs.
- Dozens of types of fields, including text, integer, real, boolean, date/time, rating, checkboxes, radio buttons, currency, image, signature, file, audio, contact, calculation, JavaScript, Google Maps coordinates, and others
- One-to-many, one-to-one, and many-to-many relationships between libraries
- 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 (aggregation): sum, maximum, minimum, average
- Reminders
- Backing up and restoring data
- Sending entries via SMS, e-mail, and other available services
- Searching entries in libraries by barcode
- Online catalog of library templates -- thousands of templates available
Find out more about Memento
- The Memento user interface
- Glossary
- User manual
- FAQ
- Products & Services