Content management system using backend database

**Michael Austin** · Jul 17 '05, 06:36 AM

Re: Content management system using backend database

Scott wrote:
[color=blue]
> Hi,
>
> Can I ask some advice in regards database solutions and content management
> solutions.? Do you have a philosophy on what is the best for databases -
> ASP, JSP, Cold fusion, PHP, etc. My company website site is going to be
> rebuilt and I am the lucky one to do this but I am unsure of the needs and
> complexity of the project, and what would be the best base code. Do you
> have any thoughts in this area? The site requires functionality like display
> projects, archive projects, sort projects by date, project location, group
> company, etc. All images and pdfs are currently uploaded through the
> content management solution, however we will have to implement a new content
> management solution as well. Do you know of an easy to use product that
> functionally work well in content management? Do you know of any products
> on the market that are like WYSIWYG database solutions?
>
> Thanks!
>
> P.S.: I've tried to best guess which newsgroups apply. Apologies if I've
> gotten it wrong - if you know of any other appropriate newsgroups, please
> let me know.
>
>[/color]

If you want to continually have to take your site down to apply the
latest MS patch, then consider ASP or .NET. I would never bet my
business on it!!! The TOC can be way too high if your site is the
"bread and butter" of the company... YMMV..

My prefs -- in this order:

Apache/PHP/OracleRdb on OpenVMS -- just try and hack it.. and with real
clusters - not those fake ones by M$ and all of the unix deriviatives...
hmmmm... 20 years and counting - and noone has yet to come close to the
capabilities of an OpenVMS cluster. Period!!!!
Apache/cgi/Oracle on OpenVMS
OSU/cgi/OracleRdb or Oracle9
Apache/PHP/Oracle on Unix or Linux.
.... 25 bazillion other choices
IIS/.NET-.ASP/SQL Server if I really had to...

Yeah M$ works, but too many companies have been crippled when their
server gets hacked by the latest script-kiddie.

Michael Austin
http://www.firstdbasource.com !! Apache On OpenVMS
http://www.firstdbasource.com/t4/t4chart.php !!with PHP, Rdb and Mysql.

**Roedy Green** · Jul 17 '05, 06:36 AM

Re: Content management system using backend database

On Tue, 22 Jun 2004 10:46:30 +1000, "Scott" <foo_yahoo_com_ au> wrote
or quoted :
[color=blue]
>ASP, JSP, Cold fusion, PHP, etc.[/color]

There are tools that work well for small projects and fall apart as
the project grows. There are also complicated tools that will have
you scratching your head for months to write HelloWorld.

Like shoes for a small child, you have to choose ones slightly too big
and grow into them.

Tools strictly for small projects include PHP, MySQL.

Tools strictly for large projects include EJB and Oracle.

In the middle are tools like JSP and JSF.

If your project is going to have to last for a decade, you want to
pick generic tools with many implementations like Servlets. If you use
something very proprietary like Delphi, FreeMarker or Flash, you may
have an easy time getting started, but you are at the mercy of that
team to keep the project going. For big companies, open source is a
nice cushion. If the team fails, you could potentially take it over
yourself. Even for small companies, open source leave the option of
someone else taking over an abandoned project.

You could scan the web to see who is doing stuff similar to what you
are doing, and ask them what they used and what they would do if they
had it to do over again. Ask them what they like most and least about
their approach. See what applies most to you.

You might even approach a magazine to turn your survey into an article
and to give some incentive for the users to talk.

see http://mindprod.com/jgloss/magazine.html

One thing I learned is every tool has its areas it drives you nuts.
When you look for a new tool, you look primarily for one that fixes
the mistakes of your old tool. You forget the new tool may fall down
in areas your old one was fine. Pay attention to what people complain
about. That is what will bother you too.

--
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.

**-P-** · Jul 17 '05, 06:37 AM

Re: Content management system using backend database

Take a look at Rhythmyx. www.percussion.com

Paul Horan
Sr. Architect VCI
Springfield, Mass

"Scott" <foo_yahoo_com_ au> wrote in message news:40d78166$0 $9458$5a62ac22@ per-qv1-newsreader-01.iinet.net.au ...[color=blue]
> Hi,
>
> Can I ask some advice in regards database solutions and content management
> solutions.? Do you have a philosophy on what is the best for databases -
> ASP, JSP, Cold fusion, PHP, etc. My company website site is going to be
> rebuilt and I am the lucky one to do this but I am unsure of the needs and
> complexity of the project, and what would be the best base code. Do you
> have any thoughts in this area? The site requires functionality like display
> projects, archive projects, sort projects by date, project location, group
> company, etc. All images and pdfs are currently uploaded through the
> content management solution, however we will have to implement a new content
> management solution as well. Do you know of an easy to use product that
> functionally work well in content management? Do you know of any products
> on the market that are like WYSIWYG database solutions?
>
> Thanks!
>
> P.S.: I've tried to best guess which newsgroups apply. Apologies if I've
> gotten it wrong - if you know of any other appropriate newsgroups, please
> let me know.
>
>[/color]

