sqlite

Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); However, I am getting an error when I try to do something like this. Is it possible to insert multiple rows at a time in an SQLite databa...

SQLite always does a Full Table Scan when like used?

I have a text column containing URLs that are uniqe. I need to do a SQL pattern match query, say using the 'like' SQL operator. In such a scenario, will SQLite do a FTS ( Full Table Scan ) regardless of whether I have an index on that column or not ( column is a primary key )? It seems to be that its doing a FTS as the speed of operat...

Exporting Sqlite data from an Android Application

My Android application stores all user data in a Sqlite database. What are my options to backup/export/import/copy this data? I know I can easily copy the database to the SD card. I would also like to send the data to a network server. Are there any packages/classes available to facilitate getting sqlite information to/from a network...

QT sqlite deploy exe

I have a Qt exe built from visual studio 2005(after taking the .cpp, .h, .moc, ui_ files) I have done some simple QSqlite queries. It works fine in my development pc. But in another pc it crashes for the line below: QSqlDatabase mSqlDb How to run the exe so that it can interact with sqlite from another pc. [Any...

How to Store BLOB data in Sqlite Using Tcl

Hello: I have a Tcl TK application that has a Sqlite back-end. I pretty much understand the syntax for inserting, manipulating, and reading string data; however, I do not understand how to store pictures or files into Sqlite with Tcl. I do know I have to create a column that holds BLOB data in Sqlite. I just don't know what to do on ...

Does using the sqlite3 .import command overwrite data in the destination table?

Does the sqlite3 .import command used to import data from delimited text files append rows to existing content if the destination table is not empty, or does it clear the table first? ...

Check table name to update data (sqlite)

I have two table like this table_CN (_id, name, phone, favorite, title) table_EN (_id, name, phone, favorite) Then I select _id value from two table SELECT _id, name, phone, favorite FROM table_CN where _id='15'UNION SELECT _id, name, phone, favorite FROM table_EN where _id='15' After that I don't know how to determine which table...

SQLite saves float values in integer

I'm using System.Data.SQLite to save data to database. In table there are 2 columns defined as float. However when I save data to DB it saves only integer part. 12.2345 => 12 11.5324 => 11 (I don't know how exactly it rounds, it just rounds) Yes I'm sure I'm using floats in my application, and I'm sure that CommandText contains float n...

Subsonic 2.2 & Sqlite

Hi, I've tried to use Subsonic 2.2 & System.Data.Sqlite.Dll latest version (1.65.0), in my project. and recevied an error message, which gave me the idea subsonic got a problem with the sqilte provider. I've switched to it's previous version, 1.60.0 and it seems like the problem was solved. any info regarding this issue? does subsoni...

Trying to plot a map using lat, lng for a sqlite DB, but CANT get my location before the map draws. UGGG!

What I can do: Take a sqlite DB of 100 lat and lng points, and drop those pins on a map. Looks GREAT! What I would like to do is get my location, BEFORE I draw my map. But it seems that: (void)locationManager:(CLLocationManager *)manager didUpdateToLocation:(CLLocation *)newLocation fromLocation:(CLLocation *)oldLocation ALWAYS fir...

On some computers application can't load sqlite dll file

Hello! I wrote an application that uses sqlite and it works great on most of the systems. It is written in C#, and the only non-framework assembly is sqlite, which is included by System.Data.SQLite.dll . I deploy it the same way on all of the machines (copy pasting the exe file, the database file and the System.Data.SQLite file). It wo...

Parameter binding fails where concatenation works

I am trying to execute the following sql from php using pdo: SELECT * FROM my_table WHERE name=?. When I do this: $sql = 'SELECT * FROM my__table WHERE name=?' ; $stmt = $dbconn->prepare($sql); $stmt->bindValue(1, $_POST['name'], PDO::PARAM_STR); $stmt->execute(); I get an empty result set. When I do this: $sql = 'SELECT ...

How do I use the SQLite3 import command using the C API?

I have the following code: int rc; rc = sqlite3_exec(sqlite3_database, ".import mydata.csv mytable", callback, 0, &errMsg); After this gets run, errMsg contains this error message: near ".": syntax error I assume that it does not recognize the import command. However, this command works when running it from the sqlite3 program on t...

What are Sql Browser with foreign key / references support?

I now want to create foreign keys for all of my mew DBs. So far i have been using sqlite and MyIasm DBs so i havent used a DB that supported it. I am thinking i should install and use a MySql server with InnoDb (connected via C#). My question is what can i use to actually see the FKs relations? I would like to see it by using a sqlite d...

Cocoa Application Framework with Packages

Ok, I am creating a document-based application in Cocoa and the document's file type is actually a package. Within that package is an XML settings file, a SQLite database and a zip file which is downloaded at runtime. Now the only thing that changes, really, is the XML settings file as the other ones can be recreated at run-time. Each...

Entity Framework with SQLite

I am trying to create entities out of a SQLite database. SQLite doesnt have foreign keys, therefore I cannot map associations between entities. Is there a way to map them somehow? ...

What's the best way to access an SQLite database in Microsoft Excel

hello, I am trying to do a simple shared database for a small workgroup of people, who use Excel for their data. I am thinking SQLite, because I don't really want to go server, as there are only 5 users and they're all local, and the database is very low intensity. What's the best tool for accessing SQLite via Excel? Thanks. ...

Using NSMigrationManager to append data to Core Data Persistent Store

I would like to append the contents from one sqlite file (that has been created using Core Data with a Model A) to another sqlite store that is used by my application (which uses the same Model A). The idea is to quickly import large amounts of data. The problem I am facing is that the code below only works once. When I try to run the ...

SQLite on iPhone - Get final query string with parameters after binding

I would like to get the final SQL query, with parameter values bound (replaced) for debugging. It is a rather large and complex query (some joins, and about 20 parameters). Just wondered if it was possible to access the final query passed to the sqlite db. //PSEUDO CODE theSQL = "SELECT a,b,c FROM myTable where aField = ?"; sqlite3_pre...

Increasing memory usage in sqlite3 ?

I've written a console app which receives events via boost::interprocess memory and dumps the info into an sqlite3 database. While running the app I've noticed that, in the Windows task manager, the memory usage was cyclically increasing every... 30s-1min. This led me to believe that the problem lies within the main loop in which I execu...