Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-30 Thread Sam Carleton 
I believe that is the one.  It is possible to run the XULRunner app stand
alone.  Go to the Firefox web site for details on exactly how to do that.
 What I did was start up Firefox, go to the add-ins, search for SQLite and
install it into Firefox.  Then in the tools menu there is a link to start
the application.

Sam

On Fri, Oct 30, 2009 at 8:44 AM, Ted Rolle  wrote:

> On Fri, 30 Oct 2009 13:25:50 +0100
> Gilles Ganault  wrote:
>
> > On Mon, 26 Oct 2009 15:07:38 -0400, Sam Carleton
> >  wrote:
> > >There is a WONDERFUL Firefox plug-in that I use, I love it!  I am
> > >guessing it works on all OS's but I use it on Windows Vista and
> > >Windows 7.
> >
> > Thanks. I assume it's the SQLite Manager plug-in:
> >
> > http://code.google.com/p/sqlite-manager/
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> Got it.  It's a file on my desktop.  How do I install it?
>
> Ted
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-30 Thread Ted Rolle 
On Fri, 30 Oct 2009 13:25:50 +0100
Gilles Ganault  wrote:

> On Mon, 26 Oct 2009 15:07:38 -0400, Sam Carleton
>  wrote:
> >There is a WONDERFUL Firefox plug-in that I use, I love it!  I am
> >guessing it works on all OS's but I use it on Windows Vista and
> >Windows 7.
> 
> Thanks. I assume it's the SQLite Manager plug-in:
> 
> http://code.google.com/p/sqlite-manager/
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Got it.  It's a file on my desktop.  How do I install it?

Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-30 Thread Gilles Ganault 
On Mon, 26 Oct 2009 15:07:38 -0400, Sam Carleton
 wrote:
>There is a WONDERFUL Firefox plug-in that I use, I love it!  I am guessing
>it works on all OS's but I use it on Windows Vista and Windows 7.

Thanks. I assume it's the SQLite Manager plug-in:

http://code.google.com/p/sqlite-manager/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-26 Thread Sam Carleton 
There is a WONDERFUL Firefox plug-in that I use, I love it!  I am guessing
it works on all OS's but I use it on Windows Vista and Windows 7.

Sam

On Mon, Oct 26, 2009 at 2:53 PM, Gilles Ganault wrote:

> On Mon, 26 Oct 2009 11:31:50 +0500, "SQL Maestro Group"
>  wrote:
> >SQLite Maestro allows you to copy query results to clipboard with ease:
> just
> >execute a query and press Ctrl+A, Ctrl+C.
>
> Thanks, I'll check it out.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-26 Thread Gilles Ganault 
On Mon, 26 Oct 2009 11:31:50 +0500, "SQL Maestro Group"
 wrote:
>SQLite Maestro allows you to copy query results to clipboard with ease: just
>execute a query and press Ctrl+A, Ctrl+C.

Thanks, I'll check it out.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-26 Thread SQL Maestro Group 
> SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
> won't let me copy the output of a SELECT into the clipboard so I can
> paste it elsewhere.
>
> Are there better alternatives?

SQLite Maestro allows you to copy query results to clipboard with ease: just
execute a query and press Ctrl+A, Ctrl+C.

It is also possible to export query results directly to MS Excel 97-2003, MS
Excel 2007, CSV/DSV/TSV, HTML, XML, MS Access, PDF, DBF, RTF, OpenDocument
Spreadsheet and some other formats. :-)

http://www.sqlmaestro.com/products/sqlite/maestro/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-24 Thread Gilles Ganault 
On Sat, 24 Oct 2009 16:28:21 +0200, Gilles Ganault
 wrote:
>>You could also try http://www.gaia-gis.it/spatialite/
>
>Ah, good one :-) It succesfully SELECTed all the rows, and let me copy
>them into the clipboard in a fraction of a second. Thanks a lot.

I'll take that back: It only displays/copies rows 500 at a time :-/

Looks like 100.000 is just too much to copy to clipboard, so they have
to be saved to a file and re-opened in a spreadsheet.

Thanks again.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-24 Thread Gilles Ganault 
On Fri, 23 Oct 2009 18:13:27 +0200, "Roger Andersson"
 wrote:
>Never had any access violation but regarding number of records
>Options -> Fetch Size -> 0
>And then like said by Donald, right click and Copy Result Set To Clipboard

Thanks for the tip, but after SELECTing 100.000 rows,  right-clicking
on the resultset and choosing "Copy Result Set to Clipboard",
SQLiteExplorer shows the hourglass and it's still not done after 5mn
:-/

No problem though, as SQLite Expert (www.sqliteexpert.com) and
Spatialite GUI (www.gaia-gis.it/spatialite/) did the job.

Thanks everyone for the feedback.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-24 Thread Gilles Ganault 
On Fri, 23 Oct 2009 09:55:17 -0700, Alex Mandel
 wrote:
>There's a reason why a lot of them don't display more than 100-1000
>records per view.

