On 2014/02/10 18:22, John McKown wrote:
Being a UNIX (Linux) partisan, and somewhat tacky towards Windows users, why not go the normal Windows route of having a "pop up" dialog box (or at least a message) similar to what normal Windows applications say about possible loss of data. Something along the lines of "You are exiting sqlite3, but there is data in one or more memory resident tables which will be lost. Proceed (Y or N)?"
Being a Windows partisan and somewhat untacky to downright loving of all other systems and uses, allow me to explain the way Windows works quickly - it has a kernel which runs services and programs, just like unix/linux/etc, and then it has a very standardized very elaborate graphical user interface system which attaches graphical areas (commonly known as "Forms") to underlying processes - much like OSX etc.
Running a process as a command-line or shell process means it can be really lightweight and devoid of any of the mentioned graphical user-interfacy stuff, with the added benefit that, a few specific adaptations aside, you can use much the same C codebase to make it run on linux or whatever else, much like the discussed slite3 tool. As such, attaching a pop-up anything to the process requires it to have evolved into a GUI-supporting system so it has parent windows to have the popped-up handles attached to - a change which is simple, but would see the exe auto-double in size. So to answer your suggestion - no, that's not a good idea.
To further this point, there must be a quadrillion free full graphical-interface SQLite tools on every OS out there... why on earth do students not simply use any of those?
FWIW, my vote goes with the current mainstream opinion, leave as is, warn when quitting, possibly provide a .save command. Forcing the shell-window closed (Alt-F4, Click close, Alt-SPACE->C, Task manager, whatever) will steal any opportunity for ever having a warning of any kind - but then, this is true for any other shell tool, why would it be a special requirement for sqlite3.exe? I don't think anybody would expect to have their DB saved if they forcibly shutdown ANY app, only when exiting normally, one should be at least warned of a potential loss.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
