sqlite

Sqlite on Android: How to create a sqlite dist db function - to be used in the app for distance calculation using lat, long

We are building an Android App that will use user's current location (lat, long) and show top 50 venues around the current location, sorted by distance. We have these venues stored in an SQLite DB. We plan to ship with the sqlite DB with the app. In order to fetch only the relevant top 50 closest venues, we want to define a db function...

one-click deploy - how do I ensure the sqlite database file only gets copied if it doesn't already exist?

Hi, Background - I'm starting to use click-once deploy for a WinForms application that has a sqlite database file, which holds the blank database structure ready to go. Question - How do I set things up so that the click-once deploy (via Publish, in VS2008) will ensure that when the user downloads it will: a) If does not already ex...

sqlite - is there a sqlite databse upgrade script template for Windows available somewhere?

Hi I'm setting up click-once deploy for a WinForms application that has click-once deploy. Question - Is there a sqlite databse upgrade script template for Windows available somewhere? That is, a way of including and automatically running some SQL on the already existing sqlite database file on the users PC (e.g. in case of adding ne...

Copying data from one sqlite db to another

Hello, I have 2 sqlite DBs with common data but with different purposes and I wanted to avoid reinserting data, so I was wondering if it was possible to copy a hole table from one DB to another. I didn't find anything about this on google regarding sqlite DB's so my hopes are not hi. Thank you, ...

Importing multiple records from sqlite db iphone sdk

I need some help! Please. I am trying to develop a very very simple application, basically just a simple book reader. Ideally, the first view would be a uitableview listing the names of chapters, then selecting the row would take you to a detail view that has the chapter which is broken up into segments. Note the segments are actually th...

how would I call/use Subsonic from within a WinForms app being deployed over clickonce (with Sqlite DB)

Hi, Background - I need a framework/approach to managed database updates for a .NET Winforms app being deployed on users PC's via clickonce deploy. The app uses a sqlite database. Q1. What mechanism does Subsonic use to run such migrations on the local PC? e.g. would it be MSBuild Q2. If it does need a tool like how can my applicat...

Using NHibernate to create an SQLite database with a "UNIQUE ON CONFLICT REPLACE" column.

Is this possible? If not, how can I create a table with a "UNIQUE ON CONFLICT REPLACE" column in code? ...

CoreData updated sqlite database

Hey there, I'm working on my first application using coredata. Everything works perfectly. When I debug the app on my device (without it already being installed on the device), then quit the app, manually modify the sqlite dbase then debug the app again, it appears to be using the old version of the database. If the two sqlite files h...

SQlite query question, importing multiple records

Ok, so I am making progress since my last question. My question now is a lot more simple, or at least I understand more clearly what my question is. In my AppDelegate I have this code to read in data from my database: -(void) readFromDatabase { // Setup the database object sqlite3 *database; // Init the Array sections = [[NSMutableArra...

Migrate SQLite database to Microsoft SQL Server

After using SQLite for development and beta-testing for a home-project I want to migrate the DB to Microsoft SQL Server to get better performance. Is there any free/cheap utils that will do this? So far I have found DBConvert that looks like a good product, are there others? ...

do i need to install sqlite?

Do i need to install sqlite for android or its already installed while installing all the plugin. I was trying to run the application MJAndroid, example in O'Reilly book but i am getting error in the file where the application is trying to extend SQLiteCursor Class. EDIT This is the Error Tree.. I am an absolute beginner to android ED...

Is it better to create the db/tables programmatically or through a .db file in assets

Hi, does Android have a "best practices" guideline on creating & populating the db/tables programmatically vs. deploying a .db file in assets? What are the pros/cons of both approaches? I have a db with big long strings in several columns, and about 50 rows, so writing the insert statements alone would take quite some space. It see...

Ideal sqlite database design

I am relatively new to db design, so any help here would be appreciated. I am working on developing an iPhone app, and keep getting stuck, so I'm thinking my database design is junk. In my app, I have basically three items I need to pull from a db. A book title value, a chapter number value, and a segment content value(comprised of a num...

Does iPhone SQLite implement SQLite's R*Tree Module?

Was wondering whether this was the case because R-tree is the best way to search for points in a rectangle as well as events within ranges (according to SQLite Documentation). However given 1.) the iPhones spatially endowed SDK adn 2.) that R-Tree needs to be specifically installed as part of SQLite, it may not be included. ...

Testing EF SQL Server based application with in-memory SQLite?

Hi I am using SQL Server with Entity Framework for a development of web app in .NET 4 with VS2010 RC. I would like to prepare testing database with sample data. Should I prepare a copy of the real database (say another SQL Server database) for testing, or can I use SQLite in memory for better performance? If using SQLite, can I use th...

sqlite explain from api

I have a complicated SQL query executed from my application. The query runs fine with the version 3.6.11 (64ms). When run in 3.6.22 it takes more than 100 sec to finish. When executed from the command line client, the execution is quick both in 11 and 22. Therefore I want to run the query with "EXPLAIN" from inside my application. Is it ...

Django shift to PostgreSQL fails to import fixtures, stating data too long

I am switching from using SQLite3 to PostgreSQL, and hoped that I could populate the database using the fixtures I had been using to populate SQLite3. However, I am getting these errors: $ python manage.py loaddata fixtures/core.json fixtures/auth.json Installing json fixture 'fixtures/core' from absolute path. Problem installing fixtu...

Need help on python sqlite?

1.I have a list of data and a sqlite DB filled with past data along with some stats on each data. I have to do the following operations with them. Check if each item in the list is present in DB. if no then collect some stats on the new item and add them to DB. Check if each item in DB is in the list. if no delete it from DB. I canno...

Sqlite: How to insert variable into string in prepared statement

I'm using a Java wrapper for accessing Sqlite but I assume this is a general Sqlite question. String stmt = "SELECT foo FROM bah WHERE foo='%/?/%'; PreparedStatement a = myConn.prepareStatement(stmt); a.setString(1, "hello"); a.executeQuery(); ... throws an exception - it doesn't like the ? being inside quotes. Everything is fine if ...

SQLite - Run multi-line SQL script from file?

I have the following SQL in a file, user.sql: CREATE TABLE user ( user_id INTEGER PRIMARY KEY, username varchar(255), password varchar(255) ); However, when the following command is executed: sqlite3 my.db < user.sql The following error is generated: Error: near line 1: near ")": syntax error I would prefer to keep the SQ...