I've been on a search for a really good Sqlite Admin tool since I started iPhone programming a year ago. I've been mainly using the Firefox Plugin 80-90% or the time and Sqlite Administrator the rest of the time. I decided to do some more searching over the last couple of days and here's my report.
Obviously this is just my opinion so your mileage may vary. I've been a Sql Server programmer for ten years, so my yard stick for tools like this is Query Analyzer/Sql Management Studio, which is a tough hurdle, especially for free tools.
Sqllite Manager Firefox Plugin
Cross Platform, Firefox. This is the Sqlite Tool I've used the most. It's actually really good, especially considering it runs in a browser. It gets updated pretty frequently which is nice. There aren't (at least I can't find) keyboard shortcuts for executing queries. The UI isn't awesome, but it get's the job done. It's got decent import features,( delimited files, sql and xml). No Excel import but you can always save as a CSV file right? If you are importing a big file or querying a lot of data sometimes the script will timeout which may or may not cause issues. Usually you can opt to continue running the script and it sort's itself out eventually. When importing files they seem to be opened fully into memory, and so it often runs out of memory and stops the import even on files in the region of tens of megabytes.
Sqlite Administrator
Windows Client, Free When I need to do more in the way of writing complex queries or db design, I'll use Sqlite Administrator. The query results grid is kind of weird as it tends to expand small columns so most of you data get's pushed off the side of the window. And I still have no idea what is going on with the "Edit Data" tab. Can import very large files as it reads them line by line rather than opening the entire file into memory. Importing can be slow though.
SqlLiteSpy,Windows, Free
While it doesn't have any import features that I could find, SqlSpy looks like a nice solid query tool and it's free. This may replace Sqlite Admin for me. I'm going to spend some more time with it. Is a self-contained, stand-alone executable.
SqlMaestro Windows $79 non commercial $139 commercial
This tool has a nice UI but it's really pricey. The extra tools it gives you above the free applications, like Blob Viewer, and Query build I don't really need. The Import Tool is backwards IMO. You have to create the table /before/ you could import a csv or xls file which is a PITA. That immediately disqualified it as the FF Plugin and Sql Admin do a far better job at importing for free.
Sqlabs Sqlite Manager Win/Mac $49 for one or $79 for dual platform license.
I was excited when I saw,Sqlabs SqlManager. It's a paid app but it has an OSX and Windows version. Both of which look really pretty UI-wise but the utility isn't there for a paid app. There are no import features I can find. When you are on the Sql Editor Panel you cannot see the table list which is a fail. It's got a query builder, but I never use those things. On the plus side it has Analysis and Optimization tools which could be useful. The demo is overly limiting so it's hard to get a good feel for it.
RazorSql Windows, OS X, Linux $69.95
After taking Razor for a spin I was fairly impressed. It works with a ton of db's other than Sqlite. The query editor is pretty good. The Import feature is backwards like Sqlmaestro, where it won't create the imported table for you, you have to do it ahead of time. It's a cross platform java app so the UI is a little sluggish compared to a native app and has that Java look and feel to it. If I were to pay for one of these tools Razor would be it.
In summary I like the free tools the best. I don't mind paying for a programming tool if it's worth it, but these paid tools are all lacking in some important respect. They just didn't bring enough to the table above and beyond what the free tools do to justify the price. The one I'd be most likely to pay for is Razor Sql, though it needs a better import tool .Sqlabs Sql Manager has promise, I'll keep an eye one that in the future, if it improves its query editor it might get my money.
It looks like the FF Plugin is going to continue to be my primary Sqlite Tool, though I'm going to put SqlSpy in the line up and finish up the RazorSql demo
A big list of Sqlite tools can be found here, Sqlite management Tools. If anybody finds some gems in that list, please post a quick review in this thread.
Update 8/16/10
I was doing quite a bit of work with some messy data, so I finally broke down an purchased RazorSql. I've been pretty happy with it.
Good editor. Good syntax highlighting. Allows for executing all or 1 statement within an editor window. Tabbed editor windows. Import is improved. Result set export is decent. Copy a result set and paste into Excel with C,V.
If you aren't doing major work the FF plugin is great. However if you are going to be spending hours at a time working in Sqlite the $70 could be money well spent for you. It saved my sanity.
see:http://stackoverflow.com/questions/835069/which-sqlite-administration-console-do-you-recommend
相关推荐
sqlite3数据库中时间字段的定义格式:Sqlite没有另外为存储日期和时间设定一个存储类集,内置的sqlite日期和时间函数能够将日期和时间以TEXT,REAL或INTEGER形式存放
对应文章地址:https://blog.csdn.net/mazhiyuan1981/article/details/109223031
sqlite的aes128、aes256、sqleet、sqlcipher、rc4等加密方式例子
SQLiteProxy一个用于SQLite的简单HTTP JSON代理
好不容易从英文网站下了个,可是只有swf文件,没找到怎么运行,自己添了个.exe来解决下问题,现在可以用了。
SQLite专家个人版免费,没有截止日期。
To do that, when you're creating the project and you get to the "Win32 Application Wizard", choose "Console Application" instead of "DLL". Then, when you are adding files to the project, also add ...
####是否在C#项目中使用SQLite?####如果是,那就不用担心,SQLite.Helper是旨在帮助您管理SQLite数据库的类。 ####如何使用?####首先,请确保在您的系统上。 将DLL添加到您的项目引用中并使用代码 using ...
在Java下连接SQLite数据库 一、下载SQLite数据库的JDBC:http://www.zentus.com/sqlitejdbc/ 二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下,并且将其添加到ClassPath系统环境变量中。一定要保证在类路径...
SQLite Expert: A powerful administration tool for your SQLite databases Are you developing SQLite3 databases and need an easy and powerful tool? SQLite Expert is the perfect choice. It is the most ...
This book starts with the architecture of SQLite database and introduces you to concepts in SQL . You will find yourself equipped to design your own database system, administer it, and maintain it. ...
SQLite Expert: A powerful administration tool for your SQLite databases Are you developing SQLite3 databases and need an easy and powerful tool? SQLite Expert is the perfect choice. It is the most ...
自述 此自述文件通常会记录启动和运行应用程序所需的任何步骤。 您可能想要涵盖的内容: Ruby版系统依赖配置数据库创建数据库初始化如何运行测试套件服务(作业队列、缓存服务器、搜索引擎等) 部署说明… 如果您不...
SQLite 学生专用免费版,只是为了体现,如果要很大存储空间的,需要自己去官网上买一个。毕竟这个只是免费得。
本文实例讲述了C#解决SQlite并发异常问题的方法。分享给大家供大家参考,具体如下: 使用C#访问sqlite时,常会遇到多线程并发导致SQLITE数据库损坏的问题。 SQLite是文件级别的数据库,其锁也是文件级别的:多个线程...
SQLite.Interop.dll for sqlite expert professional 4.2 用与SQLite Expert打开本地已加密的数据库的插件。适用32位和64位。 1.直接将下载的文件复制到SQLite Expert安装路径(如:c:\Program Files (x86)\SQLite ...
一些小型的应用程序需要使用到数据库,sqlite可以说是最好的选择。这里个人整理了一般简单通用的操作类SQLiteHelper
Chapter 5: Using SQLite Features—What You Can Do with SELECT Statements Chapter 6: Using SQLite with PHP Chapter 7: Using SQLite with Android/Java Chapter 8: Using SQLite with Core Data (iOS and OS X...
SQLite 安装包 sqlite3 及sqlite数据库jdbc jar包 2分不能再少了
gcc使用的sqlite3数据库,sqlite3.a ,可以用于Dev-C++,也可以用于Windows下使用gcc编译的程序,sqlite版本是:3270200,还包含了sqlite3.lib库文件,可以用于visual studio。