Database

patakye · patakye #1 (**permalink**)

06-24-2011, 11:33 AM

I am new to mac development ... I am trying to port an app for windows to the latest MAC OS ... and I have a question ...

The windows app creates an access database to store things, and it is not required to have access installed, it just uses that format .. i need to use something similar for MAC that is sort of native to MAC and most common .. what is a common database format used for MAC? i need to use something for which there are lots of drivers, mature, stable, etc ... should i use mysql?

i just dont want to choose something that may not be standard for mac and i might have trouble supporting it in the future ...

vansmith · vansmith #2 (**permalink**)

06-24-2011, 01:20 PM

This all depends on how sophisticated a database you need. You could use something light like SQLite or you could just as easily use something a little more sophisticated like MySQL or PostgreSQL. The latter two do not come with OS X so if this is going to be distributed, that will be something to consider. One thing to consider as well is how well the language you're using supports each of the aforementioned DBs (you should be fine though) and whether or not they support other formats.

twitchymike@mac · twitchymike@mac #3 (**permalink**)

06-24-2011, 02:24 PM

I'm an ORACLE and SQL Server Developer & DBA. I love databases. Do you mean proper RDBMS, and/or Datawarehouses?

I wish Apple made a database system for the Mac platform. The best I could find was MySQL - open source, and a nightmare to use compared to SQL Server (the one and only good piece of software Microsoft ever made). Apple had FileMaker in the '80s and it has grown, but it really is plankton compared to SQL Server. I have SQL Server 2008 running on Windows on my Mac Pro, seamlessly.

I'd say MS Access is a lot more sophisticated than FileMaker.

chas_m · chas_m #4 (**permalink**)

06-25-2011, 02:14 AM

A Mac is short for "Macintosh." It's not an acronym, thus it should not be capitalised.

To put it another way:
mac: a waterproof raincoat made of rubberized fabric
MAC: a data communication protocol sub-layer, also known as the Media Access Control
Mac: a brand name which covers several lines of personal computers designed, developed, and marketed by Apple Inc.

Ditto for iPod.

vansmith · vansmith #5 (**permalink**)

06-25-2011, 09:44 AM

This is probably better placed here in the developer forum.

xstep · xstep #6 (**permalink**)

06-25-2011, 03:37 PM

Given you mention Access, I'm guessing you want a local and perhaps private user store. In that case I'd start my investigation with SQLite which is installed with OS X and iOS.

vansmith #2 (permalink)
Member Since: Oct 19, 2008 Location: Ottawa Posts: 15,302 Mac Specs: 2012 13" MBP (2.5 i5, 8GB)	06-24-2011, 01:20 PM This all depends on how sophisticated a database you need. You could use something light like SQLite or you could just as easily use something a little more sophisticated like MySQL or PostgreSQL. The latter two do not come with OS X so if this is going to be distributed, that will be something to consider. One thing to consider as well is how well the language you're using supports each of the aforementioned DBs (you should be fine though) and whether or not they support other formats. Important Links: Community Guidelines : Use the reputation system if you've been helped. M-F Blog :: Write for the blog :: M-F IRC Channel - Chats every Sunday at 8PM EST.
	QUOTE Thanks

chas_m #4 (permalink)
Member Since: Jan 22, 2010 Location: Victoria, BC Posts: 13,696 Mac Specs: 2009 MacBook Pro, Black speakers, Black Benq second monitor, black iPhone 4, Black 2012 iPad, etc.	06-25-2011, 02:14 AM A Mac is short for "Macintosh." It's not an acronym, thus it should not be capitalised. To put it another way: mac: a waterproof raincoat made of rubberized fabric MAC: a data communication protocol sub-layer, also known as the Media Access Control Mac: a brand name which covers several lines of personal computers designed, developed, and marketed by Apple Inc. Ditto for iPod. Cheers, chas_m -- My essay for switchers and newbies
	QUOTE Thanks

vansmith #5 (permalink)
Member Since: Oct 19, 2008 Location: Ottawa Posts: 15,302 Mac Specs: 2012 13" MBP (2.5 i5, 8GB)	06-25-2011, 09:44 AM This is probably better placed here in the developer forum. Important Links: Community Guidelines : Use the reputation system if you've been helped. M-F Blog :: Write for the blog :: M-F IRC Channel - Chats every Sunday at 8PM EST.
	QUOTE Thanks

xstep #6 (permalink)
Member Since: Jun 25, 2005 Location: On the road Posts: 3,231 Mac Specs: 2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid	06-25-2011, 03:37 PM Given you mention Access, I'm guessing you want a local and perhaps private user store. In that case I'd start my investigation with SQLite which is installed with OS X and iOS. CameraTime - Time lapse photography for novice and advanced users. When asking questions, post the version of your software. You'll receive better answers. Please post your results to the thread as it is good feedback.
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
White iPhone reportedly disappears from Apple inventory database	OneMoreThing...	Apple Rumors and Reports	0	04-06-2011 12:14 PM
How to know which entourage database file is in use	tekjock	OS X - Apps and Games	0	03-11-2011 10:18 PM
iPhoto database = GONE, Entourage mails and settings = GONE, happyness = GONE	Aholesen	OS X - Apps and Games	4	10-29-2009 10:52 AM
HUGE Outlook Express database problem!	sparky	Running Windows (or anything else) on your Mac	0	12-10-2005 02:48 AM

Database

Internet Services

Web Development

Digital Marketing

Consumer Tech

patakye #1 (permalink)
Member Since: Jun 24, 2011 Posts: 1	06-24-2011, 11:33 AM I am new to mac development ... I am trying to port an app for windows to the latest MAC OS ... and I have a question ... The windows app creates an access database to store things, and it is not required to have access installed, it just uses that format .. i need to use something similar for MAC that is sort of native to MAC and most common .. what is a common database format used for MAC? i need to use something for which there are lots of drivers, mature, stable, etc ... should i use mysql? i just dont want to choose something that may not be standard for mac and i might have trouble supporting it in the future ...
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)