Hi,
I would like to use sqlite for my data storage and quite new to this
environment. Have a few queries regarding sqlite.
I have to store and read say 'n' users data. Each user will have his own
contacts(Name,phonenumber) list.
At any point of only one users data will be written or read.
What
Pavan wrote:
Should i create different tables for each user, so hat at any point
of time only one users data will be accessed ? Should i store all the
information in one table and then acess it ?
The word you want is normalisation and you could have a look at, say,
Hi Martin,
Thanks for the quick replyI have gone throu the link and it gives good
insight
of data managment from tables perspective...
But, from users point of view can it be something like this
/home/user/user1/user1.db [User1 will have table to hold contacts list]
/home/user/user1/user1.db [User1 will have table to hold contacts list]
/home/user/user2/user2.db [User2 will have table to hold contacts list]
.
.
.
/home/user/userN/userN.db [UserN will have table to hold contacts list]
This would imply that you are writing an application where each user
Pavan wrote:
The idea is that at any point of time user1 should not access user2
details and vice-versa.
SQLite doesn't have a concept of access control so if you want to stop
user1 from seeing user2's data then you'll either have to use a database
that does provide access control or , as
Hi Paul,
Thanks for the detailed reply...
The app would be on these lines, download the phone book for several users
onto the linux PC and give access to their downloaded phone books for
reading at later time, each user should
not see other user contacts list.
Thanks,
Pavan.
On 2/15/07,
