Monday, April 14, 2008

SQLiteManager 3.0 (part 2)

The new Script Editor:

posted by Marco Bambini at 2:31 PM

Del.icio.us | Digg it | Furl | ma.gnolia | Spurl | Yahoo MyWeb

9 Comments:

  • Hello

    Will there be a Linux Version ?

    Stefan Cyrus, Germany

    By Anonymous Stefan Cyrus, at 9:18 AM  

  • No I am sorry Stefan, just Mac and Windows.

    By Blogger Marco Bambini, at 9:21 AM  

  • Any chance of building into SQLite Manage 3 the ability to delete a redundant column from a table?

    By Anonymous Jack Allen, at 5:20 PM  

  • Jack, I am not sure to understand what you mean...

    By Blogger Marco Bambini, at 10:50 AM  

  • This looks like a really useful feature. Great stuff Stefan.

    By Anonymous Simon Wolf, at 11:37 AM  

  • Hi,

    Are you planning to allow reordering of columns and editing of existing columns (If I recall correctly, the latter is not possible in v2)

    Also, will you implement auto-generation of triggers to simulate FK constraints?

    Thanks
    Jean-Yves

    By Anonymous Anonymous, at 5:59 PM  

  • Editing of existing columns will be supported, I am not sure right now about reordering.
    Auto-generation of triggers to simulate FK constraints will be supported with the new RBScript support.

    By Blogger Marco Bambini, at 8:35 AM  

  • Sorry about the delay in replying. Haven't checked for a while.
    I ask about deleting existing columns from a database. What I mean is ..
    You have an application and you add some new features to it. This update means that one or more columns in the database are now redundant. As things stand you either live with the redundant columns or you delete the table (and lose the data) and re-build it or you write a conversion program.
    I can't see why SQLiteManager does not allow you to delete those columns and lose the data associated with them. This is particularly important during initial development when the design is still a bit fluid.
    Obviously as the designer / programmer its my responsibility to make sure I know what I'm doing.
    I want SQLiteManager to allow me to delete these columns and then Vacuum can remove the data associated with them.
    Does this make sense now?
    Jack

    By Anonymous Jack Allen, at 5:22 PM  

  • Yes Jack, the next version will support the feature you requested.

    By Blogger Marco Bambini, at 9:16 AM  

Post a Comment

<< Home