When I first started using SQlite, I just installed the DBD Perl module and then I found a manager plug-n for Firefox that worked so well that I haven't even fiddled with installing any other command line tool. There are some rough edges on this thing, but its not bad. Might try it to get another view of what you have created (there's a pretty nice graphical display for that). You probably have not created what you thought that you created.