Is it possible to preload Sqlite DB on Palm Pre?

⇧

⇩

51 views

I have a Palm Pre app that has a large(ish) database. I would like to transfer the database directly to the phone rather than having the app create the database.

What I tried is to create a sqlite file on the PC using a simple python script, then have the app create an empty extended db in the media/internal folders, then copy the PC file over the one created on the phone. However I get an error when trying to read the file: "database disk image is malformed".

Has anyone succeeded in doing something like this?

database sqlite webos

asked June 25, 2011 9:16 am CDT

rslite

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

Created] (SLING-2061) Preload a configured set of resource bundles from the repository
April 28, 2011 10:01:10 PM
Preload a configured set of resource bundles from the repository

Re: sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator
September 20, 2010 08:08:52 AM
This is a multi-part message in MIME format. Have you timed the entire application instead of just the SQL query? Put both apps inside a system() call and time those. Are you sure they are both compiled with the same optimization? Michael D.…

sqlite queries execute faster in sqlite manager addon but take a lot of time to execute using a java
June 3, 2011 08:30:21 AM
Hi One of my sqlite query executes faster in sqlite manager( firefox addon ) but take a lot of time to execute using a java program. Here is the snippet PreparedStatement mStatement; ResultSet mResults; …

appropriate Uses For SQLite
September 30, 2010 03:18:30 PM
I am looking into the best method for implementing a database for a small application that I will most likely be building it in Adobe Air. I looked at "Appropriate Uses For SQLite" on the the SQLite.org website and I got some conflicting info. …

IF-THEN-ELSE sqlite
April 3, 2011 08:46:28 AM
Hi I would like to do the following I have an item to insert in the table which will be inserted only if this item is not yet in that table otherwise I would like to return the item's key. like that IF 1==SELECT COUNT(*) from table WHERE…

Nth row of on sqlite DB
October 14, 2010 10:53:40 AM
Hello, I’ve been adding and deleting rows from the sqlite database. Now the primary ID is non-sequential. 1. How do I get the nth entry in the database 2. AND, How do I get the first n rows from the database ? Thanks, Kavita

ANN: C#-SQLite 3.7.6.3
June 24, 2011 01:31:01 PM
C#-SQLite has been updated to release 3.7.6.3 and is now ready for use. The 6/24/2011 release features: * Updated to SQLite version 3.7.6.3 * Silverlight support * Windows 7 Phone It now runs 58,100 of the tcl testharness tests without…

SQLite 3 and FK
December 6, 2010 06:20:16 AM
(First of all sorry for my "inglish") 3 tables : Owners Models Cars My difficult is recreate a kind of "referential integrity" through FK With 2 tables not problem but with 3 cascade table ..... Owner: PK IDowner Models: PK IDmodel Cars:…

ANN: C#-SQLite 3.7.5
March 1, 2011 10:42:13 AM
C#-SQLite has been updated to release 3.7.5 and is now ready for use. The 2/28 release features: * SQL_HAS_CODEC compiler option * Silverlight support * Windows 7 Phone Does not support WAL It now runs 54,618 of the tcl testharness tests…

SQLite bug
October 16, 2010 06:30:12 AM
Sorry, but all 3.7.x versions, compiled usind OpenWatcom for OS/2, can not create database file. For example, when I run * shell test.sqlite * where test.sqlite is absent, and try to create table, say, *create table a (b int);* I got message …

bug with sqlite
March 29, 2011 06:37:01 AM
hi why isnt it possible to create a database file with the name "con" ? i just doesnt work. no matter what file extension im taking. regrets Felix

Re: IF-THEN-ELSE sqlite
April 3, 2011 03:49:33 AM
Hi I would like to do the following I have an item to insert in the table which will be inserted only if this item is not yet in that table otherwise I would like to return the item's key. like that IF 1==SELECT COUNT(*) from table WHERE…

64 bit sqlite 3
December 17, 2010 03:36:55 AM
There is a version of SQLite 3 for 64-bit systems? or, you can simply compile the source of sqlite3 at 64-bit with c++ 2008? thanks.

Re: bug with sqlite
March 29, 2011 07:38:00 AM
Just to help clarify (hopefully) the Unix/Windows "reserved filename". CON: is similar to Unix's /dev/zero or /dev/null for example -- Files that already exist and have OS meaning. stdout is NOT a reserved filename...it's a predefined variable of…

Re: sqlite WAL mode
February 23, 2011 09:09:46 PM
Michael D. Black, Thank you for your suggestion use the sqlite 3.7 WAL mode. We wrote a small test program to open 2 WAL connections to the main database and insert 5.4 million rows into a table. The code is shown below. We wiil add sqlite error…

Re: Optimization SQLite
March 14, 2011 10:51:31 AM
Email forwarded to the sqlite-users mailing list. I use gcc and gdb and plain old text editor. I am not able to recommend an IDE since I don't use one. On Mon, Mar 14, 2011 at 11:16 AM, Thiago Gregolon <thiagog### @gmail.com>wrote: …

DB extraction from SQLITE
March 8, 2011 09:22:15 AM
Hi, I am working on embedded arm linux.I am trying to extract records form a local database of sqlite using QT Application. My local database is of size 2.6MB and contains almost 1.2 lakh records , each record has three fields (ID, name,…

Re: sqlite DB extraction
March 8, 2011 09:21:28 AM
You go from 2 minutes to 30 minutes just based on clock speed. I would imagine you don't have much disk cache on the ARM device, so every time you read the database it has to hit the file system....ouch.... Did you benchmark your PC system without…

sqlite DB extraction
March 8, 2011 08:52:47 AM
Hi, I am working on embedded arm linux.I am trying to extract records form a local database of sqlite using QT Application. My local database is of size 2.6MB and contains almost 1.2 lakh records , each record has three fields (ID, name,…

Re: Optimization SQLite
March 14, 2011 11:26:21 AM
Try CodeBlocks Cross-platform and works with gcc or MSVC or pretty much whatever. I put in gcc 64-bit for it. http://www.codeblocks.org/ Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate

Questions and Answers are licensed under cc-wiki license.

Is it possible to preload Sqlite DB on Palm Pre?

0 Answers

Be the first to answer this question

Join with account you already have