use Perl

• Use a view (Score:1)

  by Thos Davis (6347)

  While it still requires that you type the query correctly once, views are portable across relational databases (finally even MySQL as of 5.0)

  CREATE VIEW recipe_ingredient_list AS
    SELECT r.id, i.name
    FROM   ingredients i, recipe_ingredient ri, recipes r
    WHERE  r.id = ri.recipe_id
      AND  i.id = ri.ingredient_id

  so that you could use this query:

  SELECT name
  FROM   recipe_ingredient_list
  WHERE  id = ?

  And if you use PostgreSQL as the backend (so
  • Re:Use a view (Score:2)

    by Ovid (2709) on 2005.10.20 10:20 (#44043) Homepage Journal

    Aside from the "write rules in Perl" part, we actually use "updateable" views with Postgres (and SQLite) all the time where I work. It's very handy.

    Reply to This

    Parent