sqlite

large databases in sqlite - file size considerations?

I'm using a sqlite db which is very convenient and seems to meet all of my needs at this point. Currently my db size is <50MB, but I now need to add a new table which will store large text blobs, which will cause the db to reach up to 5GB within the next year. Would sqlite be able to deal with a 5GB db size? Any caveats to that, compar...

What's the best way to migrate a Django DB from SQLite to MySQL?

I need to migrate my db from sqlite to mysql, and the various tools/scripts out there are too many for me to easily spot the safest and most elegant solution. This seemed to me nice http://djangosnippets.org/snippets/14/ but appears to be 3 years since getting an update which is worrying.. Can you recommend a solution that is known to ...

SQLite/iPhone read copyright symbol

Hi All, I am having problems reading the copyright symbol from a sqlite db that I have for my App that I am developing. I import the information manually, ie, from an excel sheet. I have tried two ways of doing it and failed with both: Tried replacing the copyright symbol with "\u00ae" (unicode combination) within excel and then import...

Why doesn't the OFFSETS function respect docid condition?

Why does SELECT OFFSETS(Data) FROM Data WHERE docid = 1 AND Data MATCH 'term' take same time as SELECT OFFSETS(Data) FROM Data WHERE Data MATCH 'term' And how can I make it work fast, i.e. just for one record? Thanks! ...

Create SQLite database in android

I want to create a SQLite database in my app, which contains three tables, I will add data into tables and will use them later on. but I like to keep database ,as if when app is first time installed it checks whether the database exist or not, if exists it updates it else if not then creates a new database. further more I am making a D...

SQLITE basic syntax

I seem to misunderstand a basic syntax, why this sample works: sqlite3_prepare_v2(db, "insert into test values('boo','boo',0);", strlen(querystring)+1 , &stmt, NULL); if ((rc = sqlite3_step(stmt)) != SQLITE_DONE) fprintf(stderr, "Error: sqlite3_step() %d. Error Message %s;\n",rc,sqlite3_errmsg(db)); But when I try this query: "inse...

DISTINCT clause in SQLite

Hello. Recently i found that SQLite don't support DISTINCT ON() clause that seems postgresql-specific. For exeample, if i have table t with columns a and b. And i want to select all items with distinct b. Is the following query the only one and correct way to do so in SQLite? select * from t where b in (select distinct b from t) Samp...

How do I connect to SqlLite db file from c#?

Hey all... I am trying to connect to a sqllite db from with a c# application. I have never worked with SQLLite before. var connectionString = @"data source='C:\TestData\StressData.s3db'"; connection = new SQLiteConnection(connectionString); connection.Open(); When i attempt to open the connection I get the fol...

Followed the official android documentations but still could not use SQLite in app

My DBHelper class public class DBHelper extends SQLiteOpenHelper { public DBHelper(Context context) { super(context,"SIMPLE_DB",null,1); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE SIMPLE_TABLE ( " + "ID INTEGER PRIMARY KEY " + "DESC TEXT);"); } @Override public void onUpgrade(SQL...

Question regarding ideal database implementation for iPhone app

So I have a question about the ideal setup for an app I am getting ready to build. The app is basically going to be a memorization tool and I already have an sqlite database full of content that I will be using for the app. The user will navigate through the contents of the database(using the uipickerview), and select something for mem...

SQLITE - INSERT does not return error but no data is inserted.

I am attempting to insert data into a local SQLITE database file from a C# application. The transaction does not throw any errors but the data is not inserted. The same insert statement works from within a query analyzer. Do I need to perform a commit? Is there a Commit method? Command's transaction property is null.. var command = ...

Android: Can rawQuery be used for a local search in Android apps?

Hi everyone, I am trying to implement a local applications search for my Android app and I'm having difficulties. I've set up my searchable.xml: <?xml version="1.0" encoding="utf-8"?> <searchable xmlns:android="http://schemas.android.com/apk/res/android" android:label="@string/app_label" android:hint="@string/search_hint" > ...

How to append an integer to a const char value in iphone?

I have sql query statement which used to display the contents in the table.The sql statement consist of a where clause which is to be appended with numeric value as 1 ,2 3 etc depends upon the previously selected content.I am having the numeric value as int and i want it to append to sql statement which is const char.how can i append bot...

SQLite query does not finish execution whereas Access takes a minute to run

I am stuck very badly at trying to make an SQLite query finish execution and currently have no bright ideas. Also, I am new to the field of writing SQL queries, and I am still learning the concept of database indexes, etc.. I am migrating an application from Access to SQLite and the query takes around 1 minute to run in Access. The quer...

How could i send a html5 sqlite database from an iphone ?

Hi everybody, i'm developing a webapp for iphone/ipod and using the client's side database. I want my webapp to work mainly offline and allow users to fill the database and at a certain point i'd like to send my database to a server to process and store all the informations. The problem is i can't find a proper way to send my tables to a...

DataMapper import primary key

I'm running an import script which imports a CSV dump of a database into a local sqlite database using DataMapper. My models look like this: class Staff include DataMapper::Resource property :staff_id, String, :key => true property :full_name, String end class Project include DataMapper::Resource property :pro...

how do i take advantage of sqlite manifest typing / type affinity using sqlalchemy?

I like the idea of sqlite's manifest typing / type affinity: http://www.sqlite.org/datatype3.html Essentially, if I set a column's affinity as 'numeric', it will duck type integers or floats to store them as such, but still allow me to store strings if I want to. Seems to me this is the best 'default' type for a column when i'm not su...

Is it possible to have an enum field in a class persisted with OrmLite?

Hello. I'm trying to persist the following class with OrmLite: public class Field { @DatabaseField(id = true) public String name; @DatabaseField(canBeNull = false) public FieldType type; public Field() { } } The FieldType is a public enum. The field, corresponding to the type is string in SQLite (is doesn't support enums). Wh...

Are there any good ORMs (preferably JPA implementations) that support SQLite (on Android)?

I found a post from a while ago that addresses a similar question but I think it's a bit outdated. I realize implementations of JPA tend to be more on the heavy/dense side, so if you know of any lightweight (non-JPA) ORMs I'll most certainly appreciate your input. I did see the answer about ActiveAndroid in the other post and am curious ...

Is there any time estimation about sqlite3's open speed?

I am using SQLite3 in C++, I found the opening time of sqlite seems unstable at the first time (by that I mean the time to open windows and open the db at the first time). It takes a long time on 50M db, about 10s in windows, and vary on different times. Has any one met the same problem? I am writing a desktop application in windows, ...