Re: Realbasic 2008 and MS SQL

On May 10, 11:38 pm, Jean-Yves <no-pub-for-jypoc...@xxxxxxx> wrote:
In article
<e4dfb7fd-af13-4d2b-abae-82158ee09...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,



 allan.casi...@xxxxxxxxx wrote:
Thank you for your inputs.  There is also another shortlisted proposal
from another company which will develop the client application in
VB.NET.  Personally, I was looking for other avenues other than
the .Net technology.  That was why I am hesitant to recommend the
VB.NET solution.

Recommending RB with the Real SQL Server is not an option because my
client is "sold" to MS SQL for their own reasons.  If i had a hand on
this, I will recommend scrapping the MS SQL for Valentina or even
MySQL.

I am utterly disappointed with what I have been reading about RB's
performance with regards database apps.  I have looked at the
language, and as a former developer who delved in Xbase, I love it.
But I have to look at this from my client's perspective.  With their
volume, speed of execution is the primary criterion.

Thanks again.

I'm also not confident with the .net system ...as with many of microsoft
products in fact...

but, as I said earlier, the performances of the database is the
performances of the sql engine !
so
if you can link rb to your ms sql engine (with odbc or something ?) it
would be fine for you
only the user interface to translate from vb to rb not too difficult
the performances will be the same !

I aggree that rb sql is not the best. but they putted out a version last
week that they claimed to be far better ? 2009.1
let's see.

in my mind, valentina is the best so far, even local or network.
the api is better than rb

in fact rb should buy valentina and move it into rb...

Thanks Jean-Yves for this great recommendation! :-)

Valentina DB is a columnar database which has years of optimizations
for speed. In many cases, a complex SQL query can run hundreds or
thousands of times faster - it seems like an absurd claim, yes, but
when you see hours turn to minutes - that's what it gets.

Regarding VB - what VB does not have going for it is cross-platform.
If you need cross-platform, ie Windows, Mac OS X and Linux from the
same code base, you have few options: java (sort of), the framework
approach (like wxWidgets or QT) or a RAD tool like REALbasic or
Runtime Revolution (http://www.mirye.net). If you can do without
Linux, there is even Adobe Director.

I cannot say if RB is the best choice of any of these - but I dont
have to, because Valentina works with all major development tools. We
have local and client solutions that work with .net AND com (so VB 6
is even okay), REALbasic, Revolution, Director, C++, Cocoa (on the
Mac) - we even just put out a client for the iPhone.

We also just shipped Valentina Reports, which integrates with
Valentina DB - BOTH for local database solutions and for server
solutions. Your local app can generate reports from local databases,
your local app can generate reports from Valentina Server, or
Valentina Server can generate reports all on its own. Hands up for
anyone who have been able to get Crystal Reports to work with
REALbasic? ;-)

Because you can do so much with stored procedures, SQL and ODBC
connectivity, the best solution in many cases is to place as much
logic on the server, then build as lightweight a client as possible.
REALbasic is a great application builder, but its better when you
build lightweight applications because then you don't have to worry as
much about speed or issues popping up when REAL upgrades REALbasic.

Best regards,

Lynn Fredricks
President
Paradigma Software, Inc
http://www.valentina-db.com



.

Relevant Pages

  • Re: SQL Server Express with Advanced Services -- ? on limitations
    ... receive a message from teh client pc app to report and print local data? ... does webserver app accessing local server data violates the spirit of the ... Looking through the brief on SQL Express/AS the following line is included ... Run SQL Server Reporting Services reports on local relational data. ...
    (microsoft.public.sqlserver.msde)
  • Query Engine Error
    ... I'm new to embedding CR in .NET applications and am hoping someone can help ... to set this up as a web app, I can't (client demands). ... the SQL is OK since I ... The reports are currently embedded ...
    (microsoft.public.vb.crystal)
  • Re: SQL Code that is submitted to server changes when run on different clients
    ... > client, but when it is run on a different client the SQL code ... > I have an access ADP that in one of the reports, ... > run using SQL Profiler, I can see that when I run it on my PC, ... Did you try to use "SELECT * FROM dbo.yourUDF" as Recordsource ...
    (microsoft.public.access.adp.sqlserver)
  • any problem with 2003 mdb using sql 2005 tables linked ot another mdb?
    ... I've got a client who has several Access 2003 mdb's linked together. ... My plan is to keep the reports in Access, but replace the front end forms with ... C# and the Access tables with SQL 2005 tables. ...
    (microsoft.public.access.externaldata)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)