How to use sqlite?

Unity Engine
,
1

As I found, Mono supports sqlite for both iphone and android.

Also, I found some packages helpful.

Here’re my questions.

  1. In order to use sqlite, what files do I need?

I mean, a package I got has many files such as “Mono.Data.dll”, “sqlite3.dll”… in “/Assets/plugins” and /“Assets/plugins/Android”.

Do I just need to put them all in my project?

  1. How to create database?
    The code I got has like this.
f (Application.platform == RuntimePlatform.IPhonePlayer) {
dbconn = new SqliteConnection("URI=file:" +Application.dataPath + "/../Data.db");
} else {
dbconn = new SqliteConnection("URI=file:" +Application.dataPath + "/Data.db");	
}

dbconn.Open();
...

But I don’t have database file like “Data.db” because I didn’t create it yet.

So, I think I should create database of mine, then open it. am I wrong?

Anyone helps me. i can’t wait to know it.

Thanks in advance.!

2

I found all I was curious about. Thanks :stuck_out_tongue: