Re: [sqlite] Inmemory database in sqlite

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

Re: [sqlite] Search query alternatives.

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

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] Inmemory database in sqlite

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

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

[sqlite] Inmemory database in sqlite

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] Getting an unexpected result

"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] specified store provider cannot be found in the configuration, or is not valid exception

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

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

Re: [sqlite] Getting an unexpected result

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] group_concat query performance

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] Please fix the EBCDIC support

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] Search query alternatives.

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] Getting an unexpected result

"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

[sqlite] Getting an unexpected result

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] Search query alternatives.

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

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

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] WHERE expression with operators from text functions?

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

[sqlite] WHERE expression with operators from text functions?

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] Please fix the EBCDIC support

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

Re: [sqlite] Please fix the EBCDIC support

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

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

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 >

[sqlite] Granularity of Locks in sqlite

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] UPDATE Help

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:

Re: [sqlite] UPDATE Help

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] Unable to prepare a statement

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] sqlite Query Optimizer

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] sqlite Query Optimizer

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] group_concat query performance

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

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] sqlite Query Optimizer

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