sqlite

Sending sqlite db over network

I have an sqlite database whose data I need to transfer over the network, the server needs to modify the data, and then I need to get the db back and either update my local version or overwrite it with the new db. How should I do this? My coworker at first wanted to scrap the db and just use an .ini file, but this is going to be data tha...

Querying SQLite DB in Android Activity - saying no column found, although it exists

See title for explanation. Here is the method I'm using: public Cursor getClientByName(String name) throws SQLException { name = name.trim(); Cursor mCursor = mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID, KEY_NAME}, KEY_NAME + "=" + name, null, null, null, null, null); if (mCursor != ...

replacing linebreaks with <br> to use in UIWebView

I am pulling my data from sqlite and trying to show it in a UIWebView I have tried HTMLData = [container stringByReplacingOccurrencesOfString:@"\n" withString:@"<br />"]; HTMLData = [HTMLData stringByReplacingOccurrencesOfString:@"\r" withString:@"<br />"]; HTMLData = [HTMLData stringByReplacingOccurrencesOfString:@"\r\n" withSt...

After a new install, the SQLite3 old version persists (OS X)

I've installed the newer version of SQLite3 (3.7.0.1) on my macbook (OS X 10.5) but 'sqlite3 --version' gives me the older version I had on my system: $ sqlite3 --version 3.4.0 I suppose I was expecting this version to be overwritten but that doesn't seem to be the case. Can anyone clue me in? I'd really appreciate it, right now I'm t...

sqlite3 linking problems

I'm having troubling linking a program with sqlite3. Any ideas? gcc -g -O2 main.o work.o uuid.o sqlite3.o -lboost_system -lboost_thread -o server sqlite3.o: In function `unixDlError': /home/matt/dev/serv/sqlite3.c:27231: undefined reference to `dlerror' sqlite3.o: In function `unixDlSym': /home/matt/dev/serv/sqlite3.c:27258: undefi...

Portable JDBC vs SQLite on Android

I am using SQLite in a project used by an android application. Currently I am using the SQLite implementation provided in android.database.sqlite. I want to make a desktop application which uses the same codebase. So I need to separate all the shared behaviour into a separate portable project/jar. My problem is I'm currently making hea...

Database sync between iphone's local db and a remote central db

Hi evry1, i 've a local database running in iphone app loaded from sqlite....now i need to sync the local db with the database on the server if the user wishes to do so..can any one help me with this.... Thanks in advance!! ...

Andrdoid SimpleCursorAdapter / Listview problem

Hi all, I have a problem displaying the results of an sql query into a list view via SimpleCursorAdapter. This is my query: String sql = "" + "SELECT (Clients.firstname || \" \" || Clients.surname) AS client_name, " + "Visits._id, " + "Status.status, " + "strftime('%H:%M',time(sql_start_date,'unixepoch')) as start_time, " + ...

Inserting an image into a pre-developed SQLite DB for use with Android

Hello all, Ive developed a DB for use with my app but I've realised that I actually want extend my db to incorporate images! I will be hosting the db online but for now I am using it locally for development purposes. To create my db I have been using SQLiteBrowser, which I think is a standalone version of the Firefox SQLiteManager plugi...

Where can I find an iPhone address book with sample data ?

I'm developing an application that get access to the iPhone address book. The simulator contains only a few sample entries. I'd like to find a sample address book with thousands of entries with various character set (English, Chinese, Arabic, etc) to fully test my app. Filling the address book myself will take for ever. Basically I need...

Access SQLite from different processes

I'm developing an application that uses SQLite as the primary data storage method. I have two processes running for my app using an alternate entry point. I need to access the same DB from the two different processes but as we all now SQLite is not like a server DB engine, it can only be accessed once at a time. I wanted to know if the...

Android: how cancel/interrupt/break pending SQLite query?

In my Android application user can fill database with imported data, then perform predefined, complex SQL query. With some data pattern, query will take very long (minutes and more on HTC Hero), while common usage will not exceed 10-15 seconds. Is there any way to cancel pending SQLite query on Android? Timeout would be as good as well,...

Copy a file included with an Adobe Air application out of the Application so that it can be modified.

Is it possible to provide an existing SQLite file with an Air installer, and have the Air application copy it out to local storage upon first execution so that it can be modified? Or do I need to take my pre-made db and recreate it on the fly with Air on execution (store all the queries required to create the tables/data in the applicat...

Need to load a DLL to use SQLiteWrapper in C#

I am trying to access my databases in C#. The databases are SQLite and I am trying to access it like so: string CurrentDatabase = Path.FullName + "\\stock.sqlite"; SQLiteBase db = new SQLiteBase(CurrentDatabase); I am using a SQLite DLL I found here to access the database: http://www.codeproject.com/KB/database/cs_sqlitewrapper.aspx...

"0 tables, 0 records" after pushing a non-empty sqlite database to Heroku

I created a small sqlite database on my laptop and it has several records: sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE "bus_bingo_tile_templates" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "title" VARCHAR(50), "alt" VARCHAR(50), "image_filename" VARCHAR(50), "enabled" BOOLEAN); INSERT INTO "bus_bing...

Sqlite undefined reference to `sqlite3_open' error in Netbeans C++ on Ubuntu, Integrating SQLite into Netbeans C++ Ubuntu

Hi! I am trying to use Sqlite in my Netbeans C++ and following the tutorial here http://www.dreamincode.net/forums/topic/122300-sqlite-in-c/ When i build it,its giving me undefined reference to `sqlite3_open' and the other sqlite3 functions. I included the sqlite3.h too. What am i missing here? When i added the linker to static libr...

SQLite & C# ] How can I control the number of people editing a db file?

Hi, I'm programming a simple customer-information management software now with SQLite. One exe file, one db file, some dll files. - That's it :) 2~4 people may be going to run this exe file simultaneously and access to a database. Not only just reading but frequent editing will be done by them too. Yeahhh now here comes the one of ...

What SQLite library do you recommend on the iPhone/iPad?

A few people have wrapped the SQLite library or provided alternatives. What are their relative merits? ...

How can I design a dict like sqlite class in python which can using different field as "key"?

Hi All, I have a such a data structure, "ID NAME BIRTH AGE SEX" ================================= 1 Joe 01011980 30 M 2 Rose 12111986 24 F 3 Tom 31121965 35 M 4 Joe 15091990 20 M I want to use python + sqlite to store and query data in a easy way. I am in trying to design a dict like...

NHibernate, SQLite, and Cyrillic characters: case sensitivity and fallback queries

I'm querying an SQLite database using NHibernate. Generally, I want to do case insensitive string queries. Recently, I've discovered that although I can insert a row with Cyrillic characters, I can not select it using a case insensitive query. This is what the query looks like: string foo = "foo"; IList<T> list = session.CreateCriteria(...