SQLite and Ruby on Rails on PC
I am using instant rails which makes use of SQLite and I am unable to connect to the database. I have been using a tutorial that uses MySQL and I have been unable to find instructions for SQLite. Any suggestions? ...
sqlite
sqlite ado.net provider - which is the most popular to use? (e.g. phxsoftware, devart, mindscape)
Hi, Regarding starting to use SQLite within C# Visual Studio 2008 for a winforms application, it seems from the sqlite site you have to download a sqlite ado.net provider, and there are numerous listed (in .net section of sqlite wrappers) QUESTION - Which is the most popular/robust sqlite wrapper that people are using? Some from the ...
SQLite editor capable of handling BLOB type for Mac
Hi, I am looking for a free/cheap SQLite editor that can handle BLOB type for Mac OS X. Basically, I just need to create a database that contains images, then load it to an iPhone app bundle. No need for fancy queries. Could someone recommend the best editor available out there for this purpose? Thanks a lot ...
iPhone SDK: loading UITableView from SQLite
Hi, I think I got a good handle on UITableViews and on getting/inserting data from/to SQLite db. I am straggling with an architectural question. My application saves 3 values int the database, there can be many/many rows. However would I load them in the table? From all the tutorials I have seen, at one point entire database is loaded ...
Python sqlite3 version
Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 32 bit (Intel)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> sqlite3.version '2.4.1' Questions: Why is the version of the sqlite**3** module '2.4.1' Whats the reason behind bundling such an old sqlite with Python? Th...
Does SQLite write operation block database only for other processes or for threads of single process too?
Does SQLite write operation block database only for other processes or for threads of single process too? Is it possible to use SQLite in multithreading (=multisession) ASP.Net application? ...
SQLite + SpatiaLite problems
Hi, I'm trying to access a SpatiaLite from C# using System.Data.SQLite provider. When I try to load the SpatiaLite extension, I always get the System.Data.SQLite.SQLiteException: SQLite error The specified module could not be found. error, even though the spatialite's dll has been copied to the bin directory. I even tried specifying...
iPhone SDK: loading UITableView from SQLite - creating array from SQLite
Hi, this is a follow up forr http://stackoverflow.com/questions/1552944/iphone-sdk-loading-uitableview-from-sqlite I am planning to use following code to load SQL data to the array. Each element of the array will be a class represening each database entry: @interface Row : NSObject { int PK; NSString *desc; } @property int PK...
SQLite Access in Objective-C and Cocoa
Hi Everyone, I am in the process of learning Objective-C for Mac/iPhone development and decided to try and write something useful without looking at the bible (Aaron Hillegass: Cocoa Programming 3rd Edition). I'm writing a simple puzzle game. The data that defines the levels is stored as a string in a SQLite database and read into a le...
What is causing this propel error?
I'm geting this error in propel when I run my app: PropelException: Unable to open PDO connection [wrapped: SQLSTATE[HY000] [14] unable to open database file] I've tried everything I can think of but can't figure out what is causing the problem. my build.properties is: propel.project = LinkCannon2 # The Propel driver to use for ge...
Copy data between two table in sqlite
I have two table with different column like this: table1 ( _id, title, name, number, address ) table2 ( _id, phone, name, address ) How can I copy data 'name', 'address' from table1 to table2. And my question have two situation: First: table1, table2 in the same database file Second: table1 in d...
How to speed up query with multiple INNER JOINs
I've been toying around with switching from ms-access files to SQLite files for my simple database needs; for the usual reasons: smaller file size, less overhead, open source, etc. One thing that is preventing me from making the switch is what seems to be a lack of speed in SQLite. For simple SELECT queries, SQLite seems to perform as ...
Will I run into performance issues if I use a blob field as primary key in SQLite?
I have a sqlite database where all the primary keys are GUIDs. Currently they are stored as fixed length strings but I want to store them as blobs because it simplifies the code for storing and retrieving data. I converted part of the database and everything is functioning as expected. However, I'm not sure if I will run into performa...
SQLite: Combine SELECT and DELETE in one statemet
Hi, I need to run two statements like so: Select amount from db where ID=5 DELETE from db where ID=5 Currently I prepair a run two different statements. I wonder if there is a way to combine it in on statement. Basically all I need to do is to get and amount column from the row before is is deleted. thanks ...
Should I use a flat file or database for storing quotes for a random quotations app on Android?
Hi, I am developing an app on Android that will randomly pick and display an inspirational quotation (or verse) from a large collection of quotations. On Android I can choose between a flat file and an SQLite database. The app should satisfy the following conditions: Be scalable to 10^6 quotations and/or verses Be very fast (i.e. re...
How to use SQLite database in JME ?
How to use SQLite dabase in JME? ...
Simple Forum Engine with Support for SQLite
I need a simple forum backed by a SQLite 3 database which I can easily integrate into my new project, something in the line of Vanilla forum. What do you suggest? ...
C# Dynamically Add Columns to table in Database
Hello, I am still learning quite a bit about programming so this may be an obvious question but I am in the process of writing a program where a user can import an excel file with no column constraints (meaning each excel file could have a different number of columns and so on). What I want to do is be able to convert the imported exce...
When using py2exe, PyQt application cannot load SQlite database
My PyQt application works fine when running on Linux, when in my Windows build environment, or frozen on the machine where it was build with py2exe. But after moving the frozen executable and its supporting files to another machine it can't load the database driver. It worked fine when I had Python2.5 and an earlier version of PyQt and ...
How can I delete data with specific row number (sqlite)
I have a table people(name, address, phone), my table have 2000+ rows. I want to delete 1000 rows. How's about the query? ...