Re: [sqlite] Sqlite help

>Unfortunately, I'm not too familiar with SQLite Manager. well it's quite cool you know, try one day :) It's kind of WYSIWYG -:) Ok so unfortunatelly my database is in .gll file but when i use FF SQLite Manager in FF i can see all my tables. So i Imported my csv file to my database :-) very

Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?

For the record, the problem was that django (by default) starts a transaction before handing an http request, then commits it after the request is handled. Since we were in the middle of a transaction, all the python/django code we wrote saw the state of the DB as it was partially through a

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 16:10:10 -0700 (PDT) schrieb ceekayCK: > It was quite easy to export to csv (using excel) :) > Now i have in one column Artist , and in second column Title Fine. :-) > Ok So i use sqlite Manager in Firefox Unfortunately, I'm not too familiar with SQLite Manager. > What

Re: [sqlite] Sqlite help

*If* you can manage a reasonable export to .csv (using Excel, if needed, or not), then, yes, that would be a way to go IMHO. Lookup the .import command in the CLI (command line interface). OK Wolfgang It was quite easy to export to csv (using excel) :) Now i have in one column Artist , and

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 15:39:30 -0700 (PDT) schrieb ceekayCK: > If i changed .doc file to .txt or csv, will this help? > Or put all data from .doc to excel, and then split Artist and title to > separate columns and export to csv? *If* you can manage a reasonable export to .csv (using Excel, if

Re: [sqlite] Sqlite help

>A .doc file is basically a load of printer instructions, but generally it doesn't hold any structured data. The latter, however, is what a database needs and is made for. If i changed .doc file to .txt or csv, will this help? Or put all data from .doc to excel, and then split Artist and title

Re: [sqlite] Sqlite help

Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK: > unfortunately send me a .doc file You're at a loss there. Your friend could as well print this file and send you the printer output, essentially that would make no difference. A .doc file is basically a load of printer instructions,

Re: [sqlite] Error: malformed database schema

On 4 Jul 2011, at 10:53pm, Alexey Pechnikov wrote: > sqlite> pragma integrity_check; > *** in database main *** > Page 5 is never used > Page 35 is never used > Page 67 is never used > Page 97 is never used Use sqlite3 to dump your database to a file of SQL commands. Use sqlite3 to use that

[sqlite] Error: malformed database schema

$ sqlite3 test.db -- Loading resources from /home/mbg/.sqliterc SQLite version 3.7.7.1 2011-06-28 16:48:37 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select count(*) from sqlite_master; 283 .dump ... sqlite> select count(*) from sqlite_master; Error:

[sqlite] Sqlite help

Hi, At the beginning I will say that I am not a specialist in databases. I have the following problem to figure out: I have a database (sqlite). In it, about 8800 records (lyrics) I have received from a friend list (selected about 800 songs), but unfortunately send me a .doc file Is there a magic

[sqlite] sqlite3 amalgamation and unused variables

There seem to be a couple of variables in the sqlite3 amalgamation that get assigned a value but actually their value is not used. If there is an intention to get rid of these statements I will submit samples like h = pFile->h; (sqlite3.c in line 26039 version 3.7.7) But perhaps these lines

Re: [sqlite] Help needed for SQLite PHP

Just FYI: James told me in private mail " SQLiteDatabase is not working for sqlite3,  I changed the open script to:  $dbh = new PDO('sqlite:yourdatabase.db'); Now it is working. " On Sun, 03 Jul 2011 16:08:24 +0200, Kees Nuyt wrote: >On Sun, 3 Jul 2011 06:47:26 -0700

Re: [sqlite] Minimal SQLite

On Mon, Jul 04, 2011 at 04:37:10PM +0530, trilok nuwal scratched on the wall: > Hi All, > > I want to use SQLite for one of the application which runs on a embedded > system where we have memory limitations. > > In the SQLite we have around 180+ distinct APIs, but not all APIs we are > going to

Re: [sqlite] Minimal SQLite

On 4 Jul 2011, at 12:07pm, trilok nuwal wrote: > I want to use SQLite for one of the application which runs on a embedded > system where we have memory limitations. > > In the SQLite we have around 180+ distinct APIs, but not all APIs we are > going to use it. > > What I want is the just core

[sqlite] Minimal SQLite

Hi All, I want to use SQLite for one of the application which runs on a embedded system where we have memory limitations. In the SQLite we have around 180+ distinct APIs, but not all APIs we are going to use it. What I want is the just core APIs. Can I build SQLite in such a way that I can

[sqlite] System.Data.SQLite version 1.0.74.0 released

System.Data.SQLite version 1.0.74.0 is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLite mailing list