Posted by Jerry Stuckle on 02/21/07 11:13

469 wrote:
> Ok, well i learnined while i was needing to do things... with
> websites... but iuf you wnat to really practice... well i suggest you
> to do a complete sales site...:
>
> Clients
> ++++ Bough products
> ++++ Recomended by (Another clients asked him/her to join)
> ++++ Most visited category
>
> Products
> ++++ Basic product info
> ++++ sector and subsector
> ++++ Rankings
> ++++ relations with others
>
> Admin
> ++++ Do's and dont's
> +++ Some other crap
>
> ofc... you will have to add the administrative interfaces, to add,
> edit, delete, hide, unhide and so on... ;)
>
> a suggestion... plan fine your app... then plan the database, and then
> start coding post here or msg me if ya need halp...
>
> BTW a sugestion... if you plan to do system that arent hosted by a
> company like wehostyourwebsite.adomain.com but they're going for
> intranet thingies... i REALLY sugest you to use POSTGRESQL, and not
> only for you... but for others that also have experience with
> systems... and sometimes would like to reduce some "sql" sentences
> with stored procedures written in PL/PHP or PL/SQL or PL/PGSQL....
> composite types...
>
> if you love mysql... then you will love enven more postgresql when you
> see its benefits...
>

PostgreSQL is good - but then so is MySQL. And MySQL is supported by
many more hosting companies, so if he ever goes to a hosted solution he
will have man more options.

There is nothing wrong with using MySQL - which, BTW, also has stored
procedures.

Of course, there is nothing wrong with PostgreSQL, either. But I can't
see how you can recommend one over the other from the information given
- unless you have a totally biased (and closed) attitude.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]