Skip to main content
WordPress Development

Return to Question

Tweeted twitter.com/#!/StackWordPress/status/90352472849256448
added #4
Source Link
TMC
TMC
  • 141
  • 1
  • 3

I have user generated content that is created in a mobile app that is written to a SQL Database.

I'd like to create a new site that allows this content to be viewed on a per user basis. So if I go to

http://foo.com/user/TMC

It'll show all the content I've created in the mobile app. i want to use wordpress to eliminate the need to recreated my own content publishing engine and get the benefits of all of the wordpress ecosystem with plugins, templates, etc. Even basic things like "search" are free vs. needing to build it myself if I roll my own content publishing system.

To accomplish this, I think I need to:

  1. Be able to programmatically create wordpress posts. I want code running on another server (e.g. Google App engine) to call onto my server hosting wordpress (e.g. regular shared hosting) and create a blog post for each time a user saves new content in my mobile app. In order to do this there needs to be an web service to do this or I write directly to the DB?

  2. Be able to programmatically edit the blog post once it's saved, if the user edits the content in my mobile app. Same need for a web serices

  3. Need to be able to have unique URLs for each user of my mobile app and show only their blog posts, but it's still all part of the same instance of wordpress. So http://foo.com/users/UserA vs. http://foo.com/users/UserB. Both on same blog, each URL will show a filtered view of posts only done by that user.

  4. I need to create real or fake user accounts. Since the content is really in my mobile app, my users have accounts with me and stored in SQL. So when I push the content to Wordpress to create the content, it's not really the user that is doing it. So if I wanted to push content for userA and userB, how would the user accounts get created? Or should I overload the use of tags and say set a tag as user=UserA then when I need to accomplish what I describe in #3 above, I just use /tags/user=UserA? (I'm clearly open to suggestions)

Is what I need even remotely possible or am I on drugs?

I have user generated content that is created in a mobile app that is written to a SQL Database.

I'd like to create a new site that allows this content to be viewed on a per user basis. So if I go to

http://foo.com/user/TMC

It'll show all the content I've created in the mobile app. i want to use wordpress to eliminate the need to recreated my own content publishing engine and get the benefits of all of the wordpress ecosystem with plugins, templates, etc. Even basic things like "search" are free vs. needing to build it myself if I roll my own content publishing system.

To accomplish this, I think I need to:

  1. Be able to programmatically create wordpress posts. I want code running on another server (e.g. Google App engine) to call onto my server hosting wordpress (e.g. regular shared hosting) and create a blog post for each time a user saves new content in my mobile app. In order to do this there needs to be an web service to do this or I write directly to the DB?

  2. Be able to programmatically edit the blog post once it's saved, if the user edits the content in my mobile app. Same need for a web serices

  3. Need to be able to have unique URLs for each user of my mobile app and show only their blog posts, but it's still all part of the same instance of wordpress. So http://foo.com/users/UserA vs. http://foo.com/users/UserB. Both on same blog, each URL will show a filtered view of posts only done by that user.

Is what I need even remotely possible or am I on drugs?

I have user generated content that is created in a mobile app that is written to a SQL Database.

I'd like to create a new site that allows this content to be viewed on a per user basis. So if I go to

http://foo.com/user/TMC

It'll show all the content I've created in the mobile app. i want to use wordpress to eliminate the need to recreated my own content publishing engine and get the benefits of all of the wordpress ecosystem with plugins, templates, etc. Even basic things like "search" are free vs. needing to build it myself if I roll my own content publishing system.

To accomplish this, I think I need to:

  1. Be able to programmatically create wordpress posts. I want code running on another server (e.g. Google App engine) to call onto my server hosting wordpress (e.g. regular shared hosting) and create a blog post for each time a user saves new content in my mobile app. In order to do this there needs to be an web service to do this or I write directly to the DB?

  2. Be able to programmatically edit the blog post once it's saved, if the user edits the content in my mobile app. Same need for a web serices

  3. Need to be able to have unique URLs for each user of my mobile app and show only their blog posts, but it's still all part of the same instance of wordpress. So http://foo.com/users/UserA vs. http://foo.com/users/UserB. Both on same blog, each URL will show a filtered view of posts only done by that user.

  4. I need to create real or fake user accounts. Since the content is really in my mobile app, my users have accounts with me and stored in SQL. So when I push the content to Wordpress to create the content, it's not really the user that is doing it. So if I wanted to push content for userA and userB, how would the user accounts get created? Or should I overload the use of tags and say set a tag as user=UserA then when I need to accomplish what I describe in #3 above, I just use /tags/user=UserA? (I'm clearly open to suggestions)

Is what I need even remotely possible or am I on drugs?

Source Link
TMC
TMC
  • 141
  • 1
  • 3

Possible to use wordpress as publishing platform but programmatically inject content?

I have user generated content that is created in a mobile app that is written to a SQL Database.

I'd like to create a new site that allows this content to be viewed on a per user basis. So if I go to

http://foo.com/user/TMC

It'll show all the content I've created in the mobile app. i want to use wordpress to eliminate the need to recreated my own content publishing engine and get the benefits of all of the wordpress ecosystem with plugins, templates, etc. Even basic things like "search" are free vs. needing to build it myself if I roll my own content publishing system.

To accomplish this, I think I need to:

  1. Be able to programmatically create wordpress posts. I want code running on another server (e.g. Google App engine) to call onto my server hosting wordpress (e.g. regular shared hosting) and create a blog post for each time a user saves new content in my mobile app. In order to do this there needs to be an web service to do this or I write directly to the DB?

  2. Be able to programmatically edit the blog post once it's saved, if the user edits the content in my mobile app. Same need for a web serices

  3. Need to be able to have unique URLs for each user of my mobile app and show only their blog posts, but it's still all part of the same instance of wordpress. So http://foo.com/users/UserA vs. http://foo.com/users/UserB. Both on same blog, each URL will show a filtered view of posts only done by that user.

Is what I need even remotely possible or am I on drugs?