I'm working with sqlite and trying to create a table from another. This works: create table sources_tmp as select "literal" system,name,user from sources; but it doesn't allow me to specify the type for the "literal". I've tried this but doesn't work that way apparently: create table sources_tmp as select "literal" system as $TYPE,...
Trying this answer and not having any luck: I am using the SQLite Database browser (built with 3.3.5 of the SQLite engine) to execute this query: SELECT columnX FROM MyTable WHERE columnX LIKE '%\%16' ESCAPE '\' In column XI have a row with the data: sampledata%167 I execute the statement and get no data returned but no err...
I have a parser that parses XML file into SQLite database, and the current implementation generates the 'create table xyz ...' even the table is already existed. Is this OK? I mean, is this OK to run 'create table' even when the table exists in db? If not, is there easy way to check the names of tables (and its contents) that SQLite d...
I'm using DbLinq with SQLite for a small project of mine. Is there any way to look at the actual SQL queries that get executed behind the scenes? I remember a monitoring program for SQL Server from my internship but SQLite is a quite different beast, I fear. ...
This post refers to this page for merging SQLite databases. The sequence is as follows. Let's say I want to merge a.db and b.db. In command line I do the following. sqlite3 a.db attach 'b.db' as toM; begin; <-- insert into benchmark select * from toM.benchmark; commit; <-- detach database toM; It works well, but in the referred si...
How do you obtain the current timestamp in Sqlite? current_time, current_date, current_timestamp both return formatted dates, instead of a long. sqlite> insert into events (timestamp) values (current_timestamp); sqlite> insert into events (timestamp) values (current_date); sqlite> insert into events (timestamp) values (current_time); sq...
Using SQLite, Got a table with ~10 columns. Theres ~25million rows. That table has an INDEX on 'sid, uid, area, type'. I run a select like so: SELECT sid from actions where uid=1234 and area=1 and type=2 That returns me 1571 results, and takes 4 minutes to complete. Is that sane? I'm far from an SQL expert, so hopefully someone ca...
I wish to use the foreign keys facility, and thus upgraded my version of sqlite to the latest stable version 3.7.2. I've verified the version in terminal by entering in: > whereis sqlite3 = /usr/bin/sqlite3 > sqlite3 --version = 3.7.2 Now, when I come to create a new database using FireFox's SQL Manager plugin it reports it is using...
Hi, I have a huge csv file, separated by comma's and I want to do a analysis with glm in R. In one column there exists data with a comma implied, something like: bla,blabla When reading the file in R with read.csv.sql there comes a error-message: RS-DBI driver: (RS_sqlite_import: ./agp.csv line 47612 expected 37 columns of data but f...
Hello, I don't know if I'm wierd, but I haven't found any topic about the subject. The thing is, I have data with lat and lng stored in my SQLite database, and I want to get the nearest locations to the parameters I put in (ex. my current location - lat, lng). I know that this is possible in MySql, and I've done quite some research that...
I'm using C# to display a list of movie titles that I am calling from an SQLite database. Currently, I'm using a custom ListBox class that has a function to sort the text stripping the word 'The' from the beginning of every item. However, it doesn't exactly seem to be the simplest way to do it, since it calls from the SQLite database and...
When I need to get the number of row(data) inside a SQLite database, I run the following pseudo code. cmd = "SELECT Count(*) FROM benchmark" res = runcommand(cmd) read res to get result. But, I'm not sure if it's the best way to go. What would be the optimum way to get the number of data in a SQLite DB? I use python for accessing SQLi...
I have a script that parses xml file to generate SQLite table automatically. And, the simplified command is as follows. Table string CREATE TABLE IF NOT EXISTS benchmark (id integer primary key autoincrement,Version float, CompilationParameters_Family text, CompilationParameters_XilinxVersion text, CompilationParameters_Device text, C...
I'm working on a personal project focusing on analysis of text in a database. My intent is to do something interesting and learn about SQL and sqlite. So with my novice abilities in mind, I'd like to get advice on doing this more efficiently. Say, for example, I want to pick out the types of food in an article A. I parse my article, ...
i have a database in iphone which is regularly updated. is there a way to find out the date of last update to the database. i just need the date and not the data. also don't want to store the date of update as a extra column. ...
Hi, I have a query regarding SQLite. I am running it on Mac OS X. I created a table, added, deleted rows,columns values and everything is working fine. But when i close the terminal and exit, and reopen the terminal again, the table that i created previously is no longer there. is thi sthe normal behaviour like session only or am i goin...
Hi (this is my first post on StackOverflow :), every time i increase my database version and push the upgraded app to the users, something weird happens.. For some it works perfectly fine, and some report crashes (including through the Market's reporting system) caused by the lack of table columns i just added in onUpgrade. If you...
Hello, I am having some problem in importing a .csv file into a sqlite table. My .csv file looks like this Name,Age,, Hamish,27,, Praveen,27,, There are no trailing spaces anywhere. I create a table in the SQLite db with the same schema, but when i run .import...it shows me an error saying "expected 2 columns of data but found 1". Prob...
Hi, Is there any file size limitation for iphone resource file.For example my sqllite db size can larger than 300 mb? Thanks ...
Hi, I have written a stand-alone Windows Forms application in Visual Studio 2005 using C#, CastleProject ActiveRecord and SQLite as database (using the SQLite connector). The published application (the binaries from the bin directory) works perfectly on windows vista and windows 7 computers, however when copied to a Windows XP computer...