To: sqlite-users@sqlite.org
Subject: [sqlite] Bug : Tcl interface: array not created when call db
eval {...} ?array-name? ?script?
[ The following text is in the ISO-8859-1 character set. ]
[ Your display is set for the US-ASCII character set. ]
[ Some characters may be
I'm not sure exactly what you're asking here, but if the question is
whether to use database blobs vs files, then you might be interested in
this technical report from Microsoft:
arxiv.org/ftp/cs/papers/0701/0701168.pdf
--
}
return $ret
}
% recode a value
a value
% recode
NULL
There are, of course many reasons why a null string is not equivalent to
NULL, but for many applications, the differences are moot.
I'm just saying ...
Cheers,
Rob Sciuk
___
sqlite-users mailing list
, in the
hopes that someone can point me to something which exists (and I hope, I
simply overlooked).
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
it to be highly portable ... but I
have no knowledge of SQLite bindings for it ... shouldn't be hard, though.
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to same. Couple the very generous
license with the copious talents of those contributing to the project, and
I believe that the next 10 years are a given.
Kudos, congratulations and most of all a deep appreciation to D. Richard
Hipp, et.al. Thanks, Richard.
Sincerely,
Rob Sciuk
of effort, and I'm not
entirely sure that it is the best return on investment (eg: the recent
support of foreign keys -- NICE!!), but I put it on the table for
consideration ... naively and without understanding of the impact upon
code organization 8-).
Just a humble suggestion.
Cheers,
Rob Sciuk
-).
Cheers,
Rob Sciuk
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=
Robert S. Sciuk http://www.controlq.com 259 Simcoe St. S.
Control-Q Research tel: 905.576.8028 Oshawa, Ont.
r...@controlq.com fax: 905.576.8386
NULL.
This is somewhat disconcerting, and seems repeatable. Are aggregate
functions handled differently than tuple data?
Are there any other dependancies other than SQLITE_ENABLE_COLUMN_METADATA?
Is there anything I might have overlooked??
Any ideas??
Thanks in advance,
Rob Sciuk
On Mon, 26 Oct 2009, Jay A. Kreibich wrote:
The documentation on this is fairly clear:
http://sqlite.org/c3ref/column_database_name.html
If the Nth column returned by the statement is an expression or
subquery and is not a column value, then all of these functions
On Mon, 26 Oct 2009, D. Richard Hipp wrote:
sqlite3_column_table_name() (and all of the other METADATA functions) only
work on table columns, not on functions. The documentation says as much,
though perhaps it could be worded more directly. I'll make a note to clarify
the documentation.
Perhaps this might lead you in the right direction Jean-Christophe ...
#include stdarg.h
#include stdlib.h
#include strings.h
Str_t s_format( Str_t fmt, ... ){
va_list ap ;
Int_tnx ;
Byt_tbuf[1] ;
Str_tqptr ;
va_start( ap, fmt );
nx = vsnprintf( buf, 0, fmt, ap
?act=about
It is fast, graphical, a single executable install (eg: trivial), and
works well with existing databases ... I've just started playing with
it on FreeBSD, and I must say that so far, I'm much impressed with the
tool.
HTH.
Cheers,
Rob Sciuk
On Wed, 5 Aug 2009, Allen Fowler wrote:
I would recommend SQLite Studio without hesitation. I think it pretty
much covers your criteria, have a look:
http://sqlitestudio.one.pl/index.rvt?act=about
It is fast, graphical, a single executable install (eg: trivial), and
works well with
useful in this regard. YMMV.
http://sourceforge.net/projects/mdbtools/files/
Hope this helps ...
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
at the Firebird 2.x project
for a C++ based DBMS should the implementation language be an issue.
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I note with interest the source download now (recently?) deprecates the
configure/make build of SQLite 3.6.x sources. What gives?? I've been
configure/make(ing) SQLite since, forever, and the only problems I ever
encountered were omitting options that I needed, and quickly sorted out!
How
than
accessing a client/server database, but as it seems that you are going to
squeeze the data through a web server, other bottlenecks may apply.
Experimentation is recommended, but the real qualifier will come at
saturation point.
HTH,
Rob Sciuk
From: DeTerra, David J david.j.dete...@boeing.com
Hi all,
I was wondering if there is a feature in sqlite that would allow a set
of in-memory databases to periodically be written to disk for purposes
of database recovery on application or machine failure?
And then subsequently read
This is not a problem, per se, but in an ideal world, one might handle the
error one time, and receive all the relevant information at one go. Is
there a reason to defer reporting the details until the transaction is
completed?
Just wondering ...
Cheers,
Rob Sciuk
)
) ;
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
have certainly simplified
life for me, at what I believe to be little to no cost with respect to
consistency -- even for the purists.
Sincerely,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
of trickery involved is that in order for the value types to
be correct (meaningful), you have to take a step as it were ... with
sqlite3_step 8-). In any event, I'm all sorted out, and I appreciate your
very quick and accurate response.
Cheers,
Rob Sciuk
PS: I've said it before, and at risk
From: Igor Tandetnik [EMAIL PROTECTED]
Rob Sciuk [EMAIL PROTECTED] wrote in
The other bit of trickery involved is that in order for the value
types to be correct (meaningful), you have to take a step as it
were ... with sqlite3_step 8-).
You can use sqlite3_column_decltype[16
( stmt, i ) ;
This should work across all datatypes, and simply allow proper null
handling -- not relying upon affinity dependant conversions ... hopefully,
I've simply overlooked something really obvious, but at this moment, is
opaque to me ... any pointers??
Cheers,
Rob Sciuk
that sqlite3_column_type( smt, i ) returns SQLITE_NULL iff
the data are missing. Is this correct??
Cheers,
Rob Sciuk
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, 17 Oct 2008, Michael Schlenker wrote:
It depends a bit on what you try to write and what other constraints you
have or are ok to accept.
Michael
Danke Michael.
Yes, I see what you mean. My intent was of course to mate a generic
procedural tcl with sqlite, and add a rich data
I've enabled the thread-safe option, and compiled sqlite3.5.9 against
tcl8.5.3, also PDO in PHP 5.2.5, and used it in web sites both with PHP,
and Tcl/Rivet under Apache 1.3.41. Sqlite seems to consistently choke
either in rivet, or under PHP with a similar problem:
Fatal error
Wow!, Thanks for your very swift reply, Sir.
On Mon, 28 Jul 2008, D. Richard Hipp wrote:
Perhaps FreeBSD does not implement recursive mutexes. In that case, you can
try to recompile with -DSQLITE_HOMEGROWN_RECURSIVE_MUTEX=1 and see if that
helps. It would be good to review the comments
On Mon, 28 Jul 2008, Rob Sciuk wrote:
top of mutex.h:
#ifdef __FreeBSD__
#define SQLITE_HOMEGROWN_RECURSIVE_MUTEX 1
#endif
OK, I've tracked the resulting glitch to a rivet dependancy, and the code
now works with the suggested define included!!! I'm not entirely sure the
status
How do I sign up for the digest rather than the regular feed??
Cheers,
Rob.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dear DRH,
I post the previous (FreeBSD/Ubuntu) and this *ONLY* to exercise the new
3.5.5 bits given the wholsale changes. I hope you find them useful, but
AFAICT, 3.5.5 looks pretty good from a perf/stability standpoint.
In the obscure machine/OS category, I lit this up on an HP9000 K200
On Fri, 1 Feb 2008, [EMAIL PROTECTED] wrote:
We do not understand the async3 problem and cannot reproduce it.
All the other issues have been fixed in CVS HEAD.
Actually, upon inspection, that may be an artifact of an earlier attempt
to run the tests as root, the chocolate directory was, in
rerun, with chocolate directory removed prior to test run.
./testfixture ../test/quick.test
bind-4.4...
Error: floating point value is Not a Number
bind-4.5...
Expected: [null real real]
Got: []
btree-2.1.1...CURSOR 4041F588 rooted at1(rw) currently at 1.0 eof
PAGE 1: flags=0x09
Ran the tests on Freebsd, the make test summary follows:
[delenda = ... Ok]
16 errors out of 38961 tests
Failures on these tests: bind-4.4 bind-4.5 cast-3.14 cast-3.18 cast-3.24
printf-1.7.6 printf-1.8.6 printf-1.9.7 tcl-1.6 vtab6-2.2 vtab6-2.4
vtab6-2.5 vtab6-2.6 vtab6-7.1 vtab6-9.1.1
On Thu, 31 Jan 2008, [EMAIL PROTECTED] wrote:
Rob Sciuk [EMAIL PROTECTED] wrote:
Ran the tests on Freebsd, the make test summary follows:
[delenda = ... Ok]
16 errors out of 38961 tests
Failures on these tests: bind-4.4 bind-4.5 cast-3.14 cast-3.18 cast-3.24
printf-1.7.6 printf-1.8.6 printf
On Thu, 31 Jan 2008, [EMAIL PROTECTED] wrote:
Date: Thu, 31 Jan 2008 18:27:35 +
From: [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] make test on FreeBSD 6.2-R, SQLite 3.5.5
Alexander Batyrshin [EMAIL PROTECTED] wrote:
How to get
$ uname -a
Linux linux 2.6.22-14-generic #1 SMP Sun Oct 14 23:05:12 GMT 2007 i686 GNU/Linux
$ make test | grep -v Ok | tee test.output.ubuntu
./testfixture ../test/quick.test
bind-4.4...
Error: floating point value is Not a Number
bind-4.5...
Expected: [null real real]
Got: []
further.
Apparently the db engine has been re-worked somewhat (extensively) with
this release, and I suspect that changes eminate from that code, but I
haven't had time to investigate ...
HTH,
Rob Sciuk
-
To unsubscribe
), and
Tcl Extension (BSD/Windows). There is a unix style man page for
documentation.
http://www.controlq.com/OpenSource/Tcl_Julian.tgz
HTH,
Rob Sciuk
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
requirement?
Cheers,
Rob Sciuk
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 16 Jan 2008, John Stanton wrote:
Date: Wed, 16 Jan 2008 16:32:53 -0600
From: John Stanton [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How do I get back command history in v3.5.4?
You might be having a library location problem
, and PostGres allows separate schema and
data dumps (the default being both) in psql, there should be no reason not
to put it into the sqlite3 tool, unless I'm missing something?? Am I?
Cheers,
Rob Sciuk
-
To unsubscribe, send
On Wed, 9 Jan 2008, Zbigniew Baniewski wrote:
On Wed, Jan 09, 2008 at 12:51:16PM +, [EMAIL PROTECTED] wrote:
Why not have a possibility to make it default
behaviour of the SQL-engine itself, just by
using one pragma?
1. It'll make my code shorter.
But it makes the SQLite core code
On Sat, 5 Jan 2008, [EMAIL PROTECTED] wrote:
Shane Harrelson [EMAIL PROTECTED] wrote:
Embedded Database Vendors Face Challenges:
http://www.eweek.com/article2/0,1895,2243406,00.asp
How could an article like this not mention SQLite?
I don't know, but my guess is that the article was
On Fri, 4 Jan 2008, [EMAIL PROTECTED] wrote:
John Stanton [EMAIL PROTECTED] wrote:
You need to make a small change in the make file to get rid of the
wretched tclsh and link sqlite3 from the library. Just use an earlier
makefile as a template.
The problem with the TCL dependency was
TWIMC,
When using the sqlite3_query command, and a callback function, is there a
way of getting the _*STATEMENT*_ for the query string which is currently
executing, reliably from the sqlite3 *opaque type??
The reason I need this, I'm using SQLITE 3.5.x to manage blobjects of
various kinds,
On Fri, 1 Dec 2006, John Stanton wrote:
I cannot see a reason for what you propose, but you could do it by brute
force and ignorance - populate the DB with 1 million rows then delete them
all to add all the space to the free pages list. Then your insertions will
use the freed pages, not
.
While admittedly, this is not a panacea for the problems expressed in this
thread, and is not a SQLite datatype extension, it may prove to be of some
small utility to some subset of users.
http://www.controlq.com/OpenSource/Tcl_Julian.tgz
Enjoy.
Rob Sciuk
On Tue, 31 Oct 2006 [EMAIL PROTECTED] wrote:
No need to call in a preemtive Slashdot bombardment just yet.
Let's give diplomacy a chance...
--
D. Richard Hipp [EMAIL PROTECTED]
$.02 As was mentioned previously, why *not* add a prominent section
under the sqlite.org web site, which
On Mon, 30 Oct 2006, Igor Tandetnik wrote:
Date: Mon, 30 Oct 2006 11:21:15 -0500
From: Igor Tandetnik [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: SQLite sqlite-users@sqlite.org
Subject: [sqlite] Re: efficient way to figure out if a table is empty
Xavier Noria [EMAIL PROTECTED]
Please ignore this test -- sorry.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Wed, 18 Oct 2006, Noel Frankinet wrote:
Date: Wed, 18 Oct 2006 17:23:43 +0200
From: Noel Frankinet [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite GUI app that offers layouts
Sorry, the correct url is :
On Wed, 18 Oct 2006, Rich Shepard wrote:
On Wed, 18 Oct 2006, Rob Sciuk wrote:
Interesting, but I'm wondering why not use the tcl/tk binding to simply
generate the forms using the well crafted tcl binding which comes with the
SQLite language? Tcl/TK is a very simple scripting language
!!
Rob Sciuk.
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
an ifdef to restore the old (legacy)
behaviour, something like:
#ifdef WEIRD_AND_UNEXPECTED_BEHAVIOURS_DESIRED
...
#endif
I'd suggest that this is one for the regression suite as well.
/MHO
Rob Sciuk
On Tue, 22 Aug 2006, Laura Longo wrote:
Date: Tue, 22 Aug 2006 08:51:34 +0200
From: Laura Longo [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: database locked
Laura,
'df -h' should give you some hints, or 'showmount'. I run
On Mon, 21 Aug 2006, Laura Longo wrote:
Date: Mon, 21 Aug 2006 20:01:24 +0200
From: Laura Longo [EMAIL PROTECTED]
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: database locked
On 8/21/06, Laura Longo [EMAIL PROTECTED] wrote:
I've tried also
On Sun, 20 Aug 2006, John Salerno wrote:
Hi everyone. I'm just getting started with sqlite and I was testing it
on the command line. Is there a way to switch between databases while
at the sqlite command prompt, or must you start the command prompt
with a database? For example, must you
59 matches
Mail list logo