X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 6F1F5310275; Fri, 27 Jun 2003 15:54:52 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 94053-08; Fri, 27 Jun 2003 12:54:42 -0300 (ADT) Received: from mail.ez3pl.com (66-136-75-131.ded.swbell.net [66.136.75.131]) by svr1.postgresql.org (Postfix) with ESMTP id 1E04F310210; Fri, 27 Jun 2003 12:54:41 -0300 (ADT) Received: from speedfc.com (djackson.espeedfulfillment.com [172.25.96.11]) by mail.ez3pl.com (8.11.2/8.11.2) with ESMTP id h5RFqi211156; Fri, 27 Jun 2003 10:52:45 -0500 Message-ID: <3EFC684F.1090605@speedfc.com> Date: Fri, 27 Jun 2003 10:52:47 -0500 From: DeJuan Jackson User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alvaro Herrera Cc: Tom Lane , Bruce Momjian , Josh Berkus , Joe Conway , "Advocacy (PostgreSQL)" , PostgreSQL-general Subject: Re: [GENERAL] interesting PHP/MySQL thread References: <200306222159.h5MLxT720807@candle.pha.pa.us> <15339.1056334760@sss.pgh.pa.us> <20030623032251.GA27826@dcc.uchile.cl> <16073.1056340630@sss.pgh.pa.us> <20030623044621.GA28777@dcc.uchile.cl> In-Reply-To: <20030623044621.GA28777@dcc.uchile.cl> Content-Type: multipart/alternative; boundary="------------000704000705080605040109" X-Archive-Number: 200306/293 X-Sequence-Number: 1505 This is a multi-part message in MIME format. --------------000704000705080605040109 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit From the SQLite FAQ Item (7) * (7) Can multiple applications or multiple instances of the same application access a single database file at the same time?* Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at once. Alvaro Herrera wrote: >Actually, I read the website right after I sent the email and I was... >"surprised." I am still wondering if it allows some kind of concurrent >access. > > > --------------000704000705080605040109 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit From the SQLite FAQ Item (7)

(7) Can multiple applications or multiple instances of the same application access a single database file at the same time?

Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at once.



Alvaro Herrera wrote:
Actually, I read the website right after I sent the email and I was...
"surprised."  I am still wondering if it allows some kind of concurrent
access.

  

--------------000704000705080605040109--