I have a quite slow data retrieval from a sqlite database on my iPhone and perhaps someone have an alternative idea to explain this. From what I tracked down so far sqlite3_step(statement) is sometimes unusually slow. While retrieving e.g. 50 rows from the database to execute this step takes normally some milliseconds but sometimes it t...
Hi, QUESTION: How can I handle potential contention between two separate threads accessing the same Sqlite database? BACKGROUND: I have a C# Winforms application that uses Sqlite via ADO.net. I do have a backgroundworker thread in the winforms application. I have noticed that I can get an exception when both the main thread, and the...
Hello, How to store pdf,png file in sqlite. is this possible to store pdf and png file? Please help me out. if you have any idea please share with me. Thanks you, ...
My app has a SQLite database that users can read only. I, the developer, would like to add entries to the database from time to time and make the enlarged database available as a file on a Web server. I'd like the users to be able to "check for updates". My question is, once a user checks and finds that an updated DB file exists, how ca...
When trying to use SQLite with System.Transactions TransactionScope with the identity generator as Increment, i noticed that i was getting an exception (given below along with code) when NHibernate was trying to retrieve the next Identity number. This seems to be because the new SQLite connection is doing a auto enlist of the current tr...
I used core data to do this: NSManagedObjectContext *m = [self managedObjectContext]; Foo *f = (Foo *)[NSEntityDescription insertNewObjectForEntityForName:@"Foo" inManagedObjectContext:m]; f.created_at = [NSDate date]; [m insertObject:f]; NSError *error; [m save:&error]; Where ...
Usually i write my where statements as WHERE key=@0 then add a param. Now i would like the user to specific a few letters such as 'oat' and would like to stick wildcards around it %oat% which matches 'coating'. So how do i write the query so wildcards are around the user input (the 'seachword'). Now lets take it a step further. I would ...
How to compile SqlCipher on windows to get exe file? ...
I have an app that is a list of tasks, like a to do list. The user configures the tasks and that goes to the SQLite db. The list is displayed in a tableview. The SQL table in question consists of a taskid int, groupname varchar, taskname varchar, lastcompleted datetime, nextdue datetime, weighting integer. I currently have it working ...
Approach #1 where I have native SQL and I can change it whatever I want if (sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK) { const char *sql = "select coffeeID, coffeeName from coffee"; sqlite3_stmt *selectstmt; if(sqlite3_prepare_v2(database, sql, -1, &selectstmt, NULL) == SQLITE_OK) { while(sqlite3_step(sele...
Hi, I have this sql statement SELECT * FROM Language WHERE LanguageCode=? where LanguageCode is a varchar(2). When I use sqlite3-prepare-v2 on that statement I got SQLITE_ERROR but if I use SELECT * FROM Language WHERE LanguageID=? where LanguageID is the primary key numeric identity field the statement compiles just fine. Is there an...
I understand the title may sound confusing, but the goal is very clear: I am building an application that requires two tables: tracks and waypoints. A user enters the track name via a textfield and the table generates an ID under track_id. in the waypoints table there is a column called track_id_fk. When the OnLocationChanged() metho...
Hi, I have a really strange problem. I need to build custom sqlite3 database engine under Android OS, but I also want to use database provider implementation. Unfortunately when examining sources of Android 1.6 I noticed that it's not so easy. Many classes including android.database.; packages use original provider, also many other pa...
I would like to use a sqlite databse inside MS Access in order to use (transfer would be good enough) the content of sqlite database table in MS-Access. How can this be done in VBA ? EDIT: This "Application" is for a client and I can not make him install "extra software" than the one already installed (in this case MS-Access): Does...
I've installed the System.Data.SQLite ADO.NET Provider from http://sqlite.phxsoftware.com/. I can connect to the database from within Visual Studio, I can open table schemas, views etc. I'd like to use an existing SQLite database to create an Entity Framework model in Visual Studio 2008. When I try to create a new ADO.NET Entity Data M...
Hi, I am trying to populate a ListView in a separate class with data taken from a SQLite database held in another class. What would be the easiest way to do so? Thanks ...
Hi All: We are using SQLite database to store data. We are having a very peculiar situation. Let me summarize Database having multiple tables. Tables having 3000 rows. Tables are having index. There is considerable gain due to indexes. When I run the application and access certain data the query runs slow. But if I just open the datab...
I'm trying to learn how to use the UITableView in conjunction with a SQLite back end. My issue is that I've gotten the table to populate with the records from the database, however I'm having a problem with the section titles. I am not able to figure out the proper set up for this, and I'm repeating all tasks under each section. The ta...
I was wondering if there is a nice IF NOT EXISTS for checking columns and indexes in SQLite, or do I need to bring back the entire database schema and validate against that? ...
I'm generating about 6 wav audio files at runtime. I want to store them in internal memory. Is a blob to sqlite the right/recommended way? ...