Also ODBC for macOS, DuckDB Server parameters, SIMD optimizations and more.
Valentina Studio
Valentina Studio is the free, all purpose database management tool suite. Valentina Studio PRO adds more powerful diagramming features, more powerful visual builder tools for databases, forms creation, reports designer and more. Improvements include:
- [New][Parquet] Works with local directories containing multiple Parquet files
- [New][Parquet] Added the Show Metadata action to the Parquet Table context menu. Display metadata without using a SQL command.
- [New][Parquet] Added Show On Disk and Copy Path actions to the Parquet Table context menu.
- Path you may need for use in some SQL commands, e.g. parquet_metadata().
- [Imp][SQL Editor] Execute queries that join data from different Parquet files
- [Imp] [Data Editor] Easily switch between Parquet files that belong to the same data set
- [Imp][AI Chat] Refresh the list of available models from provider without requiring a new install of Valentina Studio
Valentina Server
Valentina Server is a powerful platform for building network or cloud based client-server or server-only solutions that integrates with 30+ developer platforms. Valentina Server includes three built in database servers: ValentinaDB Server, Valentina SQLite Server and Valentina DuckDB Server. With support for both internal data sources as well as external data sources (including MySQL, MariaDB, PostgreSQL, MS SQL Server, MongoDB and more), it also includes two other servers that can leverage all supported data sources: Valentina Reports Server and Valentina Forms Server.
- [New] [DuckDB Server] DuckDB INI-parameters: DuckDBRWMode, DuckDBThreads, DuckDBMemoryLimit, DuckDBTempDirectory, DuckDBEnableExternalAccess
- [New] [SQLite Server] SQLite INI-parameters: SqliteJournalMode, SqliteSynchronous, SqliteCacheSize, SqliteBusyTimeout, SqliteMmapSize
- [New] [ODBC] [macOS] You can use the new ODBC driver for macOS in the Valentina Database ADK for ODBC (macOS) to connect to DuckDB Server, SQLite Server and ValentinaDB Server at no additional cost.
ValentinaDB
ValentinaDB is Paradigma Software advanced, object relational database and available in ValentinaDB Server (a part of Valentina Server) and ValentinaDB ADKs (developer components for adding runtime database support to applications).
- [Opt] [SIMD] Calculation of some Aggregative functions improved by SIMD operations: COUNT, SUM, MIN/MAX, StdDev_Samp
Valentina Database ADK for ODBC
ODBC connectivity remains a standard. Valentina Database ADK includes Paradigma Software’s ODBC driver(s), including free VClient like access to Valentina Server native database servers: Valentina DuckDB Server, Valentina SQLite Server and ValentinaDB Server.
- [New] [macOS] Native, macOS drivers for support for DuckDB, SQLite and ValentinaDB.
Windows drivers shipped in Valentina Release 17.4.
This release is immediately available on the Paradigma Software website. See the original announcement on the Paradigma Software forum.