Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Is there a database program for the Mac that makes it easy to import a CSV file into a table and then query and manipulate the data using ad-hoc SQL queries?

(A Windows example of a similar product would be Microsoft Access ... it also has forms and reports, which are not as important, but I would not mind a Mac solution that has those too.)

share|improve this question
    
This is off topic as defined in the FAQ's, I suggest Stackoverflow or programmers as better options. –  Graeme Hutchison Dec 17 '11 at 8:52
5  
I don't understand. the FAQ states that this forum is for asking questions about "Apple Hardware and Software." I am not asking a programming question, I am asking for a recommendation for a software package--specifically a database application-- for Mac. As I noted, I do not WANT to program, so I am looking for a software application first. Should there be no such alternative, it would make sense then to ask in a forum for programmers. Am I missing something? –  Chris Dec 17 '11 at 9:01
    
right, I have misread this as programming from these, you say I need to create, and then say, I have built this before, then go on to mention that I've programmed with PHP & My SQL i'd rather not create a web app. So those seem to me like you wanted to make your own desktop app. Sorry. –  Graeme Hutchison Dec 17 '11 at 9:09
1  
Access is much more than just a relational database with a GUI. To what extent do you need the forms/macros/etc functionality? i.e. Do you just need a relational database with a query-builder GUI, or do you also need to be able to make interactive forms that have some application logic built into them? –  Jonathan Van Matre Dec 18 '11 at 15:01
add comment

16 Answers

up vote 3 down vote accepted

Base by Menial is a fantastic SQLite editor that can do what you're looking for. You can buy it from their website or from the Mac App Store.

share|improve this answer
add comment

Sequel Pro is a really nice GUI for working with MySQL databases. You can even connect to remote databases like you would connect to a server via ftp/ssh

http://www.sequelpro.com/

share|improve this answer
    
I use this on a daily basis. Fantastic software, plus it's FREE and the source code is available! –  macaco Jan 13 '12 at 8:43
add comment

Bento by Filemaker may be able to do this.

share|improve this answer
    
I can't find any sign that Bento allows SQL queries ... it looks like you have to use FileMaker Pro to get that. –  user4074 Apr 26 '11 at 1:17
add comment

Filemaker Pro will be your best bet overall. It is easier to use than Access, and will give you what you want and more. It's going to be a learning curve with anything if you're used to Access, so just jump in to one of them.

Filemaker Pro -

http://www.filemaker.com/products/filemaker-pro/

If you're wanting to do something SQL related though, then I'd check out the following: Sequelpro; Querious; Navicat; or MySQL Workbench.

Sequelpro is best out of all of these though, in my opinion, and it's completely free. Bam!

http://www.sequelpro.com/

share|improve this answer
    
Navicat is a manager of SQl databases like Sequelpro, Querious, or MySQL Workbench. –  Mark Dec 17 '11 at 15:56
    
Sequel Pro is so good I donated to it; go with that. –  ratbum Aug 17 '13 at 11:56
add comment

Check out SQLite and a tool like Base 2 from http://menial.co.uk/software/base/. I have not personally used it but it seems to be what you are looking for. The beauty of SQLite is the database is self contained.

share|improve this answer
    
Or the problem with SQLlite is that it is not good at being shard - depending on your use. –  Mark Dec 17 '11 at 15:57
    
yeah, it is only ever intended as a small database, many developers use it in iOS applications. –  dbtedman Dec 22 '11 at 11:37
add comment

If you are looking for a fully relational database with a GUI front-end for Mac, I would suggest checking out 4th Dimension (4D) at www.4d.com

This database development platform has been around on the Mac since 1987. While you can do a lot of development without writing any code, you will soon want to dive in and start to learn to program in 4D. It is a PASCAL-like procedural language owing to it's original development in the 1980's.

It now supports the SQL language as well.

While the program is not for the faint of heart, I promise you will NOT outgrow it.

You will most likely be interested in the 4D Developer Standard.

http://www.4d.com/products/4dv12/4ddevstandard.html

It has everything you need to get started.

Hope that helps, Walt

share|improve this answer
add comment

