Base - SQLite Editor 4+

The SQLite Editor

Menial

    • 3.4 • 12 Ratings
    • $19.99

Screenshots

Description

Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.

Base starts with all the basic features you need:
• Schema viewing
• Table contents viewing/editing
• Custom SQL queries
• Command logging

Then makes it all even better:
• Support for viewing and editing ALL column- and table-level constraints. From simple default values, to complex foreign keys, Base can handle it.

• Advanced table designing and altering. No need to manually type CREATE TABLE statements, from a single sheet you can add, edit and remove columns & constraints to your heart's content, maintaining or moving the original data within them.

• Quick data find & filter. Build lengthy SELECT statements with a few clicks, previewing results as you go.

• Easy SQL editing, with clear syntax highlighting and useful SQL autocompletion

• Store your commonly used SQL as snippets for easy re-use later

• Easy import, comprehensive export. Bring in data from CSV or SQL files. Export to SQL, delimited text, XML or Microsoft Excel-compatible formats.

What’s New

Version 2.5.2

• Fixed a bug where exported SQL files would be empty
• Fixed a bug causing CHECK constraints to not be editable

Ratings and Reviews

3.4 out of 5
12 Ratings

12 Ratings

Vic Krawchuk ,

Can’t reliably edit data in a record

After I open a database, sometimes I can double-click a data record to open an edit window so I can change data, but usually usually I can’t. Double-clicking only selects the text under the mouse as if I’m copy/pasting. It’s very unpredictable. Going through the “Alter” process for the record also does not let me change the data. The SQL database was originally created by the PhatNotes iPhone/iPad app, which is quite old and no longer supported, perhaps this has something to do with this issue? However, other SQL editors I’ve tried on MacOS don’t have any trouble accessing and modifying record data in this database. I haven’t tried this function with any other SQL databases. The reason I bought this app was specifically to deal with the above-mentioned iPad/iPhone database, which is critical to me and which I was forced to migrate to MacOS. FYI, I used iFunBox on Windows to retrieve the SQL file from the PhatNotes sandbox on the original iPad, since the data transmission facilities in PhatNotes had stopped working following an iOS upgrade.

Kerri Shotts ,

Latest Version feels Quirky

There's some problems that I've been running into in the latest version that are frustrating to get around. For example, if there's an error in the SQL, the app warns you, but you can't dismiss the dialog, which means you have to quit the entire app. There's abundnant quirkiness when creating tables (field names not being saved, not remembering column attributes); so much so that I finally gave up and did it via commandline.

So it's a nice app for viewing your data and simple interaction, but not for playing around with SQL statements or anything advanced. Which is unfortunate, because I really, really, really like the app.

Pacaya44 ,

Can't import

Purchased this to ease transition from a number of Numbers spreadsheets into SQLite. Every time I try the import function into a New table, it gives and error and aborts. Tried creating a table to match the spreadsheet and import into existing table. Does nothing. Not at all what I was looking for and not worth the price.

App Privacy

The developer, Menial, has not provided details about its privacy practices and handling of data to Apple. For more information, see the developer’s privacy policy.

No Details Provided

The developer will be required to provide privacy details when they submit their next app update.

Supports

  • Family Sharing

    Up to six family members can use this app with Family Sharing enabled.

More By This Developer