Hi Guys, I'm trying to separate out my system: development machine runs CF & PHP-based backends running MySQL,and the hope is to get both running Flex 2 front ends, with the occasional html-based front end (i.e., Ray Camden's Blog, LinPHA for a couple of friend's simple photo galleries, etc.). Mostly I want Flex front ends communicating through CF and sometimes PHP, all with MySQL (or MS Access when I'm lazy/building).
I'm half way there, have the development machine running and the pre- production server running, some stuff is talking fine, but I'm doing dumb things like, for example the MYSQL...Should I have that ONLY on the pre-production machine...and NOT on my development machine? I guess the question, at heart, is: should I be connecting my development machine to the server's database, or somehow 'mimicing' the databases? I saw, for example, with the ColdFusion/Flex Wizard, I can connect (RDS) directly to my data source ON the pre-production machine...is this model something I can do for all my work? I have Dreamweaver (last version, not CS3)...would that also simplify things? I'd like to be able to makee changes to my apps all on my development machine and push them over to the pre-production machine...and eventually from there over to my SuperMicro production machine (when it gets back from RMA). I'm running SVN/Tortoise/SubClipse and it seems to be running well...not doing it through Apache, seemed a bit too complex since I don't have multiple developers and all developement is on one machine. Nifty and I'll even use it for version my Photoshop files:) I guess the real core is: can I/should I connect ALL db-related things to the pre-production machine directly, or be mirroring them somehow by making duplicate versions on my development machine...cuz the latter is what I am trying right now and it doesn't really seem to be the right idea. Trying to build a very simple model: development machine, pre- production machine (with db's) which moves to production when the time is right (with the 'real' db's...i.e. live and open to the public). I realize this is way out of the areas usually discussed here, but I like and trust the responses around here...they've always been helpful. ps hope all you Canadians out there had a good May two-four:) Shawn
