sqlite

Secure information contained on iPhone SQLite DB

I am working on an iPhone app that uses CoreData(with SQLite) to stores some sensitive biographical data that is downloaded via a Restful Web Services for offline use in the device. I am worried that the competition could pay a subscription and extract the .sql file via SSH with a jailbroken device, and make copies of the data that has...

Managing large databases on iPhone devices: simple sqlite3 coding or CoreData?

Hi, I have to manage a table on a large database with over 20k records (the db size is 25MB). I use standard queries like SELECT\INSERT etc. programmatically using SQLITE framework. But the app on the Device is VERY VERY slow. When I tap the icon, the Default.png freezes for 10-20 seconds and the app crashes. When I run it on the simulat...

SQLite - table order in FROM clause affects query plan, why? (no explicit joins here)

Question to SQLite database engine. I have fairly complex question, which finds path in directed graph between two sets of known nodes, with exactly one node between (to be precise, path in public transport routes, but it has graph representation). Now something unexpected - there are no explicit JOINs in question (only conditions in WH...

SQLite on Android: Union with limits alternative

I want to create a Cursor, which later I will pass via CursorAdapter to AutoCompleteTextView for autocompletion suggestions. The problem is that my SQL statement needs to select 2 different result sets from the same table, just sorted by different criteria. At the same time these result sets must not overlap - otherwise I would have mult...

SQL Server CE - is an installation required (as opposed to just a DLL include) ?

Background - If I am building a WPF desktop application (VS2010 & .NET 4) and would like a lightweight database to use but without having to have a separate installation. SQLite would be OK from what I read however I was thinking it would be good to stick with the Microsoft bits and try to use SQL Server CE. Question - Does SQL Server ...

SQLite : INSERT and ORDER in the same time

Hello ! I have a table with 25.000 rows (columns with strings). I would like to improve my select query. "SELECT name FROM table WHERE name LIKE 'something' ORDER BY name LIMIT 15" The database will be static. I would like to know if it's possible to order a column when I am inserting a row in my table and if it will reduce the time ...

Strange crash with SQLite when finalizing a statement

I'm writing a C++ test app with SQLite, for which I made a small wrapper. I'm repeatedly reading some data with it, and the fourth time I do, when finalizing the statement, it crashes. I'm sure I'm matching each prepared statement with a finalize. The 4th time, before the crash, the data has ben read successfully. One curious thing: I...

Sqlite db, multiple row updates: handling text and floats

Hi, I have a large SQLite database with a mix of text and lots of other columns var1 ... var 50. Most of these are numeric, though some are text based. I am trying to extract data from the database, process it in python and write it back - I need to do this for all rows in the db. So far, the below sort of works: # get row using sele...

Subsequent insertion of records with QSqlTableRecord fail after first error

Hi, I have a problem with inserting data into SQLite database using QSqlTableModel. The table is created like this: QSqlQuery createTblSMS("CREATE TABLE sms_tbl(" "isRead BOOLEAN NOT NULL," "readTime DATETIME," "arrivalTime DATETIME NOT NULL," "sender TEXT NOT NULL," "receiver TEXT NOT NULL," ...

ContextSwitchDeadlock Exception while inserting data to sqlite database

I have a Sqlite Database where I am enumerating my directory structure and inserting records into 5 different tables. Total Files + Folders count = 4000. Also there is nested loops. Can say all loops runs for 4000 times cummulative to insert the records. Earlier it was built with Sql Server where it was running absolutely fine. It was t...

H2 Database vs SQLite on Android

Because of the lack of Unicode support on the embedded SQLite database in Android I am mostly interested in performance and stability of H2 Database vs Android SQLite Are you guys using it? Should I be aware of any H2 database shortcomings? ...

Creating .sqlite file from Core Data store?

I've seen tutorials in books and on websites that offer .sqlite files for download. The sqlite files are used for Core Data. How do I get a .sqlite file FROM an app or core data store on TO my desktop? ...

Need help with Database Access in Android

I'm using an sqlite database in my app. I have this dbhelper class in a services class like so. public class MushroomService { private int downloadprogress; private int databasesize; private DataBaseHelper myDbHelper; } public MushroomService(Context context) { myDbHelper = new DataBas...

SQLite : finding a function's minimum values

Hi folks ! I have those tables Node (#id, route_id, lat, lng) Route(#id) And I have four input values : $lat1, $lng1, $lat2, $lng2, which represent 2 GPS coordinates GPS1 and GPS2. I also have a distance function that I added to the database : distance( lat1, lng1, lat2, lng2) What I am looking for is the request that will give me ...

How to convert xml to sqlite database in android platform?

I have a xml file with info inside. I want to convert the xml file to sqlite database without using a SD card in android platform(Java Language). Does anyone have any idea how to do it? ...

SQLite DB in iPhone

Hello , Can you please tell me how to create SQLite DB in iPhone and to perform CRUD operations from objective c program to databases. How to do it programmatically?? I know to create DB and table through command line, but how to do it programmatically?? Help me.. Thank you. ...

SQLite database cached due to SVN.

My iphone application uses Core Data and a SQLite database; versions are being tracked using SVN. Adding data to the database is not reflected in the application. I make sure I delete the project out of the simulator and that the new database is added as a file to the project. I suspect the data is being cached in another location. Ple...

Count associations in sqlite database query?

I have a sqlite database with three tables: Notes, Lists, and Notes-in-Lists. Both Notes and Lists have an autogenerated id column and some extra data columns like title. Notes-in-Lists is an association table with an autokey, and two foreign keys that point to a Note id and a List id. I have a query that returns all notes in a given l...

On changing imageview src based on sqlite string field

I've seen this question asked before but it seems that the answer may be outdated. I'm pulling a numeric value off of a spinner and storing it in a sqlite database as a string. I have an imageview placed into the row xml file. I'm sure creating some sort of adapter is involved. How do i change the imageview source based on the value o...

When did PDO SQLite come into being?

What is the first version of PHP that started supporting the PDO_SQLite driver? I know it was PHP 5 that brought PDO into the core so I'm assuming that PDO_SQLite must have been in version 5.0 also... I want to know what requirements I'll need for a script using PDO_SQLite. ...