sqlite

How can we track cookies and pages visited with user - Firefox / Sqlite

We have a problem with our SAAS site. We sometimes have users kicked out because our authentication cookie is not there (or possibly corrupted). This happens rarely enough that it is hard to find, but often enough that I want to know why. I want to install a monitor / sniffer for one of our support engineers. They get the problem ever...

Cannot Retrieve Value From Last Insert Row in SQL Database

Hi Guys, I've got a problem when retrieving the primary key value of the last inserted row in the database. I have a table of name wineDetails which contains more than 2000 wine names. I display the names in alphabetical order. When I add a new wine name into the wineDetails table, the new wine name primary key is 2001 in the database...

Sqlite Query Optimization (select * from where in AND not in order by limit offset)

Any ideas for optimizing the following query using Sqlite3? SELECT * FROM Feed WHERE ActivityType IN ('PhotoActivity','CommentActivity') AND UserKey NOT IN ('testUser', 'testUser2') ORDER BY TimeStamp DESC LIMIT 20 OFFSET 0; The table will never have over 100,000 records and we expect 100 to 1 reads to writes. Any...

SQL CE, SQLite. What are the differences between them?

What is the difference between SQL CE and SQLite? In what situation would i choose one over the other? ...

execSQL SQLiteException near "?"

Why doesn't this work?? db.execSQL("INSERT INTO PARTIES (PARTY_NAME, PARTY_COUNT) SELECT DISTINCT(PARTY), COUNT(PARTY) FROM ? WHERE (Year=?) GROUP BY PARTY ORDER BY PARTY ASC", new Object[] { "Election", "2004" }); It works perfectly in rawQuery!! ...

SQLite in iPhone:I want to Retrieving 1 row for each date from sqlite

i only want to know that whether data is available for any specific date or not.If there are more than one data with the same date, i do not want to fetch all the data.I try to use LIMIT 0,1 in where clause but it means it will fetch total 1 data for the given date range. So please tell me the way to fetch data between a date range with...

Select random row from an sqlite table.

I have an sqlite table with the following schema: CREATE TABLE foo (bar VARCHAR) I'm using this table as storage for a list of strings. How do I select a random row from this table? ...

Which value query function return in case of a failure?

I'm using SQLite with PHP and I want to know if my query failed or not. Does query return FALSE in a case of a failure? ...

Is there any way to convert an integer (3 in decimal form) to its binary equivalent 11 in SQLite???-RESOLVED

i am aware that there are functions in Oracle and MsSQl that can do so , sooooo is there any function that does it or is there any way to convert it inside sqlite . my table is of structure : col 1primary key int| col2 not null int <------- i want to convert the value of this column into binary an perform a few comparisons for a set se...

Inserting primary key values using SubSonic and sqlite - problem because SubSonic thinks columns are either AutoIncrement or not

I'm using SubSonic 2.2 and sqlite and have encountered a problem when dealing with tables with an INTEGER PRIMARY KEY column that isn't AUTOINCREMENT. According to the faq: If you declare a column of a table to be INTEGER PRIMARY KEY, then whenever you insert a NULL into that column of the table, the NULL is automatically converted ...

Call to System.Web.Configuration.ProvidersHelper.InstantiateProviders taking ages and ages (from SubSonic)

I'm using SubSonic 2.2 and the .net provider for sqlite in a client application. I'm calling SubSonic.DataService.Provider and it's taking ages, e.g. 30 seconds, to return. Stepping through the SubSonic code it appears to be taking the time on this line within DataService.LoadProviders(): ProvidersHelper.InstantiateProviders(section.Pro...

ReadUncommitted broken in SqlLite against NHibernate

I am using sqlite for test cases in a project that leverages NHibernate. Everything is working great, except when I try to create a ReadUncommitted transaction: e.g. Session.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted) The error message is: "isolationLevel" (thats it) The call stack looks like: at System.Data.S...

SQLite Pivot and Cross Tab Queries

Hi, Is there any way to create a pivot and/or cross-tab query using for SQLite using any of the available .NET wrappers? Thanks. ...

Looking for best way to retrieve business hours from database

I'm using Ruby on Rails and I'm storing business hours like this: CREATE TABLE "business_hours" ( "id" integer NOT NULL PRIMARY KEY, "business_id" integer NOT NULL FOREIGN KEY REFERENCES "businesses", "day" integer NOT NULL, "open_time" time, "close_time" time) (which came from the thread at: http://stackoverflow.com/questions/10...

Language/framework to write Excel spreadsheets, webbased

I need to make a webpage (from scratch) that will interrogate a SQLite database (with a predetermined query) to produce an Excel compatible spreadsheet. I need to find a lightweight solution to implement this, but don't know where to look and what is recommended. The page itself will be fairly vanilla, only takes two dates as input, and...

Lock a SQLite database for reading from c#

Hi All, My Projects has c++ dll in which a db is created in Sqllite with share deny = none . This dll will insert data into Db and I have a c# exe which must access the db and display it . Display needs to be done asynchronously. So there any way while launching connection to sqlitedb i can lock the table or db. if Possible can anyone g...

Using Pragma-s of SQllite in C#

Hi All , I had posted a question "My Projects has c++ dll in which a db is created in Sqllite with share deny = none . This dll will insert data into Db and I have a c# exe which must access the db and display it . Display needs to be done asynchronously. So there any way while launching connection to sqlitedb i can lock the table or ...

sqlite diff-script generator

Given two sqlite databases A and B, is there a tool that can generate SQL commands that will convert A to B (or vice versa)? This must included insertions, deletions, and updates - and maybe also table alterations (though that's not important to me). Possibly this tool is not even sqlite-specific. ...

Can't initialize local server for my Rails apps

Hi all, My rails apps have been freaking out on me lately. I start my local server by running "ruby script/server" like normal. The server starts, but when I try to access it via "http://localhost:3000/", it throws me a 500 error. This happens for all my rails apps, even the old ones I've left unchanged for several months now. Here ...

Core Data VS SQL Statement, which one is gd for iphone development?

iPhone 3.0 support the Core Data, it seems a great tool for developer. But SQL statement seems it is easier to get start, but core data is easier for maintaining db. But I'm considering the SQL statement, because it seems have better performance. I am consider which one is better for iPhone development, any suggestion? ...