|
| |
|
|
DaveX
Posts: 207
Joined: 5/4/2004
Status: offline
 |
Filemaker, MySQL and huh? - 3/3/2008 21:35:37
I've digging and posting around a bit here on the is subject but not in this section yet. I wanted to be sure about what I was asking first! Here it is: I have no experience with databases other than using a commerce site built with a template that uses a built-in db.
I've started working with someone on a site that will hold a lot of video and pictures. The person I'm doing it for has recently decided he wants to implement a database. Furthermore he wants to use Filemaker Pro. Also, he wants me to build it in Dreamweaver although I've never used it. The Dreamweaver part doesn't scare me so much as I've used FP for years. What I'm wondering is is this all plausible? From what I understand, you need SQL even if you do use Filemaker. He wants to use FM and DW so he can do updates himself. I'm a bit confused as to how FM and SQL work together and, how the web pages interact with the db. Can anyone point me to a resource that will give me a good, cursory explanation and perhaps more? I'm looking for a good place to start here. Thanks, as usual!
|
|
|
|
dpf
Posts: 7121
Joined: 11/12/2003
From: India-napolis
Status: offline
|
RE: Filemaker, MySQL and huh? - 3/4/2008 6:46:10
I would be concerned about him saying he wants FP cause he wants to update it himself. sounds like he envisions having the db on his machine and updating it. once you put the db on the web, it gets updates from web (isnt that the whole point?) to do what he suggests means download a copy, modify it and then upload - danger danger....while it is in his possession, what if someone updates the db on the web? now the copies are different and when he uploads his, it will overwrite and lose that data- make sense?
you put a db on the seb for a reason - usually to update it via the pages/forms. it is common to also make private admin pages where the admin can update while it is on the web not downloaded. in doing that, he wouldnt be updating it via his normal forms and comfort zone.
the demand that it be built in DW is also hinting at something but im not sure what. I am a 100% DW fan but to the person contracting to build a site, the results and not the tool should be an issue. have a long chat and find out WHY he is so adamant about those choices. I dont know FP but seems you would be better off with more main stream like SQL or MySQL
FWIW
_____________________________
Dan
| |
|
|
|
DaveX
Posts: 207
Joined: 5/4/2004
Status: offline
|
RE: Filemaker, MySQL and huh? - 3/4/2008 22:22:04
Believe me, I know what you mean. He knows Filemaker and has used it for years which is why he wants to use it. Now, as far as how it's being used. The site viewer won't be inputting anything other than search terms. All we want it for is so that people can search for videos or pictures that are tagged. Just like YouTube. Is there a better solution?
As far as Dreamweaver goes, I don't think he would be changing much other than text here and there although I will try to get more detail from him. The upside is that he will buy me a copy of it. Which is good.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
