![]() Quite for the same reason, SQLite is not suited for a multi-threaded or a multi-process application-database access scenario. It’s not suited well for a multi user scenario and can have serious file locking issues when accessed simultaneously over the network. It is not suitable for a client server application or as a networked database. Like all databases, SQLite has its list of shortcomings. So should SQLite be used for all database driven applications? No. To administer SQLite database, an open-source SQLite GUI Database Browser utility is of much use. String txtSQLQuery = " insert into mains (desc) values ('"+txtDesc.Text+ " ')" To use SQLite in your C# application, you need to download a third party free ADO.NET data provider ( SQLite.NET.0.21_圆8_dll.zip) from here. SQLite has native language APIs for C/C++, PHP, Perl, Python, Tcl etc.Just include the library and the data file with your application. No problem of extra database drivers, ODBC configuration required.SQLite implements a large subset of the ANSI-92 SQL standard, including views, sub-queries and triggers.SQLite is ACID-compliant, meeting all four criteria - Atomicity, Consistency, Isolation, and Durability.SQLite has been ported to many platforms and runs even on Windows CE and Palm OS.SQLite has a small memory footprint and only a single library is required to access databases, making it ideal for embedded database applications.There are, of course, other reasons for choosing SQLite including: So if your application requires a standalone database, SQLite is perhaps the perfect choice for you. It also has the ability to store all the data in a single file. SQLite is a small, fast and embeddable database where the database engine and the interface are combined into a single library.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |