Sqlite requires few resources. Locking is achieved through regular file
locks which lock the entire database since it is a file.
Flow control is not applicable.
You may use semaphores etc in your application for synchronization, but
they are not used by Sqlite.
Maintenance of an Sqlite database uses regular SQL. Backups and loading
are just file copies since an Sqlite database is a single file.
Vivek R wrote:
Hi Everybody,
I have the following doubt.......
1. what are the resources required by SQLLite - they can be RAM/ROM,
semaphores, mail boxes, task requirements;
2. How do we have flow control?
3. what are the Lock mechanisms provided by the engine (row lock, table
lock..)? Any additional lock mechanism we need to build.
3. How to create a service component that creates these tables on HDD (
Hard
disk on Consumer products like DVD or Set top box ) before it leave the
factory.
4. recovery mechanisms (in case DB crash how do we recover/reconstruct
data?)
Thanks and Regards,
Vivek R