**Michael Austin** · Jul 17 '05, 06:37 AM

Re: Content management system using backend database

Scott wrote:[color=blue]
> Hi,
>
> Can I ask some advice in regards database solutions and content management
> solutions.? Do you have a philosophy on what is the best for databases -
> ASP, JSP, Cold fusion, PHP, etc. My company website site is going to be
> rebuilt and I am the lucky one to do this but I am unsure of the needs and
> complexity of the project, and what would be the best base code. Do you
> have any thoughts in this area? The site requires functionality like display
> projects, archive projects, sort projects by date, project location, group
> company, etc. All images and pdfs are currently uploaded through the
> content management solution, however we will have to implement a new content
> management solution as well. Do you know of an easy to use product that
> functionally work well in content management? Do you know of any products
> on the market that are like WYSIWYG database solutions?
>
> Thanks!
>
> P.S.: I've tried to best guess which newsgroups apply. Apologies if I've
> gotten it wrong - if you know of any other appropriate newsgroups, please
> let me know.
>
>[/color]

Above all, you want to make sure it is transportable across multiple
platforms. Just in case that windoze system is too smal/buggy...

**Jeff Cochran** · Jul 17 '05, 06:37 AM

Re: Content management system using backend database

>Can I ask some advice in regards database solutions and content management[color=blue]
>solutions.?[/color]

In the appropriate forums, yes. But now that you crossposted to a
bunch of language forums, you'll start a flame war about whose
language is best.
[color=blue]
> Do you have a philosophy on what is the best for databases -
>ASP, JSP, Cold fusion, PHP, etc.[/color]

Sure. None of the above. None are databases, so none are relevant to
programming a database.
[color=blue]
> My company website site is going to be
>rebuilt and I am the lucky one to do this but I am unsure of the needs and
>complexity of the project, and what would be the best base code. Do you
>have any thoughts in this area?[/color]

Yes. You're way too inexperienced to even attempt this decision so
hire an outside service.
[color=blue]
>The site requires functionality like display
>projects, archive projects, sort projects by date, project location, group
>company, etc. All images and pdfs are currently uploaded through the
>content management solution, however we will have to implement a new content
>management solution as well. Do you know of an easy to use product that
>functionally work well in content management?[/color]

There's a great list here:

content management system - Google Search

http://www.google.com/search?hl=en&ie=UTF-8&q=content+management+system

[color=blue]
> Do you know of any products
>on the market that are like WYSIWYG database solutions?[/color]

Databases are never WYSIWYG so the answer to your question is no.
[color=blue]
>P.S.: I've tried to best guess which newsgroups apply. Apologies if I've
>gotten it wrong - if you know of any other appropriate newsgroups, please
>let me know.[/color]

The comp.infosystem s heirarchy has a few options you missed.

And for the record, no responsible programmer ever asks "I have a
project to do, what language should I code it in?" Nor would they
mistake a front end client application for a database. Buy a canned
product or hire an outside service.

Jeff

**Michael Austin** · Jul 17 '05, 06:37 AM

Re: Content management system using backend database

Jeff Cochran wrote:
[color=blue][color=green]
>>Can I ask some advice in regards database solutions and content management
>>solutions.?[/color]
>
>
> In the appropriate forums, yes. But now that you crossposted to a
> bunch of language forums, you'll start a flame war about whose
> language is best.
>
>[color=green]
>>Do you have a philosophy on what is the best for databases -
>>ASP, JSP, Cold fusion, PHP, etc.[/color]
>
>
> Sure. None of the above. None are databases, so none are relevant to
> programming a database.
>
>[color=green]
>>My company website site is going to be
>>rebuilt and I am the lucky one to do this but I am unsure of the needs and
>>complexity of the project, and what would be the best base code. Do you
>>have any thoughts in this area?[/color]
>
>
> Yes. You're way too inexperienced to even attempt this decision so
> hire an outside service.
>
>[color=green]
>>The site requires functionality like display
>>projects, archive projects, sort projects by date, project location, group
>>company, etc. All images and pdfs are currently uploaded through the
>>content management solution, however we will have to implement a new content
>>management solution as well. Do you know of an easy to use product that
>>functionall y work well in content management?[/color]
>
>
> There's a great list here:
>
> http://www.google.com/search?hl=en&i...agement+system
>
>
>[color=green]
>>Do you know of any products
>>on the market that are like WYSIWYG database solutions?[/color]
>
>
> Databases are never WYSIWYG so the answer to your question is no.
>
>[color=green]
>>P.S.: I've tried to best guess which newsgroups apply. Apologies if I've
>>gotten it wrong - if you know of any other appropriate newsgroups, please
>>let me know.[/color]
>
>
> The comp.infosystem s heirarchy has a few options you missed.
>
> And for the record, no responsible programmer ever asks "I have a
> project to do, what language should I code it in?" Nor would they
> mistake a front end client application for a database. Buy a canned
> product or hire an outside service.
>
> Jeff[/color]

and to top it all off - real programmers, dba's and sys admins can't get
a job because of the willingness of companies to hire people who don't
know what they are doing (like this person)just to save a buck - only it
cost them a fortune to bring someone in later to redo the mess guys like
this usally cause...

M.
Sr. DBA and System Admin looking for work.

**Noel** · Jul 17 '05, 06:37 AM

Re: Content management system using backend database

On Tue, 22 Jun 2004 01:50:13 GMT, Michael Austin
<maustin@firstd basource.com> wrote:
[color=blue]
>Apache/PHP/Oracle on Unix or Linux.
>... 25 bazillion other choices[/color]

Including Apache/PHP/Firebird. A completely free solution.

**Noel** · Jul 17 '05, 06:38 AM

Re: Content management system using backend database

On Tue, 22 Jun 2004 15:17:17 GMT, Michael Austin
<maustin@firstd basource.com> wrote:

[color=blue]
>and to top it all off - real programmers, dba's and sys admins can't get
>a job because of the willingness of companies to hire people who don't
>know what they are doing (like this person)just to save a buck - only it
>cost them a fortune to bring someone in later to redo the mess guys like
>this usally cause...[/color]

Yup, it seems everybody is looking for people to fill 'junior' posts.
As a freelancer I charge far more to sort out the mess left by someone
else than I would to build a system from scratch.

**Chung Leong** · Jul 17 '05, 06:38 AM

Re: Content management system using backend database

> Can I ask some advice in regards database solutions and content management[color=blue]
> solutions.? Do you have a philosophy on what is the best for databases -
> ASP, JSP, Cold fusion, PHP, etc. My company website site is going to be
> rebuilt and I am the lucky one to do this but I am unsure of the needs and
> complexity of the project, and what would be the best base code. Do you
> have any thoughts in this area? The site requires functionality like[/color]
display[color=blue]
> projects, archive projects, sort projects by date, project location, group
> company, etc. All images and pdfs are currently uploaded through the
> content management solution, however we will have to implement a new[/color]
content[color=blue]
> management solution as well. Do you know of an easy to use product that
> functionally work well in content management? Do you know of any products
> on the market that are like WYSIWYG database solutions?[/color]

PHP CMSes are a dime a dozen, so I would recommend looking into that. Go to
www.sourceforge.net and do a search on "CMS". Most support different DB
software so you can choose which to use depending on your needs.

MS SQLServer is probably as close to "WYSIWYG" as you get can. In Enterprise
Manager you can create queries by joining tables via a drag-and-drop
interface. Database constraints can be created in the same manner. There are
wizards to guide you through tasks like backup and restore. My favorite
feature is the diagram tool, which allows you to quickly generate impressive
looking database diagrams that would awe your manager (but is otherwise
completely useless). Rather pricey compared to open source databases, but
beats hiring a DBA. Highly recommended.

Hosting on Windows is of course not an ideal solution from a security point
of view. It's reasonably safe though if you protect it with an industrial
strength firewall cum intrusion detection system. Set you back a few grands
but cheaper than hiring a Unix admin.

**Doug Hutcheson** · Jul 17 '05, 06:38 AM

Re: Content management system using backend database

"Noel" <no.spam@thank. you> wrote in message
news:v1qgd0ttpo cjoqpk6nk3ckb9b 6sim0euum@4ax.c om...[color=blue]
> On Tue, 22 Jun 2004 15:17:17 GMT, Michael Austin
> <maustin@firstd basource.com> wrote:
>
>[color=green]
> >and to top it all off - real programmers, dba's and sys admins can't get
> >a job because of the willingness of companies to hire people who don't
> >know what they are doing (like this person)just to save a buck - only it
> >cost them a fortune to bring someone in later to redo the mess guys like
> >this usally cause...[/color]
>
> Yup, it seems everybody is looking for people to fill 'junior' posts.
> As a freelancer I charge far more to sort out the mess left by someone
> else than I would to build a system from scratch.
>
>[/color]

Back in 1974, I grinned at the sign over my IT Manager's desk:
"We never have the time or money to do it right, but we always find the time
and money to do it again."

In 2004, the joke is getting a little thin, because nothing ever changes.

--
Remove the blots from my address to reply

**Scott** · Jul 17 '05, 06:38 AM

