headers
tabuleiro | 1 Sep 2003 04:56
Picon
Favicon

SQLite Browser web pages and screenshots

Hi. I posted a link to the SQLite Browser project last week, but 
unfortunately the page was only live for a couple of hours. Murphy's 
law dictated that the SourceForge's shell server hosting all projects 
starting with the letter "s" of course HAD to crash 18 hours after I 
posted the link, and it remained unavailable for 5 days... :)

The page is online now if you want to check it out. There are some 
screenshots, source code, developer information and binaries 
available at http://sqlitebrowser.sourceforge.net . This project is 
aimed at users that do not want to use SQL to interact with the 
SQLite database, so it can be a good tool for you to distribute 
freely to your customers, or to non-developers that need to produce 
data for your projects. It is not meant to be a complete console like 
the Sqlite control center, but it is currently already ported to 
MacOSX and Linux/FreeBSD/other UNix platforms that support Qt.

Regards,
Mauricio 

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
(Continue reading)

Permalink | Reply | 0 comments |
headers
Tito Ciuro | 1 Sep 2003 08:05
Picon
Gravatar

Batch delete question

Hello,

I can think of two ways to batch delete record from a DB:

 > DELETE FROM Links WHERE LinkID IN (3, 4, 5, 6);

The other option is to loop building the strings:

 > BEGIN TRANSACTION
 > DELETE FROM Links WHERE LinkID = '3';
 > DELETE FROM Links WHERE LinkID = '4';
 > ...
 > DELETE FROM Links WHERE LinkID = '6';
 > COMMIT TRANSACTION

Now the question: since a user may decide to delete, say, hundreds of 
records, building a single string could be overkill. Is the second form 
an acceptable way to perform a DELETE, or are there better ways?

Thanks,

-- Tito
Permalink | Reply | 4 comments |
headers
fnarcis | 1 Sep 2003 13:17
Picon
Favicon

(unknown)

Hi,
 I need to use sqlite with jdk 1.3.
Cam somebody please tell me what to do?
Or can somebody send me the libary compiled for windows?

Thank you.

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Permalink | Reply | 0 comments |
headers
D. Richard Hipp | 1 Sep 2003 14:08

Re: Batch delete question

Tito Ciuro wrote:
> Hello,
> 
> I can think of two ways to batch delete record from a DB:
> 
>  > DELETE FROM Links WHERE LinkID IN (3, 4, 5, 6);
> 
> The other option is to loop building the strings:
> 
>  > BEGIN TRANSACTION
>  > DELETE FROM Links WHERE LinkID = '3';
>  > DELETE FROM Links WHERE LinkID = '4';
>  > ...
>  > DELETE FROM Links WHERE LinkID = '6';
>  > COMMIT TRANSACTION
> 
> Now the question: since a user may decide to delete, say, hundreds of 
> records, building a single string could be overkill. Is the second form 
> an acceptable way to perform a DELETE, or are there better ways?
> 

Either method should work fine.

A third option is this:

   CREATE TEMP TABLE todel(x);
   INSERT INTO todel VALUES('3');
   INSERT INTO todel VALUES('4');
   ...
   INSERT INTO todel VALUES('6');
(Continue reading)

Permalink | Reply | 1 comment |
headers
andu | 1 Sep 2003 15:49

add new column

Following the example for 'delete column' in the FAQ I did the
following:

BEGIN TRANSACTION;
CREATE TEMPORARY TABLE 't1-backup'('a','b','c');
INSERT INTO 't1-backup' SELECT 'a','b','' FROM 't1';
DROP TABLE 't1';
CREATE TABLE 't1'('a','b','c');
INSERT INTO 't1' SELECT 'a','b','c' FROM 't1-backup';
DROP TABLE 't1-backup';
COMMIT;

...which works fine. 
However with the 'stable' SQLite extension for php (pear) this doesn't
work, the table is not changed. Can someone sugest a diferent
syntax for adding a column?

--

-- 
Regards, Andu Novac

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mrs. Brisby | 1 Sep 2003 15:26

Re: Batch delete question

On Mon, 2003-09-01 at 08:08, D. Richard Hipp wrote:
> Tito Ciuro wrote:
> > Hello,
> > 
> > I can think of two ways to batch delete record from a DB:
> > 
> >  > DELETE FROM Links WHERE LinkID IN (3, 4, 5, 6);

If you have a set of record selections, if the user has selected more
than half of the records, it makes sense to invert the question:

DELETE FROM Links WHERE NOT(LinkID IN (1, 2, 7));

Half memory, half time...

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Permalink | Reply | 0 comments |
headers
Paul Smith | 1 Sep 2003 18:06
Picon
Favicon

'CREATE <table> AS <select>' problem

If I do something like:

create temp mytable as select x.* from x inner join y on x.id=y.id;

I get a table 'mytable' with column names such as 'x.id', 'x.name' etc
This is sort of fine (but not what I expected)

However, then if I try to make an index on it

'create index mytable_i on mytable(x.id);'
I get an error 'syntax error near "."'

If I try
'create index mytable_i on mytable('x.id');'
I get told I can't make an index on a non-integer constant (why would I 
want to make one on an *integer* constant???)

So, how do I do this?

Or, do I have to have:
create temp mytable as select x.id as id, x.name as name, <etc> from x 
inner join y on x.id=y.id;
(which defeats some of the point of the 'create .. as ..' construct for me)

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->
(Continue reading)

Permalink | Reply | 2 comments |
headers
D. Richard Hipp | 1 Sep 2003 20:30

Re: 'CREATE <table> AS <select>' problem

Paul Smith wrote:
> 
> 'create index mytable_i on mytable(x.id);'
> I get an error 'syntax error near "."'
> 
> If I try
> 'create index mytable_i on mytable('x.id');'
> I get told I can't make an index on a non-integer constant (why would I 
> want to make one on an *integer* constant???)
> 

    CREATE INDEX mytable_i ON mytable("x.id");  -- double quotes
    CREATE INDEX mytable_i ON mytable([x.id]);  -- microsoft style

--

-- 
D. Richard Hipp -- drh@... -- 704.948.4565

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Permalink | Reply | 1 comment |
headers
Paul Smith | 1 Sep 2003 23:09
Picon
Favicon

Re: 'CREATE <table> AS <select>' problem

At 14:30 01/09/2003 -0400, you wrote:
>Paul Smith wrote:
> >
> > 'create index mytable_i on mytable(x.id);'
> > I get an error 'syntax error near "."'
> >
> > If I try
> > 'create index mytable_i on mytable('x.id');'
> > I get told I can't make an index on a non-integer constant (why would I
> > want to make one on an *integer* constant???)
> >
>
>     CREATE INDEX mytable_i ON mytable("x.id");  -- double quotes
>     CREATE INDEX mytable_i ON mytable([x.id]);  -- microsoft style

Ah, OK. I was getting the single quotes from a '.schema' output which had 
single quotes..

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
(Continue reading)

Permalink | Reply | 0 comments |
headers
eztools2003 | 2 Sep 2003 01:54
Picon
Favicon

SQLite value-add products page

Is there a page somewhere with all of the SQLite value-add products 
listed?  I understand there are several products, but how would one 
go about finding out about them at a single place?  I looked on the 
sqlite.org website, but didn't see one.  For example, how would one 
know about and find the SQLHelper product?  (actually, I need to find 
a pointer to the SQLHelper website now).

Dr. Hipp, would you consider adding such as page to the sqlite.org 
website?  Then the group could just point people who are looking to 
this page.

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/EbFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
sqlite-unsubscribe@...

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Permalink | Reply | 2 comments |

Gmane