DuckDB 1.4.1 and PostgreSQL 18 support; New Translations in Studio
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).
- [New][SQL] Aggregation Functions – regr_avgx, regr_avgy, regr_count, regr_sxx, regr_sxy, regr_syy, regr_slope, regr_intercept, regr_r2:
- regr_avgx – Returns the average of the independent variable (x)
- regr_avgy – Returns the average of the dependent variable (y)
- regr_count – Returns the number of non-NULL pairs of (x, y) used in the regression
- regr_sxx – Returns the sum of squares of the independent variable (Σ(x − avg(x))²)
- regr_sxy – Returns the sum of cross-products (Σ(x − avg(x))·(y − avg(y)))
- regr_syy – Returns the sum of squares of the dependent variable (Σ(y − avg(y))²)
- regr_slope – Returns the slope of the least-squares regression line (y = a·x + b)
- regr_intercept – Returns the intercept of the regression line with the Y-axis (b in y = a·x + b)
- regr_r2 – Returns the coefficient of determination (R²), measuring the fit of the regression line
- [Chg] Some previously added functions were renamed:
- concat_agg instead of group_concat (group_concat is still an alias)
- bit_and_agg instead of bit_and (bit_and is still a scalar sql-function)
- bit_or_agg instead of bit_or (bit_or is still a scalar sql-function)
- bit_xor_agg instead of bit_xor (bit_xor is still a scalar sql-function)
- [Imp][SQL] All aggregation functions may work in a Window function context
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] Added Spanish and Polish interface translations
- [New] Added translations of helpful tips for all available interface languages
- [Imp] Updated DuckDB engine to version 1.4.1
- [Imp] Updated PostgreSQL client libraries and dump utilities to version 18.0
- [Fix] Fixed sorting by column header click in tree mode
- [Fix] Preserved original field order as returned by the server when updating the fields list
Valentina Studio for Windows, macOS and Linux is licensed but free. Valentina Studio Pro is $199 per OS license and includes 12 months of free updates. Valentina Studio Universal is a single license that works on all three operating systems and licensed on a user basis.
This release is immediately available on the Paradigma Software website. See the original announcement on the Paradigma Software forum.