[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

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

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

mple.db 'select foo 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. Ch

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 fr

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

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

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

ndex for the second nested 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://s

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

>> On Mon, Oct 18, 2010 at 9:18 AM, Peter 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 your complete schema. The query is useful

[sqlite] Query slow on SQLite

order of difference using PGAdmin3 to access PostgreSQL and SQLiteman or SQLite Manager to access SQLite. Any help welcomed. Pete -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' ___ s

[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] Query running slow on SQLite

On 05/01/11 21:32, Richard Hipp wrote: > On Wed, Jan 5, 2011 at 4:00 PM, Peter wrote: > >> Sorry, I assumed everything you needed to know was in the database that I >> gave a link to: http://somborneshetlands.co.uk/things/sss-mini.zip >> I'll sort out a text schema

Re: [sqlite] Maintaining temporary indexes

e bothered to look at the PostgreSQL 'Explain analyze' output this is exactly what the PostgreSQL query planner does - applies the final 'where' clause to each of the joined tables thus avoiding the need for on-the-fly indexes and covering up for my poorly written query in the

Re: [sqlite] Result set column names

ending (apparently) on how many tables I have JOIN'ed in the query. Pete -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Result set column names

On 07/01/11 18:41, Igor Tandetnik wrote: > On 1/7/2011 1:31 PM, Peter wrote: >> In the C interface documentation we are told: >> >> "The name of a result column is the value of the "AS" clause for that >> column, if there is an AS clause. If there is no A

Re: [sqlite] Result set column names

On 08/01/11 09:12, Simon Slavin wrote: > > On 8 Jan 2011, at 9:09am, Peter wrote: > >> So the 'column name' may be some internal representation/magic number >> and bear no direct relationship to the name in the projector as supplied >> in the SELECT? >

Re: [sqlite] Embarassed Newbie

ve the full or relative path to that folder, eg c:\path\to\folder\sqlite3 test.db - Add that folder to your path variable - the GUI to do that is somewhere in My Computer->Advanced or some such IIRC -- Peter Hardman 'For every complex problem there is a so

Re: [sqlite] Embarassed Newbie

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

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

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

Re: [sqlite] Making sqlite support unicode?

Mrs. Brisby wrote: Now what am I trying to do? I'm trying to keep other people from getting confused. If you think I'm attacking you personally, then pay closer attention to what I am saying. No idea, but your tone is getting increasingly flippant.

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] Database Full!

