Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^2: Database abstraction including data types

by Anonymous Monk
on May 20, 2012 at 21:00 UTC ( #971519=note: print w/replies, xml ) Need Help??

in reply to Re: Database abstraction including data types ( $dbh->{pg_bool_tf} )
in thread Database abstraction including data types

Aternatively do it all in the database:

SELECT CASE WHEN column_name THEN 1 ELSE 0 END AS column_name FROM table ...

Replies are listed 'Best First'.
Re^3: Database abstraction including data types
by Anonymous Monk on May 20, 2012 at 21:06 UTC
    By the way, that whole app looks like a good candidate for SQLite which could simplify the configuration and management a bit.

      I'm not sure how many people actually use SQLite for their Postfix installation. Postfix supports it but Postfixadmin doesn't so I suppose there has been little demand. It would probably work with mostly the same SQL as MySQL except for the DDL. But given that I'd have to support the "big ones" too as that's what most people use, I don't quite see how it would simplify things?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://971519]
[GotToBTru]: we don't have one of those ;)
[LanX]: commander in chief whatever
Discipulus fears to ears this in German..
[LanX]: missing for month
[LanX]: D : Oberbefehlshaber
[GotToBTru]: yeah, thats the story I remember. some card the President is supposed to carry around at all times

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2017-01-20 12:49 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (174 votes). Check out past polls.