The first time I saw sqlite demonstrated at a linux user group, the presenter didn't realize he was using a memory database. I had to explain why all his work was lost, then proceeded to continue the demo since I knew more about the product. (This was years ago, I think we were still at sqlite 2 at the time.)
Personally, I don't like the idea of a default db. I would rather see a warning message sent to the console if no filename was specified saying that data is being saved in memory and will be lost on exit. And perhaps suggesting how to open a file if that is how they want to proceed. I really don't like a bizarre solution that has sqlite3.exe or (sqlite3 on linux/mac) behaving differently between a double click or from the command line. That just seems wrong to me. David -------------------------------------------- On Mon, 2/10/14, Stephan Beal <sgb...@googlemail.com> wrote: Subject: Re: [sqlite] Proposed enhancement to the sqlite3.exe command-line shell To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Monday, February 10, 2014, 10:46 AM On Mon, Feb 10, 2014 at 4:41 PM, Simon Slavin <slav...@bigfraud.org> wrote: > Why ? I suspect some Mac user would find it just as useful. And then why > leave Unix users out ? > Speaking as a member of the Unix-only crowd: please don't! While i admit that the current behaviour has caused minor amounts of annoyance on my part (my own fault, as i've been using it long enough to know better), i also feel that the current behaviour is "correct." i think it's an interesting idea for Windows, though. Don't have an opinion on Apple installations. If it could be configured via environment variable, i'd be happy to see it in Unix, too. e.g. SQLITE3_DEFAULT_DB, if set to a non-empty string, would be the db which gets automatically opened at startup IFF 1==argc (or some similar heuristic - maybe always load it if no filename args are provided). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users