----- Original Message ----- 

Hi Experts,

We need to create a API to allow a windows system to post 2-3 fields of data
to our mysql database.
The concerns are reliability, speed and security.
1) What protocol should be used?
2) They need to create an API to allow us to post data to their system.

Can you please give me sugestions to implementing the above task.

Thanks,
Gangadhar

------------ --------- --------- --

You didn't say if you want a Windows OS based API or an externally based API
protocol??

----------------------------------

----- Original Message ----- 
From: "Gangadhara Prasad"

Thanks for your reply.

I don't have any idea.Can you please suggest me which API is suitable for 
me.

-----------------------------
Hello,
        We write our messages below the previous message in this group.

Your question is very vague and so I cannot answer it. Windows runs on an 
API. In fact I would call Windows itself an API. If this is what you want 
then you need to go to another group as this groups is just for PHP and 
mysql.

mysql does not a have a complex authorisation process so you will need to 
have an interface or API, perhaps php.

Security is complex question and a lot of factors need to be considered in 
selecting a security scheme.

I am not sure what you mean by reliability. Do you need redundant servers?

The first step in creating an API is to write the API specification the rest 
is just code.

Decide what 'security' means. Do you need SSL or are other systems OK. What 
data must be secure and what data is less sensitive?

Security also involves logistics as there must be a way for users to be 
authorised. Different schemes suite different client bases.

Remember that nothing is truly secure - you simply make it so the effort 
needed to break the system is much greater than the reward for doing so.

What you seem to asking for is very basic and I suggest you just write a 
simple PHP script that has access to the data base. We can't help you 
without having a good idea of the expected outcome or as I suggested, an API 
Specification.

PHP is not very good for security of it's own accord. The server 
configuration plays a large role in determining it security. However it is 
best to write code that you expect to be secure and then provide the script 
with an extra level of security with Apache directives.

IP based security works best especially when the servers can be distributed 
in different continents. This however is out of the range of options that 
most have.

Hope this helps.

Reply via email to