All categories

Base CRM and Sales Tracking 2.4

Free Access and manage SQLite 3 database files.
0 
Latest version:
2.5.2 See all
Developer:

Work with a toolset for editing, managing, creating, and otherwise processing SQLite 3 database content on your Mac. Check out the options for quickly selecting the existing data or inputting new materials manually or automatically. Add or remove elements at will.

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.


v2.4 [Dec 30, 2012]
This is primarily a bug-fix release. Changes include:
• Changes made in the data browser no longer show the old value before being committed
• Exported SLK files now include column names
• Custom queries now show the number of rows returned
• Filtering large tables no longer shows empty pages
• When creating the first table in a database, the source list auto-expands to show it
• The SQL log now shows setting values to NULL correctly (they were already set correctly, but the log was wrong)
• CSV import no longer fails when the last line of a file is empty
• Exporting custom SQL queries to CSV now includes column names
• Changes made to constraints in the table editor could sometimes not be saved. They are now.

Suggestions

Sequel Ace
Sequel Ace
Free

SQL tool for Mac. Fast, easy-to-use database management for MySQL and MariaDB.

MDB ACCDB Viewer
MDB ACCDB Viewer
Free

It allows you to open Microsoft Access Databases on your Mac.

DB Browser for SQLite
DB Browser for SQLite
Free

This is a tool to create, design and edit database files compatible with SQLite.

Download
Free