Do you need to store and manage your data, catalogs of books, CDs or lists of customers – but find a spreadsheet too clumsy, an SQL database too complicated and that somehow special-purpose applications never do exactly what you want? We have given it some thought…

Tiny and handy database

Do you ever wish you could put another table within a table cell (for example, a list of orders attached to every individual customer in a customer database)? Or group a film catalog according to the year the movie was released? Or filter a list according to advanced criteria? Or attach data from one table to another? Add a computed column? And wouldn't you find it more convenient to write something like price*VAT instead of C7*$F$12? And store a view of your data created this way with one mouse click so that it would be at hand next time? And wouldn’t it be great if just to put everything together with a word processor, just to have a text template created for you or simply to be able to copy a table easily to a word processor?

With people in mind

When we were designing Sfairadora, we didn't try to make a program that will amaze you by doing millions of transactions per second. Instead our aim was to design one that allows you to do whatever you require more easily with a smaller amount of data. Start with a simple table and as your needs change and grow, Sfairadora will grow with you.

What may be simple for everyone can also save time for the more experienced. Perhaps you are an expert and might be curious as to how easily you can create a user interface when you consider it a program with its run extended in space rather than in time or how adeptly we have solved error handling in scripts. A design, which is based on elegant ideas, makes application easy for everyone to use while imposing no limits on experts.

Read more in User's Guide, or just try it out.

Awards

Editor's Pick Award Editor's Pick Award5 Stars Award5 Stars Seal of Quality

Key Features of Sfairadora

  • Intuitive data model:
    • Tables nested in a table. More…
    • Ordered and filtered data – intuitive definition of filter conditions. More…
    • Tables can be grouped and regrouped with ease. More…
    • Transparent syntax of expressions for computed items (unlike in spreadsheets, you can simply write, for example, price * count instead of E10*F11) More…
    • Straightforward copying and reorganization of data. More…
    • Easy modification of data structure while preserving existing data. More…
    • User-friendly saving data views which are then continuously updated. More…
    • Current state can be saved as a view with a single move of the mouse. More…
    • Import and export of data possible both from/to relational databases, Excel and plain text files. More…
  • Interaction of data and text:
    • Creation of text output from data by mouse drag-and-drop. More…
    • Built-in text editor editing formatted text. More…
    • Loading and saving texts in the RTF format.
  • Well-arranged presentation of data:
    • Display adjusted to contents so that you see all you need in a clear layout.
    • Transparent error diagnostics.
    • Automatically created presentations can be modified as required. More…
    • Functions for the creation of pictures. More…

For Experts

The following features allow you to use Sfairadora for the quick development of simple applications:

  • R-D/C presentation model:
    • Easy creation of presentations at any level of complexity.
    • Concept of 'presentation as a program'.
    • All properties can be specified by an expression and automatically updated.
    • More…
  • Enki programming language:
    • A single language for simple expressions as well as complex programs so that the sophistication of your solution can increase according to your needs.
    • Handling of errors using the concept of non-strict value.
    • Easy syntax of data search and aggregation.
    • Functions for the manipulation with pictures and formatted texts.
    • More…
  • Enkidu language templates:
    • Easy creation of formatted text outputs.
    • The initial version of the template can be created automatically according to the data structure.
    • More…
  • All properties of a document (data type, presentation definition, etc) can be referenced by programs through the definition objects. More…
  • You can create your own tools and file manipulators. More…