Hi all.
I spent the last days bragging that a single database file as provided by
sqlite is a far better approach to store data than -literally- thousands of
flat files. Now, I got a small amount of testing data an wow ... I'm stuck.
Area: Bioinformatics. Imagine a matrix of data: genetic mark
Just out of personal interest:
Could you detail on which versions of Windows it works, and on which it
doesn't?
Thanks
Rolf
[EMAIL PROTECTED] wrote:
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
On 3/2/06, Vishal Kashyap <[EMAIL PROTECTED]> wrote:
Dear All ,
Wanted to know if we can u
Appreciate you looking into this in such detail for me, at least I wasn't
going completely crazy thinking that it should have worked. I'll go ahead
and try to change the code generator to use your suggested workaround, but
will keep an eye on the new ticket 1700:
http://www.sqlite.org/cvstrac/tktv
Boris Popov wrote:
Looks like I'm on my own with this one :)
After a bit of fiddling with it this morning, I figured I had to do this
SELECT DISTINCT * FROM (SELECT t1.ID
FROM GR_ADDRESS t1
WHERE t1.ID > 1 UNION ALL SELECT t1.ID
FROM PERSON t1 ORDER BY t1.ID DESC)
instead of
SELECT DISTINC
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 3/2/06, Vishal Kashyap <[EMAIL PROTECTED]> wrote:
> > Dear All ,
> >
> > Wanted to know if we can use sqlite database from network drives ?
>
> It works if your operating system correctly handles locking.
> If I remember correctly there are some probl
On 3/2/06, Vishal Kashyap <[EMAIL PROTECTED]> wrote:
> Dear All ,
>
> Wanted to know if we can use sqlite database from network drives ?
It works if your operating system correctly handles locking.
If I remember correctly there are some problems with windows drives,
but NFS works.
Check the docume
I would be interested in knowing how you handle simulatneous inserts and/or
updates...
On 3/2/06, Vishal Kashyap <[EMAIL PROTECTED]> wrote:
>
> Dear All ,
>
> Wanted to know if we can use sqlite database from network drives ?
>
> --
> With Best Regards,
> Vishal Kashyap.
> http://www.vishal.net.in
Dear All ,
Wanted to know if we can use sqlite database from network drives ?
--
With Best Regards,
Vishal Kashyap.
http://www.vishal.net.in
Looks like I'm on my own with this one :)
After a bit of fiddling with it this morning, I figured I had to do this
SELECT DISTINCT * FROM (SELECT t1.ID
FROM GR_ADDRESS t1
WHERE t1.ID > 1 UNION ALL SELECT t1.ID
FROM PERSON t1 ORDER BY t1.ID DESC)
instead of
SELECT DISTINCT * FROM (SELECT t1.I
On 3/2/06, erw2 <[EMAIL PROTECTED]> wrote:
>
> Now I try to execute SQL query:
> SELECT PomiarBledow.IDpomiaru, Samochody.Samochod
> FROM (PomiarBledow INNER JOIN Modele ON PomiarBledow.IDmod =
> Modele.IDmod) INNER JOIN Samochody ON Modele.IDsam = Samochody.IDsam
> WHERE (((PomiarBledow.IDpomiaru)
Hi sqlite-users,
I have a following problem. In my database there are 3 table:
CREATE TABLE [Samochody]
(
[IDsam] integer,
[Samochod] varchar (50),
PRIMARY KEY ([IDsam])
);
CREATE TABLE [Modele]
(
[IDmod] integer,
[IDsam] integer,
[Model] varchar (
On Thu, 2 Mar 2006, Sripathi Raj wrote:
[...]
Is the IF NOT EXISTS constraint supported? When I try to use it, I get an
error message saying that there is a syntax error at 'NOT'? I'm using Sqlite
3 on Windows and I'm trying to connect to it from Perl.
[...]
Hello,
the information that you ar
Sripathi Raj wrote:
Hi,
Is the IF NOT EXISTS constraint supported? When I try to use it, I get an
error message saying that there is a syntax error at 'NOT'? I'm using Sqlite
3 on Windows and I'm trying to connect to it from Perl.
Thanks,
Raj
I can't use it either..same error so i guessed
Hi,
Is the IF NOT EXISTS constraint supported? When I try to use it, I get an
error message saying that there is a syntax error at 'NOT'? I'm using Sqlite
3 on Windows and I'm trying to connect to it from Perl.
Thanks,
Raj
-Ursprüngliche Nachricht-
Von: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 2. März 2006 17:21
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Vacuum slow
> But I wonder :
>
> if I have a db ~ 1gb and I delete all the data in the tables ( db is
> than nearly empty )
>
"Eggert, Henri" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I use sqlite 3.3.4 and I am very happy with it - it is very fast.
>
> But I wonder :
>
> if I have a db ~ 1gb and I delete all the data in the tables ( db is
> than nearly empty )
> Issuing a vacuum command takes a long time ( several min
> But I wonder :
>
> if I have a db ~ 1gb and I delete all the data in the tables ( db is
> than nearly empty )
> Issuing a vacuum command takes a long time ( several minutes ).
> Why ?
> Is there a way to "vacuum" faster ?
We found that vacuuming the database was also slow. We no longer vaccum
Hello Jay,
Thursday, March 2, 2006, 11:20:50 AM, you wrote:
>> But I wonder :
>>
>> if I have a db ~ 1gb and I delete all the data in the tables ( db is
>> than nearly empty )
>> Issuing a vacuum command takes a long time ( several minutes ).
>> Why ?
>> Is there a way to "vacuum" faster ?
JS> I
> But I wonder :
>
> if I have a db ~ 1gb and I delete all the data in the tables ( db is
> than nearly empty )
> Issuing a vacuum command takes a long time ( several minutes ).
> Why ?
> Is there a way to "vacuum" faster ?
If you delete ALL the data you can just delete the database file
then crea
Hi all,
I use sqlite 3.3.4 and I am very happy with it - it is very fast.
But I wonder :
if I have a db ~ 1gb and I delete all the data in the tables ( db is
than nearly empty )
Issuing a vacuum command takes a long time ( several minutes ).
Why ?
Is there a way to "vacuum" faster ?
Thank's f
"Jay Sprenkle" <[EMAIL PROTECTED]> writes:
>> What I think you're really asking, though, is about the rows that are NOT
>> returned because there are null values. To fix that, you're probably looking
>> for LEFT OUTER JOIN:
>
> Huh? I thought left join and left outer join were equivalent.
>
> SQ
> What I think you're really asking, though, is about the rows that are NOT
> returned because there are null values. To fix that, you're probably looking
> for LEFT OUTER JOIN:
Huh? I thought left join and left outer join were equivalent.
SQLite version 3.0.8
Enter ".help" for instructions
sql
Roger <[EMAIL PROTECTED]> writes:
> Select p.name||p1.name||p2.name
> from people as p left join user as u as
> u.uid = p.pid left joun people as p2 on
> u.uid=p2.pid left join people as p3 on
> u.uid=p3.pid;
>
> The problem is that if one of the rows does not have a value, it returns
> and empty
Hi,
use coalesce(p1.name, 'empty') to substitute a text 'empty' for a null
column.
Martin
Roger schrieb:
Please help me, i am running out of time.
I am building a web based application which runs with on sqlite as the
database.I am now creating my reports using Agata.
My problem is as fol
Please help me, i am running out of time.
I am building a web based application which runs with on sqlite as the
database.I am now creating my reports using Agata.
My problem is as follows.
I am trying to create a view so that my report tool queries directly
from the view as follows
Select p.na
On 2/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> The Acme Fox also supports PHP development, optionally
> with Oracle's open source SQLite database.
>
There's always some weird and wrong when mixing "Oracle" and "open
source". I fear for the destiny of projects funded
Thanks to everyone answering in this thread!
On Wed, Mar 01, 2006 at 05:44:45PM -0800, Nathaniel Smith wrote:
[...]
> I don't know enough about your app to know if this would work, but
> if you only have the one app instance managing locks, and locks expire
> whenever that app dies... perhaps you
Hi sqlite-users,
is now available the "devpak" for the IDE Dev-Cpp and Code::Blocks of the last
release of SQLite 3.3.4.
http://www.digitazero.org/2006/03/02/development-packages-by-digitazeroorg-eng/
Cheers, Danilo.
Home Page: http://www.digitazero.org
giovedì 2 marzo 2006, 10.31
28 matches
Mail list logo