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

[Bob Patin]

Well, that would work, although it would be best not to run FMU and  
OS X Server on the same machine.

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




> Thanks for your input.
>
> Now back to the details of this one particular client..
>
> If the solution stays in FMP 6 and stays in the client's office:
> 	- local FMP users would be served by Server 5.5 on server 1.
> 	- web users would be served by 6.0 Unlimited on a server 2.
> 	- OS X Server also on server 2 for web serving
> 	- Reliable WAN would need to be added.
> 	- Remote access (Timbuktu/ARD) would substitute onsite IT staff
>
> Do I have it right?  My head is into FMP 8.5 right now, and it's  
> hard to go back that far without my head hurting. ;-)
>
> Thanks,
>
>
> Jonathan
>
>
> At 10:27 PM -0500 9/22/06, Bob Patin wrote:
>> ... 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
>>
>> _______________________________________________
>> 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