Menu
The personal database had all but disappeared over the last 5-years. I found Ninox Database in my quest for the personal database and discovered it to be an extremely capable and constantly evolving rich rapid database development environment.
Try Azure File Storage for managed file shares that use standard SMB 3.0 protocol. Share data with on-premises and cloud servers, integrate with apps, and more. Ninox provides a highly customizable user interface which allows you to process, analyze and evaluate any kind of data. Furthermore you can integrate different services e.g. From Google with Ninox's API. Ninox works across all platforms and can be accessed through its native macOS, iOS, and Android App or via any web browser. Mongodump is a utility for creating a binary export of the contents of a database. Mongodump can export data from either mongod or mongos instances; i.e. Can export data from standalone, replica set, and sharded cluster deployments.
It is available for a wide range of platforms
- Native apps for Mac, iPad, iPhone
- Cloud version for any modern web browser
- Server edition, essentially allowing you to run your own cloud version
To call Ninox a simple personal database is an injustice, although it will do a perfectly capable job of those simple tasks like organising your object collection or keeping an inventory. For those tasks, key features like dropdowns for classification, embedding images (you can even shoot them from the iphone / ipad versions) and attaching documents are all well covered.
Powerful Relational Database
But Ninox goes much further than those simple needs, it is a fully fledged relational database system allowing 1-to-many and many-to-many relationships via a visual data model designer. This greatly aids design of database schemas and visualisation of relationships.
The relational model allows different tables of data to relate to and refer to each other.
The best thing of all is that as soon as tables are linked, all fields become programmatically available to exploit with the powerful scripting language.
Scripting Language – The killer feature
Undoubtedly the thing that sets a database environment apart from being a consumer level hobbyist product is a good scripting language. Ninox uses its own Javascript like NX language to allow extremely powerful data manipulation and some basic front end user interface controlling tasks.
All of the difficult tasks are dealt with by the language’s powerful variable handling and type conversion. Date calculations are a breeze and strings can be manipulated and mutated easily.
It’s true to say that the NX language is a work in progress, with new command sets available in every release but it is already very powerful.
NX language also forms the basis for powerful view filters for changing representations of your data.
- Ninox NX scripting language
Views and Data Presentation States
Ninox allows presentation of data in 2 main ways right now as either tabular data (like a spreadsheet) or in graphical representations with some basic graph types.
It now also allows inline editing like a spreadsheet without having to rely on the popover forms to edit records. This is a feature which will be welcomed by power users and those who wish to copy and paste data into a spreadsheet for more powerful data analysis, statistical and charting solutions.
- Line graph view of data
Forms for data entry
Let’s face it designing forms can be a total pain in the ass, even the best databases out there struggle with front end form design.
This is probably Ninox’s greatest asset. Photosweeper 2 2 4 download free. Farming simulator 17 for mac download. Form design is a drag and drop joy and the forms it produces look great and are very usable.
If this visual approach is too tedious, it is also possible to carry out the form design task in a more traditional way by selecting and data-schematising all of the fields on a single screen first before then adjusting the look of the auto-generated form.
Events and triggers
Notice in the table design view above that there are events at table level to run a script (NX language) on creation of a record and after update.
These same options are also available at field level but sadly not yet at database level.
These are powerful features allowing the triggering of script events based on user actions. That said, one cannot help but feel that this part of the software is not yet what it could be and database level events as well as chron-type timer driven events would be welcomed.
![System System](https://is2-ssl.mzstatic.com/image/thumb/PurpleSource124/v4/dc/f4/34/dcf43480-cf2e-25c5-2b30-22ad6db4767d/158729e8-2ada-431c-8a40-b168aeed8bbd_iMac-en-4.png/643x0w.png)
Work in Progress: Room for improvement
Ninox is an actively developed closed source project, but has a small but active community working with the team (in Berlin) on Beta testing and feature development.
Frank and Alexander at Ninox have promised a forum in the near future to create a more active support community and discuss scripting issues and solutions etc. Right now they offer email support and are very responsive but a forum would be much more efficient as I’m sure they must get asked the same things over and over.
Wish List
Ninox Database 2 3 0 – Flat File Database Systems
- An API (JSON please) to integrate Ninox with other applications / server driven events
- Better Calendar integration
- An online sync option that is not iCloud
- More UI improvements and options to configure the look (CSS please!)
- Ability to package a database application and deliver / market it as a standalone application (I know… pipe dream!)