MySQL is a very popular open-source relational database. Sequel Pro (http://www.sequelpro.com) is an awesome, free Mac app for working with MySQL. I use it every day at work. I couldn't do my job without it!

share|improve this answer
add comment

Just like Microsoft Office includes Microsoft Access, NeoOffice includes a database application as well as part of the office suite:

http://www.neooffice.org/neojava/en/index.php

Is this what you were looking for?

share|improve this answer
add comment

Why not MySQL with MySQL Workbench?

It's an amazing GUI, you can of course view and edit the databases contents, but also create databases graphically with all kinds of relationships. It's worth checking it out:

enter image description here

share|improve this answer
    
However does not include form creation –  Mark Feb 21 '13 at 10:02
add comment

Bento is by the FileMaker team, but is super simple. It comes with a whole bunch of samples, does most of the heavy lifting for you, and has a solid database engine underneath.

It's available on the App Store, and for iPad too.

http://itunes.apple.com/us/app/bento/id413293930?mt=12

http://www.filemaker.com/products/bento/

share|improve this answer
add comment

I would suggest looking at the latest offering from QSA Toolworks - they've taken over Helix an incredible relational database that doesn't use any coding whatsoever. Helix (the product) comes in a number of variants Helix RADE (Rapid Application Development Environment), Helix Engine (to allow databases to be used by those who don't have the Helix RADE element), there's also Helix Server and Helix Client. Check out http://www.qsatoolworks.com. This product has been running on Mac since 1983!

share|improve this answer
add comment

Sorry for delay, was on vacation... I will edit my original short answer to give more extended answers.

  • Original question asks about something similar to MS Access. I believe that MS Access was copied 4th Dimension, old good database from French. Its problems although IMO: pascal language, slow as access, expensive.

  • Bento have die just few days ago. FileMaker is similar to Access, although less powerful.

These two products include own db engines and they have own server versions (near to 1000-1500$).

Other solutions are to use database server as mySQL/PostgreSQL and some GUI Manager app. Some already was mentioned:

  • mySQL Workbench - works only with mySQL
    • pgAdmin - works only with PostgreSQL
    • Navicat - exists editions for single DB or Premium edition (~500) to all dbs
    • SequelPro - for mySQL only, free and others.

Since my first post was about Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview and I was asked to provide more info, here it is. enter image description here

  • I have found this application in April of 2013. It has totally free edition without limits. Perfect GUI for mySQL, PostgreSQL, SQLite and their own Valentina DB. I am using it up to now and so far all right.

  • Was asked about relational support, 1:M, M:1, M:M links. All this present in Valentina Studio for all that dbs. Diagrams can be used in free edition also.

  • But there is no forms as in Access. Guys say they will add forms in nearest months, then this will be FileMaker killer IMO :) We'll see. Because note again, they have own Valentina db engine and Valentina Server, as FileMaker and 4D.

  • I very recommend to check this video introduction http://www.youtube.com/watch?v=1wAd1IrwKAs Notice how perfect are diagrams and Data Editor.

share|improve this answer
    
Valentina Studio now supports Oracle and MS SQL Server too. You can import in a CSV or Excel spreadsheet if you want, run queries, and the like. There is a FREE version and there is also a PRO version that adds SQLDIFF, Diagramming and Reports. –  Lynn Feb 17 at 16:53
add comment

Symphytum

A personal database software for everyone who desires to manage and organize data in an easy and intuitive way, without having to study complex database languages and software user interfaces.

Portofino

A free and open source web framework that helps developers create outstanding enterprise applications by addressing three specific needs: productivity, features and architecture. A wizard allows the developer to create a web application by connecting to an existing database quickly and easily.

Kexi

Considered as a long awaited Open Source competitor for Microsoft Access, Filemaker and Oracle Forms. Kexi is an integrated data management application. Its development is motivated by the lack of Rapid Application Development (RAD) tools for database systems that are sufficiently powerful, inexpensive, open standards driven and portable across many operating systems and hardware platforms. It runs on OS X with Fink.

share|improve this answer
add comment

check out http://servoy.com/ _____________________

share|improve this answer
1  
You would want to add why a hosted solution meets the needs here. From my impression, the asker wants desktop software suggestions for a specific task. –  bmike Aug 17 '13 at 17:10
add comment

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

I agree with the previous post.

Kexi crashes too often. I installed it into VirtualBox Ubuntu running on a MacBook Pro and gave up after 30 minutes and five crashes resulting in data loss.

LibreOffice Base is native on the Mac, similar to MS Access but has a clunky interface and very poor copy/paste. Export is a bit limited as well. You have to go through the spreadsheet, save as CSV and then import into SQLite, but at least it's possible, sort of. It has the familiar Relationships View, Query Builder and Forms but so far unable to build a form with one-to-many dropdown box, still trying it.

My advice is to start with LibreOffice Base.

share|improve this answer
add comment

SQLite Professional is a good option and should do what your looking for. Its a SQLite frontend that will allow you to import csv files and execute queries on the results. I should note that I'm the developer.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.