RE: [PEAR] Pear DB LastInsertID
| From: | LIMBOURG Arnaud | Date: | Mon, 15 Jul 2002 07:24:22 +0000 |
| Subject: | RE: [PEAR] Pear DB LastInsertID | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-1884@lists.php.net to get a copy of this message | ||
> I don't have a problem with it either. The only esthetic thing I can
> think of is that it would be nice if the seq tables had a configurable
> prefix.
But you can configure it ! I don't remember how but you can change the
sequence format name somewhere in the options. So you can make them start
with seq_ or whatever so that they are grouped.
Arnaud.
> When you have to view the tables it would be nice to have them grouped
> together so that they don't clutter up phpMyAdmin or whatever db admin
> tool you happen to use. You wouldn't confuse them with other tables.
>
> Not a big deal but I thought it might be worth mentioning.
>
> Matt Friedman
>
>
> -----Original Message-----
> From: Jonas Koch Bentzen [mailto:test@understroem.dk]
> Sent: Sunday July 14, 2002 11:50 AM
> To: pear-general@lists.php.net
> Subject: Re: [PEAR] Pear DB LastInsertID
>
> shaggy@vip.bg skrev:
> >
> > Anyway I use PEAR sequences but I don't like the fact that
> it creates
> > a separate table in MySQL for every sequence
>
> I don't see it as a problem at all, because you never have to care
> about, even look at, the sequence tables. Say you're making an open
> source application... You write a script that creates the tables and
> runs DB::createSequence() for each table. Then, in your
> application, you
>
> use DB::nextId() to handle the sequences. You never have to
> look at or
> do something with the sequence tables.
>
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>