Notes: For a full list of changes go here. Upgrade from MySQL 5.7 to MySQL 8.0 is only supported using the in-place upgrade method. Downgrade from MySQL 8.0 to MySQL 5.7 (or from a MySQL 8.0 release to a previous MySQL 8.0 release) is not supported. The only supported alternative is to restore a backup taken before upgrading.
Bugs Fixed:
Connecting to MS SQL Server from macOS / Mac OS X. Prior to connecting to an MS SQL Server instance from a Mac machine, there are some configuration settings that need to enabled on the SQL Server database. Build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in—from in-memory performance and advanced security to in-database analytics. Protect data at rest and in motion. SQL Server is the least vulnerable database for six years running.
- NDB Cluster: EXPLAIN of a query executed with table access type eq_ref could also show a condition being pushed down, even when condition pushdown was not supported for the query. Now the access type is checked before NDB checks the condition for a possible pushdown optimization.
- This fix does not affect handling of tables which are part of a pushed join, for which NDB continues to support pushed conditions as before.
- InnoDB: Undo tablespaces remained unencrypted after enabling undo tablespace encryption at startup.
- InnoDB: Problematic macros introduced with undo tablespace DDL support in MySQL 8.0.14 were revised.
- InnoDB: Static thread local variables defined at the wrong scope were not released at thread exit.
- InnoDB: The performance_schema.data_locks LOCK_DATA column only showed the secondary index values of the locked record for a lock placed on a unique secondary index, which was not sufficient to ensure the uniqueness of identified records. The clustered index column values of the locked record are now appended.
- InnoDB: An incorrect count of transactions using a rollback segment for recovery of an XA transaction prevented an undo tablespace truncation operation from proceeding and left the purge thread busy checking for the undo tablespace to become empty.
- InnoDB: Invalid assertions were raised at startup after a failure to retrieve the space ID of a compressed file-per-table tablespace. The invalid assertion code was removed.
- InnoDB: Optimized InnoDB internal temporary tables did not support in-place UPDATE operations, which caused the number of delete-marked records to increase continuously. The large number of delete-marked records could cause longer than expected query execution times.
- InnoDB: The std::sort function in the Variance-Aware Transaction Scheduling (VATS) algorithm was replaced by the std::stable_sort function to preserve the original FIFO order for transactions of equal weight.
- InnoDB: Write-ahead did not work as expected due to an incorrectly initialized variable.
- Studio
- Server
- Developer
- Databasefor Applications
- Reportsfor Applications
- Server (OEM)for Distribution
- Store
- My Account
The Best Free DB Management Tool
Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE.Powerful Reports Editor
Design business reports to run in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit.Visual Data Modeling for Free
Backwards Engineering in Standard with Forward Engineering in Valentina Studio Pro.On Your OS
Linux, Windows & Mac OS X for Desktop. Free iValentina for iPhone & iPad.
- Valentina Studio Key Features
- Valentina Studio Pro Key Features
- Valentina Studio System Requirements
Free Valentina Studio Features & Benefits At a Glance
Schema Editing & Diagramming
- Manage multiple databases in tabs and dockable views
- Create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views, Stored Procedures, Properties, Sequences, Types, ...
- Edit properties of multiple objects at the same time
- Drill down to tables and fields; incredible fast searching
- Reverse engineering and create diagrams for existing databases. Add new objects to diagrams.
Server Administration
- Add/drop users, groups, manage privileges
- Watch live logs, run diagnostics
- Remotely Register/unregister databases
- Create/Alter Schedule events
Valentina Reports
- View Reports with parameters stored locally and registered on Valentina Server
- Print Reports with parameters stored locally and registered on Valentina Server
- Reports Designer available in Valentina Studio Pro
Valentina Forms
- Use local Valentina Forms to work with your data
- Access Valentina Forms in projects registered on Valentina Server
- Forms Designer available in Valentina Studio Pro
SQL Editing
- Write SQL queries with auto-completion, color syntax
- Define, manage, save favorite queries; access recent queries
- Function browser dictionary of each function
- Consoles for errors, warnings, performance
- Search, Export result records into CSV, JSON, Excel
Utilities
- Diagnose, compress, clone, defragment, reindex and dump data
Valentina Studio Pro Features & Benefits At a Glance
Report Designer
- Visual design layout tools turn queries into reports; live preview
- Toolbox of controls, html, barcodes, charts, graphs and more
- Sub-reports, regions, groups
- Easy add macros, expressions
- Print to all standard paper formats, set gutter, margin, max records per page
- Deploy Report projects for Valentina Reports ADK applications
- Deploy Report projects to Valentina Server
Forward Engineering
- Visual Diagram Editor generates new databases
- Toolbox of controls, labels, comments, procedures, tables, views
- Generate scripts, copy scripts into your app code
- Easy visual navigation of very large diagrams
Database Continuous Integration
- Create | Save | Load database schema snapshots in structured format
- Register | Commit | Increment database source control with any VCS
- Generate Migrate scripts
Forms Editor
- Drag-create controls, widgets & layouts to create forms visually
- Attach and write custom methods in JavaScript
- Forms work work with any supported datasource including PostgreSQL, MySQL, MS SQL Server, SQLite and ValentinaDB
- Upload Forms to Valentina Projects on Valentina Server
- Deploy forms through free Valentina Studio on Windows, MacOS and Linux
Query Builder
- Build SQL queries with just a few clicks and no code writing
- Edit built queries in Data Editor and save to Snippets library
- Copy your SQL queries to use in any application
SQL DIFF
- See all the details of differences in Tables, Links and more
- Generate scripts to execute to modify databases
Data Transfer
- Copy records between two different databases
- Specify mapping of source/target Tables and Fields
- Log details and observe the transfer and result
These are the Valentina Studio System Requirements for Valentina Studio 6 or later.
Windows
- Win Vista SP2+;
Win 7 SP1+; Windows 8; Windows 10 - HD 20 MB+; RAM 50 MB
(dependent on database size)
Linux
- Ubuntu 10.0.4 +, Centos 5.0+, Debian oldstable+,
Fedora 10+, openSuse 11+ RHEL 5+ - HD 20 MB+; RAM 50 MB
(dependent on database size)
Sql Server Client Mac Os
Mac OS X
- Mac OS X 10.7+ Intel
- HD 20 MB+; RAM 50 MB
(dependent on database size)
The amount of RAM you have available for databases will directly affect performance of large, in-memory databases.