This is really cool! I wonder if anyone else has collections of neat user-defined functions/aggregates/virtual tables/etc? Is there a canonical repository of these? Anyone know of some interesting ones?
On Tue, Sep 8, 2015 at 12:46 PM, Petite Abeille <petite.abeille at gmail.com> wrote: > Perhaps of interest: > > http://sqlite-libs.cis.ksu.edu > > > > > Begin forwarded message: > > > > From: St?phane Faroult <sfaroult at roughsea.com> > > Subject: OT: Oracle functions for SQlite > > Date: September 8, 2015 at 2:30:24 AM GMT+2 > > To: "Oracle-L (E-mail)" <Oracle-L at freelists.org> > > Reply-To: sfaroult at roughsea.com > > > > I don't know if there are many people on the list using SQLite, but I > use it more and more often; teaching SQL is one reason (give a master file > to students, and let them create, drop tables, run DML at will without any > worry, and no need to bother about having a conveniently set server), > another one is consulting, whenever I'd *like* to store some data but I am > either unauthorized or unwilling to create my stuff on the database I'm > working on. Great also for implementing the poor man's performance pack - > dump your v$ every so often to a SQLite file, and you have something far > more flexible than statspack. > > The only snag is that SQLite is a bit weak function-wise. I have last > spring given as assignment to the students in one of my classes the writing > for SQLite of functions available in other products. Making everything > homogeneous, writing a few functions I couldn't decently ask of > undergraduates (even if I usually set the bar rather high), substituting my > own date functions to the standard Unix ones so as to have the same > behavior as Oracle in October 1582 and so forth has been a huge endeavor > (not finished), it may still be a bit rough here and there but I have > started publishing this collective effort as an open source library. > > > > It's at http://sqlite-libs.cis.ksu.edu/ <http://sqlite-libs.cis.ksu.edu/ > > > > > > There isn't EVERYTHING, but all the classic functions are there. > > > > Enjoy. > > > > St?phane Faroult > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
