Re: [sqlite] Feature Request: Binding Arrays

2013-10-29 Thread Olaf Schmidt
Am 16.10.2013 10:40, schrieb Dominique Devienne: If I somehow missed a better work-around to this lack of array-binding, I'm also interested of course, but obviously I'd prefer real array binding. Maybe I'm missing something - but if I'd have a lot of "InApp- MemAllocations" in the form of

Re: [sqlite] vbscript and sqlltie

2013-10-29 Thread Olaf Schmidt
Am 27.10.2013 08:41, schrieb Joe Fuller: I’m trying t access sqllite database via vbscript. I don’t want to use odbc just ado.net. I'm pretty sure vbScript doesn't support .NET class-instancing directly, vbScript wants COM-(Dlls, to instantiate classes from). This is the sort of thing I’ve

Re: [sqlite] Feature Request: Binding Arrays

2013-10-31 Thread Olaf Schmidt
Am 29.10.2013 13:19, schrieb Dominique Devienne: So, after those functions are in place - where's the problem with: select * from table where InMySmallUnsortedArrayExists(some_column) select * from table where InMyLargerSortedArrayExists(some_column) select * from table where

Re: [sqlite] Feature Request: Binding Arrays

2013-11-01 Thread Olaf Schmidt
Am 31.10.2013 14:09, schrieb Dominique Devienne: [Userdefined functions in conjunction with fast Exists-checks in "Userland" - vs. SQLites built-in indexing in case of In (List)] I'm not convinced by this. The "real table" can be quite large, several 100's to 100,000's rows (up to 1+ million

[sqlite] Multiple in-memory database table query

2016-04-20 Thread Olaf Schmidt
Am 19.04.2016 um 20:34 schrieb Jarred Ford: > Is it possible to create multiple in-memory databases and be able to access > tables with a single query between them? For example, select * from > db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x. Yes, that's possible over appropriate

[sqlite] sqlite in vba7.1 and windows 8.1

2016-03-28 Thread Olaf Schmidt
Am 19.02.2016 um 14:31 schrieb Montes C?mara, Victor: > I've been using sqlite in vba6 for some years > using RichClient3 framework of Olaf Schmidt (www.datenhaus.de) The new site (which offers a new version of the RichClient, as well as new versions of __stdcall-compiled SQLite...

Re: [sqlite] Sqlite Server

2007-05-27 Thread Olaf Schmidt
mo-Client, wich can be used for MultiUser-Stress- Tests. There's no setup needed, neither for the serverpart, nor for the client-demo - all is working with registryless COM- components "out of the box", leaving no traces in your Win-registry. In a second ZIP you will find VB6-Sources for both

[sqlite] error in round-function?

2007-06-10 Thread Olaf Schmidt
o but... select round(0.95, 1) -> gives 0, wich is not correct of course Regarding bankers rounding, wich rounds up in case of a '5' at the appropriate position, the correct result should be 1. (tested with 3.3.17) Regards, Olaf Schmidt -- View this message in context: http://www.nabble

Re: [sqlite] error in round-function?

2007-06-10 Thread Olaf Schmidt
Hi drh, > http://www.sqlite.org/faq.html#q18 Not so easy I think (I'm well aware of rounding-problems regarding the IEEE-Float-Formats, etc.). Bankers rounding aside at the moment. select round(0.95, 1) gives 0 - not 0.9 (in case rounding down) and also not 1.0 (in case rounding up) Funny

Re: [sqlite] error in round-function?

2007-06-10 Thread Olaf Schmidt
> > select round(0.95, 1) > 0.9 > > select round(9.95, 1) > 9.9 > > select round(0.995, 2) > 0.99 > > select round(9.995, 2) > 9.99 > (3.3.17 here) As it should be, hmm. On what OS have you tested? If on windows, was it a GCC-compile or a MS-VC-compile? Olaf -- View this message in context:

Re: [sqlite] error in round-function?

2007-06-10 Thread Olaf Schmidt
Thanks to RBS and Alberto for testing... So it seems the problem is somehow Windows-related (maybe the VC-Compiler). Think I'll override the Round-Function in my wrapper. Regards, Olaf -- View this message in context: http://www.nabble.com/error-in-round-function--tf3897765.html#a11052069

Re: [sqlite] VFS in upcoming 3.5.0

2007-09-01 Thread Olaf Schmidt
his ask, but some time ago, not knowing if those work with the current pager. Simply thought, that this is a good time, to ask for an "officially supported" interface-enhancement regarding this functionality, mainly because of the new VFS and because I thought, you would use its capabili

