[sqlite] Windows 64 bit version of SQLite available?

Hi all I see SQLite is available for x86 only. I need one for x64. Where can I get it? thx HR Lee ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows 64 bit version of SQLite available?

On 29 Apr 2012, at 8:30pm, HaeRim Lee wrote: > I see SQLite is available for x86 only. SQLite is distributed as C source code. Download the amalgamation and compile it for whatever platform you want. Simon.

[sqlite] 64-bit precompiled command-line shell binary for Windows 7

Dear Sqlite development team, I'd like to add a vote for requesting a 64-bit precompiled command-line shell binary (sqlite3.exe) for Windows 7 - to be added to the list of files downloadable from the page . It would be very helpful for those of us who are

[sqlite] Good books to lear SQL using SQLite?

I am learning SQL using SQLite, can anyone tell me of a good book to learn SQL using SQLite? TIA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Good books to lear SQL using SQLite?

On 30 Apr 2012, at 3:18pm, Arbol One wrote: > I am learning SQL using SQLite, can anyone tell me of a good book to learn > SQL using SQLite? Here's the cannonical list: The second one down, _Using SQLite_ is by a frequent

Re: [sqlite] Good books to lear SQL using SQLite?

On Mon, 30 Apr 2012 10:18:33 -0400 "Arbol One" wrote: > I am learning SQL using SQLite, can anyone tell me of a good book to > learn SQL using SQLite? I'm very happy with Owens' The Definitive Guide to SQLite...there is 2nd ed. now. Sincerely, Gour -- As a strong

Re: [sqlite] Good books to lear SQL using SQLite?

On Mon, Apr 30, 2012 at 03:53:29PM +0100, Simon Slavin scratched on the wall: > > On 30 Apr 2012, at 3:18pm, Arbol One wrote: > > > I am learning SQL using SQLite, can anyone tell me of a good book > > to learn SQL using SQLite? > > Here's the cannonical list: > >

Re: [sqlite] System.Data.SQLite and pooling problem

I noticed this while supporting the NFL Draft, not sure exactly how many threads were going through the score code that was causing this exception, but the servers were generally processing 200-300 requests per second at the time. Yes, connection pooling is turned on for the code in the stack

Re: [sqlite] Good books to lear SQL using SQLite?

On 30/4/2012 10:53 PM, Simon Slavin wrote: On 30 Apr 2012, at 3:18pm, Arbol One wrote: I am learning SQL using SQLite, can anyone tell me of a good book to learn SQL using SQLite? Here's the cannonical list: The second one down,

Re: [sqlite] Good books to lear SQL using SQLite?

On Mon, Apr 30, 2012 at 10:18 AM, Arbol One wrote: > I am learning SQL using SQLite, can anyone tell me of a good book to learn > SQL using SQLite? > Its a web page and free software, not a book, but you might try this page to start off and then get a book after you

Re: [sqlite] System.Data.SQLite and pooling problem

Alexander Spence wrote: > > I noticed this while supporting the NFL Draft, not sure exactly how many threads were > going through the score code that was causing this exception, but the servers were > generally processing 200-300 requests per second at the time. > Just curious, were you

[sqlite] Fwd: Expression syntax

Anyone? -- Forwarded message -- From: Pete Date: Thu, Apr 26, 2012 at 10:55 AM Subject: Expression syntax To: sqlite-users@sqlite.org The syntax diagram for an expression using the IN/NOT IN operators shows an option to specify database.tablename as the

Re: [sqlite] sqlite] Fwd: Expression syntax

It evaluates to the content of the table. sqlite> create table t(a); sqlite> insert into t values(1); sqlite> insert into t values(2); sqlite> create table t2(a); sqlite> insert into t2 values(1); sqlite> insert into t2 values(2); sqlite> insert into t2 values(3); sqlite> insert into t2

Re: [sqlite] Fwd: Expression syntax

On 30-04-2012 18:50, Pete wrote: > Anyone? > > -- Forwarded message -- > From: Pete > Date: Thu, Apr 26, 2012 at 10:55 AM > Subject: Expression syntax > To: sqlite-users@sqlite.org > > > The syntax diagram for an expression using the IN/NOT IN operators

Re: [sqlite] Fwd: Expression syntax

On Mon, Apr 30, 2012 at 09:50:34AM -0700, Pete scratched on the wall: > Anyone? > > -- Forwarded message -- > From: Pete > Date: Thu, Apr 26, 2012 at 10:55 AM > Subject: Expression syntax > To: sqlite-users@sqlite.org > > > The syntax diagram for an

Re: [sqlite] Fwd: Expression syntax

On Mon, Apr 30, 2012 at 7:03 PM, Jay A. Kreibich wrote: > > option to specify database.tablename as the right operand. What does > > database.tablename evaluate to? > > column. You cannot provide a table and column, it must be a single-column table. > That seems to

Re: [sqlite] System.Data.SQLite and pooling problem

Joe Mistachkin wrote: > > Alexander Spence wrote: > > > > What is the purpose of these locks when Sqlite itself has been compiled as ThreadSafe? > > > > I'm not sure what the original intent of that lock was; however, after reviewing the code, > that lock does not seem to serve a useful

Re: [sqlite] Fwd: Expression syntax

On 30 Apr 2012, at 6:19pm, Stephan Beal wrote: > On Mon, Apr 30, 2012 at 7:03 PM, Jay A. Kreibich wrote: > >>> option to specify database.tablename as the right operand. What does >>> database.tablename evaluate to? >> >> column. You cannot provide

Re: [sqlite] Fwd: Expression syntax

