[FX.php List] Two DB's or One?

[Bob Patin]

... a single database... :)

I have quite a few clients who have shopping carts, and they use the  
same cart database for tracking customers, mailing lists, etc. I also  
have other clients who use their membership databases in their  
office, and also on their websites...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060


On Sep 22, 2006, at 9:43 PM, Jonathan Schwartz wrote:

> Err....do which?  Use a single DB or two separate DB's?
>
> J
>
>
> At 8:58 PM -0500 9/22/06, Bob Patin wrote:
>> Jonathan,
>>
>> I do it all the time with almost every client who has a web  
>> database...
>>
>> Bob Patin
>> Longterm Solutions
>> bob at longtermsolutions.com
>> 615-333-6858
>> http://www.longtermsolutions.com
>>
>>   CONTACT US VIA INSTANT MESSAGING:
>>      AIM or iChat: longterm1954
>>      Yahoo: longterm_solutions
>>      MSN: tech at longtermsolutions.com
>>      ICQ: 159333060
>>
>>
>> On Sep 22, 2006, at 8:55 PM, Jonathan Schwartz wrote:
>>
>>> Up until now, all my fx.php solutions have been built around an  
>>> isolated FMP database to serve the web.  When there is a primary  
>>> db back at the client, I use various routines to update and synch  
>>> the two, as needed. Obviously, none of the solutions required  
>>> live up-to-the-second data availability on the web.
>>>
>>> I'm wondering how many folks are using the same db for both  
>>> internal and web publishing?  If so, how is it working out?  If  
>>> not, why not?
>>>
>>> A little bit more detail...if the client isn't sophisticated,  
>>> doesn't have an IT staff or a fast WAN connection, this would  
>>> suggest to me *not* to keep the web db at the client office.   
>>> Rather, keep the web db at a reliable web host.
>>>
>>> One more detail.  I promise. ;-)....If the solution is in FMP 6,  
>>> that would pretty much rule putting the entire solution in a  
>>> remote hosting location, because FMP is so poor in a WAn  
>>> environment.
>>>
>>> Thoughts?
>>>
>>> Jonathan
>>> --
>>>
>>> Jonathan Schwartz
>>> FileMaker 8 Certified  Developer
>>> Associate Member, FileMaker Solutions Alliance
>>> Schwartz & Company
>>> jonathan at eschwartz.com
>>> http://www.eschwartz.com
>>> http://www.exit445.com
>>> 415-381-1852
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> -- 
>
> Jonathan Schwartz
> FileMaker 8 Certified  Developer
> Associate Member, FileMaker Solutions Alliance
> Schwartz & Company
> jonathan at eschwartz.com
> http://www.eschwartz.com
> http://www.exit445.com
> 415-381-1852
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list