Re: o.t. sugestions for entity modeler

From: Chris Parker (chris_parker_at_adelphia.net)
Date: 09/18/05

  • Next message: J F: "Re: KDE font size changes randomly" 
    Date: Sun, 18 Sep 2005 13:17:56 -0400
To: debian <debian-user@lists.debian.org>

    Adam Hardy wrote:

    > Chris Parker on 18/09/05 16:28, wrote:
    >
    >> What is a good database entity modeler? Database is mysql 4. new
    >> to sql so im just looking for something to show relationships for
    >> setting up queries easier.
    >>
    >> Also which is better for an online shopping cart, Myisam or
    >> Innodb?
    >>
    >
    > innodb if you need transactions. Which a shopping cart would.
    >
    > I don't know any Linux ERD package, but there must be at least one.
    > You could try searching http://lists.mysql.com/search.php mailing
    > list archives.
    >
    >
    >
    Am I able to switch to innodb after creating myisam? This project was
    tossed to me so I have read Learning SQL by O'reilly. It just doesn't
    say anything about switching engines (myisam to innodb) with the cart
    live. The cart is not world browsable yet, so am i able to switch
    without destroying anything? I have done backups of the database so
    its not too critical. 

    


    -- 
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: J F: "Re: KDE font size changes randomly"

    Relevant Pages

    • Re: how do i INSERT a value that contains a variable into a mySQL database
      ... or, if this is clearer, build the SQL up in stages: ... // check that $sql_string is what you want before sending it to the database ... > that gets incremented by one for each item in a shopping cart. ... > (txn_id, productID) ...
      (php.general)
    • Re: o.t. sugestions for entity modeler
      ... > What is a good database entity modeler? ... new to sql so im just looking for something to ... > Also which is better for an online shopping cart, Myisam or Innodb? ...
      (Debian-User)
    • Re: dbdebunk Quote of Week comment
      ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
      (comp.databases.theory)
    • Re: DBMS and lisp, etc.
      ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
      (comp.lang.lisp)
    • Re: dbdebunk Quote of Week comment
      ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
      (comp.databases.theory)