Re: [sqlite] how to search for asterix character?

2010-05-26 Thread Olaf Schmidt
rs, which are equal to the "comparison- descriptors" you have to "escape them" within brackets: "...Where SomeColumnContent Like '%someother[*]part%' If the above should not work, then this would be considered a "real wrapper-bug". ;-) HTH Olaf Schmidt

Re: [sqlite] how to search for asterix character?

2010-05-26 Thread Olaf Schmidt
"Bart Smissaert" schrieb im Newsbeitrag news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com... > > "...Where SomeColumnContent Like '%someother[*]part%' > > Thanks Olaf, that works fine. > As my customers won't get this I think I might let my > code take

Re: [sqlite] New to SQLite and I have a question

2010-09-11 Thread Olaf Schmidt
"Bob Keeland" schrieb > I am new to using SQLite but think that it may be good > for a project that I'm working on. I do my programming > in Visual Basic and don't know any C\C++. > Is there any problem with connecting with SQLite from > Visual Basic? No. Though the links

Re: [sqlite] Question about SQLite features.

2010-11-10 Thread Olaf Schmidt
"Tran Van Hoc" schrieb im Newsbeitrag news:43a0ef604a674b3fb80d1447b41f8...@isbvietnam.com... [Stored procedures in SQLite] IMO stored procedure-support only makes sense in "Server-Instances" which run on their own (and communicate over different IPC-mechanisms, mainly

Re: [sqlite] Question about SQLite features.

2010-11-11 Thread Olaf Schmidt
"jeff archer" schrieb >From: "Olaf Schmidt" >Wednesday, November 10, 2010 9:07:19 AM > >>[Stored procedures in SQLite] >> >>IMO stored procedure-support only makes sense in >> "Server-Instances" which run on their own... > I

Re: [sqlite] Question about SQLite features.

2010-11-11 Thread Olaf Schmidt
"Petite Abeille" schrieb > > On Nov 11, 2010, at 8:30 PM, Olaf Schmidt wrote: > > > If such an "encapsulation of business-rules" is sitting in the > > DB itself - written in a proprietary "DB-dialect", then you > > cannot call such a thin

Re: [sqlite] Question about SQLite features.

2010-11-12 Thread Olaf Schmidt
"Chris Wolf" schrieb > I can't resist adding my little opinion to yet another > "business logic in stored procs vs. app layer" holy war... ... yeah, seems this thread is evolving nicely in this regard ... > I usually prefer keeping the business logic in the application > layer and leaving the

Re: [sqlite] Stored procedures (was: Question about SQLite features.)

2010-11-12 Thread Olaf Schmidt
"BareFeetWare" schrieb > On 12/11/2010, at 6:30 AM, Olaf Schmidt wrote: > > > "jeff archer" schrieb > >> From: "Olaf Schmidt" > >> Wednesday, November 10, 2010 9:07:19 AM > >> > >>> [Stored procedures in S

Re: [sqlite] Question about SQLite features.

2010-11-12 Thread Olaf Schmidt
"Chris Wolf" schrieb [Nested Recordsets/Resultsets as an alternative to Joins, to "shape-off" redundancy in "hierarchical requests"... as a native DB-Feature usable over Sybase StoredProcs... ...and the ADO-ShapeProvider as an example for an alternative to use "these things" in a

Re: [sqlite] Stored procedures

2010-11-12 Thread Olaf Schmidt
"BareFeetWare" schrieb > On 13/11/2010, at 10:33 AM, Olaf Schmidt wrote: > >> If you have code (in either environment) that is > >> looping or grabbing one result and sticking it in a > >> second query, then your approach is probably flawed. &g

Re: [sqlite] SQLite server

2010-12-23 Thread Olaf Schmidt
"Doug" schrieb im Newsbeitrag news:043201cba22a$f023df40$d06b9d...@poweradmin.com... > This is where I think the problems will crop up. > Can you imagine making a > network round trip for each row fetch, and then for each > column fetch of each row (sqlite3_column_type, >

Re: [sqlite] Using WAL?

2011-01-03 Thread Olaf Schmidt
"Sachin Gupta" schrieb im Newsbeitrag news:51b335651c9a0c4ea520d47f23a580b414f5baf...@sinnodmbx001.techmahindra.com... > Following are the setup details that we are presuming that our > application will be put through test: > > 1. One writer thread (To avoid

Re: [sqlite] Hello I am a newbie : for SQLite : Create db : VB6

2008-04-29 Thread Olaf Schmidt
ecute Next i 'and finally we request a Resultset... Set Rs = Cnn.OpenRecordset("Select * From Tbl") Do Until Rs.EOF 'loop over it... Debug.Print Rs!ID, Rs!Txt '...and print its contents Rs.MoveNext Loop Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] temp tables and PRAGMA temp_store

2008-04-29 Thread Olaf Schmidt
e above? > I am running this from VB with the wrapper from Olaf Schmidt. Hi Bart, the reason why you don't see any changes is, that this is already the default in my version of the SQLite-engine compile (sqlite35_engine.dll). ;-) Olaf ___ sqlite-use

Re: [sqlite] Like statement and Unicode support

2008-07-31 Thread Olaf Schmidt
Context-Switching at the serverside, Demos for fast SQLite-Recordset-transfers in a Client/Server- scenario are included) So, if COM-interfaces are no K.O.-criterion for you, then give it a try... ;-) Olaf Schmidt ___ sqlite-users mailing list sqlite-use

Re: [sqlite] Visual Basic Programming to SQlite

2008-10-03 Thread Olaf Schmidt
\ compares ADO/JET and SQLite-Performance and is based on the original NWind.mdb, which is converted (a conversion-class is included) to a NWind.db automatically on first run (including the Indexes and Views). Regards, Olaf Schmidt ___ sqlite-users mailing

Re: [sqlite] concurrent users?

2008-10-07 Thread Olaf Schmidt
n a (Begin Immediate) transaction. Hope that helps, that you get an impression what this engine is good for in a multiuser-scenario. For me it is by far underrated in regards to these concurrent scenarios - try to find a good (threadpool-based) server-implementation (or write your own)

Re: [sqlite] from access to sqlite

2008-10-08 Thread Olaf Schmidt
dd hh:nn:ss'") which in this example gives: '2008-10-09 02:49:09' ...so you could use these return-values for your String- Concats in your Select-Between-Statement for a quick test. If that does not work, then you should read in the docu of your wrapper-provider, in which other format the dates are stored in SQLite after importing from other Databases. Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] from access to sqlite

2008-10-13 Thread Olaf Schmidt
"Fabio Stranieri" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > "'11/10/2008 00:00:00'" As I see it, there's no need, to hardcode your Dates this way. You can use an appropriate Format-String to retrieve that directly from VB-DateVariables: Format(now,"'dd\/mm\/

Re: [sqlite] from access to sqlite

2008-10-13 Thread Olaf Schmidt
"Toby Bascom" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Olaf is, in a word, a genius! Heh, don't make me blush here, especially in this group, where the real DB-experts hang around... Without the sqlite-engine my wrapper wouldn't exist. I'd suggest the groups on the

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

2009-01-22 Thread Olaf Schmidt
Hi, > LOCAL: RTREE 8x faster then my OLD implementation > NET: OLD is 2x faster then RTREE > Can I use some special caching concepts? How can I > improve the run-time in the NETWORK environment? You could use/write also a small Appserver-Layer - and perform the query locally then at the

Re: [sqlite] codepages

2009-01-26 Thread Olaf Schmidt
Like-queries of the form: SomeField Like 'abc%'. So normally that should work with no problems. Regards Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Smaller issues with transactions in "undefined mode"

2009-01-26 Thread Olaf Schmidt
Hi Devs, This is not really a "bug-report", but I want to mention it nonetheless, since engine-crashes are probably not what should be left unhandled, regardless if the user tries to use the engine in an undefined-mode. Let me explain: Background: Platform Windows. StdCall-compile of the

Re: [sqlite] Smaller issues with transactions in "undefined mode"

2009-01-26 Thread Olaf Schmidt
"D. Richard Hipp" schrieb im Newsbeitrag news:f6c1943c-f8ef-400a-800a-4afb2013f...@hwaci.com... > > This forgotten switch was causing a JournalMode = Off. > > > > Later on Transactions were used inside the Copy-over- > > process from FireBird. >

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

2009-03-13 Thread Olaf Schmidt
"Jean-Christophe Deschamps" schrieb im Newsbeitrag news:7.0.1.0.2.20090312013713.0262b...@q-e-d.org... > Perhaps the best way is practice: what's the way to find > this guy named Éric or is it éric, or Eric, or eric? > He lives in MÜNCHEN, München, MUNCHEN, > Munchen or ...

Re: [sqlite] Sqlite, vb6 and date time field

2009-04-12 Thread Olaf Schmidt
rrectly translates that date-string into a VB6-Date (readable over the SQLite-Recordset). Please check it out from: www.thecommon.net/2.html www.thecommon.net/3.html (contains the Download-Links) Regards, Olaf Schmidt ___ sqlite-users mailing list s

Re: [sqlite] Sporadic freezes of sqlite

2009-04-24 Thread Olaf Schmidt
ring). Do you see any chance (since all writes are already "centralized" if one uses the new async-writer-approach), that in case of a running "granular-backup" we could avoid our planned "workaround"? In either case - that will be a nice addition to the engine - t

Re: [sqlite] Optimizing concurrency with sql query - locks?

2009-05-06 Thread Olaf Schmidt
s good enough in these typical, more ReadDirection-related-scenarios - the currently implemented locking-scheme seems not all that restrictive (if working against non-shared SQLite-caches) - so I hope, the sqlite-devs (although they often recommend, to work singlethreaded wherever possible ) keep up

Re: [sqlite] Re-try logic on SQLITE_BUSY/deadlocked?

2009-05-22 Thread Olaf Schmidt
e)? And could you please check the DB-Size before and after such a typical "update-job" (so that we get an impression about the transferred byte-volume - maybe you could also give the count of new records in case of insert-jobs)? And do you work over GBit-Ethernet (or an even faster "NFS-

Re: [sqlite] Re-try logic on SQLITE_BUSY/deadlocked?

2009-05-22 Thread Olaf Schmidt
"Rosemary Alles" schrieb im Newsbeitrag news:57c55bd7-8d56-4913-adce-cbb2978dd...@ipac.caltech.edu... > > What do you mean with "cores"? > > Are these multiple client *machines* - or do we talk about > > a sinlge client-machine with multiple (cpu-)cores here? > >

Re: [sqlite] Re-try logic on SQLITE_BUSY/deadlocked?

2009-05-23 Thread Olaf Schmidt
schrieb im Newsbeitrag news:634ea812687a6d75a1ddf17adce883fc.squir...@webmail.ipac.caltech.edu... > >> My primary concern now is to prevent a dead-lock. > > That seems to make sense now (I assume you're working > > "near a deadlock" with your multipe-client-requests,

Re: [sqlite] Slow Transaction Speed?

2009-05-31 Thread Olaf Schmidt
ur mentioned, which was interesting to read. Also interesting with regards to current ext3-behaviour was the following one: Kernel developers squabble over Ext3 and Ext4 http://www.heise.de/english/newsticker/news/135446 And finally some new default-ext3-settings in the new kernel? Solving the e

Re: [sqlite] SPHiveDB: A server for sqlite database.

2009-06-14 Thread Olaf Schmidt
"stephen liu" schrieb im Newsbeitrag news:e5a33d590906140609h4f3f35fah9083be3560f5d...@mail.gmail.com... http://code.google.com/p/sphivedb/ > SPHiveDB is a server for sqlite database. It use JSON-RPC over > HTTP to expose a network interface to use SQLite database. > It

Re: [sqlite] SPHiveDB: A server for sqlite database.

2009-06-14 Thread Olaf Schmidt
"Olaf Schmidt" <s...@online.de> schrieb im Newsbeitrag news:h131eu$m0...@ger.gmane.org... > Loop 1000 times > With LoopCounter Modulo 7 (case-switch) > ... > ... > Ending up with 11 new records in the DB Ok - make the loop-counter 7000 to reach the

Re: [sqlite] SPHiveDB: A server for sqlite database.

2009-06-15 Thread Olaf Schmidt
"lau stephen" <stephen@gmail.com> schrieb im Newsbeitrag news:c26a05160906150443h44b8f434s46e6ab4215f61...@mail.gmail.com... 2009/6/14 Olaf Schmidt <s...@online.de>: >> Each client could do (with a 1:10 relation of writes and reads) >> >> Loop 1000

Re: [sqlite] Question about searches

2009-06-17 Thread Olaf Schmidt
"Christophe Leske" schrieb im Newsbeitrag news:4a37b811.4030...@multimedial.de... >> You write your own comparison function that would consider >> these two strings equal. See sqlite3_create_function, >> sqlite3_create_collation. > > this problem pertains not only to

Re: [sqlite] Pros and cons of various online code sharing sites

2009-07-10 Thread Olaf Schmidt
sil-interface-wrapper, released under GPL - if that is of any help - but as I see it - that would shift the GPL/LGPL "interfacing-issues" only one layer "away"). Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is it Possible in SQL...

2009-07-10 Thread Olaf Schmidt
"Rick Ratchford" schrieb im Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin... > So modifying TmpTable, which will still be needed for > other procedures, is not preferred. It would be great if > a recordset could be derived from it instead that contains >

Re: [sqlite] Is it Possible in SQL...

2009-07-10 Thread Olaf Schmidt
"Rick Ratchford" schrieb im Newsbeitrag news:152a3111f1ab4a9891b9158580cb7...@dolphin... > Maybe I misunderstood, but the impression I got was > that I should solve this problem using my VB language > rather than dealing with the DB. I don't understand Simons reply

Re: [sqlite] [Columns] Keeping internal + beautified names?

2009-07-14 Thread Olaf Schmidt
"Gilles Ganault" schrieb im Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com... > On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen > wrote: > >I would just use: > > > >SELECT id AS Identification FROM foobar > > Thanks. This is what I already use

Re: [sqlite] Sqlite from ASP?

2009-07-25 Thread Olaf Schmidt
"Paul Claessen" schrieb im Newsbeitrag news:005601ca0d3f$af8748e0$0e95da...@com... > Does anyone have any (simple) examples on how > to use sqlite from .ASP scripts for me? Since you have CreateObject() available in these scripts, any COM-based SQLite wrapper should do...

Re: [sqlite] Date Comparisons SQL

2009-08-03 Thread Olaf Schmidt
"Rich Shepard" schrieb im Newsbeitrag news:alpine.lnx.2.00.0908031516300.3...@salmo.appl-ecosys.com... > > It was set as String actually. > > Rick, > >That's the storage class; well, TEXT is the storage class. Yep. > > I believe this is a WRAPPER thing though.

Re: [sqlite] Date Cutoff Statement

2009-08-03 Thread Olaf Schmidt
such interface-spec exists, would it be possible to design such a thing (at least "roughly", by an sqlite-expert) and publish it here or on the sqlite-site, before I start working on that, or do you say: "just be creative!". Any input on that is appreciate

Re: [sqlite] FTS and postfix search

2009-08-06 Thread Olaf Schmidt
"Hugh Sasse" schrieb im Newsbeitrag news:alpine.lfd.2.00.0908061712390.30...@trueman.cs.cse.dmu.ac.uk... > I wonder if the idea of suffix arrays would belp. > http://www.cs.dartmouth.edu/~doug/sarray/ I was about suggesting basically the same thing... In case of Lukas'

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

2009-10-10 Thread Olaf Schmidt
ossible, after your "main-amount" of fillups was done - that adds some additional time to your overall-data-preparation efforts of your "table-list" - but will be of benefit for your single-record-lookups, based on your "... Where ID = ? ". Olaf Schmidt

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

2009-10-11 Thread Olaf Schmidt
"Ron Arts" schrieb im Newsbeitrag news:4ad19195.2060...@arts-betel.org... > I tried it, and indeed, this speeds up inserts tremendously as well, > but in fact I'm not at all concernced about insert speed, but much more about > select speed. I use the following queries: > >

Re: [sqlite] group_concat optimization

2009-10-15 Thread Olaf Schmidt
where, blowing up *total* mem-usage of a running SQLite-engine-instance by on average 25%", I'd vote for the change... ;-) Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INTERSECT?

2009-10-18 Thread Olaf Schmidt
"Pavel Ivanov" schrieb im Newsbeitrag news:f3d9d2130910170753k6e680ecdtcb892f05b21cc...@mail.gmail.com... > > select * from foo f1 where > > (select count(*) from (select distinct b from foo f2 where f1.a = f2.a and f2.b in (...) )) = > >length_of_b_list > > and b in

Re: [sqlite] INTERSECT?

2009-10-18 Thread Olaf Schmidt
"Igor Tandetnik" <itandet...@mvps.org> schrieb im Newsbeitrag news:hbfjnu$v...@ger.gmane.org... > Olaf Schmidt wrote: > > Just to add another one to the pile, any flaws I overlooked here...? > > > > select *, count(b) c_b from foo > > whe

Re: [sqlite] sqlite in-memory database far too slow in my use case

2009-10-18 Thread Olaf Schmidt
"Ron Arts" schrieb im Newsbeitrag news:4adac5c1.5010...@arts-betel.org... > Then my program opens a socket, and starts accepting connections, > those connections are long lasting, and send messages that need > a fast reply. Many of the messages result in messages being send

Re: [sqlite] SQLite server for Windows/Linux?

2009-10-23 Thread Olaf Schmidt
"Gilles Ganault" schrieb im Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com... > Maybe someone will come up with a commercial alternative. > I for one would gladly pay for a single-EXE, no-brainer solution > that can run on Windows and *nix. Hmm in this

Re: [sqlite] SQLite server for Windows/Linux?

2009-10-25 Thread Olaf Schmidt
"David Morris" schrieb im Newsbeitrag news:26044356.p...@talk.nabble.com... > > Have a peek at : http://www.sqlitening.com/support/index.php > Different language and could run under Wine on *nix Ah - yes of course, I left it out here, since it currently is "win only"

Re: [sqlite] Reverse Referencing Rows

2009-11-11 Thread Olaf Schmidt
"Rick Ratchford" schrieb im Newsbeitrag news:dbfb2606d0c1448b930064474496a...@dolphin... > A while back, Igor gave me some help on pulling out mm/dd ranges (sets) from > my table. > > This is the code that does that. > > sSQL = "SELECT Date, Year, Month, Day, Open,

Re: [sqlite] Why does LIKE operator affect order of query plan?

2009-11-16 Thread Olaf Schmidt
"Tim Romano" schrieb im Newsbeitrag news:4b0149c9.8000...@yahoo.com... > ... > My query with the LIKE operator worked instantaneously > in MS-Access, BTW, where I originally had the database. Since Access *.mdbs are often used with(in) VB- or VBA-based applications - are

Re: [sqlite] Why does LIKE operator affect order of query plan?

2009-11-16 Thread Olaf Schmidt
"Tim Romano" schrieb im Newsbeitrag news:4b017343.2040...@yahoo.com... > I've added a column to my table: > > ALTER TABLE WORDS > ADD COLUMN spell varchar COLLATE NOCASE > > and have then copied the contents of a 100% pure ASCII column > into column SPELL. > > explain

Re: [sqlite] Convert Access sql to SQLite sql

2009-12-03 Thread Olaf Schmidt
work "out of specification", if an Update is performed inside an "Instead Of Insert" trigger, but the above steps perform really good + it can be "formalized" nicely, to construct the statements also programmatically (maybe at some "PreProcessor-level",

Re: [sqlite] SQLite with HTA(vbscript) Date Format Problem

2009-12-13 Thread Olaf Schmidt
;) & " AND " & _ Format(D2, "'yy\-mm\-dd'") Or define a Const for the above shown Format-Def- Stringliteral for the second Parameter of the Format-Function. Nonetheless better to use a command-object for that task, in case your current COM-wrapper has built-in

Re: [sqlite] ICU collation

2009-12-21 Thread Olaf Schmidt
"Igor Tandetnik" schrieb im Newsbeitrag news:hgom0b$u0...@ger.gmane.org... Sylvain Pointeau wrote: > > How does sqlite handle ICU, I don't understand? > > is it used only for the sort order? > No, the collation is used both for sorting and for

Re: [sqlite] Mozilla's method

2009-12-31 Thread Olaf Schmidt
which "owns" the async thread. So, just in case you're using the dhRichClient3-wrapper-lib, there's currently no plan (and no time), to make that feature available in a reliable and stable working way (playing well with VB5/6) over the COM-interface. Olaf Schmidt _

Re: [sqlite] Mozilla's method

2010-01-01 Thread Olaf Schmidt
leaving it at its default FULL(2)) - instead you should wrap larger insert- or update-actions within a transaction - that works fast as well. Also consider using the binding-support of the wrapper (the Command-Objects), to achieve faster (and more typesafe) operations in "write direction". O

Re: [sqlite] Mozilla's method

2010-01-01 Thread Olaf Schmidt
corruption this way - and in case of an unexpected Close of the App (due to whatever reason), you will lose only the new data which was gathered within the last timer-interval. Olaf Schmidt ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mozilla's method

2010-01-01 Thread Olaf Schmidt
quire some experimenting first, which timer-interval works best (depends somewhat on the frequency and size of the incoming new data-records, but also on the underlying storage-media, the DB is hosted on - be it flash-based media, as USB-sticks for example - or "real Hard-Disks"). Olaf Sc

Re: [sqlite] Mozilla's method

2010-01-01 Thread Olaf Schmidt
ld fail" ... Apps which also only work singlethreaded within a single process ... ...the timer-based transaction-syncing then only an "easier applicable workaround" in environments which cannot - (or don't want to) make use of the more efficient working asy

Re: [sqlite] Fastest concurrent read-only performance (+ threads vs processes)

2010-03-05 Thread Olaf Schmidt
"Luke Evans" schrieb im Newsbeitrag news:3be16206-d0c6-4041-a3a6-ca3c069ee...@me.com... > It's Objective-C, but all the SQLite interfacing bits are pure C > directly driving the SQLite API compiled into the program > (3.6.22 amalgamation). Just to make sure ... do you really

Re: [sqlite] Fastest concurrent read-only performance (+ threads vs processes)

2010-03-05 Thread Olaf Schmidt
"Luke Evans" schrieb im Newsbeitrag news:5d6df6e4-c817-4788-a2a2-87dc5e32f...@me.com... > Thanks very much for your notes Olaf. > > I've done as you suggest... I already had SQLITE_THREADSAFE=2 > defined, but didn't have the SQLITE_OMIT_SHARED_CACHE > asserted (assuming private

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses)

2010-03-05 Thread Olaf Schmidt
ernel-space or user-space threads? Maybe this library serializes execution of your threads when processes can be parallelized over CPU cores. Pavel On Fri, Mar 5, 2010 at 2:09 PM, Olaf Schmidt <s...@online.de> wrote: > > "Luke Evans" <luk...@me.com> schrieb im Newsbei

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses)

