mrinal.kant wrote:CanyonCasa wrote:Add a DB Setting to not require all the confirmations.
please give examples of the confirmations not already covered under preferences (general menu -> options)
I am referring to the confirmation dialogs for all actions such as "Are you sure you want to create table..." Since DB actions occur in real time user's should backup the DB before doing anything at all.
Along those lines, under "When SQLite Manager starts..." it would be useful to have an auto backup option that copies the DB to a timestamped backup.
mrinal.kant wrote:CanyonCasa wrote:In the Create Table dialog, the "Data Type" list should include DATETIME, ENUM, and BLOB types.
added DATETIME and BLOB types in version 0.2.15. For ENUM, read below.
...
AFAIK, there is no ENUM type in sqlite. How do you propose your suggestion should be implemented?
My suggestion is not to add an ENUM type to SQLite, but to simply allow the user to define it for compatibility with other databases. This is equivalent to BLOB since SQLite does not recognize it either, nonetheless a user may define a blob type that other databases recognize on import.
In my example I was simply suggesting building each dropdown list of the "Edit Record" dialog as a unique set of values already entered for each specific column such that the user doesn't have to type all the data for every field.
Optionally, ENUM type could be treated as an affinity to only create unique lists for specific columns, just like integer type is used to cause columns to sort numerically even though SQLite stores the data as strings. This would reduce the time overhead of creating the lists for every column of large databases.