----- 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.