I have a file containing several sql statements that I'd like to use to initialize a new sqlite3 database file. Apparently, sqlite3 only handles multiple statements in one query via the sqlite3_exec function, and not through the prepare/step/finalize functions. That's all fine, but I'd like to use the QtSQL api rather than the c api dire...
I want to give my website users arbitrary read-only access to an SQLite3 database, without letting them write to the database or do any other damage. How? Making the db file read-only helps a little, but commands like "ATTACH", ".load" and ".output" allow people to read/write other files, which may not be protected. Of course, if I kne...
Hi, I am trying to install sqlite3 for php5.2 in debian. in php 5.3 sqlite3 is enable but in debian php 5.2 is the last stable version! Can I enable and use sqlite3 even so? thanks for ur answer! ...
Hi everyone, I'm trying to add a UITableView to my Tab Bar application, but I'm completely at a loss for where to start. I've tried to add a new XIB and load the XIB from the View Controller in MainWindow.xib, but all it does is crash. Can anyone provide a tutorial from adding the UITableView to my Tab Bar app all the way through to se...
Hello, I would like to know if it is possible to create the file of a database by programming? Actually I need to create a database if it does not exist. ...
I'm using sqlite3_bind_text to bind text parameters to my queries, with the SQLITE_STATIC flag, since I know the text pointer remains valid at least up until the query is executed. Recently I've made changes so that the queries are executed in the transaction mode (many such queries in a single transaction). Should the text buffer remai...
I'm working with a sqlite database, using python/django. I would need to have my results, which contain german umlauts (ä,ö,ü) to be correctly sorted (not with the umlauts at the end). Reading different articles on the web I'm not even sure if it is possible or not. So any advise/instructions on that are appreciated. I already studied th...
In the SQLite IDE SQL window, I've written the instruction to return the the equivalence of .NET DateTime.Now, which is CURRENT_TIMESTAMP. Let's say it is 10:47:00 in local time, that is, GMT -4:00 (on summertime), otherwise it is GMT -5:00. The result of my query: select current_timestamp returns 2010-09-23 14:47:00, regardless of ...
What's the easiest way to fix this sqlite3 query so that wins and losses show up as columns in a single row instead of in two separate rows? http://0890db80061d7d2b33eb4606a4c301c1.conquerclub.db.94y.info/ I can think of hard ways involving subselects, but surely there's an easy/efficient/beautiful solution here? I want to avoid so...
I have a table called "images": CREATE TABLE images ( id INTEGER PRIMARY KEY AUTOINCREMENT, url TEXT NOT NULL UNIQUE, caption TEXT ); On inserting a row, I'd like the URL column to be unique. At the same time, I'd like to find out the id of the row with that URL. INSERT OR IGNORE images (url, caption) VALUES ("h...
Hi, I am new to Django, i was going through this Django site for building up a basic app. They have explained the procedure's to use either SQLITE3 , MYSQL, postgresql... I used SQLITE3 as they tell about it being a single large file which makes it easy to use initially. The problem i am facing is to use .schema to check the database c...
Hi! I created a table with this schema using sqlite3: CREATE TABLE monitored_files (file_id INTEGER PRIMARY KEY,file_name VARCHAR(32767),original_relative_dir_path VARCHAR(32767),backupped_relative_dir_path VARCHAR(32767),directory_id INTEGER); now, I would like to get all the records where original_relative_dir_path is exactly equal ...
Trying to get Rails up on ubuntu, and I’m having trouble installing sqlite3-ruby – it apparently can’t find sqlite3.h. All the references I can find to the error suggest the problem is either: sqlite3 headers aren’t installed, or make can’t find them. It looks to me like I’ve solved both those issues and I’m still seeing the same problem...
I can read a text and an int column (sqlite3_column_text, sqlite3_column_int). But does anyone know how to read in a sqlite decimal column? The decimal columns essentially hold currency values. Thanks! ...
If I change the type of a field in my database via a Ruby on Rails migration, from string to text, will I lose the data in the field? ...
I am trying to run Rails3 on XP Profesoinal and following the tutorial here http://railstutorial.org and am receiving the following errors all the time, even trying to return static pages. The message is the procedure entry point rb_str2cstr could not be located in the dynamic link library msvcrt-ruby191.dll Also, the page gives a runti...
I've followed a standard tutorial for building a database with Android. I've created a class called DbHelper which extends SQLiteOpenHelper. I've Overridden the create handler to execute a string. @Override public void onCreate(SQLiteDatabase db) { db.execSQL(DbDefinitions.DB_CREATE); } DbDefinitions.DB_CREATE is a static String...
Using SQlite I have a large database split into years: DB_2006_thru_2007.sq3 DB_2008_thru_2009.sq3 DB_current.sq3 They all have a single table call hist_tbl with two columns (key, data). The requirements are: 1. to be able to access all the data at once. 2. inserts only go to the current version. 3. the data will continue to be...
I have a note field of string type in one of my models in my sqlite3 database, but I realized that I needed to store more text than string would allow. I just ran a migration changing the type of the field from string to text. Looking at my database, it says that the type is now text(255), whereas before it was varchar(255). What doe...
Hi all, I hope someone can help me here. I am developing two apps at the minute, one iPhone, one Mac. Both have maps, the iPhone one has standard map and the Mac one has an embedded webviw that displays the map using a webpage with JavaScript. What I would like to do is to take the core data sqlite3 database from the iphone app and re...