Sign in to follow this  
Followers 0
lte5000

Website data storage - Database vs INI file?

3 posts in this topic

#1 ·  Posted (edited)

Hi,

I'm running a small Abyss + AutoIt3 powered website, for a project of mine.

Users can make up to twenty (20) choices on my site.

I then need to store the users' choices.

Currently, I'm using one (1) INI file for data storage.

This INI file has a section for each user and each user's selections are written to keys in that section.

However, if multiple users access my site simultaneously, there is the possibility of data corruption in the INI file... correct?

I was wondering what my next step should be:

SQlite - looks scary - or INI file with some sort of mechanism to prevent data corruption?

Thanks for any advice.

Edited by lte5000

Share this post


Link to post
Share on other sites



SQLlite is the best way to go. You then have a secure database that can be accessed by multiple people at once. It looks scary, but it simply is the best method for doing this. Using an ini file isn't secure, since anyone can then open the ini file if they know the url, unless you are storing it in a protected directory.

There are tons of SQLlite user created libraries on this forum. Search the Example Scripts forum. You should get a bunch. These libraries should make it quite easy for you since all you have to do is use the functions provided in the libraries to write and access the data.


"So man has sown the wind and reaped the world. Perhaps in the next few hours there will no remembrance of the past and no hope for the future that might have been." & _"All the works of man will be consumed in the great fire after which he was created." & _"And if there is a future for man, insensitive as he is, proud and defiant in his pursuit of power, let him resolve to live it lovingly, for he knows well how to do so." & _"Then he may say once more, 'Truly the light is sweet, and what a pleasant thing it is for the eyes to see the sun.'" - The Day the Earth Caught Fire

Share this post


Link to post
Share on other sites

Thanks for the advice, I'll probably be checking into it.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0