Edit MySQL content directly from text editor?

March 1, 2006 11:57 AM

I use Textpattern to manage my Web site. I really want to use my text editor to edit my templates.

This is how editing templates in Textpattern normally works:

1. Open template in the adminstration interface.


2. Select the contents of the textarea and Copy it.


3. Switch to text editor of choice


4. Paste template code into text editor


5. Edit template


6. Select the template code in the text editor and Copy it


7. Switch back to browser.


8. Paste template code into textarea.


9. Hit the submit button.

I want to be able to edit my templates directly from my text editor. Since the template code is stored in a database, this means there has to be some intermediary interface. My first thought was to somehow mount the textpattern database directly to the filesystem, perhaps using FUSE, but I can't figure out how to get that to work.

Any ideas?

posted by rossmeissl to computers & internet (2 comments total)

Something like ecto or mozex might work. The Saft plugin for Safari supposedly lets you edit textareas in an external editor.

You could also add an editor to TextPattern.

Textpattern WYSIWYG editor plugin, similar plugin, both use TinyMCE.

Another one that uses XStandard.

(If you're using a Mac, these will most likely work on Firefox but not Safari due to JavaScript compatibility.)
posted by kirkaracha at 12:54 PM on March 1, 2006

Would this help?

Also, you can use ecto with XML-RPC for Textpattern 4.0.
posted by clearlydemon at 1:02 PM on March 1, 2006