2010-03-05 Thread Olaf Schmidt
"Pavel Ivanov" schrieb im Newsbeitrag news:f3d9d2131003051131k23c7b61cueda0bcc72e6aa...@mail.gmail.com... Oops, pressed send unintentionally... > > Long story short - I suspect the open-call, to be the "blocker" > > in your "SharedCache-Mode=Off"-scenario. > If database

Re: [sqlite] Fastest concurrent read-only performance (+ threads vsprocesses) [BUG?]

2010-03-14 Thread Olaf Schmidt
"Marcus Grimm" schrieb im Newsbeitrag news:4b9a01e8.2060...@medcom-online.de... > Increasing the number of threads does affect the overall > read performance slightly, example: > 1 Thread: 11.2 sec > 16 Threads: 8.2 sec > Single Process: 11sec. > > I still would expect

Re: [sqlite] SQLITE3 in multi-thread server

2010-03-16 Thread Olaf Schmidt
r-based clients which work against "RPC-Servers, or Application-Servers - or let's call them *WebServers* ;-) ...over sockets (e.g. receiving JSON- serialized Resultsets over http) - ... no matter what SQL- engine is working in the backend of such a WebSite ... "clientside-controlled Serv

Re: [sqlite] [Windows] Application to let end-users handle records?

2010-05-17 Thread Olaf Schmidt
dy existing schema (e.g. for visualizing in a TreeView) per: For Each Db In Cnn.Databases For Each Tbl In DB.Tables For Each Clm In Tbl.Columns '... Next Clm For Each Idx In Tbl.Indexes '... Next Idx Next Tbl Next Db Olaf Schmidt

