i've come across many android database application.

A few of the application have its database with .sqlite extension although some have .db extension.

What's the difference betwwen individuals both ? Should it both contain various things ?

Help me for your.

And what ought to be the best for the android database ?


.sqlite file is really as the title suggests personal files that consists of SQLite database. .db may be the file extension utilized by Oracle, Paradox and XoftSpySE databases

You are able to title your SQLite database anything you want. This content isn't based on the file ending but with a sequence of bytes which start every sqlite (3) file:

0x53 0x51 0x4c 0x69 0x74 0x65 0x20 0x66 0x6f 0x72 0x6d 0x61 0x74 0x20 0x33 0x00

Quite simply, it may be exactly the same database content. There's no difference, as lengthy because the creator didn't put other bytes inside it.

extensions does not matter. you may also omit any extension for your database file. Its only for the knowledge of developer to understand which file types is. A minimum of that is what in my opinion :)

Whenever you produce a database you simply will give title towards the database that you simply create. therefore the extension doesn't make a difference.. Sqlite browser will recognise it anyhow