Mac App Store

Mac App Store is the simplest way to find and download apps for your Mac.

To download Datum - SQLite from the Mac App Store, you need a Mac with OS X 10.6.6 or later. Learn More.

Datum - SQLite

By Carl Wieland

Open the Mac App Store to buy and download apps.

Description

Datum is a full featured SQLite database manager. It is light weight and blazing fast. It has all the tools to help you be a SQLite master as soon as you launch the app. Instant loading and editing. Fast, powerful, complete. It's the most powerful SQLite manager in the App Store.

Features include:
Easy to use Tabbed Interface

Speed! Load and scroll through millions of records in an instant. Taking to long? Easy to stop and keep working.

Full ATTACH/DETACH support, Attach other databases, use and modify them with equal ease.

Create beautiful yet complex tables with just few simple clicks. All constraints are supported and are easy to add or edit.

Alter your existing tables to your hearts content. Including modifying column names, constraints, and types as well as whole table constraints.

QuickLook SQLite files from Finder to see in an instant some of your data, open it up in a blink of an eye to see the rest.

Quickly browse, filter, and edit your data.

Import your data from other sources or manually add it with inline editing and easy updating. View exactly what data will be imported and choose where it goes.

Insert files directly into the tables for safe keeping. Preview images and text files directly inside the app or export them to open outside.

Take full control and execute raw sql commands directly from the app with comprehensive feedback and transactional safety.

Open query results in a new window for easier viewing. Export it for use elsewhere.

View Multiple queries data in tabs quickly and simply.

Export single tables or your whole databases in a variety of formats to whatever suites your needs. Missing a format? send us a line and we'll see what we can do.

What's New in Version 7.1

Fixes XLS import bug
Fixes errors when executing SQL
Other Bug fixes

Screenshots

Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Screenshot 5

Customer Reviews

DATUM Worth It

DATUM has worked very well for me. The only thing I wish is there were more options for CSV or OTHER Export where it would be nice for example to be able to specifiy exporting every field as text i.e. quotes around the fields. But I was able to work around these limitations but it would be much better if it had more flexibility on export.

Otherwise the SQL capabilities within the software are AWESOME and I could do all these things I needed to do to manipulate data since the files I was working on were too big for Excel exceeding the 1 MM record limit of Excel but were not problem at all for Datum.

Nice job guys. Keep up the good work and improve the flexibility of Export if you would.

Does not import XLS, even after “fix"

Cannot import XLS CSV at all. Have attempted multiple times with 3 column sheet, no spaces in column names, short column names.
Either gives “duplicate columns” or “Error importing into new table:disk I/O error”

Also, “comma” is spelled with 2 m’s, otherwise it’s just a coma.

Datum - SQLite
View in Mac App Store
  • $4.99
  • Category: Developer Tools
  • Updated:
  • Version: 7.1
  • Size: 5.8 MB
  • Language: English
  • Seller:

Compatibility: OS X 10.9 or later, 64-bit processor

Customer Ratings

Current Version:
All Versions: