Valentina Database ADK lets you bundle or embed ValentinaDB, DuckDB & SQLite database systems with your application.

What's Included in Valentina Database ADK for Xojo

• Local storage database engine. Your app can use all three databases as local data stores.
• Free VCLIENT component can communicate with Valentina Server
• Unlimited, royalty free deployment for all your applications built with Xojo on all  three desktop platforms: Windows, Linux and macOS
• 12 months of free updates are included with your license

You can easily move your project up to Valentina Server or build powerful network solutions with both local and server based storage

What are Valentina ADKs?

Valentina ADKs are a bundle of components that include shared libraries, the Valentina Client (VCLIENT) and a Local Runtime. One is specifically for providing local data stores for your applications, and the other is for adding a complete reporting engine to your applications.

You need a copy of Valentina Studio PRO to save reports built with Report Designer or save forms built with Forms Designer. Included in Omegabundle for Xojo 2026!

How Valentina ADKs Work

Valentina ADKs are a bundle of components that include shared libraries, the Valentina Client (VCLIENT) and a Local Runtime. The VCLIENT portion is free but licensed as a part of each Valentina Database ADK for Xojo, Valentina Reports ADK for Xojo and Valentina Server. The local runtime engine component is the commercial portion of the Valentina ADK for working with local storage and files. Because of this, any developer that licenses the applicable ADK or Valentina Server can use any VCLIENT with Valentina Server.

How to choose the right database for your Xojo project?

Valentina Database ADK for Xojo supports three different databases: ValentinaDB, SQLite and DuckDB. You can use all three, but what are the strengths of each?

 Why Choose ValentinaDB?

Deliver a solution that dramatically enhances the value to your application. ValentinaDB can do it.  After you port to ValentinaDB, you can step by step, optimize the Valentina way. The more you optimize using the higher level native Valentina API, your code becomes easier to read and easier to maintain. ValentinaDB also delivers blazing speed in working with millions of records. What can take you hours with other local database solutions, ValentinaDB can deliver in minutes, if not seconds! Imagine building custom apps that can deliver complex data scenarios during the course of a meeting, rather than having to resort to "Sorry, I'll have to send you that later today."

• The Database Model You Want.: Advanced object-relational data model, stick with SQL, or mix them; disk based, and temporary fast in-memory databases; encryption and more
• Ultra-fast query execution: ValentinaDB is designed for high performance, especially with complex queries,  which can lead to significantly faster results compared to traditional database platforms
• Advanced Cache System: ValentinaDB utilizes an advanced cache system to further enhance performance
• Always Getting Faster Indexing:Indexes on string/varchar and other fields are iteratively faster with over two decades of improvements
• Valentina Abstraction Links: Allows for efficient handling of hierarchical data and improved recursive queries
• Special Binary Data Handling: Valentina provides three types for binary data: FixedBinary, VarBinary, and BLOBs. BLOBs can be compressed to save significant space
• Fast Pointer Types: ObjectPtr types, stemming from the network model, offer faster join performance and use less disk space than traditional foreign key links
• Built-in Unique IDs: Every Valentina table includes a RecID field for automatic unique identification within table scope, and OID field for database-wide unique IDs (aligned with the ODMG standard). These fields use zero disk space
• Key-Value Objects Options: Valentina DB allows the creation and storage of Key-Value data stores within the database, integrated into the model
• Built in diagnostics. Supports warning and database tuning logging so you can optimize performance
• Extensibility: You can extend ValentinaDB with new features like data types and functions

Why Choose DuckDB?

DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, and open source. The DuckDB engine is built right into Valentina Database ADK for Xojo. With DuckDB, you get:

• DuckDB is built for Online Analytical Processing (OLAP)
• Rich SQL Support: DuckDB supports a comprehensive SQL dialect, including various features like window functions and joins
• Columnar Storage: Its columnar architecture optimizes for analytical tasks through better compression and vectorized operations
• Vectorized Execution: DuckDB processes data in batches to improve query performance
• Data Format Compatibility: DuckDB can interact with popular file formats like CSV, Parquet, and JSON
• Extensibility: You can extend DuckDB with new features like data types and functions

Why Choose SQLite?

SQLite is a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite support is built right into Valentina Database ADK for Xojo. With SQLite, you get:

• Transactional Support: ACID (Atomicity, Consistency, Isolation, Durability) compliance
• Widely Used: Many apps use SQLite as their on-disk file format for storing and managing application data, configuration settings, or user-specific information
• File Based: As a file based database, SQLite files are easily portable
• Just Enough: If your data store isn't going to grow much, SQLite enough
• Public Domain: Anyone can get the source code, and it is updated regularly
• Extensibility: You can extend SQLite with new features like data types and functions

What's New in Valentina Since Omegabundle for Xojo 2025?