Reasons to use Valentina DB

• 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, …

• 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.

• 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.

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

• RecID as a Perfect Machine

• dbmodel_objectptr_vs_fk

• Table Methods

• Table Method vs SQL Hints

• Links between tables

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

• 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 …

• Server-Side Cursor Advantage that are Read-Write