Re: JDBC from Cocoa or the like
Re: JDBC from Cocoa or the like
- Subject: Re: JDBC from Cocoa or the like
- From: Dru Satori <email@hidden>
- Date: Wed, 6 Oct 2010 13:45:58 -0400
I have made freetds work on iOS. It is doable, and it is usable. I never did anything with it because greeted is gpl, so turning it into a commercial product on the AppStore presented non technical "challenges". I also have PostgreSQL client Libraries working on iOS. If you want help with this, I will be happy to talk about it, but ODBC is, IMO a bad fit for iOS at many levels. In truth I think all traditional DBMS toolkits have issues in the long run on iOS. They are fine so long as the devices are on wifi within the walls. Once they go outside the walls, and you go from wifi bandwidth and latency levels to 3G or edge, these models quickly become horrible fits with the iOS model.
The problem is that *all* of the protocols, be it TDS, ODBC (which for MSSQL is still TDS), libpq, et al are designed for low latency, high bandwidth connections. They are chatty and are not optimized for running over spotty and intermittent 3g connections. A VPN does not fix the fundamental weaknesses in the wire protocols. Any MSSQL admin that has more than a couple of years of experience has seen the intermittent SSPI and connection drop errors that happen on LAN's when you get a lot of line noise (a saturated hub will often timeout otehr computers on the same hub).
Because of this, I strongly advocate n-tier solutions for iOS devices, but I understand the reasons that they are often not options. That is why I have done the legwork on other options.
If MSSQL is your destination, then FreeTDS is your best option. You may/probably will need to work with FreeTDS.org to obtain a commercial usable license, but in terms of usability and perfomance, it is fine (within reason).
Please do not misunderstand me, I am probably one of the biggest RDBMS advocates in this community (PostgreSQLforMac, ODBCKit, PGSQLKit, and the unreleased TDSKit are all my projects), but when it comes to iOS, I just do not feel that the existing client libraries are the best solution.
Andy 'Dru' Satori
On Oct 6, 2010, at 10:47 AM, colors <email@hidden> wrote:
> Alex,
>
> I have the same problem you document below, so looked into your ODBC reference. However, it looks like they want to sell me a $2000 router software package to work with the iOS. What I need is a framework (much like easyDB, but allowed to be used on a commercial product). Did I miss-read the web site?
>
> Rich
>
> On Oct 5, 2010, at 9:39 AM, Alex Kac wrote:
>
>> I saw this ODBC framework for iOS. Maybe that helps as well:
>> http://www.prlog.org/10938886-open-database-connectivity-odbc-arrives-for-apple-ipad-iphone-and-ipod-touch.html
>>
>> One problem I've always had with the N-tier arch is that of customer security. Many companies simply won't use an app that doesn't talk directly to the database within their own private VPN/network.
>>
>> On Oct 5, 2010, at 11:09 AM, Kyle Sluder wrote:
>>
>>> On Tue, Oct 5, 2010 at 9:03 AM, colors <email@hidden> wrote:
>>>> Is there a framework, or set of APIs or samples available from Apple or others to do SQL server accesses? I have looked at easyDB, but its license makes it a non-starter. I have also looked at freetds, but it does not look like it is ready for prime time (let along particularly good in the Mac support arena). To make maters a little harder, I need to have it work on the iOS too.
>>>
>>> If you didn't need it to work on iOS, you could use ODBC.
>>>
>>> Why not adopt a classic N-tier architecture, and have a service with
>>> which your apps can communicate rather than having them talk to the DB
>>> directly?
>>>
>>> --Kyle Sluder
>>> _______________________________________________
>>>
>>> Cocoa-dev mailing list (email@hidden)
>>>
>>> Please do not post admin requests or moderator comments to the list.
>>> Contact the moderators at cocoa-dev-admins(at)lists.apple.com
>>>
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>> Alex Kac - President and Founder
>> Web Information Solutions, Inc.
>>
>> "Forgiveness is not an occasional act: it is a permanent attitude."
>> -- Dr. Martin Luther King
>>
>>
>>
>>
>
> _______________________________________________
>
> Cocoa-dev mailing list (email@hidden)
>
> Please do not post admin requests or moderator comments to the list.
> Contact the moderators at cocoa-dev-admins(at)lists.apple.com
>
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden