I am able to create the DataModel, Entities and Properties. How do I now create the DB? Do I have to create it manually making sure that all the properties and entities are mapped? I am following the Recipes Core Data sample and have noticed a method in RecipesAppDelegate.m: - (NSPersistentStoreCoordinator *)persistentStoreCoordinator ...
The problem I'm running into is that when using "MyDB.sqlite" the application seems to not read the DB correctly (stops, NOT errors, at this line according to NSLogs): if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) { whereas if I rename the DB "MyDB.sql" (notice the lack of "ite") it will rea...
Hello SQLite is fine as a single-access database, but it gets risky when used by more than one user at a time. MySQL, Firebird, PostgreSQL etc. are more difficult to deploy and are simply overkill for my use. Ideally, I'd like a compact, single-EXE server meant to run on low-spec hardware (eg. 128MB RAM, 256MB flash RAM) that would be ...
Is there any good tutorial to learn C# with mono? So far, google hasn't been helpful because most tutorial are for Visual Studio. I am a Java developer, so I am familiar with Object Oriented ideas. My goal, is to be able to develop a small portable application with a SQLite backend. Thanks ...
which versions of sqlite may best suite for python 2.6.2? ...
I have created an app in xcode with sqlite3.I want to create a button named sync to sync with my mysql database in my server. Any suggestion about sync process? Please let me know. ...
Hi, In my iPhone app, I'm trying to delete a row from an SQLite database. After the delete statement is executed the row seems to be deleted correctly, but after I restart the application the row is still there. I'm using the code blow to delete the record. Any idea what could be the problem? NSString *deleteSQL = [NSString stringWithF...
i trying to do basic application. my files list; DatabaseClass.h and .m, IDRGameAppDelegate.h and .m, scoredb.sqlite, ScoreViewController.h and .m, MainWindow.xib // Main Window ScoreWindow.xib //Show Score Window 1.) my database is ; CREATE TABLE "game" ("id" INTEGER PRIMARY KEY ,"name" VARCHAR(32),"score" VARCHAR(20)); INSERT INTO ...
I use temporary tables in an SQLite based iPhone application. Performance was not as was required so I looked at various candidates for optimization. Most of these worked well and had the desired effect. However, I'd also like to try moving the temporary tables from flash into memory to see if there is any improvement. On an actual de...
I have a reasonably large data set and would like to store it in a file rather than a RDBMS. The main table in the data set is just over 1M rows, 30 columns and about 600Mb in size as a CSV. I'm considering SQLite. Is SQLite worth investigating for data sets of this size? ...
I'm trying to use prepared statements in a PHP script that accesses an SQLite3 database using PDO. The normal version of this query works as expected: $q1 = "SELECT COUNT(*) FROM fruits WHERE name='apple'"; echo $db->query($q1)->fetchColumn(); However, my prepared statement version outputs nothing. $q2 = "SELECT COUNT(*) FROM fruits...
Hi what do you suggest as a cross platform "almost all encompassing" abstraction toolkit/library, not necessarily gui oriented? the project should at some point include an extremely minimal web server and a "db" of some sort (basically to have indexes/btrees, maybe relations, so a rdbms is desiderable but avoidable if necessarily, sql ...
I am thinking of using SQLite as an in memory stub for my Oracle database. I can easily direct all my DAL commands to the SQLite, but I am now wondering how I should easily populate the data for each test method. Should each method begin by creating the needed table(s) and inserting the rows for the specific test? Should I populate in th...
I have a datalogging application (c#/.net) that logs data to a SQLite database. This database is written to constantly while the application is running. It is also possible for the database to be archived and a new database created once the size of the SQLite database reaches a predefined size. I'm writing a web application for reportin...
You can easily enter a blob value using the x'abc' syntax, but is there a way to display it that way too? As shown below, selecting directly, or implicitly converting to a string using concatenation doesn't work, and shows garbage (Windows DOS prompt here). sqlite> create table blobs (uid blob); sqlite> insert into blobs values (x'01234...
I am using the latest NHibernate 2.1.0Beta2. I'm trying to unit test with SQLite and have the configuration set up as: Dictionary<string, string> properties = new Dictionary<string, string>(); properties.Add("connection.driver_class", "NHibernate.Driver.SQLite20Driver"); properties.Add("dialect", "NHibernate.Dia...
Hi, I have a SQLite table called posts. An example is shown below. I would like to calculate the monthly income and expenses. accId date text amount balance ---------- ---------- ------------------------ ---------- ---------- 1 2008-03-25 Ex1 -64.9 37...
From now on should one use core data as a wrapper for a small iphone app with an sqlite single table database? Does it unnecessarily complicate things or is it good practice to use from now on? ...
I am trying update my version of sqlite3 on mac os x 10.5.7 I downloaded the source code that is recommended for unix and unix like programs. I followed the compile and install directions in the readme file and everything seems to work fine. However, when i check the version number of sqlite3 it remains at 3.4.0 (the old version). Wh...
I need to dump a .sql or .csv file into sqlite (I'm using sqlite3 API). I've only found documentation for importing/loading tables, not entire databases. Right now, when I type sqlite3prompt> .import FILENAME TABLE I get a syntax error, since it's expecting a table and not an entire DB. ...