Version | Change log |
Valentina Studio 16.1 Oct 16, 2025 |
Valentina DB: [New][SQL] Linear Regression Aggregation Functions according to SQL:2003: 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][SQL] Few aggregate functions renamed to have “_agg” suffix. Old Names still can be used. group_concat ??' concat_agg bit_and ??' bit_and_agg bit_or ??' bit_or_agg bit_xor ??' bit_xor_agg [Imp][SQL] All built-in and external aggregation functions now can be used in the WINDOW clause of the SELECT statement. Valentina Studio: [New] Added Spanish and Polish interface translations. [New] Added translations of helpful tips for all available interface languages: English, German, Polish, Russian, Spanish, Ukrainian. [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 15.4.1 Jul 25, 2025 |
Valentina DB ADK: [New] Added the “AppName” property to the VClientInfo class. You can use this with Valentina Server to identify the application name in the server logs. Valentina DB: [Fix]9538 - Indexed word searches were not functioning correctly. [New] Added standard SQL aggregate functions: VAR_POP(), VAR_SAMP() COVAR_POP(), COVAR_SAMP() [Chg] Renamed STDDEV() function to STDDEV_SAMP() for consistency with the SQL standard. Valentina Server: [New]9536 - Introduced support for setting an “application name” for client connections, visible in the server's connection list and logs. [SQL]: SHOW CONNECTIONS – new column fld_AppName [SQL]: GET PROPERTY Connection_AppName OF CONNECTION Valentina Studio: [New][Start Page] - Progress bar is now displayed during the first Bonjour connection scan (in the Bonjour column). [New][Start Page] - Added buttons to toggle filters in the Start Page columns. [New][Data Editor] - Added connection icon to the toolbar. [New][Data Editor] - A yellow warning icon is now shown at the bottom of the editor, with a tooltip if the table has no primary key or unique field. This feature is also available in the “Create Table” dialog. [Fix][Diagrams] Fixed the creation of new links on diagrams. [Fix][Diagrams] Enabled auto-growing of the table control when adding fields. [Fix]9357 - “Infinity” date was not working correctly in the PostgreSQL Data Editor. [Fix]9537 - ENUM values were not displaying as a dropdown. [Fix][Tip] - Tip dialog continued to appear even after unchecking “[x] Show on startup”. |
Valentina Studio 15.4.0 Jun 29, 2025 |
Valentina DB ADK: [New] Added the “AppName” property to the VClientInfo class. You can use this with Valentina Server to identify the application name in the server logs. Valentina DB: [Fix]9538 - Indexed word searches were not functioning correctly. [New] Added standard SQL aggregate functions: VAR_POP(), VAR_SAMP() COVAR_POP(), COVAR_SAMP() [Chg] Renamed STDDEV() function to STDDEV_SAMP() for consistency with the SQL standard. Valentina Server: [New]9536 - Introduced support for setting an “application name” for client connections, visible in the server's connection list and logs. [SQL]: SHOW CONNECTIONS – new column fld_AppName [SQL]: GET PROPERTY Connection_AppName OF CONNECTION Valentina Studio: [New][Start Page] - Progress bar is now displayed during the first Bonjour connection scan (in the Bonjour column). [New][Start Page] - Added buttons to toggle filters in the Start Page columns. [New][Data Editor] - Added connection icon to the toolbar. [New][Data Editor] - A yellow warning icon is now shown at the bottom of the editor, with a tooltip if the table has no primary key or unique field. This feature is also available in the “Create Table” dialog. [Fix][Diagrams] Fixed the creation of new links on diagrams. [Fix][Diagrams] Enabled auto-growing of the table control when adding fields. [Fix]9357 - “Infinity” date was not working correctly in the PostgreSQL Data Editor. [Fix]9537 - ENUM values were not displaying as a dropdown. [Fix][Tip] - Tip dialog continued to appear even after unchecking “[x] Show on startup”. |
Total downloads
57
Last month's downloads
1
Last week's downloads
1
... explore and edit your databases with ease - Valentina Studio for Windows! This software developed by Paradigma Software, Inc. offers ... including PostgreSQL, MySQL, MS SQL Server, SQLite and Valentina DB. Valentina Studio empowers you to showcase your database content using ... The application is designed to run flawlessly on Windows and the user-friendly interface ensures that you get ...
... is proud to introduce our latest featured software: Valentina Reports Server for Windows by Paradigma Software, Inc. As one of the ... comprehensive solutions for reporting and business intelligence needs, Valentina Reports Server is an ideal software choice for enterprises of any size. With powerful report engines, Valentina Reports Server is able to handle large volumes ...