SQLite with your application AND SQLite on your Server! Valentina Server is a Business Reports Server as well as an ultra fast Database Server. Soon with SQLite support for building client-server solutions and more. Continue reading Valentina Server Incorporating SQLite Engine
Happy Valentina Day 2015: Save 50% on OEM Valentina Developer Network
Valentine’s Day 2015 is here, and we are celebrating with a special 50% off VDN (Valentina Developer Network) and deploy OEM’d Valentina Server (DB AND Reports) to your customers royalty free! Ends 2/16/2015. Continue reading Happy Valentina Day 2015: Save 50% on OEM Valentina Developer Network
[TIP] Server-Side Cursor Advantage
A new WIKI page, which discusses one more reason to prefer Valentina DB:
Tip: The Secret Connection on Valentina Server
You are a database administrator and you need to log in to a live Valentina Server. It is jammed packed with users, and there are no free connections. What do you do? Continue reading Tip: The Secret Connection on Valentina Server
Buy Omegabundle for Xojo 2014 & Save on Valentina Developer Network
Paradigma Software is offering a 25% limited time discount for Valentina Developer Network to Omegabundle for Xojo buyers. Continue reading Buy Omegabundle for Xojo 2014 & Save on Valentina Developer Network
Valentina Release 5.7.1 Improves ODBC, Upgrades SQLite Support
Valentina Release 5.7.1 is now available. Updates to Valentina Studio and Studio Pro, Valentina C++ ADK and Valentina Server. Continue reading Valentina Release 5.7.1 Improves ODBC, Upgrades SQLite Support
Valentina 5.7 Delivers Access Control for Valentina Server
Valentina Technology Release 5.7 products, including Valentina Server 5.7 and Valentina Studio Pro 5.7 are now available for download from the Paradigma Software website. Continue reading Valentina 5.7 Delivers Access Control for Valentina Server
More Connections for Valentina Server Sale
Valentina Server is both a powerful business reports server for MySQL, PostgreSQL, MS SQL Server and Valentina DB as well as its own object-relational, ultra fast database server. From now until November 1, 2014, save up to $500 on more connections capacity on this enterprise class server – that’s more connects, no added cost! Continue reading More Connections for Valentina Server Sale
Valentina 5.6 Released; New Feature Hash Indexes
Paradigma Software announces that Valentina Release 5.6 is now available for download. If your software license began after October 16, 2013, the update is free. Continue reading Valentina 5.6 Released; New Feature Hash Indexes
v5.6 Builds Index of String/VarChar field in 10-15 times faster!
Bench Description
Prepare Steps
- We have table T1 with field String[120] or VarChar.
- We add 1 million records with unique values using METHOD( ‘concat( rand_string(80), RecID’ ) )
So we get table with one only field, 1 millions records, values are about 80-90 chars length.
Benches
- Build index for this field.
Continue reading v5.6 Builds Index of String/VarChar field in 10-15 times faster!
New Docs Section – Valentina DB Indexes
We have re-write from scratch section about Valentina DB Indexes. You can read it here.
Valentina Studio: Best Free SQL Database Tool
Valentina Studio SQL GUI tool is available for free on Mac OS X, Windows and Linux. Just download free and it just works. Get FREE Valentina Studio, or upgrade to Valentina Studio Pro for only $199 to enable powerful Reports Builder, Data Transfer, SQL DIFF and so much more.
Valentina Technology Release 5.5.8 Now Available
Paradigma Software announces the immediate availability of Valentina Technology Release 5.5.8, a fixes and improvements to Valentina Studio, Valentina Server and the Valentina Kernel (underlying all Valentina products).
You can find a complete list of changes in the Release Notes on the Valentina Wiki.
Sitepoint Takes a Look at Valentina Studio, DB and Reports
Taylor Ren over at Sitepoint gives Valentina Studio, Valentina DB and Valentina Reports a look over. His report primarily touches on Valentina Studio (for Linux) but also in context with MySQL. Check it out, and feel free to comment on your experiences – Taylor is very engaging with his readers.
[NEW] Generating Test/Bench Data for Data Focused Apps (Part 2)
We have implement Stored Procedure ‘GenerateDataFor()’, which solves the task described in the part1 of this article.
We have added into Valentina Wiki new section, where we will keep this and future other Stored Procedures By Paradigma Software.
On this page you can find link to WIKI page, which describes GenerateDataFor() procedure and contains download link.