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:
- m3-2010
- Started by
- Johannes Joch
- Completed by
Related branches
Related bugs
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.
(?)