Sqlite database

[sarathainside]

Hi , I downloaded sqlite from their sourceforge site. How can I create a database in it ? and where can i see the file. For instance i need to see the database file as <filename>.sqlite.

All help would be appreciated.

regards

[traq]

Firefox has an sqlite add-on.

[sarathainside]

I have a terminal running with sqlite prompt. i'm able to create tables in it using sql queries. But i need to see where these tables are actually stored in the disk . In which file format .

Regards