Hello! On Tuesday 15 December 2009 16:26:00 [email protected] wrote: > 3. ENFORCE constraint for table columns, for example: CREATE TABLE t(i > enforce integer, j enforce text). This optional constraint enforces type > checking so that an entry must match the column type (i.e. integer, real, > numeric, text, blob). Note: this can be done using a CHECK constraint, > but here is done internally using some additional custom VDBE opcodes to > give greater efficiency.
Great! Is the error message informative enough? > 4. Optional READONLY option for the ATTACH DATABASE command: the attached > database can then be opened "readonly" even when the main database is not. It's useful in most common situations. Dos this prevent creating no-exists files for attached databases? Is the error message informative enough? > 5. Patch to relax restriction for VIEWs to allow them to reference tables > in attached databases. I use a same patch too. The SQLite command did break backward-compability when did disable the feature... > Shortly I hope also to have completed a patch to allow a limited form of > "stored procedures" where the sqlite_prepare function can be used to > create a VDBE program with support for loops, rudimentary support for > if/then/else style constructions and generation of output rows that can be > then executed as and when. Do you have any description? I did see similar for SQLite version 2 only. > If there is any interest, let me know. Plus, also say whether you'd like > the diff file against the original sources or against the amalgamation. > I'm afraid I can only do this against the current sqlite version (3.6.21) > but people are welcome to try the patch against whatever version they > like. The patches also include tests that will be included in "make > test". No guarantees that it will work however well it might work for me! Please to publish patches for original source tree. The amalgamation can be easy builded from it. If you don't have web server please send me to email and I will place the pathes on my server. Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
