Re: PostgreSQL locking from PHP scripts

Herbie McDuck wrote:
>> Also, web connections are stateless and there is no way to even know
>> what web server process or database connection you'll be getting on
>> subsequent page views.
>>
> So is PHP and 'ANY' database a useless adventure when it goes to
> developing a robust business and accounting package?

Not at all.  It just means that you'll have to create your own "state"
logic using sessions.  For instance, create a column within the
necessary table that you can check to see whether or not some other
process/user is using the record in question and then build the
necessary logic around that to enable/disable access to the records.

This is something that isn't specific to PHP.  You'll encounter the same
issues with any other middleware language that uses a web browser as
it's primary means of interaction.  HTTP just doesn't keep track of the
state of your application.  It's up to you as the developer to handle that.

Charley