>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 ea
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
transa
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 shou
*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 i
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 neede
>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 t
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, but
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 file
$ 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: malformed
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
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
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 (PDT), James_21th
> wr
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 u
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
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 avoi
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 (sqlite
16 matches
Mail list logo
