Mac SQLite editor

Question

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

User · Answer

There is also Induction app  http   inductionapp com    which is free  amp  open source  https   github com Induction Induction    Just drag  amp  drop your  sqlite file on the icon to open the file   And the other great option is https   github com yepher CoreDataUtility

User · Answer

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

User · Answer

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

User · Answer

Take a look on a free tool - Valentina Studio  Amazing product   IMO this is the best manager for SQLite for all platforms    http   www valentina-db com en valentina-studio-overview    Also it works on Mac OS X  you can install Valentina Studio  FREE  directly from Mac App Store      https   itunes apple com us app valentina-studio id604825918 ls 1 amp mt 12

User · Answer

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   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   ANOTHER UPDATE  Base is available on the Mac App Store  you may find it useful to read the reviews there

User · Answer

Try a versiontracker search instead  SqliteManager from SQLabs   49  Mac  amp  Windows  is the one I prefer  but I haven t really evaluated the other alternatives

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

Try this SQLite Database Browser  See full document here  This is very simple and fast database browser for SQLite

User · Answer

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   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   ANOTHER UPDATE  Base is available on the Mac App Store  you may find it useful to read the reviews there

User · Answer

SQLite Manager for FireFox

User · Answer

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

User · Answer

MesaSQLite is the best I ve found so far   www desertsandsoftware com  Looks very promising indeed

User · Answer

Razorsql can handle many kinds of databases

User · Answer

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

[macos] Mac SQLite editor

Examples related to macos

Examples related to user-interface

Examples related to sqlite