Hi Bob, > I seem to remember that you were working on a feature that > would allow Valentina Reports to work with MySQL databases. > Is this in this release?
Right now we are working on a feature that will allow more databases to work with various Valentina frameworks. This would appear first in Valentina Studio (and reports). The first we will offer is SQLite, but others will follow. We've made it relatively easy to port MySQL/PHP solutions to Valentina because you can do a simple search-replace on the text to change your calls. We've made significant investments in development tools that don't always need to be tethered to our own DB, and doing this will make it a lot easier anyway to port to Valentina DB. A lot of folks who are relatively new to database tech don't always see how advanced Valentina is or the advantages. It is a lot easier to simply let them use engines they like at first and once they dig in, they see just how really powerful a Valentina DB based solution is compared to what they have. It sort of reminds me of the "storage" revolutions we've had in the past - Floppies -> CDROM -> DVDROM -> Viable Online Storage. Wow, how can you possibly use more the 1.44 MB? Likewise, what possible advantage is there for shrinking hours or minutes into seconds on database queries? Ive had several conversations with people recently (esp Rev users) who haven't quite understood the Valentina DB value proposition. Valentina DB is a columnar database. As a columnar database, it has two huge advantages over traditional relational databases - - The way joins work is quite different. With Vlinks, the overhead is microscopic with Valentina. We've seen relational dbs lose a significant amount of weight when ported over as a result - The 'columnar' way is really, really fast - blazingly fast. Sometimes its just twice as fast. Sometimes it is 100+ times as fast. The more complex your queries are, and the more records you have, the more you notice this. That's why we have customers in the financial services market who have set up dumps from Oracle into Valentina for use with their custom apps. On top of this, we have the Paradigma way - which is to support very broad connectivity: - cross platform dbs that work on Mac, Windows and Linux - connect from many app platforms - Rev yes, but also the likes of a pure Cocoa solution, .net, COM, Vclient for iPhone and lots, lots more - support a more advanced, modern API as well as standards like SQL The component system has two parts - A Client The DB Runtime (local storage) Clients simply interface with DB Runtimes, acting as a sort of gateway for communication. So while there isn't a local storage DB Runtime on iPhone, for example, you can query and "pull" data from Valentina databases into your iPhone app. The same sort of system applies to the "client" for PHP on the server, or the "client" that is included with Valentina for Revolution. Best regards, Lynn Fredricks President Paradigma Software http://www.paradigmasoft.com Valentina SQL Server: The Ultra-fast, Royalty Free Database Server _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