Re: [sqlite] [Windows] Application to let end-users handle records?

2010-05-17 Thread Olaf Schmidt
"Gilles Ganault" <gilles.gana...@free.fr> schrieb im Newsbeitrag news:uk03v5h4ovo8un5hq68ldbotuf1fujr...@4ax.com... > On Mon, 17 May 2010 18:59:36 +0200, "Olaf Schmidt" > <s...@online.de> wrote: > >I'd say, what you're looking for (in case a "

Re: [sqlite] Remote connection to SQLite db

2012-10-18 Thread Olaf Schmidt
Am 18.10.2012 15:41, schrieb Abhinav: Does SQL lite have an option of processes connecting to it from remote hosts with a port number? There's nothing directly built-in in the sqlite-library. In case you need that for Windows (also depends on your development- environment a bit) my

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Olaf Schmidt
Am 08.12.2012 22:09, schrieb Gilles Ganault: Ok, but where are the large number of tools that would do that? Features: - very fast, very basic spreadsheet (not based on Excel or Libre/OpenOffice) I think you will have to be more specific with regards to "spreadsheet-like functionality".

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Olaf Schmidt
Am 09.12.2012 12:40, schrieb Simon Slavin: On 9 Dec 2012, at 11:13am, Gilles Ganault wrote: OTOH, whoever writes that application could always provide two version: Basic (datagrid) and Pro (spreadsheet). If you think you can make money by providing a basic app,

Re: [sqlite] Multiple network connections

2012-12-25 Thread Olaf Schmidt
Am 25.12.2012 22:18, schrieb Çağlar Orhan: But every client has MS *.hta files and connecting to sqlite over ODBC driver with vbscript. What you rely on in this case, has nothing to do with the WebServer (IIS) ... meaning the WebServer is not used as a decoupling layer (over http). What you

Re: [sqlite] Implementing "Save As..." functionality for Application File Format usecase

2013-04-04 Thread Olaf Schmidt
Am 03.04.2013 23:11, schrieb Tiago Rodrigues: I'm writing a small simulation app and for it I would like to use SQLite3 as an application file format, ... > ... For that, the simplest idea would be to use the online backup family of functions, calling sqlite3_backup_init() and

Re: [sqlite] Large Database Windows vs Linux

2013-06-29 Thread Olaf Schmidt
Am 28.06.2013 14:54, schrieb Christopher W. Steenwyk: I have a rather large database (11 GB) that has two tables (one with approximately 500,000 rows and another with approximately 50,000,000 rows). In this database I am performing a query that joins these two tables to produce approximately

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-05 Thread Olaf Schmidt
Am 03.07.2013 14:50, schrieb Keith Medcalf: Given all that, I will NEVER use the pure sql (if I can use any other solution). given that the "ordinal in the result set" is a fallacious concept being created for the convenience of an application > program which cannot deal with sets properly

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-05 Thread Olaf Schmidt
Am 04.07.2013 20:36, schrieb James K. Lowden: Yes, and there's your O(N log N): N for the SCAN and log(N) for the SEARCH. To process 1,000,000 rows takes 1,000,000 accesses. To produce the rank requires roughly 20 searches per row (given an appropriate index), or 20,000,000 total accesses.

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-07 Thread Olaf Schmidt
Am 06.07.2013 18:58, schrieb j.merrill- There are reasons to want what is in other SQL implementations implemented with "row_number() OVER (ORDER BY ...)" but "disconnected Recordsets" or for data "passed across thread- or machine-boundaries" are definitely NOT valid reasons. Since they are

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

2013-07-07 Thread Olaf Schmidt
Am 06.07.2013 19:25, schrieb Keith Medcalf: Date: Fri, 05 Jul 2013 02:04:04 +0200 From: Olaf Schmidt <n...@vbrichclient.com> To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there a way to return the row number? (NOT the rowid) Message-ID: <kr52ig$e71$1...@ger.gmane.org>

Re: [sqlite] Finding rows with MIN(MTIME) for all IDs

2012-09-05 Thread Olaf Schmidt
Am 05.09.2012 15:58, schrieb Igor Tandetnik: Well, you could do something like this: SELECT id, a, b, ..., mtime FROM tab t1 where mtime = (select min(mtime) from tab t2 where t2.id=t1.id) ORDER BY mtime DESC; Ah, nice ... this solves the problem of the potential "non-uniqueness" of mtime...

Re: [sqlite] Finding rows with MIN(MTIME) for all IDs

2012-09-05 Thread Olaf Schmidt
Am 05.09.2012 16:57, schrieb Richard Hipp: On Wed, Sep 5, 2012 at 10:53 AM, Olaf Schmidt <s...@online.de> wrote: Am 05.09.2012 15:58, schrieb Igor Tandetnik: Well, you could do something like this: SELECT id, a, b, ..., mtime FROM tab t1 where mtime = (select min(mtime) from tab t2

Re: [sqlite] instr function or equivalent

2012-09-11 Thread Olaf Schmidt
Am 10.09.2012 17:17, schrieb Bart Smissaert: Ah, OK. I have a feeling that needs to be done either in your application code or with a user defined SQLite function. Somebody may prove me wrong. Hi Bart, since I know you're using my COM-Wrapper, a larger set of Functions (in "VBA-Style",

Re: [sqlite] Store error messages in thread local memory

2012-09-21 Thread Olaf Schmidt
Am 20.09.2012 17:40, schrieb Sebastian Krysmanski: >> What's your threading mode? >> http://www.sqlite.org/threadsafe.html Serialized This could explain, why you get these performance-results, you reported before (comparing multiple connections vs. a shared one): > I tested with a

Re: [sqlite] Store error messages in thread local memory

2012-09-21 Thread Olaf Schmidt
Am 21.09.2012 18:03, schrieb Olaf Schmidt: ...so I can effort the independent... ...arrgh, 'afford' of course, sorry for the noise... Olaf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Store error messages in thread local memory

2012-09-21 Thread Olaf Schmidt
Am 21.09.2012 19:28, schrieb Keith Medcalf: So one needs to take care that the engine operates in the properly matching modes for the two approaches when used in threads: - shared Cache (single dbHdl over all threads) => serialized (SQLITE_THREADSAFE=1) - separate Caches (a dedicated

Re: [sqlite] Store error messages in thread local memory

2012-09-24 Thread Olaf Schmidt
Am 24.09.2012 11:26, schrieb Sebastian Krysmanski: Ok, I tried that. It definitely improves performance when using a lot threads (15+)... So I take it, that your last posted result here was using a shared cache (in case of the multiple connections):

  1   2   >