sqlite

How do I 'drop' an sqlite DB on an unrooted Android phone?

Before I found out about that adb shell doesn't have the permission to do much with /data/data I was using my unrooted Verizon Droid for development of a content provider. How do I get rid of the database I created there? Is my best option writing a small app that drops the database? ...

ActiveRecord migration change primary key for no reason

I've got a table with five columns, one of which is the primary key. This primary key is using a non-standard name, like nearly all tables in that database. I've added a migration to rename the other four columns in that table. The problem is after running that migration, the primary key constraint is gone! I've done that renaming thing ...

adding a new sqlite field problem...

I've added a new field to an SQLite db table and have also added a new attribute in core data xcdatamodel. I made sure to delete the app from the iphone simulator. the app runs fine, but isn't finding the new field. if i change the data on an existing field in SQLite and relaunch the app, the change is there. the new field is not. anyo...

iphone database problem

Iam making a tab-based application where in first tab i have a custom button. and in second tab i have a table view which loading database from sqlite. in that custom button selector i have called viewlo. whose body is like this: info *viewer=[[info alloc]init]; [[self navigationController] pushViewController:viewer animated:YES]; [...

core data adding a new field to an existing sqlite table

I have an sqlite table that I'd like to add a new field to. Would I add the new field directly in sqlite or does the Core Data model change the sqlite table itself? I'm stuck for some reason right now w/ adding a new field to the db table. thanks for any help. ...

SQLite3 - Library routine called out of sequence

When running the following prepare statement for a SQLite3 db-selecct query I get a SQLLite Error 21 "Library routine called out of sequence": sqlite3 *lDb; sqlite3_stmt *lStmt; NSNumberFormatter *lNbrFmt = [[[NSNumberFormatter alloc] init] autorelease]; // Define SQL statement NSString *lSql = @"SELECT secti...

Full Android Database Helper class for existing SQLite database?

Hello, I'm trying to deploy an application with an existing SQLite database. I've been reading though the examples that are posted but they are always missing some part of the class. I feel like I'm trying to bake muffins but no one told me to use baking powder. Can someone post a full database helper class for depoying an SQLite data...

Can SVN copy sqllite?

my goal is to have a CMS that is totally self-contained like a flat-file CMS but still having database features. Am I correct that if I have a CMS based on sqllite that I can use SVN to copy it along with all my other code? Isn't that the kind of database sqllite is, just one file? Thanks. ...

Access Chrome History through JDBC

Hi all, I'm trying to connect to the chrome history database (sqlite) via a java application and run some queries in read only mode. I'm using sqlite.jar but when I connect, I get the following error: org.tmatesoft.sqljet.core.SqlJetException: BUSY: error code is BUSY I know some applications can access the file without copying it first ...

Android SQLite and Bind Variables Problem

I'm trying to do a relatively simple bitwise query operation with SQLite on Android. When I use bind variables, I get no data returned when I believe should get some rows back. If I hardcode the bind variable's value directly into the SQL, it works just fine. I'm thinking I have some silly syntax issue somewhere, but I just can't see ...

Accessing SQLite database with PHP

Hi all. I am interested in using a SQLite database in my next project because it needs to be ultra-portable and a simple file that a class can connect to and use as a database seems perfect. After Google'ing a bit I found this: http://php.net/manual/en/book.sqlite.php But that seems to work with an older version of SQLite and doesn't ...

SubSonic not recognizing SQLite foreign keys

I'm using SubSonic 3.0.0.3 and I can't seem to get the ActiveRecord .tt files to recognize and generate code for the foreign keys and relationships in my SQLite database. I think it generates everything else just fine, but after looking at other snippets online it looks like there should be more generated code than just single classes ...

Setting Up PHP & SQLite with a "Command Script"?

Hi, I'm trying to setup PHP & SQLite on my mac with by following this page: http://developer.apple.com/mac/articles/internet/phpeasyway.html. The code posted on the site is supposed to be run in a command script but I don't know how to make that happen. I've tried making a bash script and an applescript but both of those give errors. Any...

get data into sqlite from yahoo finance.

I trying to get yahoo prices into sqlite... I have the code below, but cant get the data into ipull [] then into sqlite... from urllib import urlopen import win32com.client as win32 import sqlite3 RANGE = range(3, 8) COLS = ('TICKER', 'PRICE', 'Vol') URL = 'http://quote.yahoo.com/d/quotes.csv?s=%s&f=sl1v' TICKS = ('GGP',...

Which should I use for working with a large amount of data, MySQL or SQLite?

I need to work with a fairly large amount of data, and am considering both MySQL and SQLite. So I'm trying to get a good, high-level overview of both packages: How well do each handle large databases? Is SQLite as much of a handful to work with as MySQL? Are there any good (web-based) resources comparing these two? ...

[python] need checking and padding sqlite database housekeeping and manipulate code

All, Update: based on google result and answer, I added more hints, still not finished. In using sqlite3 and during study of sqlalchemy, I found it is necessary to write below code for those housekeeping purpose for managing data, however, it may be a hard part for me to doing that in sqlalchemy then I turning back to sqlite3 module. ...

Is SQLite is suitable for personal database?

I've done some reading about SQLite. Can someone confirm if it is suitable for personal database which require a lot of calculation, analsis and graph? Currently I am working on Excel on 63 files sizing of 1.34GB. I will be creating a million row and maybe 45+ column depend on which table. ...

1) Can SQLite use cluster? 2) Does SQLite have anything like MySQL Workbench? 3) How to import Excel to SQLite?

1) If MySQL have cluster option, I wonder if SQLite have that option too. 2) I really haven't learn to write in MyQSL. So I do is use the Workbench. If I turning to SQLite, does it have something similar? 3) How to import Excel to SQLite? ...

SQLite - SELECT query returning more than expected

Hi, In the following my SQLite database has 10 values in each table. However, when performing my query there are around 100 results returned. SELECT videoformat, audioformat FROM videocodec, audiocodec Any ideas with why it is doing this? Thanks ...

SQLite: A library supporting it implements it?

I started using SQLite for my project and I found there are many libraries supporting it like Qt, pysqlite, Poco C++ etc. I also found out that previous SQLite versions didn't support foreign keys. How do the drivers know what sqlite executable to use? And how do I know they support what version of sqlite they support? Another question...