On 7/07/2009 10:13 AM, Rick Ratchford wrote:
Hi Simon.
Ah. So what I need to do then is to make the return of strftime of type INT.
Since I'm creating a recordset from an existing table (rather than creating
a table itself), then I don't have the option to set the affinity of my
newly
On Tue, Jul 07, 2009 at 12:17:36AM +0100, Simon Slavin wrote:
He didn't make up the rule. Nor did I. It's part of the standard for
mailing lists and usenet:
http://www.faqs.org/rfcs/rfc1855.html
This is way off-topic now, but, to be fair, RFC1855 is not a standard,
it is an Informational
On 7/7/09 8:47 , Nicolas Williams nicolas.willi...@sun.com 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
me too want to remove it if you know kindly tell me also...
Vishal...
--- On Tue, 6/30/09, Rajesh Nair rajesh.avit...@gmail.com wrote:
From: Rajesh Nair rajesh.avit...@gmail.com
Subject: [sqlite] Remove email ID from this list
To: sqlite-users@sqlite.org
Date: Tuesday, June 30, 2009, 5:22 PM
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
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
Quoting Alberto Daniotti albertodanio...@libero.it:
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
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 probably
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
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', Date)
Thank you for the answer.
Could you give me an example of use of BEGIN TRANSACTION?
Thanks
- Original Message -
From: Simon Slavin slav...@hearsay.demon.co.uk
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Tuesday, July 07, 2009 1:22 PM
Subject: Re: [sqlite]
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 know what
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
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 count from foo
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!
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)
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 stan.li...@gmail.com:
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
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
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
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
looked
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
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
On Mon, 6 Jul 2009 16:53:35 -0500, Nicolas Williams
nicolas.willi...@sun.com 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
bayouben...@mac.com wrote:
nuts. that makes INSERT OR REPLACE worthless if you have tables
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 =
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
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.sqlite')
e
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
-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(UPDATE
nixonron nixon...@yahoo.com 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,
On Tue, Jul 7, 2009 at 1:10 PM, Mark Spiegelmspie...@vipmail.com 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
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 things
32 matches
Mail list logo
