Paradigma Software

Valentina Release 17.4.2 empowers best parquet management in Studio. Also ODBC for macOS, DuckDB Server parameters, SIMD optimizations and more. https://valentina-db.com/en/discussions/11506-valentina-release-17-4-2-empowers-best-parquet-management-in-studio

Create and send personalized emails from your database — FREE on macOS, Linux, and Windows. Customize and extend with Valentina Studio PRO. https://bit.ly/4v9x7U4

Valentina Studio 17.4.1 is out! New Studio AI Model support + fresh updates for data management suite. Free Studio available on Linux, macOS and Windows. https://valentina-db.com/en/discussions/11493-valentina-release-17-4-1-updates-studio-ai-model-support

CPU Vectorization is a game-changer for Columnar Databases.

SIMD processes 8-64 values at once, delivering 2x–160x faster scans & filters on non-indexed data. Indexes win for lookups, but vectorization makes everything else fly! Full story: https://bit.ly/48U7bDf

In previous 17.3.x releases, we delivered a major performance breakthrough for NON-INDEXED operations in ValentinaDB using SIMD CPU Vectorisation. Now it is time for INDEXED operations. v17.4 includes 4 optimizations for INDEX-based algorithms. We achieved speedups up to20x.

Read More: https://shorturl.at/PyGhm

v17.4 adds work with local files, as it works with local databases: , , .

More details in Reddit post:

From the DuckDB community on Reddit: What would you expect from a good visual Parquet workflow for DuckDB users? Explore this post and more from the DuckDB community

Valentina Release 17.4 adds Parquet support, first free ValentinaDB extension. ODBC driver updated to support DuckDB and SQLite. Grab Valentina Studio for free. https://valentina-db.com/en/discussions/11483-valentina-release-17-4-adds-parquet-support,-first-free-valentinadb-extension

Columnar databases power today’s fastest analytics engines.
ClickHouse, DuckDB, Redshift , and ValentinaDB use this design for a reason: extreme compression and blazing scan speed on large datasets. Curious how it works? What is a columnar database?
https://bit.ly/3P38Csm

News for DuckDB users! 🔥

Valentina Studio 17.3 now fully supports the new DuckDB VARIANT type on all three desktop platforms — Windows, macOS and Linux.

You can use
* Schema Editor to work with this new field type
* Smart visual editors for VARIANT values
* Beautiful Data View with special handling
* AI Chat assistance inside SQL Editor

Proper introspection and editing of nested objects, arrays, images, etc.
If you work with semi-structured data in DuckDB, this might be a very convenient way to explore and edit it visually.

Would love to hear your feedback if you try it!

→ Read more:
https://valentina-db.com/dokuwiki/doku.php?id=valentina:articles:vstudio_v173_duck_variant

New Valentina 17.3.1 — major DB speedups: ValentinaDB adds AVX2 (x86‑64) after SIMD (Neon) vectorization. Faster DuckDB in DuckDB Server, improved data transfer. Valentina Studio database management now in Korean. Learn more & Free version: https://valentina-db.com/en/discussions/11461-valentina-release-17-3-1-adds-avx2-vectorization-to-valentinadb,-better-data-transfers,-odbc-support