Sqlite Tool For Mac

Active3 months ago

What is the best SQLite administrator for iPhone SQLite databases?

Could you get to app databases with and admin on the phone?

SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve. When you download SQLite and build it on a stock Mac OS X system, the sqlite tool has a. DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers. Free Open Source Mac Windows Linux BSD PortableApps.com.

OlavOlav

8204 gold badges20 silver badges45 bronze badges

closed as not constructive by Brian, luvieere, bmargulies, ughoavgfhw, Paŭlo EbermannSep 14 '11 at 23:47

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

See this list in the official documentation:

halfer

15.3k7 gold badges63 silver badges128 bronze badges

Berry TsakalaBerry Tsakala

4,8798 gold badges43 silver badges61 bronze badges

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged sqlite or ask your own question.

Active3 years, 2 months ago

I am aware of CocoaMySQL but I have not seen a Mac GUI for SQLite, is there one?

My Google search didn't turn up any Mac related GUI's which is why I'm asking here rather than Google.

Jonas

48.3k88 gold badges246 silver badges323 bronze badges

TeifionTeifion

45.5k73 gold badges147 silver badges187 bronze badges

closed as off-topic by Taryn♦Mar 31 '14 at 17:44

This question appears to be off-topic. The users who voted to close gave this specific reason:

'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – Taryn

If this question can be reworded to fit the rules in the help center, please edit the question.

15 Answers

finnwfinnw

39.1k17 gold badges126 silver badges204 bronze badges

Base is younger than your question, and definitely feels like a 1.0, but the user experience is miles better than the experience of using any of the 'cross-platform' apps on a Mac.

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.

ANOTHER UPDATE: Base is available on the Mac App Store, you may find it useful to read the reviews there.

benzadobenzado

64.8k20 gold badges102 silver badges132 bronze badges

I use Liya from 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).

I also test a lot on the device. You can access the SQLITE database on the device by:

Add Application supports iTunes file sharing to 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

You can also edit it and copy it back.

EDIT:You can also do this through the Organizer in XCode

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'

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.

JoonyJoony

3,9902 gold badges23 silver badges37 bronze badges

You may like SQLPro for SQLite (previously 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.

There is a seven day trial available via the website. If you purchase via our website, use the promo code STACK25 to save 25%.

Disclaimer: I'm the developer.

KyleKyle

8,32424 gold badges117 silver badges219 bronze badges

MesaSQLite is the best I've found so far.

Looks very promising indeed.

Michael Krelin - hacker

97.8k14 gold badges170 silver badges161 bronze badges

Woz

I am using simple tool for basic sqlite operation called Lita

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.

krishnakrishna

That FireFox extension looks pretty nice. I've used SQLite Browser in the past and it did the job.

Bill TurnerBill Turner

3,6031 gold badge16 silver badges25 bronze badges

I've published instructions for how to run the Firefox SQLite Manager outside 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.

Jeremy EdgellJeremy Edgell

Take a look on a free tool - Valentina Studio. Amazing product! IMO this is the best manager for SQLite for all platforms:

Also it works on Mac OS X, you can install Valentina Studio (FREE) directly from Mac App Store:

Radim Köhler

110k32 gold badges212 silver badges290 bronze badges

jorjejorje

Sqliteman is my current preference: It uses QT, so it's cross-platform. Since I develop on Windows, Linux and OS X, it helps to have the same tools available on each.

I also tried SQLite Admin (Windows, so irrelevant to the question anyway) for a while, but it seems unmaintained these days, and has the most annoying hotkeys of any application I've ever used - Ctrl-S clears the current query, with no hope of undo.

Mike HoustonMike Houston

5,7832 gold badges29 silver badges42 bronze badges

There is also Induction app (http://inductionapp.com/), which is free & open source (https://github.com/Induction/Induction).

Just drag & drop your .sqlite file on the icon to open the file.

And the other great option is https://github.com/yepher/CoreDataUtility

NycenNycen

12.1k9 gold badges54 silver badges73 bronze badges

Try this SQLite Database Browser

See full document here.This is very simple and fast database browser for SQLite.

Bhavin_mBhavin_m

1,9443 gold badges21 silver badges46 bronze badges

Try a versiontracker search instead. SqliteManager from SQLabs ($49, Mac & Windows) is the one I prefer, but I haven't really evaluated the other alternatives.

HagelinHagelin

10.5k5 gold badges25 silver badges37 bronze badges

You may try Navicat. It used to have a free 'Lite' version whih is unfortunately not available any more. The pro version supports several important DB engines, not only SQLite. I am currently using the 30-day free eval version.

Laryx DeciduaLaryx Decidua

Snippet Tool For Mac

4,2472 gold badges27 silver badges29 bronze badges

sth

174k44 gold badges252 silver badges338 bronze badges

Akintayo A. Olusegun

Floweromg