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. (Google Sheets spreadsheets are to a great degree compatible with Microsoft Excel, so that tool may also be used, if care is taken.)
The tool excels at being extensible to highly-complex uses while remaining easy to use for simple tasks. An online catalog of library templates not only provides pre-built solutions, but also gives users the opportunity to familiarize themselves with a large number of ways to use Memento to provide solutions.
Created for anyone seeking to store, manipulate, and view fielded data, Memento enables users to create custom data libraries with unique sets of data fields, quickly add new entries, and share entries with friends or colleagues. The structure of these data libraries may be changed dynamically, enabling users to incorporate significant changes quickly and really.
Data libraries may be linked, allowing any number of libraries to work together to form a database.
Personal use
The program is readily used by anyone from grocery shoppers to cooking enthusiasts collecting recipes to field scientists on a mission. Shopping lists, purchases and expenses, movie collections, tasks, fishing spots, store inventory, and pretty much anything else –- all can be easily added to a user's database and quickly found, sorted, filtered, and analyzed afterwards.
Memento allows users to link different kinds of information and use them together in a connected manner. For one example, users can create Memento libraries for drugs, pharmacies, physicians, prescriptions written for drugs filled at pharmacies, and so on, and then use them as an integrated database for the tracking of medications, conditions, treatments, etc.
Business use
Individual employees, departments, and entire businesses can manage their business data via their phones and tablets, laptops, and/or desktop computers.
Common use cases for businesses include project management, customer relationship management (CRM), inventory management, expenses and receipts, product management, and sales management.
The catalog is growing and already contains thousands of library templates.
The Memento Cloud
All data can be stored in the Memento Cloud. All such entries, 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.
Mobile version
Memento was first implemented on the Android platform for smartphones and tablets, and Android continues to be a prime platform for Memento. The mobile version uses local device storage and/or external SD card storage and can also utilize the Memento Cloud. The Mobile Version operates off locally stored data that may or may not be synchronized to the Memento Cloud.
Desktop version
User's using Microsoft Windows, Linux, or Apple Macintosh use memento to work with days stored in the Memento Cloud. Data and files are synchronized with mobile platforms through the Cloud.
Synchronization with Google Sheets
Memento supports online synchronization to the Google Sheets application via Google Drive and allows users to edit their records on their PCs.
The app can also be used as mobile forms for Google Sheets.
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 and many-to-many relationship between entries
- Importing and exporting CSV files, permitting interoperation with popular programs like Microsoft Excel
- Password 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
Primary data structures
User data is stored in Memento in Fields 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.