[sqlite] Differentiate between an empty result set and an error using Python3

Forgive me if this is an FAQ, but in looking over the python3 interface to SQLITE3, I cannot see a way to get the result code (SQLITE_OK) after an execute() command. My use case is to differentiate between an empty row set (OK) vs an error of some kind in the query. Anyone figured this

Re: [sqlite] Tcl interface: array not created when ...

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

Re: [sqlite] How to achieve fastest possible write performance for a strange and limited case

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 --

[sqlite] tcl and NULL

} 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] Is there a design doc for the virtual machine re-write?

, 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

Re: [sqlite] What languages can include SQLite statically?

rst. I've not used Lua, but I understand 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

Re: [sqlite] SQLite turns 10 years old (D. Richard Hipp)

ering adherence 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. Since

[sqlite] Pragmas and compile options ...

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

[sqlite] An SQLite Server ...

iltering 8-). 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: 90

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

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

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

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 >

[sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

e3_column_table_name() returns 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 i

Re: [sqlite] manipulating arguments (in C)

Perhaps this might lead you in the right direction Jean-Christophe ... #include #include #include 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 ) ; va_end( ap ) ;

Re: [sqlite] GUI design & managment tool?

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 >>

Re: [sqlite] GUI design & managment tool?

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 existing databases ... I've just started playing with it on FreeBSD, and I must say that so far, I'm much i

Re: [sqlite] Ability to convert Access to SQLite

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

Re: [sqlite] sqlite programmed in C++ ...

hey are. Perhaps Sylvain would prefer to have a look 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

[sqlite] Building SQLite ... configure/make deprecated?

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

[sqlite] [newbie] Binary and text-file storage in SQL(ite).

(?) SQLite, a number of variables are different 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

Re: [sqlite] archiving memory databases

> From: "DeTerra, David J" > 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

[sqlite] Error handling anomaly ...

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

Re: [sqlite] Violating Primary key Constraint

create table emp ( empno integer not null, ... primary key (empno) ) ; Cheers, Rob Sciuk ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

o problem with SQLite per se, nor with its approach to typing, nor with the existing SQLite API ... but I *DID* have a couple of unexpected stumbles in translating documentation into practice owing to the differences between "my mental model", as you put it, and SQLite's c

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

> 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 "

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

ough slightly non-intuitive. 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-). In any event, I'm all sorted out, and I appreciate your very quick and accurate response. Cheers

Re: [sqlite] prep'ed query ... LF function to return column_isNull?? (fwd)

s opaque to me ... > any pointers?? > Ooops, it appears 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

[sqlite] HELP: prep'ed query ... LF function to return column_isNull??

( 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

Re: [sqlite] Tcl/SQLite application best practices ???

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

Re: [sqlite] tcl/sqlite glitch on FreeBSD ...

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

Re: [sqlite] tcl/sqlite glitch on FreeBSD ...

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

[sqlite] tcl/sqlite glitch on FreeBSD ...

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

[sqlite] Is this list available in *DIGEST* form??

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

[sqlite] SQLite 3.5.5 make test on OpenBSD 4.2 on HPPA

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

Re: [sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

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

[sqlite] SQLite 3.5.5 on OpenBSD running on HPPA (HP9000) make test

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

[sqlite] Make test on Ubuntu 7.10 SQLite 3.5.5

$ 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: []

Re: [sqlite] make test on FreeBSD 6.2-R, SQLite 3.5.5

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

Re: [sqlite] make test on FreeBSD 6.2-R, SQLite 3.5.5

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

[sqlite] make test on FreeBSD 6.2-R, SQLite 3.5.5

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

Re: [sqlite] SQLite Compilation Problems on FreeBSD

my query on this list has been met with silence thus far, so I cannot advise you further. Apparently the db engine has been re-worked somewhat (extensively) with this release, and I suspect that changes eminate from t

Re: [sqlite] Date arithmetic question

le, both as C library (BSD/Linux/Windows), 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] -

Re: [sqlite] How do I get back command history in v3.5.4?

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

[sqlite] Compiling 3.5.4 on FreeBSD ...

requirement? Cheers, Rob Sciuk - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Dump w/o Schema

way, 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, s

Re: [sqlite] "always-trim" - feature suggestion

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

Re: [sqlite] no mention of SQLite :(

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

Re: [sqlite] Trying to use SQLite3 with PHP5....

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

[sqlite] returning Blobs in an oldstyle query ...

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,

Re: [sqlite] Preallocating fixed disk space for database ...

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

Re: [sqlite] Date data type

get working right on your platform, unless you use FreeBSD, and then it should just work. 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://ww

Re: [sqlite] SQLite and McAfee Anti-Virus

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,

Re: [sqlite] Re: efficient way to figure out if a table is empty

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 > Subject: [sqlite] Re: efficient way to figure out if a table is empty > > Xavier Noria <[EMAIL

[sqlite] test message ...

Please ignore this test -- sorry. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite GUI app that offers layouts

ite is a remarkable and useful achievement!! Rob Sciuk. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite GUI app that offers layouts

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

Re: [sqlite] SQLite GUI app that offers layouts

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 : > >

Re: [sqlite] Performance Question

On Wed, 30 Aug 2006 [EMAIL PROTECTED] wrote: > > I have to go along with Mario, here. This is a potential show stopper, > > Show stopper? Really? The bug has been there for years, literally, > and nobody has even noticed it until now - despite thousands of users > and millions and millions of

Re: [sqlite] Performance Question

uld grab a "fixed" version of SQLite ASAP were it made available. Alternatively, one might simply use an ifdef to restore the old (legacy) behaviour, something like: #ifdef WEIRD_AND_UNEXPECTED_BEHAVIOURS_DESIRED ...

Re: [sqlite] Re: database locked

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

Re: [sqlite] Re: database locked

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: > >>

Re: [sqlite] switching databases?

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