RSS | Module Info | Add a review of SQL-Translator

SQL-Translator (0.09000)

Also known as "sql-fairy", SQL::Translator reads and writes many, many dialects of SQL and translates between. As such, this is profoundly useful. I use it to write database schemas in near-ANSI syntax and then translate that to 1) MySQL (which has a peculiar foreign key syntax), 2) SQLite and 3) DBIx-Class code. This saves me a ton of duplication and coordination.

Even better, there is SQL::Translator::Diff which lets you compare a schema.sql to the schema behind a live DBI connection and outputs CREATE, DROP and ALTER commands that you can run. I use this to generate the SQL to update servers to newer schemas when I upgrade applications. It's a little slow to run the diff, but it's much more convenient than keeping track of what version of the database schema is running on what dev machine.

I also love the included 'sqlt-graph' tool which can generate a PNG, SVG, etc. representation of your schema. This is profoundly useful when discussing the data relations with developers/users who are not SQL-fluent.

Although the version number is only '0.09000', this package is definitely production-ready. I've been using it continuously for almost two years now.

Chris Dolan - 2008-06-07 22:47:25
Was this review helpful to you?  Yes No

SQL-Translator (0.08001)

good tool!

Alex - 2007-12-12 16:07:43
Was this review helpful to you?  Yes No

SQL-Translator (0.08)

I can't even believe this exists!

Mike Baas - 2007-04-05 22:45:06
Was this review helpful to you?  Yes No

SQL-Translator (0.08)

worked really well, fit like a glove!

luseronfire - 2007-03-25 22:38:46
Was this review helpful to you?  Yes No

SQL-Translator (0.07)

This module is a wonderful work!

However, I hope the author will provide more args to the GraphViz producer, so I can get more control over the tyle of the pictures generated. The default settings lead to graphs with poor appearance.

Agent Zhang - 2005-10-08 20:45:07
Was this review helpful to you?  Yes No

SQL-Translator (0.06)

While working on Handel, I've come to the point where I need a sane way to create SQL scripts for multiple database. SQL::Translater is making my life more sane in this area. Once I define the schema, I can just have it toss out create scripts for SQLite/MySQL/Postgres and go on with life. This pays off even more when I want to define foreign key relationships, but only some platforms support them; or support them in different ways.

On the flip side, I wish the docs were a little more verbose about the formats, especially the YAML producer.

Christopher H. Laco - 2005-06-07 10:45:39
Was this review helpful to you?  Yes No

SQL-Translator (0.06)

An outstanding product--I needed to create audit tables with related functions and triggers for a large (~100 tables) PostgreSQL schema, and after spending 1/2 day writing a template, I can get the sql file for the audit tables from SQL::Translator.

Scott Cain - 2004-10-15 09:10:54
Was this review helpful to you?  Yes No

SQL-Translator (0.06)

Although I'm biased (I work on this project), I think this is a great
piece of software: Very useful, very featureful, and fairly complete.

darren chamberlain - 2004-10-11 18:25:39
Was this review helpful to you?  Yes No

SQL-Translator (0.06)

This distribution is really superb in terms of the abstraction it lets you do. I use it to create my schema in OO, and generate sane SQL from that. This I pipe to whatever database I'm using. The application level is completely oblivious of all this detail.

It just works, and it does it well.

There are three quirks though.

Speed. Parsing schemas and stuff is slow. That's what you get for using Parse::RecDescent. It's well worth it though.

The documentation is occasionally sparse, and you have to dig hard and long to find silly little bits, when you're trying to pick it up. The documentation is scarecely necessary after that, though.

Lastly, the installation process is tedious, as there are lots of extensions that, IMHO, should be packaged seperately, to allow an easier installation. Not everyone wants GD diagrams, or can even install GD...

???? ???'?? - 2004-09-15 10:14:56
Was this review helpful to you?  Yes No

SQL-Translator (0.05)

I think this is a very good thing which has to be done perfectly and is surely worth much effort.

piotao - 2004-08-19 14:02:10
Was this review helpful to you?  Yes No

SQL-Translator (0.05)

I agree with most of the other reviews here. This module looks extremely useful, and I know I would use it, if only i could get it to install.

I think you might want to reconsider listing some many modules as pre-requisites in your Makefile.PL. You could likely get away with a core few, and allow the user to install the modules they might need for a specific producer only when they want to use them.

Stevan Little - 2004-07-30 21:16:47
Was this review helpful to you?  Yes No

SQL-Translator (0.05)

brilliant concept, I need this in very many ways., I cannot however get it to work. How do I use the DBI-MySQL parser? The filename seems mandatory, how do I specify the database and host?

Can someone PLEASE enter some examples in the synopses, manpages etc. It is ironic with *all* these man-pages, people seem to have cleverly avoided giving a single working example, :( sigh

I would like to do: sqlt-diagram -f DBI-MySQL 'localhost:RGW'

or something like it

Seth Heeren - 2004-07-30 19:11:15
Was this review helpful to you?  Yes No

SQL-Translator (0.05)

In order to use this module to convert from one database schema to another, you need to install the C library for GD graphics, Spreadsheet::WriteExcel, and download, compile and install the Graphviz C programs, which I think is somewhat overkill. Go look at DBIx::DBSchema instead.

Simon Cozens - 2004-07-19 04:06:56
Was this review helpful to you?  Yes No

SQL-Translator (0.05)

I wish there were a SQL::Translator::Manual as promised in the SQL::Translator POD, but this module has saved me much time and effort.

chromatic - 2004-06-13 12:41:44
Was this review helpful to you?  Yes No

SQL-Translator (0.04)

dddddddddddd

bingo - 2003-12-19 06:18:15
Was this review helpful to you?  Yes No

Perl.org sites : bugs | dev | history | jobs | learn | lists | use © Copyright 2002-2008 The Perl Foundation Site Information and Contacts