User preferences should not be stored in a database file, particularly settings 
affecting the presentation layer of the access tool (sqlite shell) that have 
nothing to do with the function of the storage layer.

-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Tom Browder
Gesendet: Mittwoch, 03. April 2019 12:53
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Betreff: [EXTERNAL] [sqlite] Why no persistent user settings in a database file?

After coming back to SQLite from a long absence, I was surprised that setting 
things like .mode and .headers in a database didn't stay that way after exiting 
the file.

Then I remembered something about a resource file and found .sqliterc on an 
internet search and that allowed the persistent settings I wanted.

However, would it not be more natural to keep those settings persistent inside 
the db file?

Thanks,

-Tom
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___________________________________________
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to