Valentina Release 17.3.1 adds AVX2 Vectorization, Data Transfers, ODBC and Korean

Extras
1

Paradigma Software announces Valentina Release 17.3.1, including improvements Valentina Studio and all ValentinaDB products (such as ValentinaDB ADK for Xojo, Valentina Server, VDN, etc). Don’t miss out on free Valentina Studio and free Valentina Server!

Download: Studio | Server

Highlights include:

  • More Massive ValentinaDB Optimization! Implemented AVX2 vectorization, mostly for NON-INDEXED SEARCH AND SORTING
  • DuckDB Support Updated. Now updated for DuckDB 1.5.2. Core improvements with a better library.
  • Data Transfer & ODBC. Lots of fixes, especially when pulling data from Microsoft Access.
  • Localization for Korean. Yes, finally! Easily switch between different languages. Plus some fixes for the Italian localization.

Other improvements include numerous fixes, some stuff outside of the Xojo ecosystem.

Click one of the links below to find the full announcement and feature set! Standard announcement is here.

[BLOG] | [FORUM] | [EN] | [DE] | [ES] | [FR] | [JP] | [PL] | [RU] | [IT] | [KR]

If you got Omegabundle for Xojo 2025 during the summer, this is a free update!

About Our Products
Valentina Studio is Paradigma Software’s powerful database management software. The PRO version also includes the design tool for designing reports used by Valentina Reports for Xojo (for embedding a powerful reports engine in your Xojo app). The base version of Valentina Studio is free and available on macOS, Windows & Linux. Competitive upgrades available from products like Navicat, Datagrip and others.

ValentinaDB is Paradigma Software advanced, object relational database and available in Valentina DB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications), including Valentina Database ADK for Xojo. Valentina Database ADK for Xojo includes support for SQLite (with SQLCipher support), DuckDB and ValentinaDB.

Valentina Reports is a powerful reporting design and deployment system. With Valentina Reports ADK for Xojo, you can embed Valentina Reports in your Xojo apps.

Valentina Server incorporates Valentina Reports Server, Valentina Forms Server and three database servers: ValentinaDB Server, Valentina DuckDB Server and Valentina SQLite Server. Available for Windows, Linux (x86, ARM64), macOS and Raspberry PI. VDN is also available that lets you include OEM copies of Valentina Server with your solution at no added cost (on all supported operating systems). Turn your single user app into a true client-server or server only solution.

3 Likes
2

How about something like FTS or even vector embeddings for text? Is that still on the to-do list? I still use an SQLite FTS in addition to Valentina. And these days vector embeddings are important for AI.

1 Like
3

Hi Trixi, yes I remember you waiting for FTS. Wow, you consider vector embeddings? Going to integrate with AI models? Vectors are produced by models … This can be nice task.

4

@Ruslan_Zasukhin

I had asked Christian from Monkeybread Software to add functions for embeddings to the MBS plugin. Currently, I use an extension for DuckDB but I recently found some alternatives for SQLite. I’m still missing the functions to recognise the language.

For emails the FTS usually is enough. My new app, however, archives messages. I found searching the shorter texts quite different. The vector data should improve that but I’m still in early stage.

5

I wonder if you using DuckDB which is now inside of our Valentina for Xojo ADK?

I have take a look on “vector embeddings“. In ideal this task requires from us

  • new field type
  • new index type
  • couple functions, which work on that index
  • using SIMD again.

Just BLOBs + functions seems to be weak solution, will require just scanning.

6

@Ruslan_Zasukhin : Yup.

1 Like
7

Nice.

So you was able to add an extension to DuckDB, and It works for you.
You did try only on dev machine or you did deploy also already?

which exactly extension you use?
which functions? names

8

Here is my current code but it’s barely at prototype stage:

embedding.zip (7.2 KB)

You need macOS with AppleIntelligence installed and the latest version of the MBS plugins. The VSS extension is downloaded when you load it the first time and then you can use it from the downloaded location (user home → .duckdb).

9

thank you.

well, I need just name of duck ext and funcs you using from it
to take a look on them

ok, we can discuss this later )

1 Like