On Mon, Apr 30, 2012 at 7:31 PM, Simon Slavin wrote: > >> column. You cannot provide a table and column, it must > >> be a single-column table. > >> > > I see no conflict with what Jay wrote. The diagram says that db.table is > allowed. Jay has said that this

Re: [sqlite] Fwd: Expression syntax

On Mon, Apr 30, 2012 at 7:40 PM, Stephan Beal wrote: > "You cannot provide a table and column" > Ignore me, please - i'm confusing DB.TABLE with TABLE.COLUMN. Sorry about that. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal

Re: [sqlite] System.Data.SQLite and pooling problem

I work for Pluck, we handle social media integration for the NFL (Comments, Ratings, Etc.) We actually handled about 2k rps at the LB with about 10 servers taking up to 300 rps. We have a setup that does not require a centralized server over our 300 some customers (This solution was inherited

Re: [sqlite] System.Data.SQLite and pooling problem

Alexander Spence wrote: > > (I'm the one that filed the Sqlite Backup API Ticket.. Actually just merged > that code in and found the access violations.) > Are you using the new backup API support in the latest System.Data.SQLite release or some custom code? > > Your fix looks a lot better than

Re: [sqlite] System.Data.SQLite and pooling problem

Thanks for the explanation, makes sense. We were using the new backup support but had to revert due to the access violations, was causing IIS to reset. The plan is to use the New Backup support once the access violation problem is solved. I'm still trying to reproduce and verify the problem

Re: [sqlite] System.Data.SQLite and pooling problem

Alexander Spence wrote: > > Btw, on an unrelated note, the is there a reason the System.Data.Sqlite source > files are not directly included by theSystem.Data.Sqlite.csproj file instead of > using a targets file? Just makes it a pain to view or make changes to the source > in visual studio. >

[sqlite] location syntax in hibernate.cfg.xml

I submitted this question a week ago but don't think I was quite clear in what I need. I am using hibernate with sqlite and everything seems to be working well except when the project is packaged. It needs to be in a certain location but when I put it there, I must not have the syntax correct

[sqlite] questions regarding WAL and Shared Cache Mode

Hello, this is my first question in the Sqlite mailing list: I am currently investigating concurrency in SQLite. I found two related topics: WAL and Shared Cache Mode. Below is a list of my understandings regarding them: 1. The main purpose of Shared Cache Mode is to enable multiple

Re: [sqlite] questions regarding WAL and Shared Cache Mode

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 30/04/12 14:52, Sean Cui wrote: > 1. The main purpose of Shared Cache Mode is to enable multiple > connections to a database file WITHIN a process. No, it is to save some memory. You can already open up multiple connections to the same or

[sqlite] Concurrency

Hi, I am trying to make sqlite available for concurrency within a process and multi-process. 1. Currently I am using the default Isolation level for Sqlite, which doesn't even allows me the multiple reads on the single table. What's the default isolation level and how can I change it? I tried

Re: [sqlite] Concurrency

On Mon, Apr 30, 2012 at 7:17 PM, Harnek Manj wrote: > Hi, > > I am trying to make sqlite available for concurrency within a process and > multi-process. > WAL mode. 5. Read about WAL, it gives the concurrency. But I think it gives > concurrency by allowing dirty

Re: [sqlite] Concurrency

Hi Richard, Thanks for the quick reply. So what I am confused is, if there is a Write (update) operation and it creates a WAL file and subsequently a read operation comes in and the read is trying to access the same data what write is working on. Does in this scenario read will wait or it

Re: [sqlite] Concurrency

On 4/30/2012 7:46 PM, Harnek Manj wrote: So what I am confused is, if there is a Write (update) operation and it creates a WAL file and subsequently a read operation comes in and the read is trying to access the same data what write is working on. Does in this scenario read will wait or it

Re: [sqlite] Concurrency

Hi Igor, Sorry about that. What I meant was "really latest committed data". As you answered that "It will read most recent", so as per the scenario I mentioned in my previous post does it mean that read will wait for the current write operation to finish? Regards Harnek -Original

Re: [sqlite] Concurrency

Here is a simple scenario to explain what the OP meant: Under WAL mode, In connection A, we issue SQL "UPDATE Employee SET Salary=0" to SQLite. While the command is executing, from another connection, we issue "SELECT Salary FROM Employee". In this case, even under WAL, the SELECT command

Re: [sqlite] Concurrency

On Mon, Apr 30, 2012 at 8:10 PM, Sean Cui wrote: > Here is a simple scenario to explain what the OP meant: > > Under WAL mode, > > In connection A, we issue SQL "UPDATE Employee SET Salary=0" to SQLite. > > While the command is executing, from another connection, we

Re: [sqlite] Concurrency

On 4/30/2012 8:03 PM, Harnek Manj wrote: Sorry about that. What I meant was "really latest committed data". As you answered that "It will read most recent", so as per the scenario I mentioned in my previous post does it mean that read will wait for the current write operation to finish? No.

Re: [sqlite] Concurrency

On 4/30/2012 5:10 PM, Sean Cui wrote: Here is a simple scenario to explain what the OP meant: Under WAL mode, In connection A, we issue SQL "UPDATE Employee SET Salary=0" to SQLite. While the command is executing, from another connection, we issue "SELECT Salary FROM Employee". In this

Re: [sqlite] Concurrency

Thanks very much for the replies. It'd be nice to have the online documentation of WAL mode updated to include the clarification of readers' visibility on uncommitted data. I think lot of developers will have the same question after reading the current doc of "...readers do not block writers