Hello ! Due the way sqlite manages it's source code (with fossil-scm) I propose to anyone that has any extension/custom sqlite code fork this project on github:
https://github.com/mackyle/sqlite And publish it there. Cheers ! > Sun Sep 13 2015 6:42:27 am CEST CEST from "Charles Leifer" ><coleifer at gmail.com> Subject: Re: [sqlite] Fwd: OT: Oracle functions for >SQlite > > 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 >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?