General discussion

Locked

What to use for the website?

By serval7 ·
Ok, I don't have much experience with database programs, I have used Access in the past and it seemed pretty intuitive for me, (I'm good with MS products).

I have Dreamweaver MX and have been designing small (non-interactive) sites for some clubsin my school.

I want to know what I should use to create pages such as the ones in www.intranets.com or www.communityzero.com that have message boards, picture galleries etc.

I think they use databases to store all members information and the messages/discussions/pictures posted. I don't believe it is a very hard thing to do (at least not hard enough to verify 100s of $$s of charge).

I would be glad if you could point me in the right direction for this.

Extra special mega-super thanks in advance for all help..

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Microsoft says SQL

by Breze In reply to What to use for the websi ...

Serval7,

If you are an MS-Man then SQL should do the trick! The mechanism is very similar to DB using Access and a majority of the web servers out there will support it.
-Good Luck

Collapse -

why to reinvent wheel?

by gokhan In reply to Microsoft says SQL

Hello,
I think your needs are basic( Do not start thinking to build something like intranet before you learn a programming language and gaining strong database skills ). So I will give you some ideas
- ezPublish: http://developer.ez.no/
- phpNuke: http://phpnuke.org/

Hope these 2 links will lead you to right direction.
Wish you good luck

Gokhan Arli (Web Developer)
gokhan@sylow.net
www.sylow.net / www.sylow.nl

Collapse -

Use What You Know -- For Now

by PJBurke In reply to why to reinvent wheel?

If you are already familiar with Access, start with that. Attempting to learn anything more exotic or high-powered now will just distract you from your main goal and task-at-hand: building a working dynamic, data-driven website. Get Site 1, Build 1done & functioning... then go back and evaluate alternatives if necessary. A whole lot of top professionals use Access to prototype serious, high-traffic, high-availability and even truly "mission critical" (as in military 'mission critical') web applications, then up-size them to SQL Server later... so you could do a whole lot worse. So start with what you know... but DO start.

Collapse -

Access is better than it looks

by jryan999 In reply to Use What You Know -- For ...

Hi there,

Myself I'm an Oracle specialist having worked with it for over 16 years on huge mobile phone billing systems - it's very powerful and stable.

However, I agree with previous comments, stick to what you know until you outgrow it.

Access is in fact more powerful than you may have imagined. BT-Cellnet the UK based built their "prepay" mobile phone registration system using Access as a "quick and dirty" then migrated to Oracle when it got too big. I was astounded when I found nearly 1m customers in the database.

Yes it has limitations, but it's unlikely without a small development team and a huge user populations that you'd hit them just yet.

Good luck.

Collapse -

Database Depends on Web Host OS

by TexasJetter In reply to What to use for the websi ...

You need to consider the OS of your hosting platform before selecting your database. If your web host uses Windows as the OS then Access is a good choice. SQL will most likely be avaiable as an additional charge item. If your web host uses anything other than Windoes you should look at one of the "other" databases. Keep in mind it takes a third party product (like ChiliSoft) to get ASP pages to run on non-Windows machines, which is how you want to do Access/SQL connections.

Collapse -

OS includes AS400

by ed_gilmore In reply to Database Depends on Web H ...

A common mistake is the thought that if you have an AS400, you will need a different database even though you are using Websphere. DB2/400 works very well in a Web environment.

Collapse -

MySql ---THE BEST

by shafi.ahmed In reply to What to use for the websi ...

hi
i am into lotus notes / domino but do a lot of web developement. I have a website called www.goarealestates.com and have used perl and mysql. Believe me i think it is the best backend database to have, which is very fast when queried. And almost all web hosting guys can affors to have it cos it is free .

Collapse -

MySQL is very good

by danmac In reply to MySql ---THE BEST

I agree with the above posts that say that you've got some work to do before you worry too much about database technologies (i.e. learning PHP, ASP or Perl), and that Access can do the trick if what you're doing is fairly lightweight (less than 100,000 rows per table).

However, when you do get to the point where you're looking at an alternative to Access, there is no reason to use anything other than MySQL or PostgreSQL in a moderate production environment. MySQL is probably the better choice to get started on the move away from Access. It's a little more user-friendly and quicker to get a handle on. The documentation is also better organized and easily available (There's a really good book from NewRider on MySQL - red cover).

I workfor a consulting company and we have used both MySQL and PostgreSQL on many projects. We only use PostgreSQL as a default because of it's extended features (Transactions, Stored Procedures, Sub-selects), but if you don't know what any of these itemsare then there's no reason not to use MySQL...

And the biggest reason why the above databases are popular - they're Free! You're going to need to be developing a pretty big, mission critical application to warrant spending the licencing fees on SQL Server or Oracle. Until you get to a database with tables that have millions of records and are doing multiple complex queries per second for hundreds of users, you won't be able to see much difference in performance.

Ok. I'll shut-up now.

Collapse -

Access/MySQL

by CUWickliffe In reply to What to use for the websi ...

From what everyone else has posted, I can recommend Access (what you know) or PHP/MySQL (what is also easy). Dreamweaver MX intergrates well with both database products. I personally use a lot of ASP pages on our departmental website (http://union.clemson.edu) and work it with an Access database, but we also use PHP and a MySQL database on a related website (http://www.clemsonnow.com) that a colleague has worked on and used to run off my server.
Your best bet? If the server supports it, go with Access and perhaps ASP pages. If your provider is a UN*X shop, you're probably better off with PHP/MySQL.

Adam

Collapse -

postgreSQL works for us

by JimKunkel In reply to What to use for the websi ...

postgreSQL has user level security, triggers (aka "stored procedures"), rules ("stored procedures lite"), transactions and is much faster than mysql in an environment where there are lots of users doing a mix of reads, inserts and updates. It is slower than mysql in a "write infrequently and read a lot" application.

Back to Web Development Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Software Forums