Can RevMedia access SQL?

shunyun · Post by **shunyun** » Sun Aug 02, 2009 6:47 pm

From the runrev website, I read that revMedia cannot access SQL. Yet I see folks discussing SQL on this forum. So... if I buy the $49 Media license, do I get the SQL routines?

Janschenkel · Post by **Janschenkel** » Sun Aug 02, 2009 7:26 pm

Database access is only for the revStudio and revEnterprise editions. I'm guessing that some people just posted their question in the wrong forum.

Jan Schenkel.

Mark · Post by **Mark** » Sun Aug 02, 2009 11:42 pm

shunyun,

RevMedia is free now. No need to pay for it. If you buy Studio or Enterprise, database features are included.

With Media you could still use the shell function to access a MySQL or SqLite command line tool locally.

You could also use an alternative way to store your data.

Best,

Mark

Ron Zellner · Post by **Ron Zellner** » Mon Aug 03, 2009 5:33 am

Is the lack of SQL a temporary aspect of Media, or is it planned to be permanently unavailable? I was counting on SQL functions.

How would the shell function work in a revlet? Is there documentation on that?

What alternatives do you suggest?

Thanks,

Ron

Janschenkel · Post by **Janschenkel** » Mon Aug 03, 2009 6:04 am

Database access is not meant for revMedia - there has to be some difference between the different editions, especially now that revMedia is becoming free. See the Comparison chart for an overview of what is part of which edition. If you need database access, you'll have to go up to revStudio or revEnterprise.

Jan Schenkel.

malte · Post by **malte** » Mon Aug 03, 2009 9:15 am

Hi Ron,

as far as I understand it, the plugin will be able to use SQL, however not if your application was built with the free version. If you go with studio or enterprise, you will be able to do sql in a browser session though.

All the best,

Malte

Mark · Post by **Mark** » Mon Aug 03, 2009 9:18 am

Hi Ron,

Database access is not included with Media, but it is available in Studio and Enterprise.

To find out how the shell works, read the Revolution documentation about the shell() function and read the documentation for each of the respective database command line utilities. Use your favorite search engine to find more information about MySQL and SQLite.

Hint: In Mac OS X, the command line utility sqlite3 is availablel by default.

You could also store data in files or in custom properties. I have an example of the latter in either the old or the new RevOnline, but unfortunately RevOnline seems broken. If you send me an e-mail, I can send you a stack.

Best regards,

Mark

Ron Zellner · Post by **Ron Zellner** » Mon Aug 03, 2009 5:44 pm

OK, I guess I didn't understand what Media is. I somehow thought that the free alpha test version was a temporary advance version of Rev 4.0. It does so many Rev functions and had the Web creation capability that I was so eager to begin trying out that I slipped into a wrong mind-set when I started using it.
Many of the postings had topics appropriate to general scripting that I didn't detect the difference until now.
Now that I'm in the correct song book I'll keep my postings straight. We have several copies of studio and I am anticipating many activities related to converting regular stacks to run on the Web. I'll play with Media to test Web conversions and wait for RevStudio 40. for aspects like SQL.
Hard to believe that Media is free- it will be a great way for my students to begin learning scripting and Web resource development.

Mark,
Yes I'd like to see the sample file that you offered. zellner@tamu.edu
The economy-x-talk site looks interesting, I expect I'll run into you there sometime.

Thanks,

Ron

LiveCode Forums.

Can RevMedia access SQL?

Can RevMedia access SQL?

SQL alternative?

Apparent misconception