Page 1 of 1

multiple databases

Posted: 19.09.2007, 16:00
by nadiap
Hello to all!
I would like to ask about the possibility of using sqlite in a simulation.
I use network simulator 2 and what i am doing is to simulate a wireless network. I have to mention that the simulation is done on the same machine. Network simulator2 uses c++ interface, so i thought that i could attach a database on each node. Additionally only one database at time will be accesed. I simply need to provide each node with a small database. Each database will be attached to the node when the node is being created and will be accesed only when a message is being received by the node. I know that it is not such a realistic approach, but i am doing my diploma thesis and the pressure of time doesn't give me lots of options.Moreover, each database will contain simple data.However, Dbs is something new to me and i believe that you do know more things.
i am googling all day but the confusion keeps growing.
Thank you!

Posted: 25.09.2007, 13:19
by aducom
I must confess that I don't realy understand what you want to do. You can using more than one db connection but if you use sqlite then I would advise to use separate databases. Since sqlite locks on update the entire database you might fall in to locking problems. If you have the several databases you can collect your data by connecting more databases and union the tables. Does this answer your question?

albert