CODEWITHSUNDEEP
sqldatabasefileinstallationformat
Devinder Singh
Devinder Singh

Reputation: 41

What file format can be use to save/access data instead on database

There is a situation in my company where we are developing a light weight .net web application with least dependencies. Application will be used hosted on client server. However there will not be any internet connection and they will use application locally.

We do not want any type of database installation on client machine. We want to keep it as simple as possible on client side. for this purpose we want to save/access data from file, as data on client side will not exceed more than 100 000 rows. We are also concerned about the speed for accessing data.

Here I want to ask how the data should be saved in file so that it can be accessed fast? What file format should be?

Whether I can use any db file which does not require any database installation on client side.

Upvotes: 1

Views: 166

Answers (3)

Steffen Ullrich
Steffen Ullrich

Reputation: 123380

You can use SQLite which is heavily uses in such scenarios (among others used by Chrome and Firefox). It is even public domain, so no license costs etc.

Upvotes: 0

Rahul Tripathi
Rahul Tripathi

Reputation: 172458

You can try Sql Compact Edition or SqlLite. Both are file based solution and fit as per your need.

Advantage of using these two would be that you can perform almost all the database queries on it and the data retrieval will be very fast. Also the you can think of optimizing the data storage and create tables etc.

Upvotes: 0

Mark Redman
Mark Redman

Reputation: 24515

You could save all data to a json file, this will become increasingly slow and prone to corruption.

Also, have a look at SqlLite.

Upvotes: 1

Related Questions