I'm writing a desktop application to do vector drawing in C++, and considering using sqlite to back my undo/redo feature. Has anybody used sqlite for undo/redo features? How does it work out for you? Clarification: I was aware of the stack approach, I have even implemented one application with that approach. The problem I encountered...
I am constructing an anagram generator that was a coding exercise, and uses a word list thats about 633,000 lines long (one word per line). I wrote the program just in Ruby originally, and I would like to modify this to deploy it online. My hosting service supports Ruby on Rails as about the only Ruby-based solution. I thought of host...
Sorry if this is overly simplistic. I've decided that I want to use an SQLite database instead of a MySQL database. I'm trying to wrap my head around how simple SQLite is and would like a simple, one answer tutorial on how to use SQLite with the Zend Framework, where to put my SQLite database in my directory structure, how to create the...
I don't know how authoritative this is but I found this: http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations and it doesn't seem good to have a lot of connections to sqlite. This seems to be bad for the web and most applications that have more than a few users. I'm having a hard time thinking of what sqlite would be used f...
How can you insert a file data(png) to col in SQLITE3 on osx (command line) and what is the better type to use as a container? blob or binary? ...
I want to use SQLite as an associative array that is saved to disk. Is this a good idea? I am worried about having to parse SQL every time I do something like: database["someindex"] which will have to be translated to something like select value from db where index = 'someindex' which in turn will have to be translated to the SQL int...
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. ...
If you have an answer that is not Java / SQLite related, I'd be pleased to read it. The environment I store items in a database with the following scheme : ################### # Item # ################### # _id # This is the primary key # parent_id # If set, it the ID of the item containing this ...
I know there is an SQLite Manager Extension for Firefox but, really, I don't like to do that from within a Web Browser. That's totally uncool. And I don't want to install Firefox just for that. ;) I hope there are other good tools, although that firefox option doesn't look too bad. But let's see if there's something better out there... ...
When I create initially an SQLite database file with pre-inserted datasets for my app, I would have to place this file somewhere in my Xcode project so that it goes to my iphone app. I guess "ressources" is the right place for that. What are the basic "steps" for deployment of an SQLite database file in an iPhone app? creating the db ...
I am developing a PHP application that uses SQLite as database management system, MySQL and PostgreSQL etc. is not an alternative (although I would really like to use pgsql), because I want the setup to be very beginner-friendly and zero-headache alike. Now many people use a shared hosting, and alot of them only offer direct FTP access t...
My primary question is which approach is faster. Some briefing I'm developing an application using Mozilla. I have this one module where I capture some data and store it in database. The data comes in intermittently. No duplicates are to be stored. For discussion sake we can assume a table with just one column, and let's name that c...
Are there any other good graphical administration tools for SQLlite on the mac, instead of the Firefox Extension? ...
Is there some command like "show columns from TABLENAME"? I only know that .dump command, but that's really dumb in this case. It puts out all the data, too. I need something to just see the table structure. ...
I am using an SQLite ODBC Driver (from here http://www.ch-werner.de/sqliteodbc/) with my VB6 application. Everything works fine, as far as retrieving and saving data, however, if I try to get the list of table columns via the following command: pragma table_info (myTableName) The ADO call fails with 2 errors (found in Connection.Erro...
Hi, In my table I want to have an ID column that is going to be unique and it is going to be autoincremented. I want to start from 0. How can I implement it? ...
Hi, I can't find a cause for a memory leak in my application. I found out that there is a memory leak through instruments and than more times I call the function than more memory leaks occurs. So it is obvious that a memory leak takes place. Here is my code. Object: @interface WordObject : NSObject { int word_id; NSString *word...
I wonder how run sqlite querys in the background as suggested in http://stackoverflow.com/questions/155964/what-are-best-practices-that-you-use-when-writing-objective-c-and-cocoa This is my try: - (void) run:(NSString *)sql { NSArray *data = [NSArray arrayWithObjects: sql, [self returnItemClass], nil]; NSInvocationOpera...
What is the syntax for specifying a primary key on more than 1 column in SQLITE ? ...
I would like to do aggregate calculations based on month for a datetime field. I am currently using the extra() function to format the date like: ...extra(select="strftime('column', '%m/%Y') as t").values('t').annotate(SUM(foo)) and it works great for sqlite3. In sqlite3 I can use strftime(), but that doesn't work with MySQL. In MyS...