On Thu, Dec 6, 2012 at 2:15 AM, Staffan Tylen <staffan.ty...@gmail.com>wrote:
> My understanding from reading the documentation is that ooSQLite currently
> doesn't support the sqlite3_create_collation API. Would it be feasible to
> add this support?
Things like the collation API and extension loading look interesting to me,
and may, or may not, be feasible.
I purposefully did not look into those areas yet, and they won't be in a
1.0.0 release for sure.
I intend to look into it later, after all the doc for 1.0.0 is done and
1.0.0 is an official release.
At the moment I rely on the sort callback functions in ooDialog but there
> are obvious limitations imposed by this. I realise that if the SQLite
> collation API callback routine is directed to some code written in Rexx
> there would most likely be a serious performance penalty in SQLite, so as
> an alternative such support could for example take the form of a
> (de)registration of the name of a collation together with a corresponding
> translate table or something similar, which an ooSQLite built-in callback
> routine could use to perform the data comparison. Does this make sense?
Yeah, I can't really say until I spend some time researching it and writing
some working C / C++ code.
My gut-feeling is that for small databases, callbacks into Rexx to do the
collation would probably work reasonably well. At what point it might
become too slow could only be determined after implementation. And,
really, small databases are really the applications I visualized using
ooRexx and ooSQLite. 300, 700, 2,000 records.
My other thought was, that for ooSQLite it might be possible to implement
some type of plugin function. Where you could for instance plugin a
collation extension written in C / C++. This is probably somewhat similar
to what you mean by (de)registration. Then if people wanted some type of
general use collation function, someone might step in with C / C++ skills,
write it, and make it generally available.
A good topic, but I'm not ready to delve into it, myself, at this point.
Someone else might want to. It is open source after all.
--
Mark Miesfeld
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Oorexx-users mailing list
Oorexx-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/oorexx-users
