I'm trying to deploy a desktop application written on WPF 4.0 that uses SQLite through Entity Framework. So i've changed .config file (absolute path to db -> relative) and copied database file itself to app's directory. It seems to be working fine, but on other PC it's throwing an error during runtime. Supplying System.Data.SQLite.dll an...
Hello all, I've been working with SQLite on android and I would like to add an arraylist to a column in a table, and then fetch the data back as an arraylist. The arraylist is a list of Longs. I've noticed that SQL has an option for storing BLOBS, however it looks like I need to convert the arraylist to a byte[] first before being able ...
Hi! I would like my app to be compatible with iOS 2.0 as with iOS 3.0 and iOS 4.0. I'm going to use SQLite for many reasons. Now: what should I do with SQLite? Should I use the features available with the SQLite shipped with iOS 2.0 only? All the best ...
Hello, I am using FMDB to deal with my database which works fine. The app uses a background thread which is doing some work and needs to access the database. At the same time the main thread needs to run some quieries on the same database. FMDB itself has a little locking system, however, I added another to my classes. Every query is o...
Greetings! I'm needing to deploy a compact database with an application I am working on. The database acts as a cache for data the app has already seen, and that data will never change, so the cached values will never become outdated. I've chosen SQLite, and I'm writing in C#. I'd like to protect the database files so they cannot be ea...
I am looking at databases for a home project (ASP.NET MVC) which I might host eventually. After reading a similar question here on Stack Overflow I have decided to go with MySQL. However, the easy of use & deployment of SQLite is tempting, and I would like to confirm my reasons before I write it off completely. My goal is to maintain u...
I am running this sort of query: insert into mytable (id, col1, col2) values (:ID, :COL1, :COL2) In Python, a dictionary of this form can be used in conjuction with the query above for parameter substitution: d = { 'ID' : 0, 'COL1' : 'hi', 'COL2' : 'there' } cursor.execute(sql_insert, d) But in the real problem, there are lots of c...
hi all, I am new in iphone and i work a project in which required to put database on the server. I take link on the server and create our table on the server. i search on the net i find that below process. The Client Side Application: 1) receive input from the user (or client app event) 2) generate SQL request 3) XML encode the reque...
I know this question has been possed before, but the explanation was a little unclear to me, my question is a little more general. I'm trying to conceptualize how one would periodically update data in an iPhone app, using a remote web service. In theory a portion of the data on the phone would be synced periodically (only when updated). ...
I've a column in which contains numbers or strings. The type of the column is varchar. Usually when we sort it using the string field, then all the numbers come first and then strings start. But I want all the strings first and then numbers. TIA ! ...
Hi to all, I am new to android application development.I have create registration form with user name,password, email. this values should be stored in sqlite database table. retrieve the data from the table. in login.java i have create the table and insert the values of registration form data in to the table dynamically. In databsehel...
I'm creating a DB using SQLite from .NET, and then inserting 1500 records (15 columns, only 3 with information). At this point the database file size is 73mb!! (huge for the amount of information involved). If I open SQLite Administrator, and do a Clear Database, it shrinks to only 142kb. What it's doing that? Anyway to avoid it? Eithe...
I'm using a SQL database to store a single float value, and I'm really having trouble getting my brain around everything that needs to be done to make it work. I've been reading the NotePad tutorial Google provides for a few days now and Googling around but it just isn't clicking in my head. Could anyone explain to me (no code needed) ...
I have a air application called snippley All i want is to get to the data (my snippets) and export them. ...
Hi guys, was just wondering what formats of databases can SQLite support. i only know of .sql. Is .mdf supported? ...
Hi.. Getting image data from sqlite database but not able to display in custom cell of imageview.is there any conversion of image data into image. ...
Hi all Here's a short program that creates a SQLite database to hold some basic music metadata. There are three tables in the database for three fields of metadata; song title, the album the song comes from and the artist who made the album. Due to the nature of the data, duplicated information in metadata is a certainty (as demonstrate...
I have a table in my schema that has a unique constraint on two columns: UNIQUE(Column1, Column2) The SQlite documentation tells me that this creates a unique index on these columns. My question is, does that make an explicitly created index on one of the columns, say Column1, redundant? ...
In my iphone app, I have a sqlite table with latitudes and longitudes of USA(All weather stations of USA) . What is the sqlite query to check whether given latitude and longitude is in a set of lat/lon in sqlite? I mean I have the lat/lon set of New York as (42.75,73.80),(37,-122) but am searching with a lat/lon which is near New York, ...
Hey all I'm having a go at developing my first android application and have never really used databases before. Anyways I need to populate and update a database based on XML files retrieved from the web on a regular basis (say once a day). Just thinking about it iv already run into some problems...Basically I need to display informati...