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
