Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Don S. <do...@se...>]

Yes it does create a table for each seq, and so it would create a table 
for every table that uses sequences.  I don't know if every table uses 
sequences, but to play devil's advocate let's say they do.

As far as database space, the sequence tables are just one int field.  I 
don't think that size would really be a concern.

If your concern is more organizational, I guess there's not much one can 
do to take advantage of the PEAR system.  Personally I don't mind having 
the table created.  I'm sure the PEAR folks took a long, hard look at this 
as well.  They had to make a number of compromises in the name of database 
abstraction, obviously.

I don't think this is that much of a concern.  Of course I'm just a fan.

Don.

On Mon, 21 Oct 2002, Adam Morton wrote:

> I would like to tak a closer look at the implemetation of this.  It looks
> like it's creating an extra table just to calculate the next sequence
> number.  Do you really want this since it could effectively double the
> amount of tables in the database?
> 
> Adam
> 
> > +1 from me on sqlInsert() with idColumn, returnMaxId, and table name as
> > sequence name.
> >
> > Adam
> >
> >> Probably not.  I wasn't aware that PEAR changed the name behind the
> >> scenes.  So just using $table_name in the php code should work great.
> >>
> >> Thanks for the heads-up.
> >>
> >> Don.
> >>
> >> On Mon, 21 Oct 2002, Matthew McNaney wrote:
> >>
> >>>
> >>> > I'm wondering if using the table_name as the sequence name will
> >>> work
> >>> on all db systems.  I don't know explicitly if it won't work, but
> >>> could there  be a possibility of naming collisions?
> >>> >
> >>> > Perhaps using "seq_$table_name" would suit?
> >>>
> >>> I just noticed that PEAR saves the sequence tables as
> >>> sequenceName_seq
> >>>
> >>> So prefixing creates:
> >>>
> >>> seq_sequenceName_seq
> >>>
> >>>
> >>> Do we still want the prefix?
> >>>
> >>> Matt
> >>>
> >>>
> >>>
> >>>
> >>> -------------------------------------------------------
> >>> This sf.net email is sponsored by:ThinkGeek
> >>> Welcome to geek heaven.
> >>> http://thinkgeek.com/sf
> >>> _______________________________________________
> >>> Phpwebsite-developers mailing list
> >>> Php...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> >>>
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This sf.net email is sponsored by:ThinkGeek
> >> Welcome to geek heaven.
> >> http://thinkgeek.com/sf
> >> _______________________________________________
> >> Phpwebsite-developers mailing list
> >> Php...@li...
> >> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> >
> >
> > ---------------------------------
> > Adam Morton
> > Developer - Web Technology Group
> > Appalachian State University
> > http://phpwebsite.appstate.edu
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > Phpwebsite-developers mailing list
> > Php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
> 
> 
> ---------------------------------
> Adam Morton
> Developer - Web Technology Group
> Appalachian State University
> http://phpwebsite.appstate.edu
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net emial is sponsored by: Influence the future of 
> Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) 
> program now. http://ad.doubleclick.net/clk;4699841;7576298;k?
> http://www.sun.com/javavote
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>