`
慭慭流觞
  • 浏览: 45592 次
  • 性别: Icon_minigender_1
  • 来自: 河南
社区版块
存档分类
最新评论

Which SQLite administration console do you recommend?

    博客分类:
  • iOS
阅读更多

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

 
分享到:
评论

相关推荐

    C#中如何使用Sqlite、SqliCe等本地数据库?

    在C#开发中,有时我们需要使用本地数据库来存储应用程序的数据,SQLite和SqlCe(SQL Server Compact Edition)是两种常见的轻量级本地数据库解决方案。本文将详细介绍如何在C#项目中集成并使用这两种数据库。 首先...

    Lita - SQLite Administration Tool | David Deraedt

    **Lita - SQLite Administration Tool** Lita是一款由David Deraedt开发的SQLite数据库管理工具。SQLite是一个开源的关系型数据库系统,广泛应用于嵌入式设备、移动应用以及各种需要轻量级数据库解决方案的场景。与...

    SQLiteExpert数据库(个人免费版)

    SQLite专家个人版免费,没有截止日期。

    SQLite 免费的,但是只能存很少的数据

    SQLite是一款开源、轻量级的数据库管理系统,常用于嵌入式环境和小型项目,它无需单独的服务器进程,可以直接在应用程序内部使用。标题提到“SQLite免费的,但是只能存很少的数据”,这可能引起了一些误解。实际上,...

    SQLite数据库 sqlitedll库文件 sqlite驱动JAR包 sqlite工具

    在Java下连接SQLite数据库 一、下载SQLite数据库的JDBC:http://www.zentus.com/sqlitejdbc/ 二、将下载到的包解压后得到jar包放到%JAVA_HOME%\lib下,并且将其添加到ClassPath系统环境变量中。一定要保证在类路径...

    SQLite Expert 非常好用的SQLite管理软件(含注册)

    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 ...

    SQLite 安装包 sqlite3 及sqlite数据库jdbc jar包

    SQLite是一种轻量级的、开源的关系型数据库管理系统,它不需要单独的服务器进程,可以直接嵌入到应用程序中使用,因此在移动设备和小型应用系统中非常流行。SQLite3是SQLite的第三个主要版本,提供了更高的性能、...

    sqliteodbc驱动sqlite3

    ### SQLiteODBC 驱动 SQLite3:深入解析与应用指南 #### 一、SQLiteODBC简介 SQLiteODBC是一种连接SQLite数据库与支持ODBC(开放式数据库连接)的应用程序之间的桥梁。通过SQLiteODBC,开发人员可以利用ODBC标准...

    SQLite数据库查看工具(SQLiteBrowser)

    SQLite数据库是一种轻量级、开源的嵌入式关系数据库,广泛应用于移动应用、小型桌面应用以及需要快速存储和检索数据的任何系统。SQLiteBrowser是一款免费且开源的图形用户界面工具,用于浏览、编辑和管理SQLite...

    SQLite.Helper:一个简单的工具,可帮助您使用C#管理SQLite数据库

    ####是否在C#项目中使用SQLite?####如果是,那就不用担心,SQLite.Helper是旨在帮助您管理SQLite数据库的类。 ####如何使用?####首先,请确保在您的系统上。 将DLL添加到您的项目引用中并使用代码 using ...

    SQLite Expert Professional Edition v3.4.64.0 setup+key

    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 ...

    LiteX - SQLite Administration Tool:SQLite管理工具-开源

    LiteX是一款专为SQLite数据库设计的开源管理工具,它提供了丰富的功能来帮助用户高效地管理和维护SQLite数据库。作为一款开源软件, LiteX遵循了开放源代码的原则,允许用户免费使用、修改并分享其源代码,这促进了...

    sqlite3文件(sqlite3.dll,sqlite3.h,sqlite3.lib)

    标题提到的"sqlite3文件"主要包括三个关键组成部分:`sqlite3.dll`、`sqlite3.h`和`sqlite3.lib`,它们在开发和运行使用SQLite3的应用程序时起着至关重要的作用。 1. `sqlite3.dll`: 这是一个动态链接库文件,通常...

    js连接sqlite代码

    在JavaScript中连接SQLite,我们可以借助一些库来实现,这通常涉及到Node.js环境,因为浏览器端的安全策略限制了对本地文件系统的直接访问,包括SQLite数据库。 在给定的文件中,我们有两个JavaScript文件:sqlite....

    sqlite_console

    自述 此自述文件通常会记录启动和运行应用程序所需的任何步骤。 您可能想要涵盖的内容: Ruby版系统依赖配置数据库创建数据库初始化如何运行测试套件服务(作业队列、缓存服务器、搜索引擎等) 部署说明… 如果您不...

    sqlite3在Visual studio 2012下的编译

    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 ...

    Delphi使用ASqlite3 连接SQLite上例子

    在IT行业中,数据库管理是至关重要的,而SQLite作为一款轻量级、自包含的数据库引擎,因其高效性和易用性而被广泛应用。本教程将详细讲解如何在Delphi环境中使用ASqlite3控件连接并操作SQLite数据库。ASqlite3是一款...

    Inside SQLite(SQLite技术内幕) 原版+个人翻译版

    SQLite是一款开源、轻量级的嵌入式数据库引擎,它被广泛应用于移动设备、桌面系统以及Web应用程序。作为一款自包含、无服务器、零配置、事务性的SQL数据库,SQLite具有高度的可移植性和可靠性,无需数据库管理员即可...

    sqlite3.h、sqlite3.lib、sqlite3.dll

    在本主题中,我们关注的是SQLite的核心组件——`sqlite3.h`、`sqlite3.lib`和`sqlite3.dll`,这些是开发过程中用于与SQLite交互的关键文件。 1. **sqlite3.h**: 这是一个头文件,包含了SQLite的所有公共API(应用...

Global site tag (gtag.js) - Google Analytics