Re: Embedding PostgreSQL in app?
Re: Embedding PostgreSQL in app?
- Subject: Re: Embedding PostgreSQL in app?
- From: Jeffrey Early <email@hidden>
- Date: Wed, 16 Jan 2013 15:48:23 -0800
Todd,
I went through this about four years ago with PostgeSQL and yes, those were the same two choices I came up with as well. I eventually got the PostgeSQL server working when embedded in the app bundled, but it was a pain, and not particularly reliable. I don't know much about the App Store policies, but I'd assume this kind of thing is a nonstarter. Bottom line, I would recommend avoiding this route unless there's truly no other option.
In my case, I was stuck with PostgreSQL due to the spatial indexing support. At the time, spatial indexing was nonexistent on sqlite, and weak on MySQL. In addition, however, mysql licensing wasn't workable for my needs. Nowadays, sqlite supports spatial indexing, so I'd just go that route.
I'd recommend really trying to make sqlite work, or looking for something that can be fully embedded.
Jeffrey
On Jan 16, 2013, at 11:08 AM, Todd Heberlein <email@hidden> wrote:
> I couldn't find a more appropriate list for this, so I hope you will indulge me (or point me to the right list).
>
> I would like to build an application that uses a back-end database (I don't think SQLite will suffice for the transaction volume), and I was planning on PostgreSQL. Is there standard conventional wisdom on doing this?
>
> Looking around I've seen a couple of approaches including:
>
> (1) Tell your customers to first install PostgreSQL. These seems like a burden for the customer and not a very Mac-like approach.
>
> (2) Embed PostgreSQL into the application bundle. (It looks like Apple's Server.app and Postgres.app went this route). I'm not sure how kosher this is or if it will get through the Mac App Store approval process.
>
> Any recommendations or pointers?
>
> Thanks,
>
> Todd
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Xcode-users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Xcode-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden