[sqlite] Virtual tables and table-valued functions
In working on a Python wrapper around virtual tables, I thought it might be beneficial if SQLite provided an official C API for creating simple table-valued functions. The wrapper could build on the existing virtual table APIs and would consist of: * user supplied list of parameters, which would be converted to HIDDEN columns in a virtual table. * user supplied list of column names, which would constitute the return values of the table-valued function * user supplied initialization function which would accept the parameters passed, i.e. SELECT * FROM user_func(p1, p2, p3), the init function would receive (p1, p2, p3). * user supplied iterate function which would accept a zero-based index and a result context, returning 1 to indicate EOF and 0 to indicate more results exist. I think this might lead to a larger ecosystem of quality open-source table-valued functions. Given the fact that creating even a simple vtable is cumbersome, providing an API that required the bare minimum seems like a good idea to me. Thoughts? PS if you're curious about the Python wrapper, I posted on it a day or two ago.
[sqlite] BUNDLE problems/questions
1. I?m trying to create a new repo by taking a branch from an existing one. So, I thought the easier way would be the new ?bundle? feature. I tried this batch file (Win7): - f new xxx.fossil --date-override 2014-01-01 f o xxx.fossil f bun export xxx --standalone --branch %1 ?R original.fossil f bun import xxx --publish --force - where %1 is replaced by the name of the branch I want to extract. The --date-override is only there to place the initial empty commit before the imported content. But, it makes no difference if I use it or not. The problem: For some branch trying to ?FOSSIL UPDATE branch? (from the initial empty trunk) works fine, and all the files are checked out. Doing the exact same thing for a different branch, however, gives me: content missing for ... each file ... missing content, unable to update If I use the UI I can see the file contents just fine. So, the files are there but, for whatever reason, inaccessible. What can be the cause of this? Why does the above sequence of commands work for one branch but not another (from the same repo)? 2. Can I make the imported bundle end up in trunk without manually shunning the initial empty commit, and making the first node of the imported bundle branch the beginning of a new branch named ?trunk?? Thanks.
[sqlite] PhoneGap with SQLite Encryption Extension?
Thank you -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Friday, December 04, 2015 16:50 To: SQLite mailing list Cc: Santinello, Anthony Subject: Re: [sqlite] PhoneGap with SQLite Encryption Extension? On 12/4/15, Ribeiro, Glauber wrote: > We have an Android application built on PhoneGap, which uses the built-in > SQLite to store data. > > Does anybody here know if it's possible to replace the built-in SQLite in > PhoneGap (Android) with a version that supports encryption (S.E.E. or other > kind), so that the application information would be transparently > encrypted? > You'll have to compile in your own copy of SQLite using the JNI. Instructions here: http://www.sqlite.org/android/doc/trunk/www/index.wiki -- D. Richard Hipp drh at sqlite.org ___ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users