Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Tom Browder
On Wed, Apr 3, 2019 at 06:57 R Smith wrote: > Hi Tom, ... > About the CLI - It's a very useful piece of toolkit, but it's intent is ... > For more usability, there are a few good options in the World from CLI's > to GUI's. I see you already know SQLite studio, some of my favourites > you might

Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Tom Browder
On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > 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. > ... Okay, I agree with all the excellent arguments about NOT keeping

Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Tim Streater
On 03 Apr 2019, at 11:52, Tom Browder wrote: > 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

Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread R Smith
Hi Tom, The settings you mention, such as .headers and .mode (along with a slew of others) are usability settings contained in the Command-Line facility (the CLI) offered by the makers of SQLite. It is however by far not the only such interface, nor is it in any way related to the data in

Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Rob Willett
Tom, Because the file is the database, your preferences for how things are displayed are just that, your preferences. Don't combine the two. If you have two users with different preferences, who wins? We move the SQLite database around all the time, across different servers. We do not want

Re: [sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Tom Browder
On Wed, Apr 3, 2019 at 05:52 Tom Browder wrote: > 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

[sqlite] Why no persistent user settings in a database file?

2019-04-03 Thread Tom Browder
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