Difference between revisions of "About:Introduction to the Memento Wiki"

From Memento Database Wiki
Jump to navigation Jump to search
m
m
 
Line 4: Line 4:
 
'''''<hr>2021<hr>'''''
 
'''''<hr>2021<hr>'''''
 
= Introduction to the Memento Wiki =
 
= Introduction to the Memento Wiki =
'''Memento Database''' consists of a set of database management apps & server software for mobile devices (Google Android devices & Apple iOS devices) -- called '''''the Mobile edition''''' -- and for personal computers and laptops (Microsoft Windows, Linux, Apple iOS) -- called '''''the Desktop edition'''''.
+
'''Memento Database''' consists of a set of database management apps & server software for mobile devices (Google Android devices & Apple iOS devices) -- called [[About:The Mobile edition|'''''the Mobile edition''''']] -- and for personal computers and laptops (Microsoft Windows, Linux, Apple iOS) -- called [[About:The Desktop edition|'''''the Desktop edition''''']], referred to as the Memento '''''Platforms'''''.
 +
 
 +
== Organization ==
 +
A Memento database is organized into [[About:Libraries, Fields, & Entries|'''''Libraries''''', '''''Fields''''', & '''''Entries''''']], very similar to ''tables'' & ''rows'' in the relational database world. People often use more generic terms, like ''records'' for entries or rows. An aggregation of data related in addressing a subject area is usually called a ''database''. A Memento '''''Database''''' would consist of a set of related (linked) libraries. The structure of a database can be represented in & exported to a Memento template file, or '''''Template'''''.
 +
 
 +
You can synchronize your data across all your devices, computers, & their operating systems -- all your platforms -- via a Memento Cloud service. While Memento's apps are available for free or for a one-time charge, cloud services are offered by subscription over time. There are several cloud subscriptions available for free or for a fee per individual, with fees providing greater capacity in storage space. For free, an individual is very constrained; the free services are useful mainly for evaluation purposes. For organizations, features supporting teams are available for a fee per user over time.
 +
 
 +
Within an account's cloud, synchronization is pretty seamless & complete. With common data types, synchronization is very tight. So, the cloud may readily be used for backup & restoration of data.
 +
 
 +
Unfortunately the term ''synchronization'' is also used by Memento in referring to its ability for a library to be synchronized with a sheet of a Google Sheets file on a user's Google Drive. This capability can be very useful for various purposes, and it allows Sheets' data analysis & transformation capabilities to integrate with library data. However, data types & usage, though analogous & similar between the two, are nevertheless incompatible in various ways, causing the facility to be not useful for backup & restoration of data, except within some constraints. See [[Spec:Synchronization with Google Sheets|Synchronization with Google Sheets]] for details.
 +
 
 +
{{BeginNote}}
 +
''Unintegrated text below''
 +
{{EndNote}}
 +
 
 +
[[Importing and exporting data|'''''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 [[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''''']].
 +
 
 +
=== 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.
 +
 
 +
=== 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.
 +
 
 +
=== Programming languages ===
 +
In general, '''no knowledge of programming languages is required''' to use Memento.
 +
 
 +
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'''].
 +
 
 +
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.
 +
 
 +
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).
 +
 
 +
=== Essential features ===
 +
* Storing entries with custom [[Field|'''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, a set of cards, a table, on a map, or in a calendar
 +
* [[Synchronizing data|'''Synchronization with Google Sheets''']]
 +
* [[Cloud storage and Teamwork|'''Teamwork''''], by providing access to libraries to other users
 +
* 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 [[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, one-to-one, and many-to-many [[Link To Entry field|'''relationships between libraries''']]
 +
* [[Importing and exporting data|'''Importing and exporting CSV files''']], permitting interoperation with popular programs like Microsoft Excel
 +
* '''[[Data Sources|Populating database entries]]''' at the touch of a button with data from Web services and other sources
 +
* '''[[Library Protection]]''' (encrypt entries using AES-128)
 +
* [[Charts List screen|'''Charts''']] &mdash; Pie, Line, Bar, Columns, Area, Scatter, Stepped Area
 +
* [[Library|'''aggregation''']]): sum, maximum, minimum, average
 +
* Reminders
 +
* [[Backup & Restore|'''Backing up and restoring data''']]
 +
* Sending entries via SMS, e-mail, and other available services
 +
* [[Barcode field|'''Searching entries in libraries by barcode''']]
 +
* Online catalog of library templates -- thousands of templates available
 +
 
 +
== Find out more about Memento ==
 +
* The Memento [[User Interface|user interface]]
 +
* [[Glossary]]
 +
* [[FAQ]]
 +
* [[Products & Services]]
  
 
'''''<hr>2016<hr>'''''
 
'''''<hr>2016<hr>'''''

Latest revision as of 10:45, 16 September 2021

« Page as of 2021-09-15, editions Mobile 4.10.2, Desktop 1.10.2 »

Home
Wiki
About
Wiki | Memento
Getting started
Home | Memento
Indexes
Home Mobile | Desktop
Support
Wiki | Memento

2021


Introduction to the Memento Wiki

Memento Database consists of a set of database management apps & server software for mobile devices (Google Android devices & Apple iOS devices) -- called the Mobile edition -- and for personal computers and laptops (Microsoft Windows, Linux, Apple iOS) -- called the Desktop edition, referred to as the Memento Platforms.

Organization

A Memento database is organized into Libraries, Fields, & Entries, very similar to tables & rows in the relational database world. People often use more generic terms, like records for entries or rows. An aggregation of data related in addressing a subject area is usually called a database. A Memento Database would consist of a set of related (linked) libraries. The structure of a database can be represented in & exported to a Memento template file, or Template.

You can synchronize your data across all your devices, computers, & their operating systems -- all your platforms -- via a Memento Cloud service. While Memento's apps are available for free or for a one-time charge, cloud services are offered by subscription over time. There are several cloud subscriptions available for free or for a fee per individual, with fees providing greater capacity in storage space. For free, an individual is very constrained; the free services are useful mainly for evaluation purposes. For organizations, features supporting teams are available for a fee per user over time.

Within an account's cloud, synchronization is pretty seamless & complete. With common data types, synchronization is very tight. So, the cloud may readily be used for backup & restoration of data.

Unfortunately the term synchronization is also used by Memento in referring to its ability for a library to be synchronized with a sheet of a Google Sheets file on a user's Google Drive. This capability can be very useful for various purposes, and it allows Sheets' data analysis & transformation capabilities to integrate with library data. However, data types & usage, though analogous & similar between the two, are nevertheless incompatible in various ways, causing the facility to be not useful for backup & restoration of data, except within some constraints. See Synchronization with Google Sheets for details.


NOTE:

Unintegrated text below


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.

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.

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.

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

Essential features

Find out more about Memento


2016


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.

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.

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.

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

Essential features

Find out more about Memento