Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • 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!

    • Gee, you mean like Alzabo?
    • 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

      • 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;