Mac OSX App with MySQL

[Charles Vincent]

Good morning! I am developing a Mac OSX App that I would like to connect to a MySQL database for the data portion of the app. How do I go about using MySQL with my Mac App? I know you have to install a framework to be able to connect to a database but I haven't found a way to do so with the Sequel Pro Source code. Help! :-)

[Rowan Beentje]

Hi Charles,

We currently provide a library as part of Sequel Pro which handles the connection part and the business of running queries, although you'll have to construct queries yourself for the time being. If you've got the latest Sequel Pro source, take a look at Frameworks/SPMySQLFramework . That includes its own Xcode project file (which is used as a subproject in Sequel Pro), and while there's no separate documentation, you should hopefully find enough in the header files and source.

Feedback appreciated!

Rowan

On 9 Aug 2012, at 14:52, Charles Vincent wrote:

> Good morning! I am developing a Mac OSX App that I would like to connect to a MySQL database for the data portion of the app. How do I go about using MySQL with my Mac App? I know you have to install a framework to be able to connect to a database but I haven't found a way to do so with the Sequel Pro Source code. Help! :-)
>

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/sequel-pro/-/vvVl-GUme-UJ.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.
>

[Charles Vincent]

Thanks for the response. Upon running the Xcode project, I get this error;

'AbsoluteToNanoseconds' is deprecated: first deprecated in Mac OS X 10.8

[Charles Vincent]

Ok Im back! No more errors this time!

How do I go about connecting to a remote MySQL database? Where do I enter in the credentials and such for the database? Also, when I have this done how would I go about connecting different parts of the application to the MySQL? Like tableviews and drop down menus and such?

Sincerely, A grateful Noob :)

[Charles Vincent]

Anyone have any ideas? Or can you point me to a tutorial? I have already added the subproject to my project and performed the steps in the read me file. Thanks again

[Steve Little]

Rowan

Sorry. Another n00b!

Like Charles, I am writing an app which interrogates a mySQL db. I a currently using a framework written by Karl Kraft, which is great but lacks the support for some basic data types in the tables. The db structure is fixed and also not built by me, so changing them is not an option.

Following on from your response to Charles, how do I include the SPMySQLFramework subproject in my project, or build a standalone framework from that subproject?

Also, do the latest version support ARC?

Thanks in advance,

Steve