Jumping jee-willigers: sqlite3 GUI browser for Windows?
Is there such a thing ? I'd really like to be able to browse my sqlite 3 databases. Can't seem to fin开发者_开发技巧d any useful tools.
You mean a tool like SQLiteAdmin?
I haven't tried it in a while, but there's sqlitecc. Also, there's dbedit2.
You can actually browse SQLite databases with Visual Studio's built-in server explorer. All you need is the free SQLite.NET driver.
Visual Studio 2005/2008 Design-Time Support
You can add a SQLite connection to the Server Explorer, create queries with the query designer, drag-and-drop tables onto a Typed DataSet and more! SQLite's designer works on full editions of Visual Studio 2005/2008, including VS2005 Express Editions. * NEW You can create/edit views, tables, indexes, foreign keys, constraints and triggers interactively within the Visual Studio Server Explorer!
(Works with VS2010 as well.)
Seems like there would be a good one, right? A few months back, I had to use one a lot. Everything I tried (all the free ones I could find) were awful, the least awful being sqliteman (http://sqliteman.com/). It's still pretty bad, though.
I'm using SQLite Maestro. While not free, it's a excellent tool. Also look for SQLite Administrator.
精彩评论