Re: [sqlite] sqlite Query Optimizer

2014-10-16 Thread Prakash Premkumar
Thanks for your reply Simon. I have read through those links. Does sqlite implement the pointers in the System R Algorithm ? Like assigning selectivity factors for predicates in where clause? Link to System R Algorithm: https://www.cs.duke.edu/courses/spring03/cps216/papers/selinger-etal-1979.pdf

Re: [sqlite] sqlite Query Optimizer

2014-10-16 Thread Simon Slavin
On 16 Oct 2014, at 7:50am, Prakash Premkumar wrote: > Does sqlite implement the pointers in the System R Algorithm ? SQLite does not implement the System R Algorithm, so no, it doesn't implement the pointers from System R. It implements the algorithms described in the

Re: [sqlite] group_concat query performance

2014-10-16 Thread Kraijenbrink - FixHet - Systeembeheer
Hi Joe, Sorry for the delay, I had to solve an server problem first. This is the sql query I've been testing with SELECT GROUP_CONCAT(Parent.fkintFolderID,'\') FilePath FROM tblFolderNestedSets Node ,tblFolderNestedSets Parent WHERE Node.intLeft BETWEEN

Re: [sqlite] sqlite Query Optimizer

2014-10-16 Thread Prakash Premkumar
Thanks a lot Simon. Are there any projects where , sqlite optimizer has been extended to add System R or other algorithms ? I browsed through the github repository and could not find any. Thanks a lot for your time. Regards Prakash On Thu, Oct 16, 2014 at 12:49 PM, Simon Slavin

Re: [sqlite] sqlite Query Optimizer

2014-10-16 Thread Simon Slavin
On 16 Oct 2014, at 11:07am, Prakash Premkumar wrote: > Are there any projects where , sqlite optimizer has been extended to add > System R The optimizer currently built into SQLite does the same job as what you're thinking of as "System R". It is not possible to use

Re: [sqlite] Unable to prepare a statement

2014-10-16 Thread Sam Carleton
Yes, that was the case. The app has two databases, a system wide DB and the active data DB. The system points to the active data DB but wasn't configured to point to the active data. Live and learn:) Pax vobiscum, Sam Carleton On Wed, Oct 15, 2014 at 6:01 AM, Dan Kennedy

Re: [sqlite] UPDATE Help

2014-10-16 Thread Shantanu Namjoshi
Thank you sir. Sometimes my brain freezes are unbelievable! Shantanu From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Tuesday, October 14, 2014 11:27 PM To: General Discussion of

Re: [sqlite] UPDATE Help

2014-10-16 Thread Shantanu Namjoshi
Thank you Simon. Will do. Shantanu From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Tuesday, October 14, 2014 11:27 PM To: General Discussion of SQLite Database Subject: Re:

[sqlite] Granularity of Locks in sqlite

2014-10-16 Thread Prakash Premkumar
Hi, >From what I understand from reading the followig doc: http://www.sqlite.org/lockingv3.html sqlite supports only file level locking.Is there any attempts to improve the granularity of locking to table level or row level ? Thanks a lot. Prakash

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread John McKown
On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp wrote: > Please try the latest version of SQLite on trunk to see if that works > better. Specifically, apply the patch at > > http://www.sqlite.org/src/vpatch?from=b2c89ef49cd1=ef30e0352b3d > > -- > D. Richard Hipp >

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread Richard Hipp
On Thu, Oct 16, 2014 at 9:53 AM, John McKown wrote: > On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp wrote: > > Please try the latest version of SQLite on trunk to see if that works > > better. Specifically, apply the patch at > > > >

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread John McKown
On Thu, Oct 16, 2014 at 9:09 AM, Richard Hipp wrote: > On Thu, Oct 16, 2014 at 9:53 AM, John McKown > wrote: > >> On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp wrote: >> > Please try the latest version of SQLite on trunk to see if

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread Teg
Hello John, I feed everything to Sqlite in UTF-8. If it's coming from Windows, that means I have to do a UTF-16 to UTF-8 conversion. I know Sqlite has UTF-16 support but, I want things to be consistent across all OS's I work with. The less I have to think about things like this, the

[sqlite] WHERE expression with operators from text functions?

2014-10-16 Thread Tom Holden
Coming up with a subject was a struggle and maybe that indicates an impossibility. Searching the archive was equally fruitless. What I am trying to do is to build a SELECT with a compound WHERE using one or more run-time parameters. Sort of like transforming an input phrase such as:

Re: [sqlite] WHERE expression with operators from text functions?

2014-10-16 Thread Richard Hipp
On Thu, Oct 16, 2014 at 12:03 PM, Tom Holden wrote: > Coming up with a subject was a struggle and maybe that indicates an > impossibility. Searching the archive was equally fruitless. > Perhaps what you really want is Full Text Search. http://www.sqlite.org/fts3.html > >

Re: [sqlite] WHERE expression with operators from text functions?

2014-10-16 Thread Tom Holden
I think you are right. The FTS MATCH looks like it should function the way I want. Thanks, Richard! I will now learn how to use FTS... Tom On Thu, Oct 16, 2014 at 12:20 PM, Richard Hipp wrote: > On Thu, Oct 16, 2014 at 12:03 PM, Tom Holden wrote: > > >

Re: [sqlite] Search query alternatives.

