Table of Contents
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.
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
- 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 …
- Server-Side Cursor Advantage that are Read-Write