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.
目录
1 Targeted users & use cases
2 Platforms
3 Primary data structures
4 Programming languages
5 Essential features
6 Find out more about Memento
<br>
## 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.
<br>
## 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 Edit
ion 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.
<br>
## 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.
<br>
## 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).
<br>
## 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, or in a calendar
Synchronization with Google Sheets
[[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.
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
</body>
- 前言简介
- 技巧经验
- 实现自动序列号
- 使用工具来转换成csv文件
- 如何制作和导出模板组合
- 实例资源
- js字段实例
- 根据身份证取出生日期、性别、年龄
- 自动标记状态,到期自动标记过期,可屏蔽过期以及聚合计算显示
- 根据出生日期计算年龄
- 人民币小写数字金额转大写
- 倒计时天数,实现倒计时纪念日等功能显示
- 取指定时间是周几的4种方法
- 自动填写年份、月份
- 只显示计算公式而不显示计算结果的办法
- 根据多个已选的员工人数,计算总工资
- 计算显示每年、每月的总工资实例
- 实现完全性的跨库计算自定义公式
- 触发器实例
- 新建或编辑条目后,更改条目内容
- 计算字段范例
- 计算星期几实例(3.8.5版本及以上)
- 计算星期几实例(3.8.5版本以下)
- 计算第几周
- 实现单条数据的百分比形式(并且控制小数点为2位)
- 自动填充实例
- js套用方法外壳,实现网站数据源自动录入内容
- js代码实例
- 动作实例
- 实例将网络数据写入库中
- js函数运用实例
- 创建一个新的条目记录
- 查询库内容
- 数据源实例
- Js套用方法外壳,实现网站数据源自动录入内容
- 其它实例
- 字符串值的控制
- 资料知识
- 表格与ME库关系
- ME库电子日历使用一帖通
- ME库CSV应用一帖通
- 新手入门
- 新手入门教程
- 常见问题集合
- 官方资料(中文版)
- 计算字段
- JavaScript字段
- 链接到条目字段
- 脚本
- 纪念品JavaScript库
- 动作
- 数据源
- 触发器
- 触发器示例
- 旧档
- 计算字段命令,FUNCTION功能
- JavaScript的字段
- javascript常用函数及功能
- 前言介绍
- 经验技巧
- 官方资料(英文版)
- Memento Database
- Glossary
- Memento Wiki
- Useful links
- Releases
- User Interface
- Tutorial:Simple To Do List
- Tutorial:Simple To Do List Enhancements
- Libraries & templates
- Library
- Library Template
- Library Edit screen
- Library Groups
- How:Add a Library
- Libraries List screen
- Fields, pages, & subheaders
- Overviews
- Field
- Field Edit card
- Field Role
- Field Type
- Page
- Specs
- Techniques, Tips, How
- Tips:Using JavaScript in Memento
- How:Field Dependencies
- 关于附件
- 交流互助
- 贡献人员