Benoit Gantaume wrote: Hi, I am trying to handle a problem that occurs when the disk is full: You could pop up a message telling the user to stop surfing for pr0n and delete some of his jpegs. - To unsubscribe, e-mail: [EMAIL P

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 PROTEC

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 th

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 hav

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 da

Re: [sqlite] more performance questions

Dave Hayden wrote: On Mar 18, 2004, at 1:30 PM, Corporate wrote: Two words! Thread Synchronization! (above the database API in your code). Works like a charm. I just sat down with a cup of coffee and came to the came conclusion... It's a shame the MailingList settings are the cause of transformin

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 av

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 w

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

ying tables. With the basic query yhe QP 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 P

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.

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

ith unions 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-use

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

kes no difference - 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

lliseconds instead of 300ms or so (times 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

ansfer_date as the only 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/

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

27;2012-05-01' order 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:808

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 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 > SELECT transfer_date FROM tr

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

hout doing 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/

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

3-31 12:00:00|31/03/2002|Presumed 023674|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

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

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

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

100.tar.gz 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 ___

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

a slower plan for no reason that's obvious to the user. Anyway, this is all 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] Very slow query

#x27;s a pretty major change. Does anyone have any ideas for optimisations 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

Re: [sqlite] Abuse of the SQLite website

On 1/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Thoughts anyone? Are there less drastic measures that might be taken to prevent this kind of abuse? A couple of people here mentioned CAPTCHA's. This is sort of the standard for preventing automated abuse (intentional or unintentional

Re: [sqlite] Embedded SQL in C

w.softintegration.com/products/sdk/embedch/ http://www.softintegration.com/support/faq/embed.html http://www.softintegration.com/solution/embedded/ Peter > May not be worth the hassle given the size of your project. > > Since you're using C, consider rewriting your code using TrollTe

Re: [sqlite] SQLite on Mac

On Jul 19, 2007, at 11:45 AM, Ahmed Sulaiman wrote: Does SQLite work on Mac, and if yes, is there any Mac enabled version that I could download? SQLite is built-in on Tiger (10.4.x)... no installation is required. pete -

[sqlite] testThreadLockingBehavior() finishes with SIG32

], 0, threadLockingText, &d[0]; It stops with message box visible from debugger: "Program received signal SIG32, Real-time event 32" What can be reason and how can I to correct it ? Peter - To unsubscribe, se

Re: [sqlite] any way to SELECT the 100th-104th row of a table?

At 3:00 PM -0700 10/7/07, Adam Megacz wrote: Hello. This is probably a stupid question, but... Is there any way to include some phrase in a SELECT clause that will match only the Nth-Mth rows of a table, for some values of N and M? Note that ROWID isn't what I'm looking for -- if you delete ro

[sqlite] sqlite3_release_memory() current status

Close to two years ago, Shawn Wilsher from Mozilla asked about freeing memory used by sqlite ( http://www.mail-archive.com/sqlite-users@sqlite.org/msg30585.html ). At the time, some benchmarks showed that setting -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 caused a small performance hit. I'm looking into

Re: [sqlite] sqlite3_release_memory() current status

On Mon, Oct 26, 2009 at 2:48 PM, D. Richard Hipp wrote: > On Oct 26, 2009, at 5:00 PM, Peter Kasting wrote: > > as > > far as > > I can tell the current code shouldn't cause any performance hit by > > enabling > > this flag. There's no additional

[sqlite] Conditional JOIN

Looking for a way to implement the following situation I need to select entries form TableA and TableB. The join needs to happen using two separate fields. One of this fields can be used in the normal way but the other filed needs some special logic The normal join field is ProdID and the u

Re: [sqlite] sqlite-users Digest, Vol 22, Issue 74

Thanks for this. I tried the CASE solution in preference to the coalesce solution since I'm more familiar with CASE than coalesce. Your statement that there must be matching TableB entries with PriceTable STANDARD for all values of TableA.ProdID is correct. It almost works but not quite. I

Re: [sqlite] Conditional JOIN

Jay, First, yes I screwed up on the table data examples. The 3/SPECIAL TAbleA values should have shown 2 3/STANDARD TableB entries. My brain is hurting too! Anyway, the main thing is that your latest suggestion works perfectly so thanks for your help, I appreciate it. Pete On Oct 2

[sqlite] Another SELECT/JOIN Question.

Trying to implement the following situation involving 4 tables Customers is the "master table" in that the results should end up with one row for each primary key value in it. I need to sum the values of a column in the Sales table, which has a column that joins to the primary key of Customer

[sqlite] Multiple joined values in one row

Given the following tables: TABLEA KeyA, DataA TableBKey TABLEB KeyB DataB .. and a JOIN on TABLEA.TableBKey=TableB.KeyB IS there a SELECT statement that returns TABLEA.KeyA, TABLEA.Data,AllDataB, where AllDataB consists of all the values of TableB.DataB strung together? For example, for T

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 10

Thank you Igor, that's exactly what I need. Pete Haworth On Nov 10, 2009, at 4:00 AM, sqlite-users-requ...@sqlite.org wrote: > You are looking for group_concat (http://sqlite.org/ > lang_aggfunc.html): > > select KeyA, DataA, group_concat(DataB) > from TABLEA join TABLEB on TABLEA.TableBKey=Ta

[sqlite] Output in currency format

I have a column defined with a type of FLOAT, which I believe is treated as REAL by SQLite. When selecting that column, I would like it to be returned with a leading "$" sign and always have a decimal point and two numbers after the decimal point. I can use concatenation to get the "$" si

[sqlite] sqlite3 for Mac OSX 10.5

sqlite3 is rejecting a SELECT statement that includes the group_concat function saying it's an unknown function, yet the same SELECT statement works fine in the Firefox SQLite Manager extension. The version of sqlite3 on my Mac is 3.4.0 but it looks like the latest version is 3.6.x. Could t

Re: [sqlite] sqlite3 for Mac OSX 10.5

Yes, the analyzer is the only precompiled binary I see on the sqlite download page The group_concat function works fine in the Firefox SQLite Manager extension on the same Mac where it fails within sqlite3. Also, the development software I'm using (Revolution) also rejects the group_conca

Re: [sqlite] Output in currency format

Seems like I should handle the formatting in my application. Not sure I agree that sqlite is not the place to do output formatting - it provides lots of date and time formatting features so at least in that area, output formatting is available. Thanks also for the info re accuracy/REAL form

Re: [sqlite] sqlite3 for Mac OSX 10.5

Thanks for all the info. I believe the problem lies within Revolution since I'm pretty sure it includes its own private library of the sqlite code. I've reported it to them and hopefully they will fix it. I understand the reasons for applications having their own copy of the code like this

Re: [sqlite] Output in currency format

Thanks for all the advice on this. Just to be clear, I wasn't referring to the accuracy of calculations when I compared the sqlite date/time formatting capabilites to the lack of similar functionality for currency, just the fact that there is a precedent for sqlite providing output formatt

Re: [sqlite] Output in currency format

Thanks for all the comments on this. Didn't realise there were so many things to worry about when dealing with currency! The system I'm developing is only dealing with US dollars right now but I would hope it might make it's way into other countries at some point. Even with dollars, I will

[sqlite] Referring to columns named with AS

I'm trying to get a SELECT statement in the following general form to work: SELECT CASE WHEN THEN ELSE END AS CalcA, sum(CalcA) AS CalcATotal I get an error "no such column" referring to CalcA when used in the sum function. I'm trying to get total of all the values of CalcA ac

[sqlite] More on Referring to columns named with AS

After searching around the web, it seems I can't expect the SELECT syntax in my earlier post to work but that repeating the aliased column logic as part of the sum function will work so I tried that and it does indeed total things up for me. But, it now only gives me one row in the result wi

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 15

m: P Kishor > Subject: Re: [sqlite] Referring to columns named with AS > To: General Discussion of SQLite Database > Message-ID: > > Content-Type: text/plain; charset=ISO-8859-1 > > On Sat, Nov 14, 2009 at 1:58 PM, Peter Haworth > wrote: >> I'm try

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 15

Interesting you should classify my data need as a waste without knowing anything about my application. What if I want to calculate a percentage that the first column is of the total - would it still be a waste to calculate the total? As far as I'm concerned , the more data manipulation that

Re: [sqlite] sqlite-users Digest, Vol 23, Issue 15

Thank you Kees. While not achieving exactly what I was thinking of (the total is in an extra row at the end of the selected rows rather than a column in each row), this will work for me. Pete Haworth http://www.mollysrevenge.com http://www.sonicbids.com/MollysRevenge http://www.myspa

[sqlite] Sqlite Java blob

oring blobs in a sqlite databse? Thnaks in advance :) -- Peter ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Java blob

d be wrong. Any ideas greatly appreciated :) Ulric Auger wrote: > Use PreparedStatement setBytes method. > No need to convert to base64. > > Ulric > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pe

Re: [sqlite] Sqlite Java blob

d be wrong. Any ideas greatly appreciated :) Ulric Auger wrote: > Use PreparedStatement setBytes method. > No need to convert to base64. > > Ulric > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pe

Re: [sqlite] Mac OS X name mangling

f I define __DARWIN__, that prevents it from setting _XOPEN_SOURCE, which the comments say are "Needed to enable pthread recursive mutexes" On Nov 30, 2007, at 1:48 PM, Peter Johnson wrote: On Nov 30, 2007, at 1:32 PM, [EMAIL PROTECTED] wrote: Peter Johnson <[EMAIL PROTECTED]>

[sqlite] Mac OS X name mangling

l in shell.c seems a little suspect. Does anyone have any experience with this, or any suggestions? --Peter Johnson [EMAIL PROTECTED] This email is PRIVILEGED AND CONFIDENTIAL to Zattoo Inc.

Re: [sqlite] Mac OS X name mangling

On Nov 30, 2007, at 1:32 PM, [EMAIL PROTECTED] wrote: Peter Johnson <[EMAIL PROTECTED]> wrote: I'm running into a problem building SQLite 3.5.1 targeting a minimum of Mac OS X 10.3, but building against the 10.4 (Universal) SDK. I think this issue has been addressed in 3.5.3. Hav

Re: [sqlite] Mac OS X name mangling

eat, that's the confirmation I was hoping for! Thanks. Please also note that "thread safe" is an oxymoron. :-) I hear that. --Peter Johnson [EMAIL PROTECTED]

[sqlite] Multithreading. Again.

have a table of OSes (their runtime libraries) and SQLite (compile-time options/defines) and possible problems with multithreading. Thanks for your time. Peter Cunderlik

