I am using an SQLITE database to store latitudes and longitudes of locations. I want to be able to sort the results by rough distance from the current location. I already have the current location of the device as a double (lat, lng), the lat and lng in the database are also doubles. What I want is a query that will create a virtual co...
i am looking for a form of data storage that will answer a few requirements. i realize these requirements are non-standard, and for now i'm using activerecord and ORM solutions like everyone else, but this is my "holy grail" - if you know of anything like this, i would be eternally grateful: pure PHP multiple repositories, preferably f...
Hello, I would like to create a table in a SQLite database using the Server Explorer in VS2008. I am able to do other operations on the database but when it comes to creating a table using the query builder I get Not Supported messages. is there another way other than writing code just for the sole purpose of creating the table? CREATE...
I am looking to implement a sort of 'activity log' table where actions a user does are stored in a sqlite table and then presented to the user so that they can see the latest activity they have done. However, naturally, I don't feel it is necessary to keep every single bit of history, so I am wondering if there is a way to configure the ...
I'm looking for suggestions on the best way to implement a full-text search on some static data on the iPhone. Basically I have an app that contains the offline version of a web site, about 50MB of text, and I'd like for users to be able to search for terms. I figure that I should somehow build an table of ("word", reference_to_file_con...
Hello, I have the following function in my iPhone project which works great...unless the query returns nothing and then the app crashes. It is being a pain to debug with none of the breakpoints being activated at all! I know this works as I pass in static stuff that is in the DB and it returns a value. -(NSString *)getSomeText:(NSStr...
I am able to retrieve information from a SQLite database in PHP, but not write to it. For example, this code works perfectly fine: $db = new PDO("sqlite:foo.db"); $rowCount = $db->query("SELECT COUNT(*) FROM tblname;")->fetchColumn(0); echo $rowCount; // works as it should However, the following snippet results in an, 'unable to open ...
What are the differences between SQLite and DISQLite and why would I want to pick one over the other? My context is that I am dealing with a large database (could be up to 10 GB), the critical part of which is in one very simple table with a single indexed field and one text field up to a few KB in size. My development tool is Delphi 2...
Please provide samples of command line tool dbmetal to generate code file from a sqlite database. ...
I am working with SQLite. Suppose I have a table sales with two columns, date and count, to keep track of how many glasses of lemonade I sold on that date. If I don't sell any lemonade on a given day, I am too depressed to create a new row in the sales table. I'd like to find out the average number of glasses sold over a given date ran...
I would like to store Python objects into a SQLite database. Is that possible? If so what would be some links / examples for it? ...
Hey there, I would like to perform an SQLite query and order my results with numbers last. Eg: SQLite will ordinarily order results like this when I specify ASC on a text field: 0, 1, 2, A, B, C Whereas I would like this: A, B, C, 0, 1, 2 Any ideas? Is this possible? Thanks! Nick. ...
I've broken the code down to the smallest possible statement: Dim cn As System.Data.SQLite.SQLiteConnection And I get the following error when calling the code from a WinForm applicaiton: System.BadImageFormatException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=d...
I am developing offline implementation of an iphone app. I cannot insert pdf files into sqlite DB. can anyone help me to insert pdf/xls into sqlite DB. Thanks in advance! ...
I have .sql files which has following contents : #cat db.sql create table server(name varchar(50),ipaddress varchar(15),id init) create table client(name varchar(50),ipaddress varchar(15),id init) How to import this file into sqlite ?So that these are created automatically? Thanks. ...
What is the fastest way to populate a SQLite database from a DataTable in C# .net 2. Currently I am building insert statments for each row in the table. I have tried a dataadaptor but the speed didn't seem to be any faster. It currently takes 5 min to loop through 20,000 rows and write them to the database. Any sugestions? solution: I...
Core dumped while running this program: int main(void) { sqlite3 *conn; int error = 0; error = sqlite3_open("cloud_db.sqlite3", &conn); if (error) { puts("Can not open database"); exit(0); } error = sqlite3_exec(conn, "update server set servername=\'Laks\' where ipaddress=\'192.168.1.111...
In my iPhone app, I use a sqlite table to hold my data. While I'm looping through a select statement on one of the tables, I want to do another select (and update) statement on the same table in some conditions. It's pretty complicated to explain why I would want to do this, but I'm pretty sure I need to. The problem is that when I loo...
I wrote something like create table if not exists QuickTest ( id integer primary key NOT NULL, a TEXT DEFAULT @0, b TEXT, c TEXT); I get an error on @0. Is there a way to insert parameters here or do i need to hardcode the value in? I typically like using parameters when setting values. ...
I have question about python and sqlite3. I want to drop a table from within Python. The command cur.execute('drop table if exists tab1') Does not work. cur.executescript('drop table if exists tab1;') does the job. The execute method allows the creation of tables. However, it won't drop them? Is there a reason for this? ...