>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
"Gilles Ganault" schrieb im
Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com...
> Maybe someone will come up with a commercial alternative.
> I for one would gladly pay for a single-EXE, no-brainer solution
> that can run on Windows and *nix.
Hmm in this case, what about:
http://www.
On Fri, 23 Oct 2009, Arjen Markus wrote:
> To: General Discussion of SQLite Database
> From: Arjen Markus
> 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 th
> You can implement your own database cache which will respect overall
> limit on memory usage.
>
> Pavel
Was hoping to avoid that :(
With so many cache pages available, shouldn't the sqlite3_release_memory
calls, caused by the soft limit, have been able to keep memory below the
soft limit?
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
Yes, correct. I just showed it to indicate that all databases that are
ever created use this page_size of 4KB.
> > PRAGMA page_size=4096
>
> This PRAGMA governs characteristics of a database you have not yet
> created: it's pages on disk, not pages in memory. The page_size is a
> characteristic
On 23 Oct 2009, at 4:06pm, Doug wrote:
> PRAGMA page_size=4096
This PRAGMA governs characteristics of a database you have not yet
created: it's pages on disk, not pages in memory. The page_size is a
characteristic of the database file on disk. It has no effect in a
program which opens a
> 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'.
> Rea
-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
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 follow
You can implement your own database cache which will respect overall
limit on memory usage.
Pavel
On Fri, Oct 23, 2009 at 11:06 AM, Doug wrote:
> I'm trying to figure out how to limit SQLite's memory usage while still
> giving it as much memory as I can.
>
> The app has about 50-60 separate data
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@sq
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
I'm trying to figure out how to limit SQLite's memory usage while still
giving it as much memory as I can.
The app has about 50-60 separate database handles to 50-60 separate database
files. Each handle is only used by a single thread at a time, and most are
always accessed by the thread that cre
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 :-/
__
Thanks for the links
On Fri, 23 Oct 2009 08:48:53 -0400, "Griggs, Donald"
wrote:
>I know almost nothing about them, but the following may possibly be of
>interest:
>
>http://sqlrelay.sourceforge.net/
This one looks quite a bit big for my needs :-/
>http://www.it77.de/sqlite/sqlite.htm
"28.05.
Sigh. That last sentence sounds confusing, I meant it literally, in
your where clause you tell the system how to deal with NULL cases
using IS NOT and IS NOT NULL.
-scott
On Fri, Oct 23, 2009 at 7:37 AM, Scott Hess wrote:
> NULL is the logical lack of a value, and is not the same as some other
NULL is the logical lack of a value, and is not the same as some other
value EVERY SINGLE TIME. NULL is not equal to 1, NULL is not equal to
'one', NULL is also not equal to NULL. It's like NaN, except
not-a-value. When you join using equality (or comparison) on a column
which can have NULL valu
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 progr
Gilles,
I know almost nothing about them, but the following may possibly be of
interest:
http://sqlrelay.sourceforge.net/
http://www.it77.de/sqlite/sqlite.htm
http://www.sqlite.org/cvstrac/wiki?p=ClientServer
Donald
___
sqlite-users mailing list
sq
Is this the right behavior?
CREATE TABLE t1(x INTEGER NOT NULL, y INTEGER);
INSERT INTO t1(x, y) VALUES (1, 0);
INSERT INTO t1(x, y) VALUES (2, 1);
INSERT INTO t1(x, y) VALUES (3, NULL);
sqlite> SELECT * FROM t1 A NATURAL JOIN t1 B;
1|0
2|1
I sense this could be right, but anyway... why
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>
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: [sqli
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
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-
On Fri, 23 Oct 2009 03:25:45 -0700, Roger Binns
wrote:
>The problem is that the moment you have a network accessible service you
>have to deal with administration. Things like authentication, security,
>log files etc.
In the absolute, yes, but not if SQLite is to be used in a firewalled
LAN just
Gilles Ganault wrote:
> I wanted to check if someone had
> recently written a similar solution so that SQLite can be used as a
> light, no-brainer DB server?
The problem is that the moment you have a network accessible service you
have to deal with administration. Things like authentication, secu
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 alt
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-use
Hello
I know that SQLite is meant as a server-less, file server-based
solution, but... since Richard Hipp has also written a single-EXE SCM
solution (www.fossil-scm.org), I wanted to check if someone had
recently written a similar solution so that SQLite can be used as a
light, no-brainer DB serve
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 sq
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.
__
32 matches
Mail list logo