What's the best database admin software for OSX?
Active4 years, 7 months ago
What is the best database software for os x? Update Cancel. Ad by Jira Software, Atlassian. Jira official site. One tool to track issues & release great software. Try Jira for free. What are some of the best database design tools for Mac OS X? What is the best database software? What is the best free database software? Finally, if you’re looking for a database creation software on Mac that’s powerful, good looking and yet still easy to use, Ninox Database is definitely worth taking a closer look. Ninox is a slick database creation software for Mac and iOS and although it can’t import Microsoft Access file on macOS, it has taken the complex mechanics.
Databases I'm interested in are
Prefer one tool for all the databases, rather than one for each database.
John Mac
John MacJohn Mac
1,43533 gold badges1919 silver badges2929 bronze badges
closed as off-topic by Pang, luk2302, Igor Borisenko, HaveNoDisplayName, sideshowbarkerDec 25 '15 at 6:14
This question appears to be off-topic. The users who voted to close gave this specific reason:
6 Answers
I've used SQuirreL SQL in the past. It's written in Java, so it works on any platform with a decent JVM and any database with a decent JDBC driver. I think it'll do most, if not all of what you are asking for.
artlogicartlogic
For MySql, use http://www.sequelpro.com/ (foss) or http://www.araelium.com/querious/ (paid)
ChrisChris
27.2k3939 gold badges164164 silver badges222222 bronze badges
For just postgres, pgAdmin3 has gotten better in the last few releases and works fine in OS X. I've also used SQuirrel, which works on jdbc compliant db's, but it's been a while.
Dana the SaneDana the Sane
11.2k88 gold badges4949 silver badges7373 bronze badges
I use Aqua Data studio 6 at work on a daily basis, with SQL Server, Sybase IQ and Netezza. It's convenient not having to switch tools all the time. It also has a handy SQL prettier that helps keep my blood pressure low when people send me mangled SQL to look at. Netezza is unsupported but works fine with generic ODBC/JDBC.
While it is a java app the only time I really run into problems is when I run a query that returns to many rows (over 100k). You can set the limits and or play with memory but every once in a while I shoot myself in the foot and bang on my keyboard.
I run windows but linux and mac are also supported.
Nice just noticed that version 7 has built in pivot tables. That will save me from cutting and pasting datasets to excel!
jason saldojason saldo
6,63855 gold badges3030 silver badges3939 bronze badges
For MySQL, you could try:
141k2929 gold badges206206 silver badges257257 bronze badges
I'm a mac developer that wanted some tools for some of these as well, so I built a few tools.
SQLPro for SQLite is the oldest and has gone over fairly well with a 4 star average rating and great reviews.
SQLPro for MSSQL it a newer app built for connecting to MSSQL databases (specifically I wanted Azure support, but it does other versions as well), which has also been getting great reviews. Best project program for mac.
I have also been asked by a few people for a Postgres version, so that will be coming in the near future.
KyleKyle
8,3192424 gold badges117117 silver badges219219 bronze badges
Not the answer you're looking for? Browse other questions tagged databasemacos or ask your own question.
Today's Best Tech Deals
Picked by Macworld's Editors
Top Deals On Great Products
Picked by Techconnect's Editors
When FileMaker relegated Bento to the dustbin, users of the occasionally maligned but rather excellent and exceedingly simple personal database for the Mac and iOS were left wondering what’s next for the collection of Bento data they had accumulated over the previous few years. Are any applications as versatile as Bento available to take over its role? And is there an easy way to transfer your data from Bento to one of those other apps?
Though some critics of Bento felt that the app was too inflexible and that it put a straitjacket on database creation, it was a slick database app that enabled users to create nice-looking relational databases without requiring much more than an interest in organizing your personal data. Turns out, finding a capable replacement is a pretty tall order.
Over the past few weeks I’ve reviewed three apps that offer features similar to Bento: Tap Zapp Software’s TapForms (), Apimac’s iDatabase (), and Giowisys Software’s Symphytum () For this story I also looked at Filemaker Inc.’s flagship FileMaker Pro, as a slightly more expensive and far more capable alternative. Each offers useful database tools—some of them better than Bento’s, but most of them not.
![]() Importing existing Bento data
Which of these apps gives you the best options for importing your existing Bento data? The short and unsurprising answer is FileMaker Pro. TapForms, iDatabase, and Symphytum only offer options for importing data files in their native formats or as comma-delimited (CSV) files. Bento has no problem exporting data in a CSV format, but, since CSV files are text files, they can contain only text data. If you have any images stored in your Bento database, they will not show up in your new database.
FileMakerPro is the only app that provides an option for importing your entire Bento database—including images and, if you’ve created relational databases, the relationships between your various files.
Templates
One feature that made Bento such a great app was its collection of templates, supplemented by the user-submitted templates available on Filemaker’s Bento Template Exchange.
With more than 25 choices, Tap Forms offers twice as many templates as any of the other apps. These templates are by no means beautiful, but they do supply forms containing a number of useful fields that may give you a starting point for creating new forms of your own.
For its part, iDatabase offers a collection of very basic but colorful templates that offer a good foundation for creating something a bit more sophisticated.
Program like origin for mac. When you want to reinstall Origin,. Sometimes with technical issues that require extra troubleshooting, you’ll need to make sure you fully remove all parts of the Origin client from your computer. These steps, especially for PC, can harm your computer if not done the right way. This removes Origin from your Mac.
What Is A Good Database Program![]()
FileMaker Pro’s templates are far more sophisticated than those offered by the other three apps. Its 16 ‘Starter Solutions’ cover everything from basic contact databases to time billing and content management. As a result, like Bento’s templates, FileMaker’s templates offer a way of creating a complete stand-alone system that requires little customization to be useful.
Labels
It took Bento a while to climb aboard the label-printing train, but when this feature finally appeared, Bento made simple work of creating all kinds of labels. With the exception of FileMaker Pro, none of the would-be successor apps to Bento offer anything in the way of label printing. Though the other three apps offer basic form creation options, you can’t use their form tools to create and print labels.
FileMaker Pro’s label creation tools are far better than Bento’s. Whereas Bento used the app’s print dialog for label creation, FileMaker Pro lets you create forms for multiple types of labels. The app ships with dozens of prefab templates, but you can also create and save custom label templates for any kind of label you might find.
Relational database capabilitiesTypes Of Databases
For all its basicness, Bento offered some very good tools for creating relational databases. You never saw Bento’s relational underpinnings; but if you linked two collections together, the data you entered in one collection’s form showed up in another collection’s data.
Tap Forms offers something quite similar to what Bento did. By using a specialized field type called a ‘Link to Form’ field, you can create relationships with any of the other forms you’ve created. After creating them, you can use the form to add new records to the related database the form, or you can select from a list of the related database’s records to add them to the database you’re working with.
FileMaker Pro’s relational capabilities, though stellar, are a bit complicated to locate and navigate if you’re new to the idea of creating relational databases. Several of the app’s templates offer files with relationships to multiple databases. But using FileMaker Pro to create your own relationships between files is much harder than doing the same thing with Tap Forms or Bento.
Form customization
With the exception of FileMaker Pro, none of these apps gives you much power to customize the forms you’ve created. Once you’ve created your database, these apps’ forms display every created field in linear fashion from top to bottom. You can’t create more than one form for a database, and customization is limited to moving fields vertically on a form. You can’t place fields next to each other, and the first field you create when using iDatabase becomes a key field, meaning that it must always be the first field on your form.
What Is A Good Database Software
FileMaker Pro allows you to customize in almost any way you can imagine. The form creation tool can be a challenge to master; but once you become proficient, it gives you an incredible amount of form creation freedom.
Free Database Program For MacBottom line
Regrettably, no personal database app completely replaces Bento. Though the basic apps—and Tap Forms, in particular—offer some of the tools you may have grown to love in Bento, none of them rise to the same level of simplicity and capability that Bento did.
The only real alternative is FileMaker Pro, which easily imports your existing Bento data, offers a powerful collection of database tools, and supports the kind of customization you’ve grown used to with Bento. But FileMaker Pro is not designed with simplicity in mind. So while it offers more than any of the other apps do, it may also be considerably more than you want or need.
Chart: Personal Databases What Is Database Software Examples
Note: When you purchase something after clicking links in our articles, we may earn a small commission. Read our affiliate link policy for more details.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |