Thanks for your reply. I have read through the link you suggested, very
helpful...if I may ask another question concerning this. Say on my
application I have 2 users reading some of the database contents at the same
time and they both log something in my application at the same time. For
example say they want to both review different customer accounts and add a
payment to the different customer accounts. Would there be a delay with
both of those when using SQLite, if so would it be significant?
Can I use SQLite this way have my application stored on the server and allow
users on a LAN/peer to peer have the ability to open my app and write to it
at the same time? does this type of multi user access often corrupt the
database? If my database does become corrupt how can I repair it.
Sorry for the redudancy in the questions...like I said am new to SQL (used
MS SQL a little) and really new to the idea of using an embedded database
engine.
Thanks in advance for information
Simon Slavin-3 wrote:
>
>
> On 26 May 2010, at 10:04pm, jdee5 wrote:
>
>> I am looking for an SQL engine that is easy to install and sqlite seems
>> like
>> the right way to go. I have an application (currently just for network
>> use
>> on a LAN) and I want to move to using SQL, my application is fairly small
>> and simple and I like the idea of embedding SQL and using SQLite so my
>> end
>> user doesn't notice any difference from my current application...however,
>> more than 1 person may want to access the db at a time does SQLite allow
>> for
>> this?
>
> Yes. SQLite supports locking for multi-user and multi-process access. It
> is unusual in that it locks the entire database file rather than
> individual records, but the SQLite calls you make handle multi-user access
> correctly. You /will/ have to make your application aware of how to
> handle the errors which arise if one user keeps the database locked so
> long that the other user can't access it. I recommend you read this page
> (though you don't have to memorise it all):
>
> <http://www.sqlite.org/lockingv3.html>
>
>> Can it just sequentially record transactions as they are made even if
>> made simultaneously... I have search all over and can't come to a clear
>> conclusion, I am also very new to using SQL.
>
> Under most circumstances, even if two programs are entering transactions
> at the same time, SQLite will handle this without the programs having to
> be aware of it. However, make sure you handle the SQLITE_BUSY and
> SQLITE_LOCKED errors correctly. I hope someone can recommend a page which
> breaks down how to do this.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/Novice-SQLite-user-tp28686380p28688425.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
