According to Apple documentation on debugging Core Data it says we should be able to pass an argument to the application which will output the SQL core data sends to SQLite. I have gone into the arguments tab of my executable in XCode and specified the argument: -com.apple.CoreData.SQLDebug 1 However, I see no SQL in the console. ...
I'm trying to compile the SQLite amalgamation source into my iPhone app (to give me access to the full-text searching functionality that isn't available in the iPhone-compiled version of the binary. When I add sqlite3.c and sqlite3.h to a normal Carbon C app template, it compiles just fine (with a single warning about an unused variabl...
I am not sure how to correct this error. The type or namespace name `SQLiteConnection' could not be found. Are you missing a using directive or an assembly reference? I included the reference Mono.Data Mono.Data.Sqlite Mono.Data.SqliteClient and a few non related refs. I am using //using System.Data.SQLite; //<-- this line was all i...
I know from this question that Firefox 3.0 and up stores its cookies in an SQLite database. My question is: can you access this database from other desktop programs in such a way that you could add a cookie? I realize this has security implications. However, I do not want to read them at all. I want to be able to set one cookie if po...
Is there a way to pre allocate my SQLite database to a certain size? Currently I'm adding and deleting a number of records and would like to avoid this over head at create time. ...
Hi everyone, I'm having a problem with mixing managed and unmanaged code. I have created two projects under a single solution in Visual Studio 2008 under Vista x64 SP1. One of them does not have CLR support and is a static library. My second project is compiled as an executable with CLR enabled. It depends on the first static library, an...
Here's my proposed (very simplified to illustrate the problem space) design for a C# console application. The database connections implement IDisposable, and this solution doesn't allow for using the database connection objects. Can someone propose a more correct structure for a console application? This is a problem I need to solve ...
I am a bit of a noob still with rails, but I am running across something that seems a bit odd. I added a boolean field to a model in the database thusly t.column :admin, :bool, :default => false, :null => false However, the value in the sqlite3 database seems to be either 't' or 'f'. That is fine, but I would still expect user.admin? ...
Hello good fellas I'm struggling since this morning about this sqlite thing.after reading some good tutorials i decided to use it as my embedded database in my winform application. i downloaded SQLite-1.0.61.0-setup that install the system.datal.sqlite for me and downloaded the firefox plugin sqlite manager and another management tool ...
I am currently working on a project for the iPhone that requires accessing a large amount of hierarchical data stored in a local sqlite database. One of the more common operations is calculating a rollup status field. Right now, I'm doing that by recursing through all the descendants of that item (which can be anywhere from 1 to n levels...
Hello people i've been struggling to use sqlite in my C#2.0 application and i, ve finally decided to get rid of assumptions and ask really basic questions.when i created a database say iagency with table users, from external tools like firefox plugging and another sqladmin tool i can't query it from sqlicommand inside vs2005.it displays ...
I've been doing some development using sqlite (which BTW it's awesome). Until now I've used the SQLite Administrator. Although it has some great features, there are some annoying bugs. So, I ask you, what administration consoles (GUI) do you recommend for SQLite? ...
I'm on a system with no access to disk. My C program has in memory the contents of a valid, small, sqlite3 file (received over the network). I would like to use sqlite3's C API to open and access this file (read-only is fine). How do I do this? I know I can create an empty in-memory database with sqlite3_open(":memory:", &foo) but is...
I have a C++ application that uses ADO to talk to an Oracle database. I'm updating the application to support an offline documents. I've decided to implement SQLite for the local side. I've implemented a wrapper around the ADO classes that will call the appropriate code. However, ADO's way of adding/editing/deleting rows is a bit diffic...
I am looking for a way to retrieve the "surrounding" rows in a NHibernate query given a primary key and a sort order? E.g. I have a table with log entries and I want to display the entry with primary key 4242 and the previous 5 entries as well as the following 5 entries ordered by date (there is no direct relation between date and prima...
Hi, I am trying to get the rowcount of a sqlite3 cursor in my Python3k program, but I am puzzled, as the rowcount is always -1, despite what python3 docs say (actually it is contradictory, it should be None). Even after fetching all the rows, rowcount stays at -1. Is it a Sqlite3 implementation bug? A Sqlite3 bug? I have already checked ...
I have a SQLite database that contains a huge set of log messages. I want to display this in a list view (using wxWidgets). The user can reorder the list (by pressing the column header), apply a filter on the result set and navigate through it as a usual list, using the scroll bar. The user can also select one or multiple entries in th...
We're beginning development of an in-house app in the iPhone Enterprise developer program. Since it's close to OS 3.0, we're reconsidering our original design of using SQLite and using Core Data instead. Here's some more info: There is a legacy desktop application that this is replacing. We will reuse the existing back end. We curre...
You can get a list of databases using PRAGMA database_list or a list of tables in the "main" database using select name from sqlite_master where type='table' but as I just wrote, it only returns the tables from the "main" DB only, and I don't see a way to know which tables are in the other DBs. So how does one list the tables in t...
In Oracle OCI, I can prepare a statement like: select * from t where pk in :1 and bind a VArray collection for the :1 placeholder. I don't see any way to do the equivalent in SQLite, unless I use one of the following works arounds: prepare select * from t where pk=:1 instead and execute this N times with all the pks in my collect...