My First SQLite Project

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: My First SQLite Project

Post by Rathinagiri »

Yes, that would be better. :)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: My First SQLite Project

Post by sudip »

Hi All,

I am back again (I was busy due to festival).

IMHO, you are talking about problem of LOST UPDATE and DATA INTEGRITY.

LOST UPDATE problem is usually solved by record locking. Here, with SQLite we may use programming technique, eg., making one particular field 0 or 1 (as Sqlite has no logical field).

For DATA INTEGRITY, AFIK, Sqlite has FOREIGN KEY facility, but to implement data integrity, we have to use Insert or Delete triggers.

Again, TRANSACTION facility of Sqlite will help 1) to maintain data integrity and 2) efficiency (speed).

I may be wrong, so please correct me if I am wrong :)

With best regards.

Sudip
With best regards,
Sudip
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: My First SQLite Project

Post by mol »

IMHO, "magic fields" with 0 or 1 - lock/unlock record has big defect - when program crashes (or computer crashes - e.g. power loose) - record remains locked and special action for clenup of locks are required.
I remember that mechanism built in PROGEN.
User avatar
sudip
Posts: 1454
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Re: My First SQLite Project

Post by sudip »

Yes Marek,
You are correct.
So, in this case ATOMIC TRANSACTION facility of Sqlite may be helpful :)
With best regards.
Sudip
With best regards,
Sudip
Post Reply