Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-09-13 05:16:36
- TheEric
- Plugin Author
- From: Wyoming
- Registered: 2004-09-17
- Posts: 566
Staging Plugin
I just completed a plugin for a client that is installed on a staging site. The client makes all their changes to the staging site, and upon testing it and verifying it all works, they click on the “Push Live” button which copies the tables from that staging site, to the live site. It does requires two separate installs of TXP.
Would anyone be interested in this plugin if I were to make it public?
- Eric
Offline
Re: Staging Plugin
Eric,
Maybe I’m understanding it wrong but could this plugin also be used for design updates?
If so I think that it would be of great use for the community
Here’s the situation
Site v1, DB1
Site v2, DB1a
Site v2 uses the content from v1, DB1 but the presentation tables are used from DB1a. Once the design is finished the update button is clicked and DB1a is copied on DB1.
I understand that the plugin is doing more or less the opposite. right?
Last edited by colak (2009-09-13 05:47:42)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#3 2009-09-13 07:12:00
- FireFusion
- Member
- Registered: 2005-05-10
- Posts: 698
Re: Staging Plugin
Yes please!
Offline
#4 2009-09-13 07:15:29
- FireFusion
- Member
- Registered: 2005-05-10
- Posts: 698
Re: Staging Plugin
Btw, have you considered using the new multi-site feature for the staging area?
Offline
#5 2009-09-13 15:24:52
- TheEric
- Plugin Author
- From: Wyoming
- Registered: 2004-09-17
- Posts: 566
Re: Staging Plugin
It uses two separate installs. one at staging.domain.com, and the other at www.domain.com, and two completely separate databases. Upon clicking the “push live” button, itt can move content tables, or presentation tables, or plugin tables. If there’s enough interest, I’ll pretty up the plugin for public consumption.
Offline
#6 2009-09-13 17:02:00
- woof
- Member
- Registered: 2004-08-01
- Posts: 128
Re: Staging Plugin
Sounds very useful Eric.
+1
Offline
#7 2009-09-13 18:31:08
- TheEric
- Plugin Author
- From: Wyoming
- Registered: 2004-09-17
- Posts: 566
Re: Staging Plugin
@Colak
It can copy over everything from Content (Categories, Articles, Images, Files, Links) to Presentation (Sections, Pages, Forms, CSS) as well as Plugins. It’s a bit rough, but it’s definitely something that I’m thinking of building upon and releasing as a public plugin.
It does use two separate databases V1 would be the staging install, and V2 would be the live install. Both would be indentical, but major changes would first be done on the staging site, and once they’re approved, pushed live. I thought about using the multiple site feature of 4.2, but this client (and others similiar) needed something completely removed from the live site.
Offline
Re: Staging Plugin
hi eric,
sounds very cool. Can it work with the ‘staging’ install/db in local comp and the other one online?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#9 2009-09-13 19:18:24
- TheEric
- Plugin Author
- From: Wyoming
- Registered: 2004-09-17
- Posts: 566
Re: Staging Plugin
That would most likely not work, as generally databases are secured against any outside connections. Usually, though not always, they accept only connections from the internal network. Something similar could be built using a JSON interface that would accept connections from outside, but that’s beyond the scope of this particular plugin.
Offline
Re: Staging Plugin
Sounds great!
Some quick thoughts:
- Could you specify which tables are (and aren’t) copied across, in order to:
- avoid overwriting comments on the live site
- maintain different user tables to stop people accidentally updating the wrong site
- avoid conflicts with plugin licenses
- If you’re updating content tables like images/files, would you also need to manually update the file system?
Offline
Re: Staging Plugin
+1 yes please, sounds usefull
Offline
Re: Staging Plugin
pieman wrote:
** avoid conflicts with plugin licenses
All plugins are licensed as GPL.
Offline