MySQL Databases - Best front end for MySQL (Mac OS X)

Author

Best front end for MySQL (Mac OS X)

Jeffrey Rolland

2006-03-27, 1:32 pm

Hello, all!

I have MySQL loaded on Mac OS X, and I would like the best front end for
it. I am willing to consider commercial front ends.

I have used MS Access in the past, and, as much as I dislike Microsoft,
I must admit, they really got it right with Access. I would like a front
end that approximates their Query-by-Example screen as much as possible.
I have Virtual PC and I am seriously considering purchasing MS Access
and downloading an install of MySQL for Windows to just use MS Access
and ODBC as a front end for MySQL.

Navicat seems OK, but is it possible to create other than inner joins
with the Query Builder?

Thanks in advance for any assistance you can provide.

Sincerely,
--
Jeffrey Rolland | "Beneath this mask there is more than
<wildstar200@hotmail.com> | flesh. There is an idea, Mr. Creedy, and
| ideas are bulletproof. "
| - _V for Vendetta_

Thomas Bartkus

2006-03-28, 9:28 am

"Jeffrey Rolland" <wildstar200@hotmail.com> wrote in message
news:wildstar200-F89741.12185727032006@216-165-192-90.crescentb.com...
> Hello, all!
>
> I have MySQL loaded on Mac OS X, and I would like the best front end for
> it. I am willing to consider commercial front ends.
>
> I have used MS Access in the past, and, as much as I dislike Microsoft,
> I must admit, they really got it right with Access. I would like a front
> end that approximates their Query-by-Example screen as much as possible.
> I have Virtual PC and I am seriously considering purchasing MS Access
> and downloading an install of MySQL for Windows to just use MS Access
> and ODBC as a front end for MySQL.

If you merely want to use Access as a MySQL front end - you can do that!

There is no need to install MySQL on Windows unless you want to. Access can
link tables to a Linux hosted MySQL server so it's really not necessary.

The Access query builder is a useful way to learn SQL just so long as you
are mindful of the differences between JET and MySQL. EG - Jets use of
brackets '[]' where MySQL wants to use back ticks, VBA functions vs. MySQL
functions, and date/time base differences.

Bear in mind, also, that you can define Pass Through Queries in Access which
allows you to pass MySQL flavor functions directly to the server.

In the end, Access will look like a nice crutch you will eventually abandon.
Unless, of course, you are trying integrate MySQL into the MS Office system.
If that's the case, you will find Access to be essential equipment.

Thomas Bartkus

> Navicat seems OK, but is it possible to create other than inner joins
> with the Query Builder?
>

Brian Inglis

2006-03-29, 3:27 am

On Mon, 27 Mar 2006 12:19:00 -0600 in alt.comp.databases, Jeffrey
Rolland <wildstar200@hotmail.com> wrote:

>Hello, all!
>
>I have MySQL loaded on Mac OS X, and I would like the best front end for
>it. I am willing to consider commercial front ends.
>
>I have used MS Access in the past, and, as much as I dislike Microsoft,
>I must admit, they really got it right with Access. I would like a front
>end that approximates their Query-by-Example screen as much as possible.
>I have Virtual PC and I am seriously considering purchasing MS Access
>and downloading an install of MySQL for Windows to just use MS Access
>and ODBC as a front end for MySQL.
>
>Navicat seems OK, but is it possible to create other than inner joins
>with the Query Builder?
>
>Thanks in advance for any assistance you can provide.

Could look at OpenOffice V2 BASE (I haven't, so can't comment).

--
Thanks. Take care, Brian Inglis Calgary, Alberta, Canada

Brian.Inglis@CSi.com (Brian[dot]Inglis& #123;at}SystematicSW
[dot]ab[dot]ca)
fake address use address above to reply

Jeffrey Rolland

2006-03-29, 11:28 am

In article <TJqdnbFz--Aa0rTZnZ2dnUVZ_t-dnZ2d@telcove.net>,
"Thomas Bartkus" < thomasbartkus@comcas
t.net> wrote:

> "Jeffrey Rolland" <wildstar200@hotmail.com> wrote in message
> news:wildstar200-F89741.12185727032006@216-165-192-90.crescentb.com...
>
> If you merely want to use Access as a MySQL front end - you can do that!
>
> There is no need to install MySQL on Windows unless you want to. Access can
> link tables to a Linux hosted MySQL server so it's really not necessary.

<snip>

> Thomas Bartkus

<snip>

I thought I had posted this in Google, but it doesn't appear to be
showing up, so here goes again.

How can I link to MySQL databases on my Mac using MS Access on Virtual
PC?

I know how to mount the PC harddrive as a Mac OS X volume when VPC isn't
running, but I have no idea how to access Mac volumes from in VPC. Are
you sure this isn't a dual-boot Linux/Windows thing? It would be great
if it isn't.

Sincerely,
--
Jeffrey Rolland | "Beneath this mask there is more than
<wildstar200@hotmail.com> | flesh. There is an idea, Mr. Creedy, and
| ideas are bulletproof. "
| - _V for Vendetta_

Jeffrey Rolland

2006-04-02, 1:26 pm

In article
<wildstar200-F89741.12185727032006@216-165-192-90.crescentb.com>,
Jeffrey Rolland <wildstar200@hotmail.com> wrote:

> Hello, all!
>
> I have MySQL loaded on Mac OS X, and I would like the best front end for
> it. I am willing to consider commercial front ends.
>
> I have used MS Access in the past, and, as much as I dislike Microsoft,
> I must admit, they really got it right with Access. I would like a front
> end that approximates their Query-by-Example screen as much as possible.
> I have Virtual PC and I am seriously considering purchasing MS Access
> and downloading an install of MySQL for Windows to just use MS Access
> and ODBC as a front end for MySQL.
>
> Navicat seems OK, but is it possible to create other than inner joins
> with the Query Builder?
>
> Thanks in advance for any assistance you can provide.
>
> Sincerely,
> --
> Jeffrey Rolland | "Beneath this mask there is more than
> <wildstar200@hotmail.com> | flesh. There is an idea, Mr. Creedy, and
> | ideas are bulletproof. "
> | - _V for Vendetta_

Well, I finally decided to go for Navicat, at an educator's discount of
$75. It has a query builder screen, similiar to MS Access's QBE screen,
a table edit screen, so I don't have to use SQL TABLE or INSERT
statements, and an import wizard (with which I am still having a
teeny-tiny technical glitch importing date fields, but that's another
story), which saves me the trouble of learning how to import data using
the command line.

Navicat is a good piece of software, and a bargain to boot, considering
that MS Access is $200. I heartily recommend it.

Thanks for all the input.

Sincerely,
--
Jeffrey Rolland | "Beneath this mask there is more than
<wildstar200@hotmail.com> | flesh. There is an idea, Mr. Creedy, and
| ideas are bulletproof. "
| - _V for Vendetta_

Sponsored Links