> 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
