Can SQLITE support multiple users?

By Sqlite

I am trying to develop a Windows-based application where multiple users access the same database at the same time. Can SQLite support multiple accesses at once? Is SQLite stable in this regard? What makes SQLite better or worse than MS SQL CE?

Thank you.

Yes, SQLite can support multiple Users. But it will lock the entire database when writing, so if you have a lot of concurrent writes, then it is not the database you want (usually the database is locked for a few milliseconds-so for most purposes this It’s okay). But it is well tested and very stable (and widely used), so you can rely on it.

You can read this short document for when to use SQLite Information, instead of: http://www.sqlite.org/whentouse.html

I am trying to develop a Windows-based application that is accessed by multiple users at the same time The same database. Can SQLite support multiple access at one time? Is SQLite stable in this regard? What makes SQLite better or worse than MS SQL CE?

Thank you.

Yes, SQLite can support multiple users at the same time. But it will lock the entire Database, so if you have a lot of concurrent writes, then it’s not the database you want (usually the database is locked for a few milliseconds-so for most uses it doesn’t matter). But it is well tested and It is very stable (and widely used), so you can rely on it.

You can read this short document to get information on when to use SQLite instead of: http://www.sqlite .org/whentouse.html

, , , ,

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 900 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.