1 person found this helpful
Can I link a DW created site to an EXTERNAL SQL Express database for read/write?
DW is an HTML/CSS editor, so it doesn't really have anything to do with database connections you use. What programming language are you going to use for your database interactions?
Can it be made secure
Your website security has nothing to do with DW.
Am considering using Contribute to allow non-technical end users to change sections
In theory, yes, you can do this. In practice you may find Contribute clunky and limiting.
1 person found this helpful
To follow-up a bit on Rob's reply, no version of Contribute has complete support on Win 10, Mavericks or Yosemite operating systems. Some people tolerate the deficiencies with workarounds. Suffice it to say, El Capitan would probably be no different and might be much worse. IMO, Contribute's days are numbered.
Most web developers offer their code challenged employees / clients a CMS (browser-based content management system). It makes more sense because the CMS resides on the client's server so people are not tethered to outdated software. The CMS can be accessed from anywhere by logging in through a browser with an internet connection.
If you're not up to coding a custom CMS, there are some commercial solutions you could try.
Perch ($59 license per site)
PHP & MySql required
Adobe Business Catalyst (subscription includes CMS & hosting)
Thank you.. I really don't know which programming language... I've been developing software for about 40 years so I will learn something new... sigh... I used DW 10 years ago with Cold Fusion... but I am told that CF is going out of style... I assume that CF can link to an external SQL DB. Do you have any recommendations... I am struggling with the architecture plan.
As for use of Contribute... if it isn't a great choice, I would like a few ideas. Nancy O has suggested a few. I will do some research. Any other ideas? Thank you
I would like a few ideas.
A CMS of some sort is the industry standard solution these days. The most common environment is LAMP (LINUX, Apache, MySQL, PHP).
Some of us write custom CMS systems for a living. I focus on CMS's for retreat centers. There are all kinds of available CMS solutions ranging from general purpose, off-the-shelf CMS's like WordPress, to completely custom, with a lot of possibilities in between.
1 person found this helpful
Develop a plan. Figure out what functionality your employees require to maintain the site in a CMS. As Rob says, they come big and small & everything in between. Bigger is not always better unless you really need it.
Really appreciate the help... am leaning towards DW and Cold Fusion with link to SQL Express... I know php is much more common, but I need the features of SQL Server that just don't seem to exist in MySQL... anyway... as far as CMS solutions... all I need my end users to be able to do is change the content of one rectangular box in the middle of the website with their own content... Text, Pictures, Links. Nothing complicated... all the CMS solutions I have researched are either PHP MySQL, create entire website with their system, Host on their servers, etc, etc... All I need is to let my users change one small section of the website and do this easily...my latest thoughts are to use a simple Iframe... iframe src="Text.html"style="width: 100%; height: 100%"></iframe> and let the user create a Word Doc ans save as html... and then FTP to the site. As soon as the new Text.html file is uploaded, the web site user area changes. Opinions?
I think an iframe is a bad idea for a lot of reasons. And Word is just in invitation for problems later when they introduce a bunch of MS Word junk into your files. Cringe. Don't go there if you can avoid it.
Why not give them a server-side include (plain text file) to edit with CK Editor?
OK... thank you. I will look at CKEditor
OK. So you just need a single box of content from each client. In that case, the right solution depends on a few things, including:
- how many clients (10 or 10,000?)
- what the clients expect. Do they expect to be able to directly edit the content?
- How often the content changes.
(these are question for you to consider. We don't necessarily need to know)
You must be able to reject content that is wrong, such as wrong file types.
You also have to provide a log-in system with separate username/password for each client. They will lose the password or the employee who has the password will get fired, so you have to provide a mechanism for them to reacquire a password.
My CMS has security, ease of use, complete log-in system, and nice WYSIWYG input forms, but that's because the clients have staff working on their websites every day, so all the work of creating the client editing system was worth it. The necessary features for client editing may not be justified if all you need is a single box of content. Maybe a simple alternative would be to allow them to email you the content
Looked at CKEditor... will probably do what I want. Thank you... only problem is that site is hosted by a third party outside my clients office... only way to get at it (I think) is thru FTP. Is there a way to make CKEditor work under those circumstances? Thank you.
No, CKeditor won't work with FTP. It uses HTTP.
CKeditor gives you a nice little box for clients to format content in, but that's all it does. You have to wrap it in a secure environment and sanitize the content added to it.