Precompiled Binaries for Mac OS X (x86) sqlite-tools-osx-x.zip (1.29 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3analyzer program. Summary: in this tutorial, you will learn step by step on how to download and use the SQLite tools to your computer. Download SQLite tools. To download SQLite, you open the download page of the SQlite official website. At the time of this writing, the latest version is sqlite-jdbc-3.27.2.1.jar. The JAR file includes both Java class files and SQLite binaries for Mac OX S, Linux, and Windows, Both 32-bit and 64-bit. SQLite connection strings. The SQLite JDBC driver allows you to load an SQLite database from the file system using the following connection string. The SQLite file format is stable, cross-platform, and backwards compatible and the developers pledge to keep it that way through at least the year 2050. SQLite database files are commonly used as containers to transfer rich content between systems and as a long-term archival format for data.
Active3 years, 3 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.
Jonas48.5k8888 gold badges246246 silver badges323323 bronze badges
TeifionTeifion45.7k7474 gold badges147147 silver badges188188 bronze badges
closed as off-topic by Taryn♦Mar 31 '14 at 17:44
Download simatic manager v5.5. 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
15 Answers
finnwfinnw39.2k1717 gold badges127127 silver badges204204 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
65.1k2020 gold badges104104 silver badges132132 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.
JoonyJoony4,01022 gold badges2424 silver badges3737 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.
KyleKyle8,3342424 gold badges117117 silver badges219219 bronze badges
MesaSQLite is the best I've found so far.
Looks very promising indeed.
Michael Krelin - hacker98.7k1414 gold badges171171 silver badges161161 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 Turner3,60311 gold badge1717 silver badges2525 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
Sqlite For Mac Tutorial
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öhler110k3232 gold badges215215 silver badges292292 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.
Explore interactive family trees, the map of #Westeros and more on the @GameofThrones Viewer’s Guide. Game of Thrones Viewer's Guide - Season 6, Episode 10 Enter the world of Game of Thrones with official maps of the Seven Kingdoms and interactive family trees that capture the rich backgrounds of the characters and locations featured in the. Jun 26, 2016 Spoilers through Season 6 of 'Game of Thrones' follow. Jon Snow is King in the North (Credit: HBO) Sunday night's episode of Game of Thrones exceeded every single one of my expectations. Stream Season 6 Episode 10 of Game of Thrones: The Winds of Winter online or on your device plus recaps, previews, and other clips. Dive deeper into the episode The Winds of Winter. Jun 25, 2016 Game of Thrones Season 6, Episode 10 live stream: Watch online Last week on Game of Thrones, Sansa and Jon reclaimed Winterfell from the Boltons, meaning that a Stark is officially in charge of the. Game of thrones season 6 episode 10.
Mike HoustonMike Houston5,81822 gold badges2929 silver badges4242 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
NycenNycen12.2k99 gold badges5454 silver badges7373 bronze badges
Try this SQLite Database Browser
See full document here.This is very simple and fast database browser for SQLite.
Bhavin_mBhavin_m1,95433 gold badges2121 silver badges4646 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.
HagelinHagelin10.5k55 gold badges2626 silver badges3737 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 Decidua4,29722 gold badges2727 silver badges2929 bronze badges
sth175k4444 gold badges252252 silver badges338338 bronze badges
Akintayo A. Olusegun