macos Mac SQLite 编辑器
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/100959/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Mac SQLite editor
提问by Teifion
I am aware of CocoaMySQLbut I have not seen a Mac GUI for SQLite, is there one?
我知道CocoaMySQL，但我还没有看到 SQLite 的 Mac GUI，有吗？
My Google search didn't turn up any Mac related GUI's which is why I'm asking here rather than Google.
我的谷歌搜索没有出现任何与 Mac 相关的 GUI，这就是为什么我在这里问而不是谷歌。
采纳答案by finnw
回答by benzado
Baseis younger than your question, and definitely feels like a 1.0, but the user experience is milesbetter than the experience of using any of the "cross-platform" apps on a Mac.
Base比您的问题更年轻，绝对感觉像是 1.0，但用户体验比在 Mac 上使用任何“跨平台”应用程序的体验要好几英里。
http://menial.co.uk/software/base/
http://menial.co.uk/software/base/
I recommend you buy a license before the developer realizes he is charging too little for it.
我建议您在开发人员意识到他收取的费用太少之前购买许可证。
UPDATE: Since December 2008, Base is now up to version 2.1, it has become an excellent product. I don't remember what it used to cost, but I paid for the 1.x to 2.x upgrade. Still highly recommended.
更新：自 2008 年 12 月以来，Base 现已升级到 2.1 版本，它已成为一款出色的产品。我不记得以前的成本是多少，但我支付了 1.x 到 2.x 的升级费用。还是非常推荐的。
ANOTHER UPDATE: Base is available on the Mac App Store, you may find it useful to read the reviews there.
另一个更新：Base 在 Mac App Store 上可用，您可能会发现阅读那里的评论很有用。
回答by Joony
I use Liyafrom the Mac App Store, it's free, does the job, and the project is maintained (a month or so between updates as of Jan 2013).
我使用Mac App Store 中的Liya，它是免费的，可以完成工作，并且项目得到维护（截至 2013 年 1 月，更新间隔一个月左右）。
I also test a lot on the device. You can access the SQLITE database on the device by:
我也在设备上测试了很多。您可以通过以下方式访问设备上的 SQLITE 数据库：
- Add
Application supports iTunes file sharingto the info.plist and setting it to YES - Running the app on a device
- Open iTunes
- Select the device
- Select the "Apps" tab
- Scroll down to the "File Sharing" section and select the app
- The .sqlite file should appear in the right hand pane - select it and "Save to..."
- Once it's saved open it up in your favourite SQLITE editor
- 添加
Application supports iTunes file sharing到 info.plist 并将其设置为 YES - 在设备上运行应用程序
- 打开 iTunes
- 选择设备
- 选择“应用程序”选项卡
- 向下滚动到“文件共享”部分并选择应用程序
- .sqlite 文件应出现在右侧窗格中 - 选择它并“保存到...”
- 保存后在您最喜欢的 SQLITE 编辑器中打开它
You can also edit it and copy it back.
您也可以编辑它并将其复制回来。
EDIT: You can also do this through the Organizer in XCode
编辑：您也可以通过 XCode 中的 Organizer 执行此操作
- Open the Organizer in XCode (Window > Organiser)
- Select the "Devices" tab
- Expand the device on the left that you want to download/upload data to
- Select Applications
- Select an Application in the main panel
- The panel at the bottom (Data files in Sandbox) will update with all the files within that application
- Choose Download and save it somewhere
- Find the file in Finder
- Right click and select "Show Package Contents"
- 在 XCode 中打开管理器（窗口 > 管理器）
- 选择“设备”选项卡
- 展开左侧要下载/上传数据的设备
- 选择应用
- 在主面板中选择一个应用程序
- 底部的面板（沙盒中的数据文件）将更新该应用程序中的所有文件
- 选择下载并将其保存在某处
- 在 Finder 中查找文件
- 右键单击并选择“显示包内容”
You can now view, edit, and re-upload the package to your debug device. This can be really handy for keeping snapshots of different states to try out on other devices.
您现在可以查看、编辑包并将其重新上传到您的调试设备。这对于保存不同状态的快照以在其他设备上试用非常方便。
回答by Kyle
You may like SQLPro for SQLite(previously SQLite Professional - App Store).
您可能喜欢SQLPro for SQLite（以前是 SQLite Professional - App Store）。
The app has a few neat features such as:
该应用程序具有一些简洁的功能，例如：
- Auto-completion and syntax highlighting.
- Versions Integration (rollback to previous versions).
- Inline data filtering.
- The ability to load sqlite extensions.
- SQLite 2 Compatibility.
- Exporting options to CSV, JSON, XML and MySQL.
- Importing from CSV, JSON or XML.
- Column reordering.
- Full screen support.
- 自动完成和语法高亮。
- 版本集成（回滚到以前的版本）。
- 内联数据过滤。
- 加载sqlite 扩展的能力。
- SQLite 2 兼容性。
- 将选项导出到 CSV、JSON、XML 和 MySQL。
- 从 CSV、JSON 或 XML 导入。
- 列重新排序。
- 全屏支持。
There is a seven day trial available via the website. If you purchase via our website, use the promo code STACK25to save 25%.
该网站提供 7 天试用期。如果您通过我们的网站购买，使用促销代码STACK25可节省 25%。
Disclaimer: I'm the developer.
免责声明：我是开发人员。
回答by Kyle
MesaSQLite is the best I've found so far.
MesaSQLite 是迄今为止我发现的最好的。
Looks very promising indeed.
看起来确实很有前途。
回答by krishna
I am using simple tool for basic sqlite operation called Lita
我正在使用名为Lita 的简单工具进行基本的 SQLite 操作
This tool is based on Adobe Air so that must be installed prior to use of Lita. Adobe air can be downloaded for free from Adobe site.
此工具基于 Adobe Air，因此必须在使用 Lita 之前安装。Adobe air 可以从Adobe 网站免费下载。
回答by Bill Turner
That FireFox extension looks pretty nice. I've used SQLite Browserin the past and it did the job.
FireFox 扩展看起来很不错。我过去使用过SQLite 浏览器，它完成了这项工作。
回答by Jeremy Edgell
I've published instructions for how to run the Firefox SQLite Manageroutside of Firefox, since FF hase become so bloated in the last few releases. It's really easy and I've even compiled a DMG for the sqlite gui if anyone wants it.
我已经发布了有关如何在Firefox之外运行Firefox SQLite 管理器的说明，因为 FF 在最近的几个版本中变得如此臃肿。这真的很容易，如果有人想要的话，我什至为 sqlite gui 编译了一个 DMG。
回答by jorje
Take a look on a free tool - Valentina Studio. Amazing product! IMO this is the best manager for SQLite for all platforms:
看看免费工具 - Valentina Studio。惊人的产品！IMO 这是适用于所有平台的 SQLite 的最佳管理器：
Also it works on Mac OS X, you can install Valentina Studio (FREE) directly from Mac App Store:
它也适用于 Mac OS X，您可以直接从 Mac App Store 安装 Valentina Studio（免费）：
回答by Nycen
There is also Induction app (http://inductionapp.com/), which is free & open source (https://github.com/Induction/Induction).
还有 Induction 应用程序 ( http://inductionapp.com/)，它是免费和开源的 ( https://github.com/Induction/Induction)。
Just drag & drop your .sqlite file on the icon to open the file.
只需将您的 .sqlite 文件拖放到图标上即可打开该文件。
And the other great option is https://github.com/yepher/CoreDataUtility
