Hi All, I tried to create linq-to-sqlite dbml using DbLinq but in vain. Each time I get different type of errors. May be I'm somewhere wrong. Can anyone tell me the step by step procedure to create the dbml file from the Dblinq source code. ...
I have a really frustrating error that I've spent hours looking at and cannot fix. I can get data from my db no problem with this code, but inserting or updating gives me these errors: *** Assertion failure in +[Functions db_insert_answer:question_type:score:], /Volumes/Xcode/Kanji/Classes/Functions.m:129 *** Terminating app due to un...
I'm developing an android app. It has multiple threads reading from and writing to the android SQLite db. I am receiving the following error: SQLiteException: error code 5: database is locked I understand the SQLite locks the entire db on inserting/updating, but these errors only seems to happen when inserting/updating while I'm runnin...
Hi everyone, i'm starting to learn Qt for python and as i was wondering after reading this post : qt - pyqt QTableView not populating when changing databases. if there was a way to use SQLAlchemy sessions instead of (re-)opening a database connection as a Table Model with Qt's QTableView widget. Something that would work a little bit l...
Can someone help/guide me with using SQLite lib on Linux (MONO) and Windows (.NET) On linux i use native mono sqlite client, and on windows i use http://sqlite.phxsoftware.com/ is there a way to define 'using' directives like this : #if (linux) using Mono.Data.Sqlite; #else using System.Data.SQLite; Another problem is small diff...
I have the following code my $db = DBI->connect( "dbi:SQLite:data.db", "", "", { RaiseError => 1, AutoCommit => 1, PrintError => 0 } ); my $row = $db->selectall_arrayref( "SELECT * FROM something WHERE name=\'$hash->{name}\'"); print Dumper $row; How do I do the same with my $sql = $db->prepare("......"); $sql->execute...
I have the following test code use Data::Dumper; my $hash = { foo => 'bar', os => 'linux' }; my @keys = qw (foo os); my $extra = 'test'; my @final_array = (map {$hash->{$_}} @keys,$extra); print Dumper \@final_array; The output is $VAR1 = [ 'bar', 'linux', undef ...
Newly compiled SQLite displays a strange behavior concerning the date/time functions. Do you have any idea what is going on and how to fix it? $ date Mon Mar 8 14:52:11 CET 2010 $ ./sqlite3 TEST0 SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> SELECT d...
I'm trying to solve the problem that composite keys in sqlite don't allow autoincrement. I don't know if it's possible at all, but I was trying to store the last used id in a different table, and use a trigger to assign the next id when inserting a new reccord. I have to use composite keys, because a single pk wouldn't be unique (becau...
There is any NoSql database as simple as SQLite? I'm looking for a lightweight database to persist a small set of data for a simple desktop application. I still can use SQLite but prefer a more OO approach since my app doesn't handle much data. ...
I have created a file named "MyFile.db" using SQLite3 from my C#.net application. This file got created in my "D:\MyProject\bin" folder. I have created a table named "MyTable" inside "MyFile.db" from same C# app. Now I am running sqlite3.exe from my "C:\" drive to get Command Line Shell For SQLite. How can I get the file "D:\MyProject\...
Hi everyone I got a question ;) Actually I want to use core-data in different threads. I have two UIviews that display data from the same table in the database. If a remove an entry in the first view I'm supposed save and then ask the PersistentStoreCoordinator to give me (the UIview) a brain new managed object. That what they say in ...
Hello, I'am currently migrating an iphone application using SQLite to CoreData. I need to do an INSERT or REPLACE to add only the new content, is there a way to do this or do I have to fetch all the DB and look for existing objects and add the new ones ? Thanks. ...
I have a SQLite database that I am trying to sort by Alphabetical order. The problem is, SQLite doesn't seem to consider A=a during sorting, thus I get results like this: A B C T a b c g I want to get: A a b B C c g T What special SQL thing needs to be done that I don't know about? SELECT * FROM NOTES ORDER BY title ...
Hi, when selecting a column that can contains a NULL value I get an exception thrown on this statement. self.DirectionFromCity = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 8)]; How should I go about setting these attributes as NULL values are OK for the Database. ...
Hi, I am looking for some advice on the best strategy for getting / putting GIF files in an SQLlite Database and how to initialize the ImageView. I have images stored on URLs that can be downloaded but I'm not sure the best method to get them stored into the SQlite database. should it be NSURLRequest - NSData - BLOB then retrieve ...
I'm creating my own RSS Reader, and to see which RSS items were already downloaded I'm converting the links(of each item) to MD5 hashes. When an RSS feed is loaded, it adds all the items to a ListView object and then checks the MD5 hashes against a text file and removes the ones that already exist. This way, only new items are shown. ...
I've got a very large SQLite table with over 500,000 rows with about 15 columns (mostly floats). I'm wanting to transfer data from the SQLite DB to a Django app (which could be backed by many RDBMs, but Postgres in my case). Everything works OK, but as the iteration continues, memory usage jumps by 2-3 meg a second for the Python process...
I have never used DBIx::Class until today, so I'm completely new at it. I'm not sure if this is possible or not, but basically I have a table in my SQLite database that has a timestamp column in it. The default value for the timestamp column is "CURRENT_TIMESTAMP". SQLite stores this in the GMT timezone, but my server is in the CDT ti...
Reason: Im wondering how to handle schema migrations. The newer SQLite versions support an "ALTER TABLE" SQL command which would save me having to copy data, drop the table, recreate table and re-insert data. ...