REALbasic MySQL Plugin
Last updated on September 9th, 2007
Download
This is a plugin for REALbasic that offers native connectivity to MySQL, using REALbasic's built-in database API.
As of REALbasic 2007 Release 4, REAL Software is no longer distributing a MySQL plugin for REALbasic. We know that there are a lot of people using the plugin, and because of that we are now supporting and maintaining it.
This plugin is licensed under the GNU General Public License v2. It allows access to MySQL Community Edition and MySQL Enterprise Edition.
It allows access to community installations of MySQL database servers using REALbasic's built-in database API. While we are not lawyers, our interpretation of the GPL is that it is viral, and any applications that are distributed publicly must also contain the source code of the application and plugin. If you are in doubt about how the GPL applies to you, please consult your attorney.
We have created a Google Group to be able to discuss the future of this plugin and offer support to those who need help using it in their application. If you have any questions, comments, or ideas, please let us know at the realbasic-mysql-plugin group.
Release History
Subscribe to updates for this product:
RSS,
Atom
September 26th, 2007 at 9:20 am
[…] As always, the plug-in is licensed under the GNU General Public License v2, and is free to use, share and modify. More information can be found at: http://www.alacatialabs.com/products/realbasic-mysql-plugin/. […]
February 25th, 2008 at 6:15 am
This plugin don’t work with bigint in REALBASIC 7 r5
For example:
You have this mysql table
CREATE TABLE `table` (
`anumber` bigint(1) NOT NULL default ‘0′
);
// INSERT(3587416441)
And then I do this in realbasic
rs = db.SQLSelect(”SELECT anumber FROM table LIMIT 1″)
msgbox str(rs.IdxField(1).Int64) = 2147483647
msgbox str(rs.IdxField(1).IntegerValue) = 2147483647
msgbox str(rs.IdxField(1).Value) = 2147483647
msgbox rs.IdxField(1).StringValue = 2147483647
msgbox rs.IdxField(1).getString = 2147483647
I don’t know if this is the MySql plugin or Realbasic.
And more important how to fix this problem.
March 17th, 2008 at 10:12 am
Where can I download the RBmySQL source since it is under GPL
March 17th, 2008 at 10:47 am
It’s included in the download, in the directory named “source.”
April 4th, 2008 at 1:55 pm
Hello, I am using realbasic r7 and I have a problem with where my program seeks socket mysql running under Linux. The program seeks socket in a / tmp directory where mysql as before but placed in the new versions, it is in another site. It would be possible to tell to realbasic where is the mysql socket and thus avoid having to modify the configuration mysql?
Nota: I using a translator for spanish to english.
April 4th, 2008 at 2:14 pm
There is no way to specify connecting directly to the socket path.
April 15th, 2008 at 5:19 am
You may be able to use the my.cnf file to specify the socket path for the program — the mysql client API generally consults the my.cnf file to see if there are any specific options for it. (Note, I have not tried this, so I cannot say it works, but it’s worth a try)
Alternatively, you can do the same for your .my.cnf in your home directory (or that of the user running the app), if you cannot make changes to the /etc/my.cnf file.
HTH,
-Doug
July 1st, 2008 at 7:16 am
Is there a possibility that the plugin will work asynchronously ? like a socket in RealBasic ?
I want to perform a big SELECT and my Appliction hangs till the end of the datas tranfert.
Thanks
July 1st, 2008 at 10:53 am
Hi, i´m from Mexico and here is hard to find some help i´m trying to change from filemaker to realbasic but i need to use databases so i´ll like to use this plugin i have realbasic professional R1 can i use this plugin with this release
July 1st, 2008 at 10:54 am
Is there some manual to use the plugin
July 23rd, 2008 at 8:14 am
Hi,
is there any possibility to last_insert_id and affected_rows? Maybe this would be a good reason for a update of that plugin?
Petrues
July 24th, 2008 at 11:47 am
This plugin doesn’t work with double value fields, compiling application for linux.
In mac and windows it’s right, when you select data from a double field, you get the correct value (let’s say 1.2345)
But in linux, the same sw, the same select, you get a truncated value ( 1 ) with no decimals.
Any hints?
Thanks
Marco
July 26th, 2008 at 2:33 am
Do the mySQL plugin support the MySQL Version 5 in UTF-8 coding? I have a problem that is I can read/write chinese character in the RealBasic. But I can’t get the correct character display from other application(for example, MySQL Query Browser), or I can say it can not decoding correctly. The Database already in UTF-8 coding. Can anyone sugguest me how can I overcome this problem?
July 31st, 2008 at 5:03 am
I have RB 2008 r3 standard edition. It needs the professional edition to use your plugin? Thanks.
October 1st, 2008 at 9:44 am
HELP HELP HELP !!! I’m using mysql plugin on Realbasic 2007 r4, and it works fine when running the compiled software on windows. But now I’m going to compile my software for linux (I tried Fedora 8 and Ubuntu 8.04.1). It says:
Runtime Error 4: Failed Assertion
Press OK to Continue
Press Cancel to Quit.
Please report what caused this error
along with the information below.
../Common/plugin.cpp: 6614
Failure Condition: 0
The application cannot continue because a needed file cannot be installed. libstdc++.so.5: impossibile aprire il file oggetto condiviso: Nessun file o directory
I searched for a updated version of your plugin, but the last dated sept. 2007. Can you help me? Thank you