2014-10-16 Thread Eduardo Morras
On Thu, 16 Oct 2014 09:05:51 +1100 Michael Falconer wrote: > Hi all, > > first off I must start with an apology. I know I'm sort of doing the > wrong thing here as this question is NOT related to sqlite. It is a > general SQL question but I ask it here because I

[sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
Greetings! I am trying to create a report with this query, select id, ProjID, PClass, PSubClass, bdate, lang, wDir From LSOpenJobs Where cust = 'PIPA' AND fromLang = 'EN-CA' AND (lang = 'DE-DE' OR lang = 'PT-BR') AND PSubClass LIKE '%-Trans' OR PSubClass Like '%-Valid' AND (PClass =

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
"jose isaias cabrera" wrote... Greetings! I am trying to create a report with this query, select id, ProjID, PClass, PSubClass, bdate, lang, wDir From LSOpenJobs Where cust = 'PIPA' AND fromLang = 'EN-CA' AND (lang = 'DE-DE' OR lang = 'PT-BR') AND PSubClass LIKE '%-Trans' OR PSubClass Like

Re: [sqlite] Search query alternatives.

2014-10-16 Thread Michael Falconer
Thanks Eduardo, a most interesting link. On 17 October 2014 05:41, Eduardo Morras wrote: > On Thu, 16 Oct 2014 09:05:51 +1100 > Michael Falconer wrote: > > > Hi all, > > > > first off I must start with an apology. I know I'm sort of doing the >

Re: [sqlite] Please fix the EBCDIC support

2014-10-16 Thread k
Hi all, this is my first reply-to post to this mailing list (using gmane nttp interface) so I hope this post passes moderation ok and is correctly threaded and not duplicated...). Regarding the inability to use databases created on EBCDIC systems on 'normal' systems, my initial thoughts are

Re: [sqlite] group_concat query performance

2014-10-16 Thread Joe Mistachkin
Kraijenbrink - FixHet - Systeembeheer wrote: > > Sorry for the delay, I had to solve an server problem first. This is the > sql query I've been testing with > Thanks for the query. It's difficult to track down performance issues with System.Data.SQLite without seeing the C# (or VB.NET) example

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread Keith Medcalf
You said: select id, ProjID, PClass, PSubClass, bdate, lang, wDir From LSOpenJobs Where cust = 'PIPA' AND fromLang = 'EN-CA' AND (lang = 'DE-DE' OR lang = 'PT-BR') AND PSubClass LIKE '%-Trans' OR PSubClass Like '%-Valid' AND (PClass = 'Language' OR PClass =

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread Richard Hipp
On Thu, Oct 16, 2014 at 7:16 PM, Keith Medcalf wrote: > > Although the parser does not care how you format your query, human > readability is improved by using nice formatting. > Indeed, the error would have likely been spotted much faster had the query been reformatted for

[sqlite] specified store provider cannot be found in the configuration, or is not valid exception

2014-10-16 Thread Ben Lam
Hi, Really appreciate any help. I get the exception 'The specified store provider cannot be found in the configuration, or is not valid.' on this line in the code: using (var handheldEntities = new HandheldDatabaseOnDesktopEntities()) My environment: VS2010 SP1, WIN 8.1 PRO Snippet from

Re: [sqlite] Getting an unexpected result

2014-10-16 Thread jose isaias cabrera
"Richard Hipp" wrote... On Thu, Oct 16, 2014 at 7:16 PM, Keith Medcalf wrote: Although the parser does not care how you format your query, human readability is improved by using nice formatting. Indeed, the error would have likely been spotted much faster had the

[sqlite] Inmemory database in sqlite

2014-10-16 Thread Prakash Premkumar
Hi, Does in memory database in sqlite have journal files associated with it ? If there's a system failure before an in memory database is backed up ? Will there be data loss ? Or Can you kindly tell me how sqlite handles this ? Thanks Prakash ___

Re: [sqlite] Inmemory database in sqlite

2014-10-16 Thread Igor Tandetnik
On 10/17/2014 12:48 AM, Prakash Premkumar wrote: Does in memory database in sqlite have journal files associated with it ? No. The journal is in memory, too. If there's a system failure before an in memory database is backed up ? What do you mean, backed up? Backed up where and by whom? --

Re: [sqlite] Inmemory database in sqlite

2014-10-16 Thread Prakash Premkumar
Thanks for your reply Igor, I mean , I have written INSERT statements in to the inmemory database and a system failure occurs before I dump the data to a file using the SQLite Backup API, will there be a data loss ? There is no assurance of durablity for in memory databases right ? Thanks

Re: [sqlite] Inmemory database in sqlite

2014-10-16 Thread Igor Tandetnik
On 10/17/2014 1:00 AM, Prakash Premkumar wrote: I mean , I have written INSERT statements in to the inmemory database and a system failure occurs before I dump the data to a file using the SQLite Backup API, will there be a data loss ? Of course. There is no assurance of durablity for in

Re: [sqlite] Search query alternatives.

2014-10-16 Thread GB
Michael, a Guy named Joe Celko elaborated about trees and hierarchies in SQL a few years ago. Have a look here: http://www.amazon.com/Hierarchies-Smarties-Edition-Kaufmann-Management/dp/0123877334/ref=dp_ob_title_bk regards gerd ___ sqlite-users

Re: [sqlite] Inmemory database in sqlite

2014-10-16 Thread Alessandro Marzocchi
Today, random-access memory takes the form of integrated circuits . RAM is normally associated with volatile types of memory (such as DRAM memory modules