Skip to main content
V
VDH_Bill
Participant
January 5, 2010
Question

Database building

  • January 5, 2010
  • 5 replies
  • 571 views

I am new to coldfusion, coming mostly from PHP and mySQL so forgive me if this is elementary

but I would appreciate any input.

As it goes I am accustomed to using things like PHPmyAdmin for building databases quickly as opposed to the cfc, cfm style I have been (trying) to learn for building a data source in coldfusion.

Is there a way to quickly build and poplute a database in Coldfusion with a userinterface as opposed to code style?

It comes off as lazy now that I am writing it but I also like streamlined.

The training I have gotten have given me a good understanding of the apache derby embedded sources using the components but I would like to find a quicker way to build the databases so I can move onto the flex/coldfusion projects themselves.

Thanks for your help

Bill Van der Hagen

    This topic has been closed for replies.

    5 replies

    V
    VDH_BillAuthor
    Participant
    January 6, 2010

    Thanks everyone, for now I am using mySQL which I have done in the past and that should work well if I decide I need a GUI I know of a few out there to try out.

    I was confused with all the datasource options when I was being led to apache derby which I had never used.

    I appreciate all the help

    D
    Dan_Bracuk
    Inspiring
    January 5, 2010

    Before doing anything, have you determined what your database is supposed to do?  Have you decided on a data model yet?  If not, do so.

    As far as building the tables is concerned, you don't need web application software do accomplish this.  Your db software may have some utilities that enable you to do this with a gui interface.  Personally, I prefer typing my own create table queries but that doesn't mean everyone has to.

    ilssac
    ilssac
    Inspiring
    January 5, 2010

    I think the OP's original question centered around how to administer the bundled Derby database tool included in current versions of ColdFusion

    ilssac
    ilssac
    Inspiring
    January 5, 2010

    As the other reply indicates, I'm not sure what is available for Derby, but it's just the 'free', 'starter' database that comes with ColdFusion.  But, as I understand it, A much more universal starter then the MS Access that used to be what all the examples came in.

    If you want to continue to use mySQL, that is a popular database to use with ColdFusion as is MSSQL, Oracle and even the above mentioned MS Access though almost every experienced developer would recomened against the latter choice.

    ColdFusion is not really meant to be the database management tool of choice, though lots of interfaces are built to do some level of management at some point or the other.  These are usually meant to be simple user interfaces to allow the editing and adding of small amounts of data in the overall database.  They are not really meant to replace a back end managment tool like PHPmyAdmin, Toad, Sql Developer or any other full featured database managament tool.

    HTH

    Ian

    J
    JR__Bob__Dobbs-qSBHQ2
    Inspiring
    January 5, 2010

    I'm not familiar with PHPmyAdmin.  Can you describe the kinds of features/functions you'd like to have?  What database are you using?


    AdamPresley
    AdamPresley
    Participating Frequently
    January 5, 2010

    So you are using Apache Derby? Can't say I've used it, so I am not familiar with any front-end GUI interfaces that work with it. Let us know what you find.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices