<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>
<P>>From: "Frank Ellermann" <A
href="mailto:Frank.Ellermann@t-online.de">Frank.Ellermann@t-online.de</A><BR>>To:
"David Wilson" <A
href="mailto:davidwwilson@attbi.com">davidwwilson@attbi.com</A><BR>>Cc: "EIS
fans" <A
href="mailto:seqfan@ext.jussieu.fr">seqfan@ext.jussieu.fr</A><BR>>Subject:
Re: record sequence fields<BR>>Date: Wednesday, June 18, 2003 11:05
AM<BR>><BR>>David Wilson wrote:<BR>><BR>>> I am attempting to
convert the OEIS to a MySQL database.<BR>><BR>>That's an interesting idea.
Changing records is probably<BR>>simple, a reference to sequence X is only
allowed if X exists.<BR>><BR>>But additions and deletions can be
difficult, because you need<BR>>transactions for several records at once
(e.g. cross-referenced<BR>>pre-numbered sequences).</P>
<P>Right now, I am only concerned with getting a working database<BR>incarnation
of the existing sequences, and not with inserts or<BR>crossrefs, I will deal
with those if and when I decide to extend<BR>the application.</P>
<P>>> Longest single element: A019439 (196 chars)<BR>>How do you define
"element" ? I tried "concatenation of %S,<BR>>%T, and %U" for A19439, but
that resulted in 212 characters.</P>
<P>Sorry, that should have been A019437</P>
<P>>> Longest name: A076740 (641 chars)</P>
<P>>Hm... :-( I'm still unhappy with too long %N lines.<BR><BR>If you could
give me an idea of what is "too long" for various<BR>fields, I could provide you
with data about where the problems<BR>are.</P>
<P>>> Longest comment line: A075886 (2148 chars)<BR>><BR>>Oops,
thanks for info. My default line length limit is 2048,<BR>>because the
DOS-version of my editor is restricted. But maybe<BR>>I should change this to
4000 (the hard DOS-limit is 4095).</P>
<P>Hey, at least the database is no longer on punch cards.<BR><BR>> Bye,
Frank<BR>></P></FONT></DIV></BODY></HTML>