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

[Jonathan Schwartz]

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