I think this is a very good feature to have, thumbs up ! ? > Tue Jan 12 2016 9:50:33 pm CET CET from "James K. Lowden" ><jklowden at schemamania.org> Subject: Re: [sqlite] whish list for 2016 > > On Fri, 8 Jan 2016 08:28:29 +0100 > Dominique Devienne <ddevienne at gmail.com> wrote: > > >> >>>One way to do that would be to honor a special user-created table, >>> say "PRAGMAS", with name-value pairs that are automatically applied >>> when the database is opened. >>> >>>
>> Interesting idea. A "special"-to-SQLite sqlite_pragmas table, similar >> to sqlite_master. >> > Similar in name, yes. sqlite_master is special in that it's built into > the database file structure, though. You couldn't add another such > table without changing the file structure, something OFL understandably > doesn't want to do. > > I'm suggesting that the presence of a user-created > "configuration table" would govern the behavior of the database, > analogous to a configuration file. > > --jkl > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?