I need to load some configuration data after app updates for my iphone app. I bundle in a file with a bunch of SQL statements (800+) to run on first launch. It looks like I may be painted in a corner now. If I run it on the main thread at startup, it take so long to run that the app crashes due to the startup taking too long. If I ru...
I'm developing a cocoa application that could be used to manage customer and employee details in a small business. When I read through the NSDocument architecture, I believe that the document/window management and workflow it gives you is excellent, however I am trying to figure out how that architecture fits into (if at all) an appli...
I tried to run my unit tests with C# Sqlite instead of going to a real database or mocking the hell out of our database layer using this blog post as guideline: Nhibernate C# Sqlite. Unfortunately NHibernate requires a connection to be an DbConnection which is not provided by the C#-Sqlite Driver. I looked into the source code and notic...
I'm fairly new to LINQ and trying to find a more elegant way (other than ADO.Net) to query and manipulate data in a SQLite database. I'm using System.Data.SQLite and wondering if there is a DataContext class or a way to use DataContext class to work with SQLite. I believe LINQPad uses the same assembly for its SQLite/MySQL driver and wi...
I'm a novice iphone developer, and just completed my first iphone app. After provisioning my iphone for development, I noticed that the app used way too much memory, and that several memory leaks that were issuing from the app accessing the sqlite database in the app caused the app to crash often. After running instruments, I have decid...
I run the very same query on two almost identical database. The only difference is that the first database has ID entries from 1 to 9000 for 2 tables while the other is in the 458231044 and 103511044 range for the 2 same tables. (for the same 9000 entries) The query compares ID and UNIX time numerous times. Running it on first database...
I am trying to find the path for the android database files on Ubuntu 10.4, because I want to access with SQLite Browser. Someone can tell? ...
I have a winforms app that uses sqlite to store data. Instead of shipping a blank database, can I use scripts to create the tables the first time the user uses the app? Can you point to a C# example? Update: I want to avoid shipping a blank database. So if a user install the app for 1 user only, only his profile gets a copy. All users p...
Hi, I have a question about SqLite. I have a Table called "Alphabets" It cantains list of Alphabets: id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, alphabet TEXT Example 'Alphabets"table: id | alphabet 1 | A 2 | B 3 | C 4 | D 5 | E 6 | F ... This table gets populated by list of all Alphabets. Then I have another table ...
I'm doing a small project including a connection to sqlite. I write to two tables with a one to many relation. The last batch to the second table won't get written unless I explicitly closes the connection. I find it strange since the database is in auto-commit mode (i.e. connection.commit() throws an error). I would like to keep the c...
Hi every one, I'm new to android and want to develop application to manage inventory on mobile. I can run the application "Hello world" and can communicate with database as well. But i'am having problem with navigation and forms and controls. for my application i want to store the inventory data in database and retrieve in a grid for...
What is the meaning of this in Objective C? int sqlite3_bind_int(sqlite3_stmt*, int, int) ...
I need to migrate a complex project from sqlite to PostgreSQL. A lot of people seems to have problem with foreign keys, data truncature and so on... Is there a full automated utility ? Do I need to check some data or schema before the migration ? Edit : I tried django-command-extensions DumpScript but it doesn't run on my 2GB RAM PC...
Hi i am using FMDB to retrieve data from SQLITE database. db = [[FMDatabase alloc] initWithPath:path]; [db open]; FMResultSet *fResult= [db executeQuery:@"SELECT * FROM Users"]; aUsers = [[NSMutableArray alloc] init]; while([fResult next]) { userData = [fResult stringForColumn:@"Name"]; lblUsers.text=[lblUsers.text...
I am trying to do a bulk transaction using SQLITE on CHROME (and SAFARI). I'm doing this with javascript so this is what I have: ============================================================= query = "BEGIN TRANSACTION; " query += "INSERT INTO schools (name) VALUES('School 1');" query += "COMMIT TRANSACTION;" db.executeSql(query); ...
One of my applications downloads a database from a server. When I install the application onto my phone, it downloads the file correctly and loads the information, no exceptions thrown or anything. However, when I upload the apk into the Android Market Place and download it onto the phone, the application downloads the database and then...
Hello, Im trying to insert values on Android SQLite Database. The question is, Iḿ trying to insert a word, the table has 3 columns, ID, WORD, COUNT. When I insert a word in the database, some method will verify if this word exists on the database. If yes, it will increment the value of COUNT for this word. Example. I have a word "Quest...
I'm trying to query a word, for this Im using the db.query method. But I want use a where clause, I've done like this on my code, but, the emulator returns an error. public String select(String wrd) { String list = new String(); Cursor cursor = this.db.query(TABLE_NAME, new String[] {"word"}, "word like " + wrd + "", null, null...
I have an application I'm porting from MSSQL and .NET to SQLite and Mono. I'm using NHibernate, FluentNHibernate, NHibernateLINQ and SQLite. When I test the application with only one person connected everything works OK, but the moment somebody else starts using the app it breaks and throws an SQLite Exception saying "Database File is ...
When creating my SQLite database in Android I set the database locale - db.setLocale(new Locale("cz_CZ")). This is a Czech locale. A SELECT statement works and takes the locale into account, for example: SELECT * from table WHERE name='sctzy' COLLATE LOCALIZED Will find the entry 'ščťžý'. But using LIKE will fail: SELECT * from ta...