Connecting to other databases ( contd )

[telbourn7]

Are there any timelines for a new release of Runbasic that will connect to higher-performance databases than SQLite ?

I've seen mention of MySQL on here - any thoughts about Postgre or a generic OLE DB ( or whatever MS call it now ) type connector ?

Regards to all - Runbasic rocks ;D

[carlgundel]

We will have a version that connects to MySQL and other databases, but it probably won't appear for a few months yet.

-Carl

[gcav]

Is ODBC being considered??
ODBC would open up several database options...

[Carl Gundel - admin]

We are going to add other databases. ODBC is definitely a consideration, but it isn't necessary for adding Oracle, SQL Server, PostgreSQL, etc.

-Carl

[bovnet]

Any roadmap update ?

[mcgeorge]

I just bought the program and would like to know when the connection is possible with other databases. I see that the last request is already several months old.
I would really appreciate an answer.

[jerry]

Carl,
Good question... When will mySql access be available?

[jerry]

Yeah... it's 6 years since the last post to this topic. But...

What I do to access mysql is this. I wrote three programs in freebasic. One inserts, one updates, one does selects on mysql. I then write my runbasic front end that calls one of the three "freebasic servlets" via rc$ = shell$(freebasic.servelet). in the call I pass the name of the db, the table and whatever columns I want to include" if the call is successful, I get back the results in rc$. If the call fails then rc$ = "".

The run basic looks like:
a$ = shell$(extrasFilePath$+"password "+name$+" "+pass$)

In this example the freebasic servelet named password, connects to mysql, does a select on the password db, password table for a match for the name$ and pass$. Success returns the environment setup for the user in rc$, a failed match returns rc$="" and an error returns rc$="ERROR". It's works! It's quite fast and Ive done a lot of runbasic front ends for a number of projects.

Anyone interested, I'll happily share my freebasic source code. Contact me: [e-mail]

[jerry]

Ive since rewritten the three freebasic servlets ablve into just one. Before I describe the freebasic part, I'll discuss the MYSQL part.

I only support specific runbasic work apps that hammer on a company mysql cluster. My apps do simple queries including highly complex writes, updates, etc.. What Ive been able to do is create a database with multiple tables. Im able to cap the table size to a max of 52 columns. The naming of each column in each table uses the same layout. Column 1 is named 0A, next is 0B, up to 0Z. When I hit the 26th column the name changes to 1A, then 1B all the way up to 1Z. This allows the 52 column width needed for some of the user base needs.

Now, my new single servlet accepts, as input; number of columns to expect, database name, tablename, A single letter command (Read,Write,Update) and then a string of comma separated data.

With the ability to specify a table width in the call along with table name eliminates a lot of unnecessary code and makes maintenance of the applet source very easy.

Using the applet, I can access tables as small as one or two columns, to as large as 52 columns, which is our maximum use case.