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
