Hello there, I hope this isn't going to too wide a dist-list. If it is, let me apologise now. Sorry ;-)
I needed to write a read-only viewer for SQLite. It's intention is to allow my "power users" to see the various tables, triggers and views but not be able to do anything with them. I know there are other ways to do this (ie it's not 100% secure), but the general principle is to give them the entry point to the tables and data that they need. In an attempt to give something back to the open-source world, I thought I'd put it on the net for all to review. http://code.google.com/p/lonedev/downloads/list You need to have Java 1.6 (although Java 1.5 may work). I've also only tested this on Windows (hence the batch file), but you should be able to add a similar startup script on Linux/Unix/MacOS etc. You can right-click on tables and views and select "View Data" to see tthe data. You can also see the sql "dump" of the schema by right-clicking the "Database" root tree and selecting "Dump Schema" will need "sqlite3" to be in your path for this to work though. Indeed, I have only tested this with SQLite3 databases, so there might be some strangeness going on with various versions. I'm by no means an SQLite expert, and would love genuine feedback on the user experience and how you think it could be improved. Thanks for listening, and I once again apologise if this has just annoyed thousands of people. Cheers Richard _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users