On 29 Aug 2013, at 9:11am, techi eth <techi...@gmail.com> wrote: > 1) Is their any way I can calculate approx file size based on data. > > Ex : Let us say i am creating table with (row ID int ,Test Text). > > Each text string size is 10 byte. If I will create 100 row of this in > database then what would be Max size of created database file.
Assuming that you are talking about a database file created from scratch, you might be able to take a guess at the maximum file size by just creating a file like that yourself and seeing how bit it is. But the answer for your users would depend on which file system and which operating system they are using. This is because those things govern the page size selected by SQLite: <http://www.sqlite.org/pragma.html#pragma_page_size> You would have to allow so much 'slop' it might be easier just to pick an acceptable number -- say half a megabyte, and use that. > 2) How do I can fix the database file size to make sure I have not exceeded > max page count? > > http://www.sqlite.org/pragma.html#pragma_max_page_count No need. SQLite will itself refuse to make a database file bigger than that. I believe it generates an SQLITE_IOERR for the command that tries to exceed that page count. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
