Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    27

    Testing of db schema

    I'm in the beginning stages of writing (and learning as I go) a Python database app using SQLite.

    I have the db structure planned on paper, and I have the queries I'll need in mind, but before I start coding I want to fully test the db design so I know it's right and ready.

    What's the best free software to use to test the db structure quickly?
    Last edited by CVD; 05-08-10 at 23:09.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Test it for what?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Apr 2008
    Location
    Bangalore, India
    Posts
    27
    If you mean testing the schema and keys/triggers stuff. You can pick any visual tool like dbvis, sqlyog that connect straight away to the db backend and you can run the ddl/queries. As for feeding in sample data you'll need to write those scripts yourself, I'm not aware of any freeware data test tools.

    Otherwise I dont understand what you want to test.
    --
    Girish.B
    Lytecube.com
    code free application environments

  4. #4
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by CVD View Post
    I'm in the beginning stages of writing (and learning as I go) a Python database app using SQLite.

    I have the db structure planned on paper, and I have the queries I'll need in mind, but before I start coding I want to fully test the db design so I know it's right and ready.

    What's the best free software to use to test the db structure quickly?
    Python is. You can simply start up python, import a few modules, and start typing commands straight into the interpreter.

    You've got a rough idea of what your app needs to do, all you need to do is actually step through it and see what you get.

    You can then copy and paste that session into a file (even interspersed through your code) and use the doctest module to rerun it on demand, and highlight any unexpected results.

    This way, if you make a small change to your schema, you have a suite of tests that can tell you what broke and needs to be updated. I find this is a great way to move from paper to actual code.

    Incidentally, there is a Perl section here and if you'd like to have a Python section on this forum, you might lobby the admins to add one.

  5. #5
    Join Date
    Apr 2008
    Posts
    27
    Thanks sco08y.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •