Local storage in SQLite (URL, Username and all the forms)

Registered by Johannes Joch

Local storage in SQLite (URL, Username and all the forms)

Blueprint information

Status:
Started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
Johannes Joch
Definition:
New
Series goal:
None
Implementation:
Good progress
Milestone target:
milestone icon m3-2010
Started by
Johannes Joch

Related branches

Sprints

Whiteboard

There is one database called "data" set up on a sqlite bases. This is by default supported by Android, very resource friendly and supplies us with the basis database functionality. One difficulty we faced was, that sqlite does not support foreign keys, nor does it support any kinds of join. Therefore the database entries and queries have to be done with special caution.
Four tables are created in the DB, namely the ones you see in the graphic on the wiki page.
Also we learned the lesson, that if you have the DB on the device and then rename a column, you need to reinstall the DB or just use another emulated device, as you will get run-time errors otherwise.

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.