Home > Database, Rules of software design > Remember the Ctrl-S shortcut, Keep it Holy

Remember the Ctrl-S shortcut, Keep it Holy

I’ve been using an old (really old now that I think about it) SQLite GUI simply called SQLite Administrator for years. It’s light, retro-compatible with SQLite2, and does the basics of what one wants out of an SQLite GUI:

  • List tables
  • Table (and triggers, indexes, views) edition/creation GUI
  • On the fly queries
  • Export to CSV

If you’ve used Windows enough in the last 15 years, you know Ctrl-S means save. Across dozens of programs. If for some reason there is no save function, Ctrl-S is rarely used.

SQLite Administrator broke holy law (besides being pissy about large integers and dates) by mapping Ctrl-S (undocumented) as clear screen (and of the no undo variety).

Now trying SQLiteStudio.

  1. 2011-02-03 at 1:33 pm

    This is the old Microsoft trick. Change all of the commands around and call the new version “better”, “easier”, “more intuitive”. How many different menus and key commands have you forgotten in the past 2 decades?
    {I still remember to reveal codes in Word Perfect.}

    • MPelletier
      2011-02-03 at 1:43 pm

      Exactly. But even Microsoft keeps a few basic ones nowadays like Ctrl-S, Ctrl-Z, Ctrl-P, and Alt-F4. It might not be democratic, but at least it’s standard nowadays.

  2. 2014-03-03 at 1:28 am

    Thanks for mentioning SQLiteStudio! I got so fed up using SQLite Administrator and losing my work that I searched the web to see if anyone else has had this problem and stumbled across your post. I’m glad to see I’m not alone. SQLiteStudio looks a lot better, and I’ll be using it from now on.

  3. MPelletier
    2014-03-03 at 8:27 am

    You’re welcome Zach. I settled with Singular SQLite Explorer, which is simple yet powerful.

  4. thedude
    2014-04-14 at 12:40 pm

    Found this page after noticing SQLite Administrator shows large integers as zero on my computer. Glad I’m not the only one!

    • MPelletier
      2014-04-14 at 12:49 pm

      You can add 0 (MyColumn+0) to fool SQLite Administrator into displaying big numbers properly.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: