Database for login application

I want to make a login with few users,, as i read on the internet there are many methods to make a database (.mat,excel sheet,sql etc) and store user data, If anyone can provide me with details

1) What kind of a data base suitable for this application ?
2) How to do this ?

It would be a great help, thanks.

Answer 1

[Walter Roberson]

Any of those could be used, and your choice will not make much difference if you only ever have one access at a time. The choice starts to become more important if you have multiple simultaneous access and you are recording whether users are logged in or not.

For all of the possibilities you list above, you need to be careful of security. The temptation is to store the username and password in plain text. The security of that is gone as soon as anyone can get a copy of the database to examine. You need to encrypt the passwords somehow.

Answer 2

[Milindu]

thanks a lot ,,,

This login part is actually for a surveillance system application i am developing. Since it is a security application it would be good to have few simultaneous access and recording of users are logged in or not.

• Why does my choice important in above conditions ?
• Does this makes sql as the best choice ?
• I do not have any prior knowledge in sql, so would choosing sql makes this part too complex ?

[Walter Roberson]

When you have any information that is being written to, it is important that only one program at a time can write to the data (and only one copy of the program.)

If you only have one sensor, then you do not have to worry, as it can only do one thing at a time. But if you have several sensors, then they might need to access the data at the same time, and then you can end up with conflicting versions of information.

Database programs such as mysql are designed to be be accessed over a network and to internally handle multiple requests to the same data. A .mat file on a shared network drive is _not_ designed to protect multiple accesses.

I cannot answer whether sql is the best choice, or if one of the other databases is better. For example, would you be willing to pay 10 times as much for a database system that executed 1/100th of a second faster?

[Milindu]

Thanks for the ideas, i don't know weather i grasp everything you said, but it was helpful.

In my project i take video input and detect moving object in it, trying to detect weather moving figure is a human figure or not / if it is a human figure generate a alarm and record it . Since their are many objectives i think it would be enough to do a single access(one login at a time) and record log in time of that user. For that using .mat or excel is enough (i think).

If possible any information on working with .mat files would be a great help.

tnx

[Walter Roberson]

What kind of information about working with .mat files were you hoping for? You can load() .mat files and you can save() information to .mat files.