Yup. The Firefox-based  SQLiteManager couldn't handle the 100.000 rows
I SELECTed :-/

>You could also try http://www.gaia-gis.it/spatialite/

Ah, good one :-) It succesfully SELECTed all the rows, and let me copy
them into the clipboard in a fraction of a second. Thanks a lot.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Clark Christensen 
>SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
>won't let me copy the output of a SELECT into the clipboard so I can
>paste it elsewhere.

FWIW, I'm pretty happy with SQLiteSpy, even though I don't use it for 
copy/paste of results.  I used SQLite Explorer before, and am happy with the 
switch.

In the (admittedly older) version I have, I can click on any cell in the 
results, press Ctrl-A, Ctrl-C, and it appears to copy the resultset into the 
clipboard.  I just pasted a couple thousand rows of results into both Excel, 
and into a text editor following these steps.


 -Clark


- Original Message 
From: Gilles Ganault <gilles.gana...@free.fr>
To: sqlite-users@sqlite.org
Sent: Fri, October 23, 2009 2:45:18 AM
Subject: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

Hello

I'm looking for a Windows alternative to the CLI sqlite.exe to manage
SQLite databases.

SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
won't let me copy the output of a SELECT into the clipboard so I can
paste it elsewhere.

Are there better alternatives?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Keith Roberts 
On Fri, 23 Oct 2009, Arjen Markus wrote:

> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> From: Arjen Markus <arjen.mar...@deltares.nl>
> Subject: Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?
> 
> How about SQLIteStudio? http://sqlitestudio.one.pl/index.rvt
>
> Regards,
>
> Arjen

Looks OK to me.

Also found this link:

http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Not had time to check them all out yet though.

Kind Regards,

Keith Roberts

-
Websites:
http://www.php-debuggers.net
http://www.karsites.net
http://www.raised-from-the-dead.org.uk

