Memento Database: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
mNo edit summary
Tags: Mobile edit Mobile web edit
 
(98 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Seminal Wiki ==
{{Stamp|2023-08-12|5.0|2.0}}
This wiki is in its infancy. During this time, you can expect it to be pretty accurate as far as it goes, but then it will just stop, with red links indicating pages yet to be written.
{{BannerMenu}}
 
{{PageTitle|The Memento Database application}}
The existing [[User Manual]] and [[FAQ]] are the last previous documentation available for Memento and should still be referenced while the wiki is still taking shape.


== Memento Database ==
== 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 — [[Library|libraries]] and associated files — may be synchronized across these [[Platforms|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.)
'''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 [[Synchronizing data|'''''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 data|'''''Import/export from/to comma-delimited (CSV) files''''']] enables coordinated use with external applications, like Microsoft Excel.


The tool is 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.
Data libraries may be linked, allowing any number of libraries to work together to form a database and provide a solution.
 
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.


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 [[Cloud storage and Teamwork|'''''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 [[Cloud storage and Teamwork|'''''teamwork use''''']].


=== Personal use ===
=== Targeted users & use cases ===
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'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 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.
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.


=== Business use ===
=== ''[[Platforms]]'' ===
Individual employees, departments, and entire businesses can manage their business data via their phones and tablets, laptops, and/or desktop computers.
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.


Common use cases for businesses include project management, customer relationship management (CRM), inventory management, expenses and receipts, product management, and sales management.
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 may be synchronized with mobile platforms through the Cloud.


The catalog is growing and already contains thousands of library templates.
=== Primary data structures ===
User data is stored in Memento in '''''[[Field|fields]]''''' making up '''''[[Entry|entries]]''''' within a '''''[[Library|library]]'''''. See '''''[[Terminology]]''''' to see how this relates to other database technologies and tools. A collection of libraries is called a '''''[[Library Groups|group]]'''''. A collection of fields within a Library structure is called a '''''[[Page|page]]'''''. When data is entered into fields, an '''''[[Entry|entry]]''''' is created, so while a library's '''structure''' is made up of '''fields''', the library's '''data''' is made up of '''entries'''.


=== The Memento Cloud ===
=== Programming languages ===
All data can be stored in the [[Cloud storage and Teamwork|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 [[Cloud storage and Teamwork|teamwork use]].
In general, '''no knowledge of programming languages is required''' to use Memento.


=== Mobile version ===
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 perform functions '''[[Actions|at the touch of a button]]''' or '''[[Triggers|at various junctures in the handling of a library entry]]'''. Memento provides a rich '''[[Memento JavaScript Library|API (Application Programming Interface)]]''' for JavaScript programming. For a full description of the JavaScript language, read '''[https://developer.mozilla.org/docs/Web/JavaScript here]'''. The implementation is based on [https://www.mozilla.org/rhino/ '''the Rhino library''']. Since Rhino does not implement the latest version of JavaScript, those features added more recently to JavaScript are not available to Memento.
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 ===
Memento also includes a proprietary scripting 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. When attempting to do complex scripting, the use of Calculation fields becomes very tedious.
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 is implemented using the Java 8 language. If you have esoteric questions about field value limits, arithmetic operation details, etc, you could reference the [http://docs.oracle.com/javase/specs/index.html '''Java 8 documentation'''], (but I don't recommend it very highly).
Memento supports [[Sync with Google Sheets|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 ==
=== Essential features ===
* Storing entries with custom fields
* Storing entries with custom [[Field|'''fields''']]
* Sorting, grouping, and filtering entries by any fields
* [[Slicing & Dicing|'''Performing Data analysis''']], including aggregation, charting, sorting, grouping, and filtering entries by any fields
* Displaying data in the form of a list, table, on a map, or in a calendar
* Displaying data in the form of a list, a set of cards, a table, on a map, on a Kanban (task management) board, or in a calendar
* Synchronization with Google Sheets
* [[Synchronizing data|'''Synchronization with Google Sheets''']]
* Teamwork, by providing access to libraries to other users
* [[Cloud storage and Teamwork|'''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.
* Access to data from [[Platforms|'''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 field|calculation]], [[JavaScript]], Google Maps coordinates, and others
* 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 field|JavaScript]]''', geolocations with Google Maps coordinates, and others
* One-to-many and many-to-many relationship between entries
* One-to-many, one-to-one, and many-to-many [[Link To Entry field|'''relationships between libraries''']]
* [[Importing and exporting CSV files]], permitting interoperation with popular programs like Microsoft Excel
* [[Importing and exporting data|'''Importing and exporting CSV files''']], permitting interoperation with popular programs like Microsoft Excel
* [[Library protection|Password protection]] (encrypt entries using AES-128)
* '''[[Data Sources|Populating database entries]]''' at the touch of a button with data from Web services and other sources
* [[Charts]]: Pie, Line, Bar, Columns, Area, Scatter, Stepped Area
* '''[[Library Protection]]''' (encrypt entries using AES-128)
* Mass calculations (aggregation): sum, maximum, minimum, average
* [[Charts List screen|'''Charts''']] — Pie, Line, Bar, Columns, Area, Scatter, Stepped Area
* [[Library|'''aggregation''']]): sum, maximum, minimum, average
* Reminders
* Reminders
* Backing up and restoring data
* [[Backup & Restore|'''Backing up and restoring data''']]
* Sending entries via SMS, e-mail, and other available services
* Sending entries via SMS, e-mail, and other available services
* Searching entries in libraries by barcode
* [[Barcode field|'''Searching entries in libraries by barcode''']]
* Online catalog of library templates -- thousands of templates available
* Online catalog of library templates -- thousands of templates available


== Primary data structures ==
== Find out more about Memento ==
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.
* The Memento [[User Interface|user interface]]
* [[Glossary]]
* [[Products & Services]]


== Find out more about Memento ==
<small>[[About:Memento Wiki|Introduction to the Memento Wiki]]</small>
* [[User manual]]
 
* [[FAQ]]
[[Category:en]] [[Category:About]]
* [[Tips]]
* [[Memento tutorials|Tutorials]]
* [[User-contributed articles]]

Latest revision as of 14:20, 29 August 2023

« Page as of 2023-08-12, editions Mobile 5.0, Desktop 2.0 »
Wiki
Home 		About
Wiki | Memento 		Getting started
Wiki | Memento 		Indexes
Mobile | Desktop | Scripting 		Support
Wiki | Memento 
The Memento Database application

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 may be synchronized with mobile platforms through the Cloud.

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's data is made up of entries.

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. JavaScript may also be used to perform functions at the touch of a button or at various junctures in the handling of a library entry. Memento provides a rich API (Application Programming Interface) for JavaScript programming. For a full description of the JavaScript language, read here. The implementation is based on the Rhino library. Since Rhino does not implement the latest version of JavaScript, those features added more recently to JavaScript are not available to Memento.

Memento also includes a proprietary scripting 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. When attempting to do complex scripting, the use of Calculation fields becomes very tedious.

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 very highly).

Essential features

Find out more about Memento

Introduction to the Memento Wiki

Retrieved from "https://wiki.mementodatabase.com/index.php?title=Memento_Database&oldid=4680"