How do I create a sqlite 3 (.sl3) database file?

views:

168

answers:

How do I create a sqlite 3 (.sl3) database file?

I have a *.sqlite file... but I need the database in *.sl3 format? What software/tool can I us to create that?

What are the steps?

This is to be used in an iPhone app. Original developer used an .sl3 file, now that I have updated the DB - I can't seem to export/generate a .sl3 file

I have tried just changing the extension - all the way to inserting the *.sqlite file in XCode and pointing the app delegates to the new DB file format... doesn't work.

Thanks in advance...

+2 A:

If you open sqlite3 database with SQLITE_OPEN_CREATE you create the database if it does not exists (Documentation of sqlite3_open). You can dump database from CLI by dump command.

Maciej Piechotka 2010-03-20 18:59:06

Just rename the file. SQLite doesn't care about file extensions. You could call it "mydatabase.froggy" if you want.

Update: Reading more closely, I see you've tried renaming it. That should work, as I mentioned above. What kind of error are you seeing?

Larry Lustig 2010-03-20 19:03:26

The issue was something in the content, the way I imported the .csv file into the database cause something. I imported the rows a few at a time - and somehow made my way thru all 600 rows with no error. DB complete... and it worked in the app. weird. probably an encoding issue with the content or .csv itself.

BC 2010-03-28 04:02:43

ansaurus

tags:

views:

answers:

How do I create a sqlite 3 (.sl3) database file?

related questions