Category: macOS

[NEW] Valentina Reports adds MS SQL as Datasource

Valentina Studio Adds MS SQL Server SupportIt isn’t often we add a new database type, but this is one we’ve had a lot of requests for – MS SQL Server.

Today this happens! Valentina Reports starting from 5.5b15 can use MS SQL server as native datasource. Notice, that this works on all 3 OS:  Windows + Mac OS X + Linux.

 

 

If you use MS SQL and you want to test it, you can download it here for all OS:
http://www.valentina-db.com/download/beta/5.5b20 

Right now you can…

  • Download Valentina Studio to do the following steps…
  • Make a new Valentina Project (from File Menu) on your desktop
  • Make a new datasource — define to your MS SQL server
  • Make a new Report – can be with simple query as SELECT * FROM T, do click, click, click in the wizard to get default layout of fields.
  • Click PREVIEW button on the left to see report with data from your MS SQL Server.

To start use this new datasource in your application you need just to specify a corresponded string that describes datasource connection string. See details.

[FIX] Valentina for RB/Xojo: Mac + Linux updated the work with pictures

In new Xojo was changed the work with pictures for Mac/Cocoa and Linux.

We have improve plugin “Valentina for REALbasic/Xojo” to support these new formats. This fix affects both normal pictures and preview pictures in Valentina Reports.

Valentina Studio on Mac App Store

Valentina Studio 5.1 is now available for free through Mac App Store. Valentina Studio 5.1 was recently released with support for SSH, making it your best choice for working with virtual hosting services and the databases you may have stored there.

Valentina Studio on the Mac App Store also has in-app upgrading to Valentina Studio Pro for your convenience.

[NEW][MAC] VStudio.app and installer of VServer_x64 now are signed

OS X 10.8 has option “System Settings -> Security -> General -> Allow: MAS App Store and identified developers”  on default to be ON, so you cannot installed easy not signed applications and run installers. Note that 10.7 also can have this option enabled on some computers.

To resolve this issue, we have sign vstudio.app and vserver_x64.pkg installer.

Unfortunately we cannot easy sign other our installers (V4RB, V4REV, V4CC, … ) because we using third party installer.  So for now, for 5.0, we going to ship these installers not signed. To run them, OS X developer should in the Finder do CTRL + click on icon of installer and choose OPEN command in the contextual menu. In this case you will see the button ALLOW in the OS X security dialog. Click it, and continue as usual.

[NEW] VKERNEL now can create journal at a specified location + Sandboxed Mac Apps with V4CC.

Frank have contact us with request add ability for V4CC (Valentina for Cocoa) developers to specify the location of journal of a database. This is important for sandboxed applications, which on default can access only their sandbox folder and a file(s) that user specify explicitly.

PROBLEM is that if a user choose somedb.vdb file in the SelectFile dialog , then Valentina engine needs yet to create a journal file near to .vdb file. But for a sandboxed application this is prohibited by OS X. This is why developer want to be able specify another location for journal file.

Btw, this problem exists more of year for SQLite database that is used e.g. in CoreData of Apple, when it is used by a sandboxed app. Strange, but the only advice from Apple is – disable journal file.

We have spend couple of days to add into C++ level  and into V4CC ADK this feature. Rest ADKs soon.

Now you can write the following in V4CC:

Continue reading [NEW] VKERNEL now can create journal at a specified location + Sandboxed Mac Apps with V4CC.

[NEW] VStudio + iValentina now sync bookmarks using iCloud

We have made first step to support iCloud technology from Apple.

Now Valentina Studio for MAC OS X (and only one, which is download from MacAppStore) will have iCloud prefs pane, that allows you to specify what to synch in the iCloud. For now this is bookmarks and resent connections to db servers.

Continue reading [NEW] VStudio + iValentina now sync bookmarks using iCloud

VStudio:Report Editor – Now works with PostgreSQL as Datasource.

Valentina Studio Pro’s Report Editor now works using a PostgreSQL database specified as datasource! If have some Postgre database, connect to it and start design new report using data of that database. You can instantly preview your data right within Valentina Studio Pro. Reports are saved into a project format so you can reuse them at any time.

You can already use design reports this way from data from any Valentina DB ADK (REALbasic, Revolution, Cocoa, NET, PHP, … ). You can see few snapshots below.

Support for PostgreSQL will be included in Valentina Studio 5.0b1 – coming real soon. Valentina Reports will be able to work with local Valentina databases, Valentina Server hosted databases, local SQLite and now with PostgreSQL server.

Continue reading VStudio:Report Editor – Now works with PostgreSQL as Datasource.

Valentina Office Server /5 Now Free

Valentina Office Server is a combined database and enterprise ready reports server from Beaverton, Oregon-based Paradigma Software. Almost any individual or organization can now get a free copy of it -actually, up to three copies – one for each operating system: Linux, Windows and Mac OS X.

With all the FOSS databases around, why Valentina? For one, you get an awesome reports server, and I have yet to come across a FOSS reports system to beat it. On the database end, Valentina is an extremely fast and modern columnar database. It can do so many things you won’t find in FOSS products.

The response to this release has been phenomenal. As people write in Ill be posting additional posts clarifying the program.

[NEW][V4CC] Interface Builder Plugin – Zero Lines of Code!

In version 4.8 we add one more cool feature to Valentina for Cocoa (V4CC) ADK – Interface Builder plugin!

V4CC Interface Builder Plugin allows you to develop a Cocoa application with embedded V4CC.framework without writing any code to link GUI with a Valentina database. Instead you will use bindings and few Valentina Controllers.

You can read Manual of V4CC IB plugin and learn few tutorial lessons.