All email addresses are challenge-response protected with
TMDA [http://tmda.net]
-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Alex Mandel 
Gilles Ganault wrote:
> On Fri, 23 Oct 2009 12:00:47 +0200, Thibaut Gheysen
>  wrote:
>> You can use sqlite-manager (http://code.google.com/p/sqlite-manager/). 
> 
> Thanks for the tip, but I'd rather a stand-alone rather than a Firefox
> plug-in.
> 

If you have the XUL libraries installed it will run standalone I
believe. Just to check when you are testing these tools, are you also
looking at "Save to CSV" which would be just as good as a copy paste?

There's a reason why a lot of them don't display more than 100-1000
records per view.

You could also try http://www.gaia-gis.it/spatialite/

Alex

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Roger Andersson 
> Unless I overlooked it, it won't let me copy all the rows 
> into the clipboard (tried CTRL-A, also tried selecting the 
> first and the last row followed by CTRL-C, to no avail).
>
> Also...
> 
> "V3.01 29/11/2007"
> 
> "Access violation at address 006C304F in module 'sqlite3Explorer.exe'.
> Read of address 0039."
> 
> Too bad :-/ Thanks anyway.
> =
> 
Never had any access violation but regarding number of records
Options -> Fetch Size -> 0
And then like said by Donald, right click and Copy Result Set To Clipboard

/Roger

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Griggs, Donald 
 

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault
Sent: Friday, October 23, 2009 11:12 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

On Fri, 23 Oct 2009 10:19:17 -0400, "Griggs, Donald"
<donald.gri...@allscripts.com> wrote:
>I'm grateful to Mike Cariotoglou for Sqlite3Explorer
> http://www.singular.gr/sqlite/

Unless I overlooked it, it won't let me copy all the rows into the
clipboard (tried CTRL-A, also tried selecting the first and the last row
followed by CTRL-C, to no avail).

Also...

"V3.01 29/11/2007"

"Access violation at address 006C304F in module 'sqlite3Explorer.exe'.
Read of address 0039."

Too bad :-/ Thanks anyway.
=

Regarding Sqlite3Explorer:  "..it won't let me copy all the rows into
the clipboard ..."

   I should probably have mentioned that RIGHT-CLICK within the output
grid provides an option to "COPY RESULT SET TO CLIPBOARD".
   I just tried it with 9150 rows, and they appeared to paste correctly
into a blank Micro$oft Excel spreadsheet.

For truly *huge* outputs, you may prefer a script to export from
sqlite3.exe and import elsewhere.

Regarding:
  "Access violation "
I cant' say.  I think the author may be on this list, or you can search
out his email address.

Hope this helps,
  Donald
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 10:19:17 -0400, "Griggs, Donald"
 wrote:
>I'm grateful to Mike Cariotoglou for Sqlite3Explorer
> http://www.singular.gr/sqlite/

Unless I overlooked it, it won't let me copy all the rows into the
clipboard (tried CTRL-A, also tried selecting the first and the last
row followed by CTRL-C, to no avail).

Also...

"V3.01 29/11/2007"

"Access violation at address 006C304F in module 'sqlite3Explorer.exe'.
Read of address 0039."

Too bad :-/ Thanks anyway.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 12:11:52 +0100, "O'Neill, Owen"
 wrote:
>I'm pretty sure QT is statically linked against it on the windows
>versions. 

I'll check it out, although I'd rather something actively supported.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 22:36:16 +1100, Neville Franks
 wrote:
>The best I have found is SQLite Expert http://www.sqliteexpert.com/
>The Personal version is free. And I have checked out many.

Thanks for the pointer. The Free version doesn't allow copying more
than 100 rows into the clipboard, so I'll check the commercial version
instead.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 12:56:59 +0200, Arjen Markus
 wrote:
>How about SQLIteStudio? http://sqlitestudio.one.pl/index.rvt

Thanks for the link. It seems unable to return all the rows, and only
displays them by 1.000, so I can't just select the whole thing and
copy it into the clipboard :-/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Griggs, Donald 
Regarding:  "...copy the output of a SELECT into the clipboard so I can
paste it elsewhere."

 Sorry for piling on another "me too" post, but:

I'm grateful to Mike Cariotoglou for Sqlite3Explorer
 http://www.singular.gr/sqlite/

You can copy/paste the results of a select instantly into a program that
accepts tab separators (such as Excel).


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Neville Franks 
Gilles,
The best I have found is SQLite Expert http://www.sqliteexpert.com/
The Personal version is free. And I have checked out many.


Friday, October 23, 2009, 8:45:18 PM, you wrote:

GG> Hello

GG> I'm looking for a Windows alternative to the CLI sqlite.exe to manage
GG> SQLite databases.

GG> SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
GG> won't let me copy the output of a SELECT into the clipboard so I can
GG> paste it elsewhere.

GG> Are there better alternatives?

GG> Thank you.

---
Best regards,
  Neville Franks, http://www.surfulater.com http://blog.surfulater.com
 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread O'Neill, Owen 

I'm pretty sure QT is statically linked against it on the windows
versions. 

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault
Sent: Friday, October 23, 2009 11:55 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

On Fri, 23 Oct 2009 11:13:05 +0100, "O'Neill, Owen"
<oone...@averyberkel.com> wrote:
>http://sqlitebrowser.sourceforge.net/screenshots.html

Thanks for the pointer.

"Version 1.2 released - 04/05/2005"
"SQLite Database Browser requires Trolltech's QT"

I'll give it a shot but if I find something more recent and
dependence-free, I'll report back.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Arjen Markus 
How about SQLIteStudio? http://sqlitestudio.one.pl/index.rvt

Regards,

Arjen

On 2009-10-23 12:54, Gilles Ganault wrote:
> On Fri, 23 Oct 2009 11:13:05 +0100, "O'Neill, Owen"
>  wrote:
>> http://sqlitebrowser.sourceforge.net/screenshots.html
> 
> Thanks for the pointer.
> 
> "Version 1.2 released - 04/05/2005"
> "SQLite Database Browser requires Trolltech's QT"
> 
> I'll give it a shot but if I find something more recent and
> dependence-free, I'll report back.
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 11:13:05 +0100, "O'Neill, Owen"
 wrote:
>http://sqlitebrowser.sourceforge.net/screenshots.html

Thanks for the pointer.

"Version 1.2 released - 04/05/2005"
"SQLite Database Browser requires Trolltech's QT"

I'll give it a shot but if I find something more recent and
dependence-free, I'll report back.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread O'Neill, Owen 

http://sqlitebrowser.sourceforge.net/screenshots.html


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault
Sent: Friday, October 23, 2009 10:45 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

Hello

I'm looking for a Windows alternative to the CLI sqlite.exe to manage
SQLite databases.

SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
won't let me copy the output of a SELECT into the clipboard so I can
paste it elsewhere.

Are there better alternatives?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
On Fri, 23 Oct 2009 12:00:47 +0200, Thibaut Gheysen
 wrote:
>You can use sqlite-manager (http://code.google.com/p/sqlite-manager/). 

Thanks for the tip, but I'd rather a stand-alone rather than a Firefox
plug-in.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Thibaut Gheysen 
You can use sqlite-manager (http://code.google.com/p/sqlite-manager/). 
To copy select result into the clipboard : just select the rows, 
right-click on these rows and  click on "Copy Row(s) as CSV".

Thibaut.

Gilles Ganault a écrit :
> Hello
>
> I'm looking for a Windows alternative to the CLI sqlite.exe to manage
> SQLite databases.
>
> SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
> won't let me copy the output of a SELECT into the clipboard so I can
> paste it elsewhere.
>
> Are there better alternatives?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [Windows] Good GUI alternative to sqlite.exe?

2009-10-23 Thread Gilles Ganault 
Hello

I'm looking for a Windows alternative to the CLI sqlite.exe to manage
SQLite databases.

SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it
won't let me copy the output of a SELECT into the clipboard so I can
paste it elsewhere.

Are there better alternatives?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users