The SQLite table editor RazorSQL allows users to edit database table data in a spreadsheet like format. Users can easily add and remove rows, or edit individual cells. The find / replace tool allows users to quickly find and/or replace text. The edit in new window option allows users to easily edit multi-line text. Download Base - SQLite Editor for macOS 10.8 or later and enjoy it on your Mac. ‎Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. The SQLite table editor RazorSQL allows users to edit database table data in a spreadsheet like format. Users can easily add and remove rows, or edit individual cells. The find / replace tool allows users to quickly find and/or replace text. Navicat for SQLite Enterprise Edition is a powerful database administration and development tool for SQLite. It comes with advanced features such as the Data Modeling Tool, Import/Export, Visual Query Builder, Database Migration, and Batch Job Scheduling.

Active6 years, 9 months ago

I am following a tutorial for Ruby on Rails3. The author types the following which launches sqlite Database Browser and opens the specified database.

What can I do to configure my system to do the same? I am on Mac OSX 10.6

Thanks in advance :)

AhmetB - Google

19.7k28 gold badges91 silver badges158 bronze badges

chellchell

2,45815 gold badges58 silver badges115 bronze badges

3 Answers

On Mac OS X, the command open FILE will perform the same action as double-clicking the file in the Finder. If it is not working, it's because the file type needs to be associated with the application:

Select the file in the Finder.
Select 'Get Info' from the File menu.
In the 'Open with:' section, pick the application you want.
Optionally, click 'Change All..' to use that app for all files with same extension.

Afterward, open will launch that app with that file.

Html Editor For Mac

If you don't want to change the type, you can also tell the open command which app to use:

Type man open to see the manual page which will explain in more detail how it works.

benzadobenzado

64.8k20 gold badges102 silver badges132 bronze badges

Photo Editor For Mac

You can install sqlite3 command line tool from MacPorts or you can download, satisfy dependencies and compile it yourself.

If you have macports installed, execute command

then

to launch command line interface on specified sqlite3 file.

AhmetB - GoogleAhmetB - Google

19.7k28 gold badges91 silver badges158 bronze badges

Download sqlite-shell-osx-x86-3071401.zip from http://www.sqlite.org/download.htmlDouble click the zip, then double click sqlite3.

SQLiteSQLite

3 Answers

Html Editor For Mac

Photo Editor For Mac

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

Sqlite Editor For Mac Sqlite Flow