Amiga.org

Amiga computer related discussion => Amiga Software Issues and Discussion => Topic started by: mantisspider on November 28, 2003, 10:11:13 PM

Title: programming question about interacting with MSSQL and MySQL
Post by: mantisspider on November 28, 2003, 10:11:13 PM

Hi guys, i got a programming and internet protocal thingy question, anyone able to shed any light pls?

Can applications written for the amiga interact with MSSQL or MySQL databases on the net?
In whatever programming language.

cheers

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: amiga1260 on November 28, 2003, 10:26:07 PM

You could program with php and use a webbrowser to interact. It is possible to use C(++) or Java to program applications for the Amiga to interact with MySQL and MSSQL, but I do not try it.

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: mantisspider on November 28, 2003, 10:55:09 PM

Im already using a web browser but I want to use a non web based interface so that high res graphics and videos can be used.
Decent audio and graphics is needed :-S but nice fast interaction between the client and the database too :-( tricky?

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: pappavis on November 28, 2003, 11:26:25 PM

In 1997 I manged to compile mSQL to the AMiga with Geek Gadgets.  Its been updated but not in anything like 6 years or so...
Its not exactly what you want.. since there is no java on AmigaOS your efforts are hopeless.  Forget it, dont waste your time...

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: mantisspider on November 28, 2003, 11:31:14 PM

cheers man

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: mantisspider on November 29, 2003, 01:47:38 AM

Hi guys,

the game i am working on is here:
http://www.silibil.com/game.htm (http://www.silibil.com/game.htm)

its only a rough with javascript and no server side stuff... but is only to test the idea

its a mix of "its only rock n roll" and rock star ate my hampster"

:-)

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: amiga1260 on November 29, 2003, 12:32:48 PM

There are some Java compilers for the amiga. Check it out on Aminet.

And here is a C library to program a server/client side:
 
http://www.aminet.net/dev/gg/sqlite.readme

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: RobinC on November 29, 2003, 04:06:18 PM

SQL stands for Structured Query Language - it's a standard for interacting with database servers. Of those you've mentioned MySQL, MSSQL, there are also other ones like Oracle etc. Each of these has a huge overlap of commands, but there are some that are slightly different, so choose one and stick to it (personally I use MySQL, but so long as you know the command set for what you use you'll be ok).

Being a standard means it is well documented, if you look up the rfc on SQL (sorry, not got the number handy) it'll explain all protocol stuff, the other option is to find a link library etc if you're going to use something like C. PHP has a module to use it, and no doubt there are modules for other languages to. If you want to get down and dirty then do the communications layer yourself, it's not *that* hard.

Robin

Title: Re: programming question about interacting with MSSQL and MySQL
Post by: mantisspider on November 30, 2003, 02:59:41 AM

cheers robin