Hi John, A limit of 32 characters is probably fine for Workplace names, and is certainly sufficient for usernames. Although some users might otherwise wish to set long Workplace names, I think there is some sense in restricting it to 32 characters; otherwise, the Navigator in the Client's GUI could be distorted horrendously by, for example, a 300 character Workplace name. I have yet to come across someone with a passion for horizontal scroll bars...
Just my two pennies' worth. Best regards, Max On 22 Jun 2011, at 00:44, John Deal wrote: > Hello Alan, > > Actually I did not. MySQL has its own C++ connector. After the SOCI > experience I am a bit nervous of C++ wrappers. > > It turns out that I actually don't get much out of the wrappers over the > native C interface. I also get more precise knowledge of where things go > wrong. In addition, the logic of the MySQL side follows very closely the > SQLite side. > > I actually just finished the initial coding but have not tried to compile it > yet. Hope to have some functionality working by the meeting on Sunday. > > On the string sizes, Currently I have the buffers to 256 characters except > workplace name (and maybe user name) at 32. I am not sure where I found the > 32 character limit for workplace name. It is not an issue with SQLite but > creates some efficiency issues with MySQL. > > Thanks, > > John > > --- On Tue, 6/21/11, Alan Alvarez <aalva...@aliensoft.net> wrote: > >> From: Alan Alvarez <aalva...@aliensoft.net> >> Subject: Re: [Mira-development] Maximum Size String Fields >> To: "Mira Development Mailing List" <mira-development@lists.sourceforge.net> >> Date: Tuesday, June 21, 2011, 7:22 PM >> Hello John, >> >> >> >> On Mon, Jun 20, 2011 at 6:50 AM, John Deal <bassd...@yahoo.com> >> wrote: >> >>> Still working on the MySQL DB backend. Because of >> the way MySQL's C interface works, >> >> Just out of curiosity, have you considered using mysql++ ? >> I >> understand this would impose yet another dependency. I was >> just >> wondering if you weighted the pros and cons. >> >>> I need to know the maximum size of the string (text) >> fields (user name, workplace name, utility list, password, >> etc.). I looked around on the Wiki and in the .h files and >> did not see any size limit information (except the string >> type size limit). I could get around this by allocating >> very large buffers but with resulting memory waste. Does >> anyone know what the size limits are and if not should we >> set size limits (this is both a client and server issue)? >> >> I don't think we've set a limit to this. You could set one >> yourself >> that makes sense to you. >> >> -- >> regards, >> >> Alan Alvarez >> >> ------------------------------------------------------------------------------ >> EditLive Enterprise is the world's most technically >> advanced content >> authoring tool. Experience the power of Track Changes, >> Inline Image >> Editing and ensure content is compliant with Accessibility >> Checking. >> http://p.sf.net/sfu/ephox-dev2dev >> _______________________________________________ >> Mira-development mailing list >> Mira-development@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mira-development >> > > ------------------------------------------------------------------------------ > EditLive Enterprise is the world's most technically advanced content > authoring tool. Experience the power of Track Changes, Inline Image > Editing and ensure content is compliant with Accessibility Checking. > http://p.sf.net/sfu/ephox-dev2dev > _______________________________________________ > Mira-development mailing list > Mira-development@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mira-development ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Mira-development mailing list Mira-development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mira-development
