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: 5068
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 86 times
Been thanked: 101 times
Contact:

Re: My First SQLite Project

Post by Rathinagiri » Wed Sep 30, 2009 7:06 am

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: 1443
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Post by sudip » Wed Sep 30, 2009 8:11 am

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: 2670
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 69 times
Been thanked: 24 times
Contact:

Post by mol » Wed Sep 30, 2009 8:26 pm

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: 1443
Joined: Sat Mar 07, 2009 11:52 am
Location: Kolkata, WB, India

Post by sudip » Thu Oct 01, 2009 4:25 am

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

Who is online

Users browsing this forum: No registered users and 4 guests