Base - SQLite Editor 4+
The SQLite Editor
Menial
-
- £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
Great but needs an update
Trying to edit my iPhone add database with Base is fine. It lets you get the job done which is the main thing. But it's not a pleasure to use. If you've sorted a table by a column and then edit some text in the large text pop-up window and press "Save"… boom… the record you were working on has jumped somewhere off screen and the sort on a field you had has been forgotten. It's really frustrating.
Apart from that it has let me do everything I want and it's definitely better than editing the database through the command line.
Base is no "Sequel Pro" for usability or basic features. I'm definitely donating £20 to Squel Pro after having paid for Base.
Rubbish
I paid for this app and now it wants me to pay a monthly subscription. But the app is really poor, very basic. I never use it. Really a monthly fee, after using it I would not pay the fee for a life time free upgrades never mind monthly. REALLY!
A great SQLite application that has been built for Mac OS from the ground up
I use SQLite (mainly through CoreData) in my Mac OS and iOS applications, and also in the development enviroments of my Ruby on Rails applications. Base allows be to quickly and easily view and edit these SQLite databases, through a very clean and simple "Apple" like UI. All of the other alternative SQLite applications that I have tried, have had a very clunky "cross platform" feel to them, and don't have the feature set of Base. Since I have started to use base, I haven't had to resort to the command line once to inspect or edit my SQLite databases.
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.
Information
- Provider
- Menial Ltd
- Size
- 8.4 MB
- Category
- Developer Tools
- Compatibility
-
- Mac
- Requires macOS 10.14 or later.
- Languages
-
English
- Age Rating
- 4+
- Copyright
- © 2020 Menial Ltd
- Price
- £19.99
Supports
-
Family Sharing
Up to six family members can use this app with Family Sharing enabled.