Re: [sqlite] Multithreading. Again.

ad, use some other thread to do something with it within a transaction and close the connection in a third one. That's all. Thank you for your help. Peter

Re: [sqlite] DLLs containing user-defined SQL functions

How does introducing a new shared library format that supports automatic bidirectional linking (as in Unix) break backwards compatibility? Nobody says they have to stop supporting DLLs. Just provide something better in addition to DLLs... Despite disliking many of the Win32 "features", I see no

Re: [sqlite] suggesiton needed for using SQL lite in a situation

ps and tricks - that usually helps a lot. :-) In any case you can break the database into multiple files later - it needs some work and changing the schema perhaps, but it's not an overkill. Current limitation is 10 attached database files but AFAIK this can be changed easily in the sources and recompiled if needed. Peter

Re: [sqlite] v3.2.1 and current differences!

At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: SQLite 3.3.0 can read and write all prior versions of SQLite databases. But SQLite 3.2.8 cannot read or write a database created by SQLite 3.3.0, unless you use PRAGMA legacy_file_format=TRUE; prior to creating the database, or unless you co

Re: [sqlite] v3.2.1 and current differences!

At 4:01 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: Peter Bierman <[EMAIL PROTECTED]> wrote: At 2:20 PM -0400 6/26/06, [EMAIL PROTECTED] wrote: >SQLite 3.3.0 can read and write all prior versions of SQLite >databases. But SQLite 3.2.8 cannot read or write a database >created

Re: [sqlite] real time gui updates

Try sqlite3_update_hook function. (http://www.sqlite.org/capi3ref.html#sqlite3_update_hook) Or you can create a trigger which in turn calls your own C function. (http://www.sqlite.org/capi3ref.html#sqlite3_create_function) Peter

Re: [sqlite] i have a few Qs - sqlite3

w you how to search for a text, and other things. Once you master all kinds SELECTs, this mailing list can give you lot of answers on optimizing your searches using indices and help you with other SQLite-specific syntax. If this is not what you're looking for, try to be more specific. Sorry for

Re: [sqlite] test program won't run anymore! sqliteBtreeOpen: Assertion 'seizeof...

nfo (e.g. sizeof(ptr)). Why should the size of this pointer be different than sizeof(char *)? Try to simulate this check in your own test program. Peter On 7/24/06, Keiichi McGuire <[EMAIL PROTECTED]> wrote: I'm pretty sure my gcc is not broken (although I'm not sure how to check s

Re: [sqlite] Using SQLite with MinGW Studio

In the ld command line, don't use the "lib" prefix, specify "sqlite3.dll.a" instead of "libsqlite3.dll.a". Peter On 7/25/06, Hat Keinen <[EMAIL PROTECTED]> wrote: Hello, I'm using the MinGW Developer Studio (on windows/windows version), http://www

Re: [sqlite] Reading the same table from two threads

it'd be allowed to set the callbacks only before opening the first connection in the process. Peter

Re: [sqlite] UTF8

ecode special Unicode things like right-to-left stuff, I'd recommend some serious library, such as ICU (icu.sourceforge.net). If you want to detect the encoding/codepage, I don't think it can be done in general, unless you know what text to expect. I might be wrong. Peter

Re: [sqlite] memory leak

can mean a number of things, a leak not necessarily being the most likely. If there is a leak then you should be able to verify that by running under the Valgrind tool (http://valgrind.org/). Peter.

Re: [sqlite] Problems opening db in win9x and utf8 filename

y, but each file or directory name has its 8.3 name as well, i.e. "Program Files" would be "progra~1". I think this is the safest way how to pass filenames to SQLite. It should work on Win 9x as well as 2K and XP. Peter

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

dump directly. The dump follows the sql syntax, so you could import the modified dump into your existing DB. Search for .dump on http://www.sqlite.org/sqlite.html . Peter

Re: [sqlite] Problems opening db in win9x and utf8 filename

han Latin-1 charsets (especially in filenames). If Costas can provide a patch, I think it'd be a useful addition to the SQLite's Win32 file handling. I'm not sure that opening a database from a filehandle or FILE structure would be a good idea. Peter

Re: [sqlite] documentation on the webserver

source tarball, in the www directory (you have to run make doc, or something like that.) Peter - To unsubscribe, send email to [EMAIL PROTECTED] -

  1   2   3   4   5   6   7   8   >