Hey Mobi, 2010/3/22 mobi phil <[email protected]>: >>> Another serious design issue is that you make db equivalent of any >>> std::string or WString the "TEXT". "TEXT" can have up to gigantesc >>> sizes, like in mysq, and you cannot predict the size of the field >>> untill you retrieve an element. As I see this is not the case for >>> sqlite, but it is souriously the case for Mysql. This means that you > >> I believe that is indeed not optimal (but an easy start, and as good as it >> gets for Sqlite). > > Well... this part of the project seems to be more important than > others, and for me it is about using it or not... In the context where > I am using it, I cannot afford allocation of memory for mysql "TEXT" > type, in order to be sure that myqlclient lib will not do buffer > overrun etc. > >> We should extend support for the std::string and WString by adding an >> optional 'size' parameter to the dbo::field() function call. The same >> 'size' argument can also be used to indicate the size of a (binary) >> blob of (C type const char *), which we will also want to support. >> These two things are on my wish list for Wt::Dbo. > > Do you expect a beta version soon? When? Can you pls. inform when > available in git?
It is now ! New dbo backend features: - support for blobs, mapping onto C++ std::vector<unsigned char> types (perhaps we can add other type traits later) - native support for date and time stamps - a size parameter in dbo::field which when used with std::string and WString results in varchar(x) SQL types. The backend API has been expanded (and thus, broken) to accomodate some of the differences between Postgres and SQlite3 with respect to these features. Regards, koen ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
