I might missed that but: what are you trying to
acomplish by using explorer to copy the
database file ?
I guess you are doing it for backup purpose.
For this, be aware that it might be dangerous to
do a simple file copy on a running database since
you might forget some temporary files used by
sqlit
On 8/07/2009 2:14 AM, Rick Ratchford wrote:
[snip]
> To John Machin: To save from answering multiple messages (and save space for
> all), I'll address John's reply here.
>
> --
> "Consider getting answers faster by (a) trying thi
On Tue, Jul 7, 2009 at 1:10 PM, Mark Spiegel wrote:
> This should give you a picture of who is opening the file and with what
> flags. In particular, how is your SQLite app and Explorer opening the file?
Thanks for the pointer to Filemon; I'm always happy to learn about a
new tool. Apparently it
nixonron wrote:
> cursor.execute("UPDATE country SET slug=%s WHERE country_cd=%s",
> (slugify(country_name), country_cd))
> conn.commit()
>
>
> Here is the error message
>
> Traceback (most recent call last):
> File "C:\Python25\ron_scripts\newsqlite.py", line 9,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
nixonron wrote:
> conn = sqlite3.connect("c://Ujimadata//aid.sqlite")
If you are using forward slashes then you only need one. Having more
may cause errors. (Backslashes need two because they are a quoting
character.)
>cursor.execute("UPDAT
After fixing the connection issue I get a syntax error when trying to connect
to a sqlite database and wonder if its python or sqlite. Error message seems
to indicate sqlite. I check the code in Komodo and don't get any syntax
errors.
Here is the code
import sqlite3
from sluggy import slugify
Doug,
That worked. Thanks.
Doug Currie-2 wrote:
>
>
> On Jul 7, 2009, at 4:36 PM, nixonron wrote:
>
>> conn = sqlite3.connect('c:\Ujimadata\aid.sqlite')
>
> Perhaps you meant
>
> conn = sqlite3.connect('c:\\Ujimadata\\aid.sqlite')
>
> or
>
> conn = sqlite3.connect('c:/Ujimadata/aid.sqli
On Jul 7, 2009, at 4:36 PM, nixonron wrote:
> conn = sqlite3.connect('c:\Ujimadata\aid.sqlite')
Perhaps you meant
conn = sqlite3.connect('c:\\Ujimadata\\aid.sqlite')
or
conn = sqlite3.connect('c:/Ujimadata/aid.sqlite')
e
___
sqlite-users mailing l
I've created a database in a directory called Ujimadata on my C: drive. I'm
using sqlite in Django project. Here is the code I'm using in Komodo when I
get the "sqlite3.OperationalError: unable to open database file" error.
import sqlite3
from sluggy import slugify
conn = sqlite3.connect('c:\Uj
On Mon, 6 Jul 2009 16:53:35 -0500, Nicolas Williams
wrote:
>On Sat, Jul 04, 2009 at 10:24:50AM +0200, Kees Nuyt wrote:
>> On Fri, 03 Jul 2009 14:38:43 -0700, James Gregurich
>> wrote:
>>
>> >
>> >nuts. that makes INSERT OR REPLACE worthless if you have tables
>> >dependent on one another.
>>
folks,
I have the following db file set up:
> sqlite> .dump
> BEGIN TRANSACTION;
> CREATE TABLE test1(i INTEGER, a INTEGER, b INTEGER, c INTEGER, d
> INTEGER);
> INSERT INTO "test1" VALUES(0,1,2,3,4);
> INSERT INTO "test1" VALUES(1,10,20,30,40);
> INSERT INTO "test1" VALUES(2,100,200,300,400);
Just to make sure I understood you correctly, is this what you are suggesting?
* Open file with sqlite app (in my case sqlite3)
* execute BEGIN EXCLUSIVE TRANSACTION;
* initiate the file copy
* COMMIT; after the copy is finished.
I tried doing this, but very early into the copy Windows issues the
On 7 Jul 2009, at 3:06pm, Alberto Daniotti wrote:
> Thank you for the answer.
> Could you give me an example of use of BEGIN TRANSACTION?
BEGIN TRANSACTION;
INSERT INTO favouriteColour (person,colour) VALUES ('Jenny', 'orange');
INSERT INTO favouriteColour (person) VALUES ('John');
INSERT INTO f
Stan Bielski wrote:
> In the course of copying a largish (20 GB) database file while
> accessing it via sqlite3, the machine became very unresponsive. I
> opened task manager and found that the system was using a huge amount
> of virtual memory, causing it to thrash. Per-process memory usage
> look
You should synchronize your backup (copy). Try surrounding it with an
exclusive transaction.
Stan Bielski wrote:
> Sorry for the repost, but the original thread was hijacked by another
> list user. This is a serious problem IMHO; it looks like the DB can't
> be backed-up without rendering the ma
Thank you Dennis.
That does make sense. In my particular situation, I'd have to typecast the
variable fed to the SQL, since it is an INT type that holds the day that is
to be searched on.
What I ended up doing, for purposes of time and because there are other
routines that will need to do this a
Maybe if you write-protected the file before starting the copy...
My guess is that the process that connects to do the query opens the
file in read/write mode causing the operating system to think someone is
trying to write to the file. So the OS tries to keep a copy of the data
being read by the
Haven't seen your previous post but just a WAG, have you selected the
VM Size column in task manager to show you per process VM usage. In XP
TM, it is under Tools Menu/Select Columns/Virtual Memory Size. This
should indicate which process is hogging VM.
2009/7/7 Stan Bielski :
> Sorry for the repo
Sorry for the repost, but the original thread was hijacked by another
list user. This is a serious problem IMHO; it looks like the DB can't
be backed-up without rendering the machine unusable if a query hits it
while a copy is in progress.
Hello,
In the course of copying a largish (20 GB) databas
>
We appreciate all the feedback on our questions regarding large SQLite
tables. We
are running a variety of performance tests and hope to post the
results soon. This might
provide the start of a thread regarding performance tuning SQLite for
this particular workload.
Thanks,
Matt
>
> heck
Robert Citek wrote:
> create table foo (
> col_1, col_2, col_3, col_4, col_5, col_6, col_7, col_8, col_9,
> col_10, col_11, col_12, col_13, col_14, col_15, col_16, col_17,
> col_18, col_19, col_20, col_21, col_22 ) ;
> .mode tab
> .imp "foo.tsv" "foo"
> select col_9, col_22, count(*) as "coun
I have a command pipeline that I would like to transfer to sqlite.
However, the performance under sqlite is significantly slower, which
makes me think that I am doing something not quite correctly. How can
I improve the performance of this task using sqlite?
foo.tsv is a tab-delimited file with 2
>> See? That's how I read this, too. Oh, well... I've wasted more
>> time
>> on stupider things than this, so it's no use cying over spilled
>> milk. :-)
>
> This, at least, seems pretty clear:
>
>
> http://sqlite.org/compile.html#enable_update_delete_limit
Yup, you're right, Jay. I don't
Thank you for the answer.
Could you give me an example of use of BEGIN TRANSACTION?
Thanks
- Original Message -
From: "Simon Slavin"
To: "General Discussion of SQLite Database"
Sent: Tuesday, July 07, 2009 1:22 PM
Subject: Re: [sqlite] Importing file from C-code
>
> On 7 Jul 2009, at
Rick Ratchford wrote:
> So what I need to do then is to make the return of strftime of type INT.
>
> Can CAST(strftime('%d', Date), INTEGER) be used in this context, or is there
> another way?
>
>
Rick,
You could use a cast (with correct syntax) as you have suggested
CAST(strftime('%d', Da
On 7 Jul 2009, at 10:03am, Vishal Sharma wrote:
> me too want to remove it if you know kindly tell me also...
Click on the link that appears on the bottom line of every message
including this one.
Simon.
___
sqlite-users mailing list
sqlite-users@sq
On 7 Jul 2009, at 10:39am, Alberto Daniotti wrote:
> I have a question. I want integrate sqlite in a c-program. I want to
> know if is possible import a table from a external text file without
> using INSERT (it's too slow) and if it's how i must do.
If INSERT is too slow for you, you probab
Quoting Alberto Daniotti :
> Good Morning.
> I have a question. I want integrate sqlite in a c-program. I want to
> know if is possible import a table from a external text file without
> using INSERT (it's too slow) and if it's how i must do.
How often would you need to do that? If it's a one
Hi,
I need a database to be accessible from all the nodes in a cluster but
don't want the burden of administering a full client/server product (as
for instance MySQL), so I was thinking about placing an SQLite database
in a disk partition shared by all the nodes with a cluster filesystem.
Has an
Good Morning.
I have a question. I want integrate sqlite in a c-program. I want to know if is
possible import a table from a external text file without using INSERT (it's
too slow) and if it's how i must do.
Thanks
___
sqlite-users mailing list
sqlite-
me too want to remove it if you know kindly tell me also...
Vishal...
--- On Tue, 6/30/09, Rajesh Nair wrote:
From: Rajesh Nair
Subject: [sqlite] Remove email ID from this list
To: sqlite-users@sqlite.org
Date: Tuesday, June 30, 2009, 5:22 PM
HI,
How to remove my mail id from this discuss
On 7/7/09 8:47 , "Nicolas Williams" wrote:
> On Tue, Jul 07, 2009 at 12:17:36AM +0100, Simon Slavin wrote:
[...]
> This is way off-topic now, but, to be fair, RFC1855 is not a standard,
> it is an Informational status RFC -- it provides information.
>
It possibly is never off-topic to educate
32 matches
Mail list logo
