473,769 Members | 1,730 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Content management system using backend database

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.
Jul 17 '05 #1
17 3200
Scott wrote:
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.


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.
Jul 17 '05 #2
On Tue, 22 Jun 2004 10:46:30 +1000, "Scott" <foo_yahoo_com_ au> wrote
or quoted :
ASP, JSP, Cold fusion, PHP, etc.


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.
Jul 17 '05 #3
-P-
Take a look at Rhythmyx. www.percussion.com

Paul Horan
Sr. Architect VCI
Springfield, Mass

"Scott" <foo_yahoo_com_ au> wrote in message news:40******** **************@ per-qv1-newsreader-01.iinet.net.au ...
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.

Jul 17 '05 #4
Scott wrote:
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.


Above all, you want to make sure it is transportable across multiple
platforms. Just in case that windoze system is too smal/buggy...
Jul 17 '05 #5
>Can I ask some advice in regards database solutions and content management
solutions.?
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.
Do you have a philosophy on what is the best for databases -
ASP, JSP, Cold fusion, PHP, etc.
Sure. None of the above. None are databases, so none are relevant to
programming a database.
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?
Yes. You're way too inexperienced to even attempt this decision so
hire an outside service.
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?
There's a great list here:

http://www.google.com/search?hl=en&i...agement+system

Do you know of any products
on the market that are like WYSIWYG database solutions?
Databases are never WYSIWYG so the answer to your question is no.
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.


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
Jul 17 '05 #6
Jeff Cochran wrote:
Can I ask some advice in regards database solutions and content management
solutions.?

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.

Do you have a philosophy on what is the best for databases -
ASP, JSP, Cold fusion, PHP, etc.

Sure. None of the above. None are databases, so none are relevant to
programming a database.

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?

Yes. You're way too inexperienced to even attempt this decision so
hire an outside service.

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?

There's a great list here:

http://www.google.com/search?hl=en&i...agement+system
Do you know of any products
on the market that are like WYSIWYG database solutions?

Databases are never WYSIWYG so the answer to your question is no.

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.

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


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.
Jul 17 '05 #7
On Tue, 22 Jun 2004 01:50:13 GMT, Michael Austin
<ma*****@firstd basource.com> wrote:
Apache/PHP/Oracle on Unix or Linux.
... 25 bazillion other choices


Including Apache/PHP/Firebird. A completely free solution.
Jul 17 '05 #8
On Tue, 22 Jun 2004 15:17:17 GMT, Michael Austin
<ma*****@firstd basource.com> wrote:

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...


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.
Jul 17 '05 #9
> 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?


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.
Jul 17 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2496
by: Mudge | last post by:
Hi, I am relatively new to PHP, but I don't care about that. I want to build a database driven Web site that is really a content management system that allows visitors to register and log in and write stories for the web site, and also allows visitors to vote on the articles. I'm thinking that maybe I should use a content management system in existence already because it might save time, then if i need to, i could just change the system...
2
1809
by: Rootshell | last post by:
I need to create the table and I want to edit its content from www level. Here is some example: http://www.rootshell.be/~flash44 There is a table. Is there possibilty to edit the content using <input> command?
12
3229
by: jonathan.beckett | last post by:
Hi All, For the past few months I have been working on an open source Apache/PHP/MySQL content management system - and have recently made it available for download. It's still very much a work in progress (current release version is 0.4.6), but you should get a very good idea of what it's about by visiting the site (which uses it, funnily enough), or downloading a copy of it and trying it out.
0
2326
by: jonathan.beckett | last post by:
Hi All, I have just made version 0.4.8 of the PluggedOut CMS Content Management System available for download - it's free, and covered by the GPL. It's still very much a work in progress (current release version is 0.4.8), but you should get a very good idea of what it's about by visiting the site (which uses it, funnily enough), or downloading a copy of it and trying it out.
4
1795
by: | last post by:
Do any of the ASP programmers on this form utitlize ASP Content Management Systems for any of their customer (or own sites). If so, I would be grateful for any feedback and thoughts on using CMS in a hybrid static or asp web page environment. We are reaching the point where our site content and format is chaning too rapidly to be able to deploy custom asp applications quickly enough or smoothly enough. If this is too off-topic could...
0
2144
by: Scott Abel | last post by:
For immediate release: The Rockley Group Content Management Workshop Series Coming to Atlanta, Seattle, Vancouver, Chicago, Washington, DC, Toronto, and Research Triangle Park Learn more: http://www.rockley.com/workshops.htm The Rockley Group Content Management Workshop Series is designed to
7
370
by: Water Cooler v2 | last post by:
I know what it is, and yet the knowledge of what a CMS is, is so vague that I find myself asking this question every now and then. I've googled and read the resources too. However, the knowledge is still not clear. It is so vague. Me: Just what is a content management system? Myself: A place where content can be stored.
10
1920
by: JJ | last post by:
I am needing to write a simple content management system for my web site. I've not done this before so if anyone has any link/info please could you mention them? One thing I am confused about: Do all content management systems store their content in a database? If so, can their pages be indexed by a search bot? If it does cause potential indexing problems, could you potentially have a content management system that creates a new page...
0
1019
by: vayalumkan | last post by:
Hi Sir, I want some technical help on how to develop(Implement) a Content Management System using ASP.NET and C#? Can any body help me to develop a CMS (Content Management System) ? Using ASP.NET technology and C#. Database SQL Server 2005
0
10045
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9994
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9863
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8870
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7408
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6673
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5298
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3958
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.