I have a question about how to structure communication between a (new) Firefox extension and existing C# code. The firefox extension will use configuration data and will produce other data, so needs to get the config data from somewhere and save it's output somewhere. The data is produced/consumed by existing C# code, so I need to deci...
Newbie question. I'm using a SimleCursorAdapter to populate a spinner from an SQLite table, as shown in the Android dev docs: Spinner list=(Spinner)findViewById(R.id.cboModel); SimpleCursorAdapter ModelAdapter = new SimpleCursorAdapter(this, android.R.layout.simple_spinner_item, model, new String[] {"Drug"}, new ...
I am working on an Cocoa project using SQL databases, or CSV/Excel files as the input. Right now, I have hard-coded the SQL schema for the SQLie files I am importing (For example, the program would know that the first column is a STRING, second column is a INT... etc.). I am wondering if there's any C or Objective-C library or method to...
I know that I can import .csv file into a pre-existing table in a sqlite database through: .import filename.csv tablename However, is there such method/library that can automatically create the table (and its schema), so that I don't have to manually define: column1 = string, column2 = int ....etc. Or, maybe we can import everything ...
I am looking for a small database that can be "embedded" into my Python application without running a separate server, as one can do with SQLite or Metakit. I don't need an SQL database, in fact storing free-form data like Python dictionaries or JSON is preferable. The other requirement is that to be able to run an instance of the data...
Hi, I have an sqlite file inside my iPhone app. I want the users to be able to export and import the file again, directly from the app to their desktop, for backup purposes. But I don't want them to directly access the sqlite file or the data from anywhere other than the iPhone. How do I convert the file to a proprietary format that is u...
Hi, In my iphone application,i have used sqlite3 for storing the data. how to get the size of the database using the iphone functionality? if anybody has any code or any useful link or any other resolution,which would be appreciated. Thanks, Mishal Shah ...
hello, in my (quite simple) application, --> i have one subview (named "Splash") loaded in the main view at launch time, like this (in my mainView class) : -(void)awakeFromNib{ [self addSubview:splash]; } --> I have also a UITableView (named "myTable") loaded by clicking a button (which calls the IBAction named "LoadData:") in the ...
This is a relatively simple question but I want to make sure I am doing this the right way. What is the best practice for connecting to a database? This is how I am currently doing it and I want to make sure this is more or less following best practice. private static SQLiteConnection conn; public static SQLiteConnection Conn ...
My understanding is that sqllite is pretty much the only choice for database on the iphone. Is there an O/R Mapper for it? ...
Hi, I am using sqlit3 in my iphone application to store details of the user I have a table carrying of 50 columns. Now i have to insert data within the columns. can anybody suggest optimum way to do that which will not impact the performance. Thanks ...
Hello. I have downloaded and installed linq-to-sqlite from http://sqlite.phxsoftware.com/ But the following test code: [ Table( Name = "items" ) ] public class MyItem { [ Column( IsPrimaryKey = true ) ] int MyId; } public class MyDb : DataContext { public MyDb( IDbConnection c ) : base( c ) {} public Table< MyItem > myItems; }...
Hi I want to make a database for my mobile 6 cellphone app. What I did was in visual studios I went to my project name and right clicked on it, went to add -> add new item -> data -> choose datafile. It created a database file called "AppDatabase1.sdf" Now I want to connect to my database but I don't know how what the connection strin...
I'm new to sqlite so please be patient :) I've got a UITableView reading the data from a sqlite db. If i delete a record, the row in the db is deleted. The problem is that the other rows keep their primary keys, so for example, I have 3 rows and the primary keys are 1,2,4. is there any possibility to update the keys to be 1,2,3? Thanks...
I am writing a app in python and utilzing sqlite. I have a list of strings which I would like to add too the database, where each element represents some data which coincides with the column it will be put. currently I have something like this cursor.execute("""insert into credit values ('Citi','5567','visa',6000...
Is the sqlite3 Ruby gem thread safe? I can't find any documentation to say that it is. In my experiments, accessing a database from multiple Ruby threads eventually leads to the following error: /Library/Ruby/Gems/1.8/gems/sqlite3-ruby-1.2.5/lib/sqlite3/driver/native/driver.rb:84: [BUG] Bus Error Is there anything I'm missing? If not...
Hi, I am using sqlite in my iPhone app. I have some database operations, in which I have to insert into two tables different data(means there is no data-dependency). Can I perform these two operations in seperate thread. While the insert operation in each table are more than one. So I am doing this in a while loop also. ...
Hi all, I am devloping an editor with spell check feature in Flex + AIR using Sqlite as an embedded database. In database I have a table with the words. The table contains lacs of words. I have written the code to search for the word in table. I have used the sync method for all this. This pauses my application while searching. I would...
On a new machine, installed ruby with the 1-click installer for windows. Installed rails 2.3.2 and all associated gems, then I installed the sqlite3 binaries (into the c:\ruby\bin folder). Lastly I did gem install sqlite3-ruby -v=1.2.3 (which is apparently the latest version that works with windows) This error happens when I run rake ...
So I've just tried to migrate my first rails application from the development environment on my laptop to my hosted environment(just another machine that is externally facing), but I seem to keep getting errors with apache/passenger trying to run my app. Basically I've configured apache and passenger correctly in that the main site sti...