I am writing editing front ends in Python since several years now, and I am fed up with micromanaging every UI detail of a window or dialog every single time. Is there a technology that allows me to, say, specify the relations between a GTK+ Glade-designed interface and the tables and records of an SQLite database to do all the middle m...
I created a sqlite3 database, created tables and insert some data. I can retrieve using select query by using terminal application. But when i add this database to my iPhone application resources and try to access data programatically I get error as "no such table: table name" Why does this happen? ...
I have large blobs in an SQLite app, and need to update small segments of these blobs in a piecewise fashion. Something like saying "update bytes X through Y of blob B with data D", this can be done in other databases with Blob manipulating functions, but I can't find anything like this for SQLite, am I stuck? Or does SQLite have ways of...
Let's say I have two or more processes dealing with an SQLite database - a "player" process and many "editor" processes. The "player" process reads the database and updates a view - in my case it would be a waveform being mixed to the soundcard depending on events stored in the database. An "editor" process is any editor for that data...
The problem I've got a programm that uses storm 0.14 and it gives me this error on windows: sqlite3.OperationError: database table is locked The thing is, under linux it works correctly. I've got the impression that it happens only after a certain amount of changes have been done, as it happens in some code, that copies a lot of ob...
I'm starting to get involved in an open source project Gramps which is exploring switching their backend from BSDDB to a relational database. Either SQLite or MySQL we haven't fully decided and may even try to do both in some limited capacity. I'm a professional developer but I'm new to python so I'm not that familiar with the current se...
i want t0 delete a row with minimum value of a particular field from a table if number of records less than 5; ...
hey guys i wanted to know the best way to get this thing done: i have a huge table with +40k records (tv show titles) in sqlite and i want to do real time lookups to this table. for eg if user searches for a show, as and when user enters search terms i read sqlite and filter records after every keystroke (like google search suggestion) ...
It is possible to get a row with all column names of a table like this: |id|foo|bar|age|street|address| id dont like to use "Pragma table_info(bla)" Thanks. ...
I have the following table of counters: CREATE TABLE cache ( key text PRIMARY KEY, generation int ); I would like to increment one of the counters, or set it to zero if the corresponding row doesn't exist yet. Is there a way to do this without concurrency issues in standard SQL? The operation is sometimes part of a transaction...
Background: My team is dedicated to ensuring that straight from checkout, our code compiles and unit tests run successfully. To facilitate this and test some of our NHibernate mappings, we've added a SQLite DB to our repository which is a mirror of our production SQL Server 2005 database. We're using the latest versions of: MbUnit3 (p...
Hi, in the following piece of code, I see that when my 'description' is something like: " ' ' ", I have a problem updating the description to the sqlite record. How do i handle the ' character. thanks! sql = wxString::Format( "UPDATE event SET event_description='%s' WHERE id=%d", description.c_str(), event_id); rc = sqlite3_...
How can I set the start value for an AUTOINCREMENT field in SQLite? ...
I have a content based, read-only iPhone app. Users can select favorite topics, which I need to track. Some topics I'd like to make available between app updates through the App Store. I'll need to track if users have downloaded these particular topics or not until the App Store update is available. This approach will consist of two ...
Hi, I'm wondering if someone can help me understand what is wrong with this block of code. I never get past the sqlite3_prepare_v2 statement and the debugger says : 'NSInternalInconsistencyException', reason: 'Error while creating add statement. 'out of memory'' static sqlite3 *database = nil; sqlite3_stmt *addStmt = nil; if(add...
On an official sqlite3 web page there is written that I should think about sqlite as a replacement of fopen() function. What do you think about it? Is it always good solution to replece application internal data storage with sqlite? What are the pluses and the minuses of such solution? Do you have some experience in it? EDIT: How abo...
Does anybody have any tips on utilities that can be used to bulk load data that is stored in delimited text files into an SQLite database? Ideally something that can be called as a stand-alone program from a script etc. A group I work with has an Oracle Database that's going to dump a bunch of data out to file and then load that data ...
What is the most efficient way to select the first and last element only, from a column in SQLite? Thanks. ...
void max_min(sqlite3 *db) { //call back********* int i, ncols; sqlite3_stmt *stmt; char *sql; const char *tail; char *zErrMsg = 0; int rc; //****************** //min/max variables char min[20]; char max[20]; //we want only the min and max value of this table sql = "SELECT MIN(Start...
I have a command line tool that I have written (in Python) that interfaces to a SQLite database (one DB per user). This program presents a lot of data to the user which can be cumbersome in a terminal. One option is to provide a wxPython interface, but another thought is to leverage Firefox or Webkit to provide an interface. Anyone eve...