Switch to: V9V8V7V6V5

Reasons to use Valentina DB

This is NOT a complete Feature List, which can be found HERE.
This is NOT a strict documentation.
This is a collection of good reasons, written in free style, which can help developers to see the Valentina advantages.

Marketing Advantages

Works Everywhere

  • Works on 3 desktop OS: Linux, Mac OS, Windows.
  • You can choose Application Developer Kit (ADK) for a lots of languages and IDEs: C, C++, Obj-C, .NET (C#, VB.NET, …), COM (VB6, …) PHP, Ruby, Xojo, Director, LiveCode, …

Cost Effective

  • Royalty FREE deployment. You can develop any number of applications and deploy any number of their copies with embedded db engine.
  • 1 year of free upgrades after purchase.

Unified Usage of LOCAL DB and SERVER

  • Valentina Database is the only database (as well as we know), which provides both:
    • LOCAL single-user database engine, embeddable into your applications.
    • SERVER multi-user access to the same Valentina DB files. Can be connected from applications linked with VCLIENT library.
  • Many times we have hear that a developer wants to develop application, which can work with some local database and with a multi-user SERVER.
    • For example, you can choose SQLite and mySQL/PostgreSQL. It is obvious that you get problems because these databases have different set of features and SQL commands.
    • But if you choose Valentina, you can use same commands and same SQL for both LOCAL and SERVER databases. Only few lines of code will differ when you open/connect to a database.

Valentina Database Model

This sections collects reasons that provide advantage thanks to Valentina Database Model features.

RecID as IDEAL Machine

ObjectPtr as IDEAL Machine

Table Methods

Links

  • Links between tables
  • BinaryLink as IDEAL M:M link of 2 tables.

Valentina SQL Extensions

  • Get/Set Properties of Database Schema Objects
  • Optional join-condition
  • Operator →
  • Recursion commands
  • Stored Procedures
  • ENUM type, which is more smart and useful
  • Link Commands
  • Link Refactoring Commands
  • SELECT … FOR XML
  • SELECT … FOR JSON
  • SELECT … FOR REPORT
  • REPORT … FROM …