use Perl

• Stick it out... (Score:1)

  by jordan (120)

  It actually sounds pretty cool.
  

  If it is a mess, at least you'll have learned a lot about just how far to go with this kind of thing.
  

  Sure, your brain may hurt now, but no pain, no gain. On the other hand, you have failed to save yourself headaches...
  

  Look at it this way, if it is a failure, and your brain does explode, at least it will be a spectacular failure. I'd rather be a spectacular failure than a boring success!
  

  (when did I start sounding like Stuart Smalley?)
  • Re:Stick it out... (Score:1)

    by nkuitse (193)

    It actually sounds pretty cool.
    
    Thanks for the encouraging words. My brain is much better now. Lying in the grass with my eyes closed helped a lot. :-)
    
    I wouldn't say it's a mess, just big and I tend to work on several parts of it at once. When I'm in the groove this can work very well (until my brain conks out); at other times, it results in a certain amount of wheel-spinning...
• CREATE TABLE abstraction? (Score:1)

  by chromatic (983)

  Does this allow you to describe a table structure and dump out SQL statements to create it in various databases? That'd surely be useful!
  • Re:CREATE TABLE abstraction? (Score:3, Funny)

    by autarch (914)

    Gee, you mean like Alzabo?
    • Re:CREATE TABLE abstraction? (Score:1)

      by chromatic (983)

      Now that you mention it, Alzabo::Create::Schema [cpan.org] looks extremely useful. Darn you for making my life easier yet again!
  • Re:CREATE TABLE abstraction? (Score:1)

    by nkuitse (193)

    Does this allow you to describe a table structure and dump out SQL statements to create it in various databases?
    
    Maybe. I'm only targeting PosgretSQL at the moment, but it should be easy to target other RDBMSes too, as this would mostly* entail making a few new SQL templates.
    
    * There are bound to be some PostgreSQLisms outside of the templates; hopefully, not many.
    
    Here's a much-abridged example of a table definition:
    
    tables/Orders/definition.yml

    --- #YAML:1.0
    name: Orders
    singular: Order
    description: Book
    • Re:CREATE TABLE abstraction? (Score:2)

      by TeeJay (2309)

      You could probably try and use some of the code from tedia2sql - it generates loads of code for oracle, postgres, etc - most of the big databases.

      And you can create it all from dia which is nice - should be easy to create your other stuff from dia too.

      I am currently working on a new project to combine schema and code creation so that you can create your databases, your queries (all kept in a nice phrasebook natch), and documentation from a couple of perl scripts.

      --
      
      @JAPH = qw(Hacker Perl Another Just);
      print reverse @JAPH;
      • Re:CREATE TABLE abstraction? (Score:1)

        by nkuitse (193)

        Thanks for the tip. I've gotten over the hump now, I think, so I probably won't use tedia2sql, but it's always good to know about the alternatives...