MECHENG401:Meetings:19March
Meeting
It looks like further research is required in several areas. These are:
- SQLite
- How scalable is it? max size? max tables? etc..
- What important features of SQL does it implement/not implement
- What kind of support does it have for Blobs/images?
- What sort of ACID properties does it support/
- Does it support tables and foreign key constraints and other standard features?
- Google Gears
- Database synchronisation support
- Support for directly accessing a server database
- Programmer access to a remote database (and a local one) -> can you control what gets cached and when? Access it?
- Can you seamlessly change between accessing a local DB and a remote DB with the same interface?
- Thick client solution
- The feasibility of creating a web interface for accessing a server based DB for all user groups, and for those who want to use the program remotely to enter data, installing the full DB and web server on their machine, so they can use the site in exactly the same way they would if they were in the office
Other research areas
- Distributed databases
- Database merging
- Database backup systems
- In particular, incremental backups
Fall back
- If no available frameworks/solutions meet our particular needs, we may need to investigate database caching and merging, in order to develop our own method. Ideally this would be a general, reusable solution.