Memento Database: Difference between revisions

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

Storing entries with custom fields
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, on a Kanban (task management) board, 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, geolocations with 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
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 — Pie, Line, Bar, Columns, Area, Scatter, Stepped Area
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

Introduction to the Memento Wiki

@@ Line 1: / Line 1: @@
+{{Stamp|2023-08-12|5.0|2.0}}
+{{BannerMenu}}
+{{PageTitle|The Memento Database application}}
-Memento Database is a highly flexible and customizable database management tool.<br />
+== Memento Database ==
-Created for anyone seeking to store various data on their Android devices, the software enables users to create custom libraries with unique sets of data fields, quickly add new entries and, finally, share entries with friends or colleagues, or export them to other systems with just a few taps.
+'''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 &mdash; [[Library|'''''libraries''''']] and associated files &mdash; 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.
-===Google Sheets===
+Data libraries may be linked, allowing any number of libraries to work together to form a database and provide a solution.
-Memento supports online synchronization via the Google Sheets application and allows you to edit your records on your PC.
-The app can also be used as mobile forms for Google Sheets.
-===Cloud===
+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''''']].
-All your data can be stored in the cloud. All your entries, photos and files will be synchronized automatically.
-You can provide access to your records for other users.
-===Personal use===
+=== Targeted users & use cases ===
-The program can be used literally by anyone: from cooking enthusiasts collecting recipes to field scientists on a mission. Lists of purchases or expenses, a collection of movies, tasks, fishing spots, your store inventory and pretty much anything else – all of this can be easily added to Memento Database and quickly found afterwards!
+Memento's goals include serving:
-Memento allows you to establish a connection between various kinds of records.
+:; the casual, perhaps single-library user
-For example, if you have a list of trips and a list of tourism equipment you can add any usable equipment to an entry on the trip list.
+::: 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
-===Business use===
+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.
-Your employees will be able to manage any business data through their phones and tablets.
-Common use cases for business: project management, customer relationship management (crm), inventory management, expenses and receipts, products management, sales management.
-===Online catalog===
+=== ''[[Platforms]]'' ===
-Our online catalog of library templates gives you an opportunity to familiarize yourself with a large number of ways to use 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 Edition''' operates off locally stored data that may or may not be synchronized to the Memento Cloud.
-The catalog currently contains over 3,000 library templates.
-===Desktop version===
+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.
-You can work with your data on Windows / Linux / Mac. Sync across desktop and mobile platforms is performed through Memento Cloud.
-== Main features ==
+=== Primary data structures ===
-* Storing entries with custom fields.
+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'''.
-* Sorting, grouping and filtering entries by any fields.
-* Memento can display your data in form of a list, table, on a map, and even in a calendar.
+=== Programming languages ===
-* Synchronization with Google Sheets.
+In general, '''no knowledge of programming languages is required''' to use Memento.
-* The multiuser environment.
-* Teamwork - you can provide access to your libraries to other users.
+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.
-* Access to your data from several android devices – you can work with the same library on your phone and tablet.
-* 19 types of fields:  – text, integer, boolean, date/time, rating, currency, image, signature, file, audio, contact, calculation, Google Maps coordinate and others.
+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.
-* Many-to-many relationship between entries.
-* Importing and exporting CSV-files / Excel.
+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).
-* Password protection (encrypt entries using AES-128).
-* Charts: Pie, Line, Bar, Columns, Area, Scatter, Stepped Area.
+=== Essential features ===
-* Mass calculations (aggregation):  sum, maximum, minimum, average.
+* Storing entries with custom [[Field|'''fields''']]
-* Reminders.
+* [[Slicing & Dicing|'''Performing Data analysis''']], including aggregation, charting, sorting, grouping, and filtering entries by any fields
-* Backing up and restoring data.
+* 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
-* Sending entries via SMS, e-mail, and other available services.
+* [[Synchronizing data|'''Synchronization with Google Sheets''']]
-* Search entries in database by barcode.
+* [[Cloud storage and Teamwork|'''Teamwork''']], by providing access to libraries to other users
-* Online catalog of library templates. Over 3000 templates available.
+* 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.
-* You can keeping track of everything.
+* 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 ==
-* [[User manual]]
+* The Memento [[User Interface|user interface]]
-* [[FAQ]]
+* [[Glossary]]
-* [[Tips]]
+* [[Products & Services]]
-* [[Memento tutorials]]
-* [[User-contributed articles]]
+<small>[[About:Memento Wiki|Introduction to the Memento Wiki]]</small>
+[[Category:en]] [[Category:About]]