Is it possible to use SQLite instead of MSSQL SERVER in ASP.NET projects?
-
Hi, I want to create a web application in my local server. All clients can connect to it through the local network. This server has a static IP and all related settings have been set for port forwarding, so we can access the server and my web application through Internet. I want to use SQLite system in my app. Is it possible? Can users use data stored in SQLite at the same time?
-
Hi, I want to create a web application in my local server. All clients can connect to it through the local network. This server has a static IP and all related settings have been set for port forwarding, so we can access the server and my web application through Internet. I want to use SQLite system in my app. Is it possible? Can users use data stored in SQLite at the same time?
Assuming you mean SQLite:
Appropriate Uses For SQLite[^]:
SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
Note that writing to the database will lock the entire database file. Concurrent writes will not be supported.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer