[sqlite] Very slow query

ons on the current schema? TIA -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [BUG] 1200x slow-down running query in 3.7.3

ed SELECT. The flock_owner table has an index on each of flock_no, owner_person_id and owner_change_date. Pete -- Peter Hardman Breeder of Shetland sheep and cattle ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] [BUG] 1200x slow-down running query in 3.7.3

>> On Mon, Oct 18, 2010 at 9:18 AM, Peter <pe...@somborneshetlands.co.uk>wrote: >> > I have a query which takes 17 minutes to run with 3.7.3 against 800ms >> > with 3.7.2 >> > >> > > Thank you for the report. > > Can you please send yo

[sqlite] Query running slow on SQLite

On Wed, Jan 5, 2011 at 12:42 PM, Peter somborneshetlands.co.uk>wrote: > I have a Python web application that I am converting to use SQLite3 for > local deployment instead of PostgreSQL to make it simpler to install. > > Some queries run up to 50 times slower using SQLite. We ca

Re: [sqlite] Embarassed Newbie

Richard Hipp wrote, On 08/01/11 13:10: > On Sat, Jan 8, 2011 at 8:06 AM, Peter<pe...@somborneshetlands.co.uk> wrote: >> On 08/01/11 11:43, james630...@aol.com wrote: >>> sqlite3 test.db >> >> I assume by 'binaries' you mean sqlite-shell-win32... and >>

Re: [sqlite] Result set column names

Jay A. Kreibich wrote, On 08/01/11 14:07: > On Sat, Jan 08, 2011 at 09:12:36AM +, Simon Slavin scratched on the wall: >> >> On 8 Jan 2011, at 9:09am, Peter wrote: >> >>> So the 'column name' may be some internal representation/magic number >>> and

Re: [sqlite] Embarassed Newbie

james630...@aol.com wrote, On 08/01/11 13:45: > Hi Peter, > > Thanks for your response. > > At the DOS command prompt I manually changed directory as suggested but to > no avail. > > I originally downloaded all 3 downloads as instructed by the download page. >

[sqlite] bug with NULL in NOT IN

rows, for id=1 and id=2. http://www.sqlite.org/nulls.html doesn't list it, so perhaps this has never come up before. Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug with NULL in NOT IN

st column of the result row should be NULL, not "0"? > Since rule (d) above is not true for "1 IN (null, 2, 3)", do we fall > through to rule (e) and return NULL? I'd say so, yes - and MySQL and postgres seem to agree too. Cheers, Peter _

Re: [sqlite] bug with NULL in NOT IN

/www.sqlite.org/draft/doc/35to36.html notes that 3.6.0 will fix this issue. Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] db vs shell

from bar ; ' | uniq | sort | uniq | wc -l" Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] db vs shell

ing find indeed. Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] db vs shell

On Tue, Jul 29, 2008 at 02:29:53AM -0500, Robert Citek wrote: > $ sqlite3 -version > 3.4.2 On 3.4.0 and 3.5.9 here, the pure-SQL version is -much- faster than the shell pipe. Could you tell us more about the contents of your database? Cheers,

Re: [sqlite] db vs shell

On Tue, Jul 29, 2008 at 03:27:20AM -0500, Robert Citek wrote: > real 3.25 .. > real 22.48 I'm seeing the second being twice as -fast- as the first one here, still. How many CPU cores are in your testing machine? Parallel execution -might- explain the difference. Cheers,

Re: [sqlite] Finding similar duplicates

e first name of x > begins with the first two characters of y first name". Using a literal > example for above the SQL would end: where x.first_name like 'da%' Your query does not include the % your literal example does. Alternatively, you could get substr from both an

Re: [sqlite] Proposed removal of (mis-)feature

dea. Any application doing "" now is prone to breakage as described in your post. Consider this a vote for removal :) Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please test unix builds

.unable to realloc 343598469 bytes *** Signal 6 Cheers, Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Spiders vandalizing the wiki

D. Richard Hipp wrote: If you have any suggestions on what to do about them, I'd like to hear from you. Block the entire IP range, for say 2 weeks at a time. I'm guessing that these spiders are coming from spammers looking to harvest email addresses. Last nights attack came from 61.51.123.205.

Re: [sqlite] How do I create a log of SQLite SQL statements, etc?

Scott Chapman wrote: I'd like to be able to see all the sql traffic going to/from my sqlite database. Lookup "sqlite_trace" in sqlite.h - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [sqlite] C\C++ interface

Bronislav wrote: I usualy download every new version of SQLite, ...there is no change in description since 2003/10. Should that mean that there was no change? There isn't a change in the public API at every update. If there is a change in the version number, then there are obviously changes in

Re: [sqlite] Concurrence in DB - again

Thiago Mello wrote: about the sqlite_compile(), Im using simple call back function. Are you calling any other sqlite_* function within the callback? Doing that will probably get you the "call out of sequence" error. Regards P.

Re: [sqlite] Concurrence in DB - again

Thiago Mello wrote: Yes, in my callback() functions I have some sqlite_exec() functions. How I can avoid this? Well you have to rewrite your code, store the complete result of one query before calling sqlite_exec* again. You can probably achieve a similar result with some SQL wizardry, but I

Re: [sqlite] Checking for read-only

Steve Palmer wrote: Is there an easy way I can open a database via sqlite_open and then find out if sqlite has opened it in read-only mode without first needing to do any sort of modification and get an error code? I want to adjust the UI in my application to disable certain functionality if the

Re: [sqlite] Encryption in 2.8.13

Ulrik Petersen wrote: I see that in 2.8.13, there are stubs for an encryption layer, but the encryption itself seems not to have been made publicly available. Any chance of this becoming public in the next release? Form what I understand of the description on the SQlite site, encryption is

Re: [sqlite] Create a New Database?

Richard wrote: G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not found Hehe, take it you're new to OSX (I think) unix like intricacicies. Should you not type: ./sqlite test.db as you've probably got a setting somewhere to search system paths for binaries not including the

Re: [sqlite] runtime detect of THREADSAFE

Stefano Barbato wrote: is there a way to detect at runtime if the sqlite library has been compiled with the THREADSAFE=1 flag or not? No, or not that I know of. It would be nice for ver 3 to have a simple function which returns a structure of the database library capabilities. The obvious ones

Re: [sqlite] like-op

Rod Dav4is wrote: I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) Don't hesitate to contact customer services to arrange for your 30day no quibble refund. :-Þ P.

[sqlite] Query planner creating a slow plan

P says; SEARCH TABLE transfer AS tr USING INDEX sqlite_autoindex_transfer_1 (regn_no=? AND transfer_dateSeems to me it ought to be able to just sort the result of the first plan. ATM it's an order of magnitude quicker at least to do the sort in Python in the application. Pete -- Peter H

Re: [sqlite] Re Query planner creating a slow plan

Black, Michael (IS) wrote, On 26/04/12 15:11: select transfer_date from (select transfer_date from transfer_history where regn_no='039540' and transfer_date<= '2012-05-01') order by transfer_date; Makes no difference. Pete -- Peter Hard

Re: [sqlite] Re Query planner creating a slow plan

interact with aggregates and order by. What happens if you don't use the view, but perform the query using the actual tables? Makes no difference - the planner is still using the scans instead of indexes. -- Peter Hardman ___ sqlite-users mailing list

Re: [sqlite] Re Query planner creating a slow plan

nce - the planner still picks the same plan using scans. -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Re Query planner creating a slow plan

s from Sqliteman this time). The planner has reverted to using indexes instead of scans... -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Re Query planner creating a slow plan

nly returned item make it use the transfer_date index instead of the preferable regn_no index? No, that makes no difference either. Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Re Query planner creating a slow plan

der by transfer_date asc No, that uses scans as well. I'm tempted to suggest this might be a bug since the pattern seems illogical. Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Re Query planner creating a slow plan

Simon Slavin wrote, On 26/04/12 16:39: On 26 Apr 2012, at 4:24pm, Peter<pe...@somborneshetlands.co.uk> wrote: > There are indexes on all the fields used in the tables of the transfer_history view. > > While tinkering I have discovered something: > > If instead of &g

Re: [sqlite] Re Query planner creating a slow plan

subselects, can you? AFAIK you can't create indexes on a view, or can you? Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Re Query planner creating a slow plan

es. I've just downloaded and extracted the database and it has all 44 tables and 18 views - well Sqliteman thinks it has anyway.. Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

Re: [sqlite] Re Query planner creating a slow plan

23674|1004|Glynwood|1995-04-04 00:00:00|4/4/95|Birth sqlite> Seems to work for me. You'll have to use 023674 instead of 039540 as the latter doesn't exist in this test database. Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] Re Query planner creating a slow plan

an 'order by transfer_date' clause and the planner no longer uses indexes but uses scans instead. Then if you do a select * ... it goes back to using indexes. With 100K+ records in the full database the difference in execution times is not insignificant. Pete -- Peter Hardman

Re: [sqlite] Re Query planner creating a slow plan

The build runs ./configure --prefix=/usr --disable-static Then make with CFLAGS='CFLAGS -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY -DSQLITE_SECURE_DELETE' Pete -- Peter Hardman ___ sqlite-users mailing list

Re: [sqlite] EXT :Re: Re Query planner creating a slow plan

ll history since Richard has now fixed this behaviour (a49e909c87). Pete -- Peter Hardman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Putting the journal/WAL on a separate filesystem

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

[sqlite] Detecting multiple CHECK failures

I'm a great believer in using CHECK constraints to do as much validation as possible within the database rather than code it in my application. However, I think I'm right in saying that as soon as a CHECK constraint fails, an error is returned to my application so no other CHECK constraints are

Re: [sqlite] Detecting multiple CHECK failures

Hi Simon, Actually, I do get the CHECK constraint name returned to me in the error message otherwise, as you say, it would be impossible to find out what failed. I use a translation table in my application to reformat the SQLite error message to a more suitable format to present to my users based

Re: [sqlite] Detecting multiple CHECK failures

On Thu, Oct 9, 2014 at 9:00 AM, wrote: > Message: 6 > Date: Wed, 8 Oct 2014 14:40:57 -0500 > From: Nico Williams > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Detecting multiple CHECK

Re: [sqlite] [sqlite-announce] SQLite version 3.8.7

No big deal, but on line 885 of shell.c, did you really mean to test if azArg (of type char**) was greater than 0 rather than not equal to 0? It throws a warning on Solaris 9 with the SUNPro compiler. On Friday, October 17, 2014 10:00 AM, D. Richard Hipp wrote: > > >SQLite

Re: [sqlite] JSON indexing

to be being used and supported. Peter On Tuesday, October 21, 2014 11:10 AM, Mike Jarmy <mja...@gmail.com> wrote: > > >Hmm, UnQL looks like just what I was looking for. Seems like the project >never really got rolling though. > >DocumentDB looks very interesting. Th

[sqlite] FTS4 Problem

I have an sqlite database in which I've created a virtual table using FTS4. For nearly a year, we've been using it to do full text searching with no problem. The database contains a table of products (tblProducts) with columns id, SKU, itemDesc, etc. The virtual table is created like this:

Re: [sqlite] FTS4 Problem

problem. I guess one of the triggers for keeping the virtual table up to date must have failed for some reason. Thank you again! -- Peter Truskier Berkeley, CA USA 1-510-495-6442 > On Dec 24, 2014, at 11:47 AM, Richard Hipp <d...@sqlite.org> wrote: > > Have you run integrity ch

Re: [sqlite] FTS4 Problem

As I mentioned, I seem to have solved the problem by doing a "rebuild" command on the FTS4 table. But, as I thought about it further, I'm still confused as to why dropping, and then re-creating the virtual table didn't solve the problem as well. What am I missing? Thanks, Peter &

Re: [sqlite] Suggestion for syntax enhancement for virtual tables

p database, and do any required cleanup in xDisconnect instead of xDestroy for that instance. But if xDisconnect can be called at other times, cleanup could be premature. Best, Peter On Friday, January 2, 2015 12:56 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > > >On 01/02/2

[sqlite] How often is xDisconnect called? (Was: Suggestion for syntax enhancement for virtual tables)

** to avoid deadlock issues involving multiple sqlite3.mutex mutexes. I'm not sure exactly what this means, but it implies that xDisconnect can be called in the middle of a session. Peter On 1/2/2015 3:00 PM, Peter Aronson wrote: If only the xDisconnect method is called on a virtual table

Re: [sqlite] using a hex integer as input to DateTime

ITE_ANY, globalfunc_info, S_hextoint_function, NULL, NULL); After connecting, but before executing your SQL. Peter On Wednesday, January 14, 2015 4:32 PM, Paul Sanderson <sandersonforens...@gmail.com

[sqlite] Encoding question

I'm new to the unicode world so this question may not make sense. The "PRAGMA encoding" statement tells me the encoding of a database. Can I rely on all data in the database having that encoding? For example, if the encoding is UTF8 and a row is inserted containing UTF16 encoded data, will it

Re: [sqlite] Encoding question

On Mon, Feb 2, 2015 at 9:00 AM, wrote: > From: RSmith > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Encoding question > Message-ID: <54cebb71.8060...@rsweb.co.za> > Content-Type: text/plain; charset=windows-1252; format=flowed > > In

Re: [sqlite] Porting SQLite to another operating system (not supported out of the box)

You could add VFS creation if you ever do a revised edition (along with a virtual table example that actually used xBestIndex and xFilter...). On Tuesday, February 10, 2015 9:58 AM, Jay Kreibich wrote: > > > > >No, it does not. Using SQLite covers Virtual Tables in great

Re: [sqlite] binding multiple values in a query

that, as long as the array you wanted to bind was made up of integers. Although it wouldn't be hard to make a version that worked on floats or strings. Peter On Wednesday, February 11, 2015 3:46 PM, Jono Poff <jonathan.p...@taitradio.com> wrote: > > >Hi, > >I wonder

[sqlite] order by not working in combination with random()

of trouble until I realized the initialization function for my extension was being run twice by SELECT load_extension, and I fixed the function to be OK with being run multiple times). ?It wouldn't explain a 3x+ slowdown, but would explain a 2x anyway. Peter On Friday, August 28, 2015 7:45

[sqlite] List duplication

I've seen it too. All of the duplicate messages appear to have been sent to both sqlite-dev at mailinglists.sqlite.org and sqlite-dev at sqlite.org or to both sqlite-usersmailinglists.sqlite.org and sqlite-users at sqlite.org. Peter On Fri, 2/27/15

[sqlite] Error: no such column: When column exists!

When I look at your queries table in sqlite3 in a windows command prompt, the failing SQL has a non-ASCII character instead of a semicolon. Peter On Wednesday, July 15, 2015 12:53 PM, Jason H wrote: So yes, I was missing 'S's, but that is only because I've been hacking at the tables

[sqlite] create temporary virtual table

you are done with it, the xDestroy methods will be called and all should be as normal. Peter On Monday, July 20, 2015 3:34 PM, Andy Rahn wrote: I see there is no way to create a temporary virtual table. One idea I had was to create a second, in-memory db and attach that, then create

[sqlite] CSV excel import

into the mix, you can make your spreadsheets show up a virtual tables using the VirtualOGR module. Peter On Thursday, July 30, 2015 11:37 AM, Sylvain Pointeau wrote: On Thu, Jul 30, 2015 at 8:32 PM, Bernardo Sulzbach < mafagafogigante at gmail.com> wrote: > > My point is

[sqlite] [ANN] SQLiteAdmin V1.3.6

t onto the SQLiteAdmin application window. Peter Haworth lcSQL Software www.lcsql.com

[sqlite] UPDATE Problem

I have a table, Transactions, with a column , Value, of type NUMERIC. The Value column is supposed to have 2 decimal places in all rows but some have only one. To correct this I issued the following command: UPDATE Transactions SET Value=Value||0 WHERE substr(Value,-2,1)='.' No errors on

[sqlite] UPDATE Problem

Thanks to all for explaining my confusion. The printf solution seems like the best way to handle this since I don't need to worry about how many decimal places are in the number.

[sqlite] Possible bug with locking/retying

If you look here: http://beets.radbox.org/blog/, you can see the blog entry is dated August 24th, 2012. Peter On 5/2/2015 5:18 PM, Simon Slavin wrote: > In searching for something else I came across this: > > <http://beets.radbox.org/blog/sqlite-nightmare.html> > >

[sqlite] sqlite3 and Unicode

When using the .dump command with .output to a filename, what encoding does sqlite3 for the file? Same as the database encoding? Is it possible to change whatever encoding is used? Similarly, when using the .import command, does sqlite3 assume the input file is the same encoding as the database?

[sqlite] sqlite3 and Unicode

Thanks for all the replies. I'm still confused on this. It sounds like maybe UTF8 is the answer on OSX but UTF-16LE on Windows. Whatever the answer to that, it seems there isn't a way to control the encoding within sqlite3 so I guess I won't worry about it. Pete lcSQL Software

[sqlite] Determine type of prepared statement via C Interface?

Well, there's sqlite3_stmt_readonly which appears to do pretty much what you're asking for: https://www.sqlite.org/c3ref/stmt_readonly.html. Or, if you want more detailed control, there's the whole authorizer interface: https://www.sqlite.org/c3ref/set_authorizer.html. Peter On 5/8/2015 10

[sqlite] Two Threads Share In-Memory Table

See https://www.sqlite.org/sharedcache.html and in particular, section 6 at the bottom. Peter On 5/10/2015 10:42 AM, Joe Pasquariello wrote: > Hello, > > One thread of our Windows application is an HTTP server reading data > from an SQLite database for display by web clients.

[sqlite] Fwd: bulk upload from Excel

, and then create a virtual table of an Excel spread-sheet using the VirtualOGR module (see http://www.gdal.org/drv_sqlite.html?and?http://www.gdal.org/ogr_sql_sqlite.html). ?There might be a simpler approach, of course. Peter? On Monday, May 11, 2015 11:08 AM, maksood alam <786maksood at gmail.

[sqlite] Fwd: bulk upload from Excel

I don't know what happened to my links in the previous email. ?Again: http://www.gdal.org/ogr_sql_sqlite.html http://www.gdal.org/drv_sqlite.html ? On Monday, May 11, 2015 12:01 PM, Peter Aronson wrote: It's a little indirect, but starting with GDAL 1.10, if you have a version oft he

[sqlite] sqlite3 .dump

Couple of questions regarding the above command. Why does the above command include a PRAGMA foreign_keys=OFF command? Wouldn't it make more sense for the CREATE commands to include IF NOT EXISTS? Pete lcSQL Software Home of lcStackBrowser

[sqlite] AUTOINC vs. UUIDs

solution? ?Of course not, but then, what is? ?But for that particular problem domain they have proved viable. Mind you, the original article linked was guilty of gross over-generalization, and got the amount of randomess in a UUID wrong (it's 122 bits, not 124). Peter? ? On Wednesday, May 20

[sqlite] AUTOINC vs. UUIDs

Never mind about the 122 vs 124 bit thing. ?I could have swore I read that... On Wednesday, May 20, 2015 4:52 PM, Peter Aronson wrote: Now you're just getting silly. ?What if the application sets all rowids, everywhere to 1? ?The fact is, the chance of collision on a UUID is pretty

Re: [sqlite] Intended use case for 'without rowid'?

with partial indexes too. Peter On 11/15/2013 4:47 AM, Luís Simão wrote: SQLite answers those question in: http://www.sqlite.org/draft/withoutrowid.html BR ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Intended use case for 'without rowid'?

of SQLite from say, 3.7.0 onward, which would forbid partial indexes and without rowid tables in conforming databases.  And later releases could kick the minimum up.   Peter From: RSmith <rsm...@rsweb.co.za> >To: sqlite-users@sqlite.org >Sent: Friday, November 15, 2013 2:11 PM

Re: [sqlite] Intended use case for 'without rowid'?

Actually, we were talking about the schema format number at offset 44.  However, neither that nor any of the other you point out will let you know if a without rowid table is present.  That's discovered when parsing the contents of the sqlite_master table.   Peter From: Simon Slavin <s

Re: [sqlite] Intended use case for 'without rowid'?

, unless you have a statically loaded extension that accesses a database object.) Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Intended use case for 'without rowid'?

For Peter & Pepijn - I think the issue is essentially a forward-compatibility problem moreso than a backward-compatibility one. So I think your idea on introducing some version control would be the least painful. Indeed. The lack of rowid itself is not an issue. It's that someone c

Re: [sqlite] Transaction involving multiple attached databases

And you can't execute it at all if any of the attached databases are read-only.   Peter >On 11/26/2013 2:24 PM, Joshua Grauman wrote: >> If I have multiple databases attached and then do a: >> BEGIN EXCLUSIVE >> >> I assume all the sqlite3 tables involved get locked

Re: [sqlite] RFE: Rename Column

> > > > You're both right. Igor's statement pretty-much /is/ the reason one > cannot rename a column. One would need to write a parser and changer for > SQL statements that could identify and change column names in many > statements with all sorts of weird possibilities for formatting. > > Two

[sqlite] Minor documentation typos in PRAGMA command syntax section?

I know…picky picky me…;} respect….. Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Command line shell not flushing stderr when interactive

n to redirect STDIN to Emacs shell window.     */     char *env_var = getenv("TERM");     if (env_var) {   if (!strcmp (env_var, "emacs"))     stdin_is_interactive = 1;     }   } #endif Peter From: Christopher Wellons <well...@nullprogram.com> >To: sqlite-users@sqlite.o

[sqlite] When is the decltype recognized?

Hello! Over at python.org there is a bug report that its sqlite3 module sometimes doesn't correctly deserialize a typed column. From my limited understanding it boils down to the following once you go down to sqlite's C API: #include #include "sqlite3.h" int main(int argc, char **argv) {

Re: [sqlite] When is the decltype recognized?

Clemens Ladisch wrote: > Peter Otten wrote: >> select * from (select alpha from demo union all select alpha from demo) >> order by alpha decltype: (null) >> >> select * from (select alpha from demo union all select alpha from demo) >> decltype: custom >>

Re: [sqlite] When is the decltype recognized?

Clemens Ladisch wrote: > Peter Otten wrote: >> Clemens Ladisch wrote: >>> Peter Otten wrote: >>>> select * from (select alpha from demo union all select alpha from demo) >>>> order by alpha decltype: (null) >>>> >>>> sele

[sqlite] Loadable extensions

Is there a list of available loadable extensions for functions, virtual tables, etc? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin ___

Re: [sqlite] Loadable extensions

ype: text/plain; charset=us-ascii > > > On 17 Feb 2014, at 6:33pm, Peter Haworth <p...@lcsql.com> wrote: > > > Is there a list of available loadable extensions for functions, virtual > > tables, etc? > > I've seen some extensions lists on the web but n

[sqlite] Still trying to track down loadable extensions

I'm still hunting for loadable extensions. The SQLite web site makes reference to extensions being part of the source code in the contrib folder but when I browser around there, I can only see 2 files dlmalloc and sqlcon. I know nothing about git so can someone please point me in the right

[sqlite] sqlite issue when using AIX

int)pSrc->nSrc)-1; i++, pRight++, pLeft++){ Apologies if this has already been reported. I did check through the current tickets searching for AIX, and didn't find anything so I'm assuming that it hasn't already been repo

[sqlite] sqlite issue when using AIX

Hi, Many thanks for the feedback and apologies for the delay in responding. As requested, I have downloaded 3.8.4.1 onto our AIX machine, and it works fine. Kind regards, Peter Simpson (Hopewiser) P.S. Did try and respond online but subscription request got rejected somewhere along

Re: [sqlite] UNIQUE index not working as expected - what am I overlooking?

traint are null -- you can have any number of rows like that. See the discussion here: https://community.oracle.com/message/1255458 or Oracle documentation here http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm#i1034458. Peter I traced out the disc id prior to the

[sqlite] comma-separated string data

ps a WHERE id='66'? Thanks, peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BLOBs and NULLs

h 15) of the time_hi_and_version field to the 4-bit version number from Section 4.1.3 (which is 4). */   uuid_data[6] &= 0x0f;   uuid_data[6] |= 0x40; This assumes that sqlite3_randomness generates sufficiently good random numbers, but it appears to in my tests.

Re: [sqlite] BLOBs and NULLs

SQLite seemed to provide good randomness in my (admittedly informal) tests.   Peter From: jose isaias cabrera <cabr...@wrc.xerox.com> >To: Peter Aronson <pbaron...@att.net>; General Discussion of SQLite Database ><sqlite-users@sqlite.org> >Sent: Tuesday, April 22

[sqlite] Trigger cascade/nesting

ON audit_test_a FOR EACH ROW BEGIN UPDATE audit_test_a set last_changed = strftime('%Y-%m-%d %H:%M:%f', 'now', 'localtime') WHERE rec_id = old.rec_id; INSERT INTO change_history VALUES (); END Thanks for your help -- Peter Hardman

Re: [sqlite] Trigger cascade/nesting

t=ISO-8859-1; format=flowed On 04/23/2014 05:05 PM, Peter Hardman wrote: >Hi, > >Is there a way of preventing triggers cascading? > >I have a table where I need to set a timestamp field when a new record >is INSERTED. The table uses an auto-increment key field so a BEFORE >INSE

[sqlite] When to open/close connections

There's a discussion on another forum I'm on about whether it's good practice to open an SQLite database as part of program initialization and close it when the program terminates, or whether the connection should be opened and closed around each transaction. I've always used the first approach

[sqlite] Foreign Key errors

It seems that foreign key errors on columns where the foreign key definition has a constraint name don't include the constraint name in the error message. This is using sqlite version 3.8.3.1. Is this under the control of a compile switch or PRAGMA or am I stuck with the way it is? Pete

  1   2   3   4   5   6   7   >