Featured Products
Omegabundle for Xojo 2018 Products

Valentina Server combines a world class Enterprise Reports Server and two Database Servers into a single, powerful solution.

 Valentina Server Features & What's New in Valentina Server 8

Since Valentina Server incorporates three different servers, including Valentina Reports Server, ValentinaDB Server and Valentina SQLite Server, and also now serves Valentina Forms, each Paradigma technology automatically inherits all the newest improvements in each.

When you order Omegabundle for Xojo 2018, you need to select a single OS platform for your copy of Valentina Server. Please note that Raspberry Pi support is only available if you select the Linux version of Valentina Server.

Four Powerful Server Technologies

  • Enterprise Reports Server turns data into highly formatted reports with options for charts, barcodes, graphs and more into rich media web pages, text, images, PDFs
  • ValentinaDB Database Server based on ultra-fast, object-relational columnar technology, including Valentina DB KeyValue database *
  • Valentina SQLite Database Server with full multi-access, industry standard server features
  • [NEW] Serve Valentina Forms to users of Valentina Studio (Standard or PRO)

Server Administration

  • Add/drop users, groups, manage privileges
  • Watch live logs, run diagnostics
  • Remotely Register/unregister databases
  • Remotely Register/unregister Valentina Projects
  • Create/Alter/View Schedule Events
  • Highly secure with SSL and powerful, built in encryption
  • Administer your databases with free Valentina Studio

Integration

  • 30+ Native Drivers for Client Application Access
  • REST based access opens integration to most mobile platforms; also works with Xojo Web Edition
  • Report Server integrates with MySQL, MariaDB, MS SQL Server, SQLite (Valentina SQLite Server), ValentinaDB (ValentinaDB ADK, ValentinaDB Database Server, PostgreSQL
  • 32 / 64 bit natively on Windows, Linux and macOS, Raspberry Pi (Debian, ARM 7)
  • [NEW] "papersource" options for printing reports to attached printer

Commercial Support & Updates

  • 12 full months of technology upgrades from your data of purchase
  • Direct, next business day support, with more advanced support options available

Utilities & Examples

  • Diagnose, compress, clone, defragment, reindex and dump data
  • [NEW] Updated Python Examples

Capacity & Deployment

  • Single deployment, commercial license
  • Update before the end of your update period at a discounted rate

 

Are You Hardcore on ValentinaDB?

Since October 2017, ValentinaDB - including ValentinaDB ADK For Xojo and ValentinaDB Server (a part of Valentina Server) has gained these two new features and improvements, including the speed optimizations you expect in this ultra-fast, object-relational modern database.

  • [New] - “LINK RECORD(LAST) OF T1 WITH RECORD(LAST) OF T2”, you can now use the LAST keyword to specify the last_recid_of_table(“T”)
  • [NEW] - ARRAY field type according to SQL 2003 standard: a single dimension, fixed size, plus over 20 support functions for working with them
  • [Imp] - SELECT...FOR XML, SELECT...FOR JSON and REST now support VARIANT field type.
  • [Imp] - SHOW VIDENTS returns names of KeyValue objects
  • [Imp] - TRUNCATE TABLE now works for a Table with Links if all Links are empty
  • [Imp] - Exceptions about date/time now shows the current DateTime format and separators, so a developer can easily understand what to change.
  • [Imp] - Building of IndexByWords for Text/VarChar now x 4 to x 40 times faster - 2 GB of TEXT data indexed in 100 seconds (on MacBook 2016)
  • [Imp] - LIKE/ILIKE uses IndexByWords even for CONTAINS search of kind '%str%' if between %% present only one word, i.e. no word-delimiters, making these searches up to x 250 times faster - 1GB TEXT field with 50K records returns search in 0.016 milliseconds instead of 5 seconds
  • [Imp][SQL] - MERGE command now works with VIEW