Re: [Fofredux-devel] unknown column feed.latitude (upgrade issues)

[Kevin <ke...@dr...>]

> Ok - so read/unread in tags it is. Sounds reasonable. Do we filter
> read/unread when we display an item's tags? If so, do we use
> read/unread as the "magic tags" regardless of language (I think we
> will definitely want to support multiple languages in the UI)
>
> Also, as for backwards compatability, you mean being able to switch
> back and forth b/w FoF v0.19 and FoFRedux v0.2? We will need to
> reconfigure tables at some point, and this may be the best point to
> provide an "upgrade" script that would migrate the "read" column to a
> "read/unread" flag. ADODB is nice in that it supports table format,
> but we could write a script for this first release. Do you think that
> covers the compatability enough?

For me, just running install.php and doing an OPML import was a *good
enough* upgrade path.  ;)

Ben, Do you really think retaining backwards compatiblity with FoF at the
db schema level is a good idea?  What about if we provide a decent import
function that pulls the feeds and items from the FoF tables but does not
modify them?


> On 11/28/05, Benjamin Stewart <bs...@cr...> wrote:
>> Whatever we do, I would like to reiterate the desire to maintain
>> backwards compatability for the first release, which means we can't ge=
t
>> rid of 'read' yet.
>>
>> Ultimately, I think I like the idea of using tags for all status, and =
we
>> might have some "reserved" tags (read, unread, etc) that don't show up
>> as normal tags in the UI, but act just like tags.
>>
>> --Benjy
>>
>>
>>
>> On Mon, Nov 28, 2005 at 01:50:42PM -0500, Andrew Turner wrote:
>> > Do we want to support some enumerated "Flag" that is separate from
>> > tags/categories for things like read, unread, "flagged", "delete" ?
>> >
>> > I guess incorporating this into tags is the most flexible means. Wou=
ld
>> > require less coding to do a search on "all items with tags windows,
>> > programming, unread" and completely flexible "flags"
>> >
>> > What say anyone else?
>> >
>> > Andy
>> >
>> >
>> > On 11/28/05, Kevin <ke...@dr...> wrote:
>> > > Benjamin Stewart wrote:
>> > >
>> > > <snip>
>> > >
>> > > >(Oh, this does bring up the question of whether or not we want to
>> change
>> > > >the name of the 'read' column at some point, so we can stop
>> confusing
>> > > >mysql)
>> > > >
>> > > >
>> > > +1.   Using reserved words as column names is a bad idea.  The
>> backtick
>> > > workaround is not cross DB compatible.  This column could even be
>> > > eliminated by using a "read" or "unread" tag.
>> > >
>> > > --Kevin
>> > >
>> > >
>> > > -------------------------------------------------------
>> > > This SF.net email is sponsored by: Splunk Inc. Do you grep through
>> log files
>> > > for problems?  Stop!  Download the new AJAX search engine that mak=
es
>> > > searching your log files as easy as surfing the  web.  DOWNLOAD
>> SPLUNK!
>> > > http://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
>> > > _______________________________________________
>> > > Fofredux-devel mailing list
>> > > Fof...@li...
>> > > https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>> > >
>> >
>> >
>> > --
>> > Andrew Turner
>> > ajt...@hi...        42.4266N x 83.4931W
>> > http://highearthorbit.com              Northville, Michigan, USA
>> > idealistic technocrat
>> >
>> > Photos - http://flickr.com/photos/ajturner
>> > Travel   - http://highearthorbit.com/projects/location/
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.net email is sponsored by: Splunk Inc. Do you grep through l=
og
>> files
>> > for problems?  Stop!  Download the new AJAX search engine that makes
>> > searching your log files as easy as surfing the  web.  DOWNLOAD
>> SPLUNK!
>> > http://ads.osdn.com/?ad_idv37&alloc_id=16865&op=3Dclick
>> > _______________________________________________
>> > Fofredux-devel mailing list
>> > Fof...@li...
>> > https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>>
>
>
> --
> Andrew Turner
> ajt...@hi...        42.4266N x 83.4931W
> http://highearthorbit.com              Northville, Michigan, USA
> idealistic technocrat
>
> Photos - http://flickr.com/photos/ajturner
> Travel   - http://highearthorbit.com/projects/location/
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id=16865&op=3Dclick
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>


--=20
Kevin