You don't need any file parsing with SQLite and SQLite is not a file-parsing utility. SQLite is a database engine. It creates file of its own format and parses it without user noticing it. All you have to do is issue necessary SQL commands to work with your database. You definitely need to read more about concepts of relational databases.
Pavel On Fri, Dec 4, 2009 at 8:01 AM, Pronab Ganguly <pgangul...@gmail.com> wrote: > Thanks a lot for all help suggestion.Let me know if you have any experience > on file parsing using sqlite. > -P > > On Fri, Dec 4, 2009 at 6:15 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > >> > SQLite is an implementation of SQL. SQL is used to store information in >> a way that allows you to look things up more quickly than searching a flat >> file. If you can search for data your flat files fast enough to make your >> software work acceptably, you do not need SQL and your project will be >> simpler without it. >> >> You missed the point, Simon. Without SQL and SQLite Pronab will have >> to implement his own platform-independent file format which is much >> more work than just start using SQLite and use SQL. In this case using >> SQL will indeed be simpler than without it. >> >> To Pronab: if you're not familiar with SQL and SQL-based database >> concepts learn them first. After that you just need to understand how >> those concepts are applicable to SQLite and start using it. Some >> documents that can help at the beginning are >> http://www.sqlite.org/cintro.html and >> http://www.sqlite.org/quickstart.html. >> >> Pavel >> >> On Fri, Dec 4, 2009 at 7:36 AM, Simon Slavin <slav...@bigfraud.org> wrote: >> > >> > On 4 Dec 2009, at 11:50am, Pronab Ganguly wrote: >> > >> >> I am newbie to sqlite.Would like to is sqlite is better than flat file >> parsing? >> >> >> >> We have platform specific files of different formats to be read so our >> >> code is complex and difficult for maintenance considering support for >> >> newer platforms and backward compatibility. >> >> >> >> We are planning for a generic file, this is going to be same across >> >> all the platforms. The generic file can be a flat file also. Now >> >> initially I planned to write a flat file parser for the required >> >> information retrieval. Now came to know about sqlite.Please help me >> >> how can I use the power sqlite to support the above requirement >> >> basically to retrieve the information >> > >> > SQLite is an implementation of SQL. SQL is used to store information in >> a way that allows you to look things up more quickly than searching a flat >> file. If you can search for data your flat files fast enough to make your >> software work acceptably, you do not need SQL and your project will be >> simpler without it. >> > >> > Simon. >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
