[ellamae]

hi guys!
i am creating an application for series 60 phone using python. i am new with this and i want to seek some help on how will i create a database for my application. for example, in VB6, i am using MS Access. In python, i have no idea which database will i be using to store the data.

[simo.salminen]

If you store your data to lists or dictionary and use only basic data types, you can get away with simple eval/repr.

lets assume you have following data:

database = {'data': 0}

save:

open("file", "w").write(repr(database))

load:

database = eval(open("file").read())

Of course, this is unsecure. Check out the pys60 doc if you wanna use real sql database.

[korakotc]

I wrote a few snippets here. They may be useful to you.
http://www.bigbold.com/snippets/tags/sql/series60

[korakotc]

Simo, there is a convenient way to load/store simple data/structure to a file.

import marshal

data = {'a':1, 'b':2}
f = open('C:\\file.bin', 'wb')
marshal.dump(data, f)

Similarly you can load data from the file.

f = open('C:\\file.bin', 'rb')
data = marshal.load(f)

"pickle" module is more appropriate to this kind of task.
However, it's not included in pys60 1.3.1

[simo.salminen]

Yes, marshal is faster. Nice thing about eval/repr is that you can view and modify the files using text editor, which is nice during development.