Re: Content management system using backend database

ACTUALLY...I was asked these questions by a friend. I pretty much
cut-and-pasted his questions into my post. Knowing that *I* wasn't
experienced in this area of IT, but also knowing that my friend wouldn't
think to try Usenet, I thought I'd post on his behalf. Personally I would
have told him to hire a consultant rather than ask me, but thought I'd do
what I could to try to help.

Unfortunately, it's digressed off topic into an opportunity to display some
rather large chips on one's shoulders. The first couple posts were somewhat
helpful; the last few have been fucking useless.

Sorry Michael that you're out of work...nah, actually I couldn't care
less...

"Doug Hutcheson" <doug.blot.hutc heson@nrm.blot. qld.blot.gov.bl ot.au> wrote
in message news:rP3Cc.172$ ze3.8188@news.o ptus.net.au...[color=blue]
> "Noel" <no.spam@thank. you> wrote in message
> news:v1qgd0ttpo cjoqpk6nk3ckb9b 6sim0euum@4ax.c om...[color=green]
> > On Tue, 22 Jun 2004 15:17:17 GMT, Michael Austin
> > <maustin@firstd basource.com> wrote:
> >
> >[color=darkred]
> > >and to top it all off - real programmers, dba's and sys admins can't[/color][/color][/color]
get[color=blue][color=green][color=darkred]
> > >a job because of the willingness of companies to hire people who don't
> > >know what they are doing (like this person)just to save a buck - only[/color][/color][/color]
it[color=blue][color=green][color=darkred]
> > >cost them a fortune to bring someone in later to redo the mess guys[/color][/color][/color]
like[color=blue][color=green][color=darkred]
> > >this usally cause...[/color]
> >
> > Yup, it seems everybody is looking for people to fill 'junior' posts.
> > As a freelancer I charge far more to sort out the mess left by someone
> > else than I would to build a system from scratch.
> >
> >[/color]
>
>
> Back in 1974, I grinned at the sign over my IT Manager's desk:
> "We never have the time or money to do it right, but we always find the[/color]
time[color=blue]
> and money to do it again."
>
> In 2004, the joke is getting a little thin, because nothing ever changes.
>
> --
> Remove the blots from my address to reply
>
>[/color]

**Gene Wirchenko** · Jul 17 '05, 06:38 AM

Re: Content management system using backend database

"Scott" <foo> wrote:
[color=blue]
>ACTUALLY...I was asked these questions by a friend. I pretty much
>cut-and-pasted his questions into my post. Knowing that *I* wasn't
>experienced in this area of IT, but also knowing that my friend wouldn't
>think to try Usenet, I thought I'd post on his behalf. Personally I would
>have told him to hire a consultant rather than ask me, but thought I'd do
>what I could to try to help.
>
>Unfortunatel y, it's digressed off topic into an opportunity to display some
>rather large chips on one's shoulders. The first couple posts were somewhat
>helpful; the last few have been fucking useless.[/color]

They have been the most accurate.

I had an opportunity to clean up one system that had "just
growed". I proposed that the first thing be done was basic
documenting. I did not get the work; the owner wanted someone "who
could just jump in".

What? Without evaluating what is there?

With that lack of understanding of how software is developed, it
is no wonder that there are many messed-up systems.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

**Noel** · Jul 17 '05, 06:39 AM

Re: Content management system using backend database

On Wed, 23 Jun 2004 12:13:13 +1000, "Scott" <foo> wrote:
[color=blue]
>Unfortunatel y, it's digressed off topic into an opportunity to display some
>rather large chips on one's shoulders. The first couple posts were somewhat
>helpful; the last few have been fucking useless.[/color]

They are not chips on shoulders, but rather perennial issues that
never seem to go away. In order to be done properly, such work should
always be done by people qualified to do it. I'm sorry if you think
this 'fucking useless', but these newsgroups are not your personal
consultancy service.
[color=blue]
>Sorry Michael that you're out of work...nah, actually I couldn't care
>less...[/color]

That speaks volumes, really it does.

**Laconic2** · Jul 17 '05, 06:39 AM

Re: Content management system using backend database

"Noel" <no.spam@thank. you> wrote in message
news:o8fid01v93 202qt6dfl47khjc 38f5i3sd9@4ax.c om...
[color=blue]
> these newsgroups are not your personal
> consultancy service.
>[color=green]
> >Sorry Michael that you're out of work...nah, actually I couldn't care
> >less...[/color]
>
> That speaks volumes, really it does.[/color]

This give me an idea. How about if people who have work, but don't know how
to do it were to PAY people who know how to do it but are out of work for
their help, instead of asking for it for free.

That way Michael could get some some for his knowledge and the questioner
could get more useful responses.

Content management system using backend database

Content management system using backend database

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment