I'd sort of like to use SQLite from within C#.Net, but I can't seem to find an appropriate library. Is there one? An official one? Are there other ways to use SQLite than with a wrapper?
Ccna final exam - java, php, javascript, ios, cshap all in one. This is a collaboratively edited question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
Monday, June 4, 2012
Is there a .NET/C# wrapper for SQLite?
Wednesday, May 30, 2012
Any Good ORM tools for Android development?
Anyone working on the Android ('gPhone') have or know of a place where I can find a good ORM tool for it? The code is written in Java, and the DB is SQLite. What I would like to find is a tool that given the object definition, can auto-generate the tables and the CRUD functions (that would be awesome), or, barring that, a tool that can take the table definition, the object definition, and auto-generate the CRUD functionality. The rub is that all of this must happen within the android framework, which has its own conventions as to how DB access works.
Wednesday, May 23, 2012
What "additional configuration" is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
I have a project in which I'd like to use some of the .NET 4.0 features but a core requirement is that I can use the System.Data.SQLite framework which is compiled against 2.X. I see mention of this being possible such as the accepted answer here but I don't see how to actually achieve this.
How to get a list of column names on sqlite3 / iPhone?
I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist.
Monday, May 21, 2012
Android SQLite: nullColumnHack parameter in insert/replace methods
Tuesday, May 8, 2012
SQLite database on PhoneGap
I want to implement SQLite database for iPhone using PhoneGap. I know some basics SQLite database in iPhone native application. But how can I implement SQLite database in PhoneGap?
Friday, April 27, 2012
How to avoid SQLiteException locking errors
I'm developing an Android application. It has multiple threads reading from and writing to the Android SQLite database. I am receiving the following error:
Sunday, April 22, 2012
Is Core Data useful for readonly data too?
I'm creating an iPhone App and am wondering whether Core Data is better for readonly data than a SQLite database. It feels like the SQLite DB is the better choice, is that right? Can I even pre-fill the Core Data storage?
Monday, April 16, 2012
Android ContentProvider Performance
I'm curious if anyone has done any performance testing on querying a ContentProvider via ContentResolver vs querying a SQLiteDatabase object in the same process. I'm guessing that a ContentResolver query passes back a Cursor that communicates with the database through a Binder (Android IPC). This means that if I read the contents of 100 records through the Cursor that would result 100 Binder method calls. Are my guesses correct and if so would that be significantly slower than accessing the database in the same process?
Tuesday, April 10, 2012
Android sqlite get boolean from database
was just wondering, how can I obtain the value of a boolean field in a sqlite database in android?
Android. Content provider or Database?
Since I've seen a presentation from Google IO I'm a bit confused in the question, if it's better to use content providers or databases. Or it makes no difference if I don't want to share any data with other applications.
Android ContentProvider Performance
I'm curious if anyone has done any performance testing on querying a ContentProvider via ContentResolver vs querying a SQLiteDatabase object in the same process. I'm guessing that a ContentResolver query passes back a Cursor that communicates with the database through a Binder (Android IPC). This means that if I read the contents of 100 records through the Cursor that would result 100 Binder method calls. Are my guesses correct and if so would that be significantly slower than accessing the database in the same process?
Sunday, April 8, 2012
Add an SQLite database to an iPhone app
I am trying to learn SQLite, and I am building an iPhone app. But I would like to add an SQLite database to my building app. I have got three tutorials, but I am not clear on that code.
Where"s the best SQLite 3 tutorial for iPhone-SDK?
I'm looking for an complete tutorial which not just tells me how an query is executed, but also how I set up the whole thing including setting up the library, creating an database, and so on.
Tuesday, April 3, 2012
Best way to join tables using sqlite in android
I am trying to find out the best way to do a simple table join on my two tables using a sqlite database in an android application. Is the simplest way to use CursorJoiner or is there any easier way?
Monday, March 5, 2012
SQLlite Android. Managing data
Hi friends. I'll tell you the aim of this part of my app. I've got a SQLite dB which has 3 columns. First is "Quantity", Second is "Product" and third is "Price". Well, what i want to do is to get the whole dB and send it by email. This is what i have right now:
SQLlite Android. Managing data
Hi friends. I'll tell you the aim of this part of my app. I've got a SQLite dB which has 3 columns. First is "Quantity", Second is "Product" and third is "Price". Well, what i want to do is to get the whole dB and send it by email. This is what i have right now:
Thursday, March 1, 2012
database insertion working well on android emulator but not on device
I have created a database using this tutorial .
Android database closed exception
I'm working on a project where I'm downloading and saving data from web to sqlite database. A few minutes ago I receive a strange exception to our server from a user which is saying that the sqlite database is already closed..and I just checked the whole file where the exception happened and I'm not calling dbHelper.close(); . Here is the function where the app crashes and LogCat message :
Wednesday, February 29, 2012
iPhone: Sqlite update or insert row
I want to update the quantity if the menuid is already available otherwise add a new row. I used the following code.But no row is added or updated.