NestaDB for iPad


What is NestaDB ?

NestaDB is a card type database software.
The simple and powefull database software for iPad.

Address book, list of collections and personal data such as customer management, sales management and other business data to organize the various data available for searching.

Has been designed for use with easy operation.
You can create your own database of many.

This software provides an interface 'Query by Example' for searches. This allows you to quickly access data you want.

NestaDB is a FREE application.
This is not SQL database.

Features

  • Data entry using a form effectively.
  • CSV file import functionality via HTTP server.
  • Database can be sent email in a CSV file.
  • Supported by the data search functionality to narrow down.
  • Database fields can freely layout.
  • Field types are Text, Number, Date, Multiline-Text and Photo are available.
  • Scripting language is provided for manipulating the database.
  • Script is using the Lua programming language.

Getting Started


Create a database

Enter the database name to create.
The database name can be up to 60 characters.


Delete a database

Tap the Edit button or Swipe the database.
The database will be removed by tapping the Delete button.
Please note that this operation can not be undone.


Fields layout

Adding a field or layout changes can be done by tapping the tab layout.
You can change the layout are done entering the data.

You can make a query in to turn on the Index key.


Trigger

Trigger can be specified Lua script to be executed when the data is updated.

Trigger type is as follows.

  • When a new entity is added.
  • When the entity has been updated.
  • Before an entity is deleted.
  • When the entity has been deleted.
  • When the value of field is updated.

NestaDB Trigger Tutorial is here.

Query

Set search conditions using the data that is entered.
This setting results are reflected in the List and Form.

Field becomes logical AND condition, another condition is logical OR page.


Form of data

If you add new data, tap the + icon.
Popover will appear for input by tapping the cells you want to enter data.


List of data

The data displayed in a list format.

Pop over for the input will be displayed by long-press the target cell.
Sort (ascending / descending) can be selected by tapping the title field.


CSV import and export


CSV import via HTTP Server

NestaDB has been implemented by the HTTP server to import the CSV file.
To use the CSV import must be connected to Wi-Fi.
Upload a file from another computer browser to access the URL.


Scripting language

NestaDB scripting language is provided for manipulating the database.
Script is using the Lua programming language.

NestaDB Script Tutorial is here.


Database Backup and Restore

To create a backup of the current database.
Can run as many times as the backup.

To replace the current database restore.

Database backup is done in iTunes.
Sharing documents from the App menu, copy the three files below.

  • nestadb.hdb
  • nestadb.bdb
  • nestadb.fdb

Backup files are stored in the following file name.

  • ndb-backup_YYYY-MM-DD_HHMMSS.zip


Author: YAMAMOTO Naoki
Create date: 2012/01/29
Last modified: 2013/04/20