What is the best method for a content creation and presentation application with JSF and Primefaces

[Steve Dev]

Hi ,

I create an web application that allows to create and present content as for the case of wiki. but the idea here is the users only view content, the content is created only by the administrator and presented in the web site.
The technique that I have currently adopted is to use a column of type "Text" in "Mysql" and to use a Text Editor to create the content in the website.

This works well even with images where we can create a content that contains images and display them afterwards.

Is this technique a good method to respond to this type of need ?
If not, what the other methods that can we use ?

Thanks

[Tim Holloway]

It's what I'd probably use, although I think I had problems with limitations on what options the PrimeFaces (rich) Text control offered. Can't remember, but I think it didn't do a good job of cut and paste.

TEXT is one of 4 different text options for a MySQL column definition. Good for most things, since it allows for up to 32767 or so characters (including format characters). You can also use MEDIUMTEXT or LONGTEXT if you need something bigger. In systems like JPA, all of them can map to CLOBs.

[Steve Dev]

There is another solution but which requires custom development, in fact it consists of saving the content generated by Text Editor into html file, then we visualize this html page using iframe for example. it seems to be more optimal but the first solution can be considered the fastest.

[Tim Holloway]

I don't understand what that means, but similar apps like WordPress save entries in databases as HTML CLOBS. An HTML text snippet can be easily displayed using the JSF outputText control.