dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
 

Mobile Development Platform Comparison Matrix : Page 2

Get a side-by-side comparison of the leading mobile development platforms. This breakdown of Android, BlackBerry, iPhone, Windows, webOS and Symbian also includes an at-a-glance matrix of mobile databases.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


 

Tools Features Max Size of DB Languages Supported Connection Protocols Footprint Operating Systems Supported Synchronization/Integration with Backend Deployment Options Security Documentation/Developer Support Cost
SQL Server Compact

• Microsoft SQL Server Management Studio
• Microsoft Visual Studio



• Can be deployed on smart devices and computers
• SQL Server Compact Edition Tools for Visual Studio 2005 SP1
• SQL Server Compact Edition Developer SDK
• SQL Server Compact Edition Server Tools
• |DataDirectory| substitution string support

4G

T-SQL

• ADO.NET
• ODBC
• OLE DB
• LINQ

• <2MB disk space
• 5MB memory

• Windows Embedded
• Windows Mobile
• Windows Desktop
• Windows Server

• Remote Data Access (RDA)
• Merge replication
• Requires a Client Access License (CAL) to the host SQL Server

• ClickOnce
• Microsoft Installer Package (MSI)
• Xcopy

• Data transfer - 128-bit data encryption
• Authentication and authorization for RDA handled by Internet Information Services (IIS)
• Encryption via Secure Sockets Layer (SSL)
• DB file secured using RSA 128-bit data file encryption and can be password protected

• Microsoft Support
• Books Online
• Blogs
• Videos
• Community Forums
• Newsgroups

Free

Oracle Database Lite

• Mobile database offering consists of Database Lite Client and middle tier, Oracle Database Lite Mobile Server
• User interface into Mobile Server is Mobile Manager
• Mobile Database Workench (MDW)
• Mobile Development Kit (MDK)
• Packaging Wizard

• Synchronization support for SQLite databases
• Windows Mobile 5 and 6/CE Standard SDK 5.0 support
• Android and Blackberry device support
• JDK 1.5 compatibility
• C++/.Net stored procedures support
• Troubleshooting with Mobile Server Repository Diagnostic Tool (MSRDT)
• Oracle RAC support

• 4GB of relational data
• 16TB of BLOB data

• SQL-92
• Java
• C++
• .NET stored procedures and triggers

• ODBC
• JDBC
• ADO.NET

Starting around 1MB

• Windows (2003, XP, Vista)
• Windows Mobile (5, 6)
• Linux (RedHat)
• Linux Embedded
• Symbian (7, 8, 9)
• Mobile Server is deployable on Windows, Linux, Sun SPARC, HP-UX and IBM AIX

• Mobile Server provides bi-directional data synchronization to an enterprise instance of an Oracle database.
• Asynchronous and synchronous incremental data synchronization between thousands of mobile users and the Oracle Database recovers from network failures during synchronization
• File-based synchronization in absense of network connectivity
• Synchronization support has been extended to include SQLite databases with version 10.3 of Database Lite

• Packaging Wizard
• Mobile Server
• Mobile Server integration with the WebLogic Server 11g and Oracle Application Server (OAS)

• FIPS-140 compliance
• SSL
• 128-bit AES encryption

• Code samples, and tutorials provided with MDK
• Documentation, support and community forums

• $60 per user
• Mobile Server - $23,000 per processor

DB2 Everyplace (Enterprise Edition)

• Mobile Devices Administration Center
• XML Scripting Tool

• Optimized for SAP
• Transaction support
• Failure recovery
• Allows for indexing for performance tuning
• Stored procedures only supported as remote calls via the Remote Query and Stored Procedure Adapter

See DB2 Everyplace limits for a list of DB2 limits

• C/C++
• Java
• .NET
• VB
• Subset of standard SQL

• DB2 Call Level Interface (CLI)
• ODBC
• JDBC
• ADO.NET

350KB

• Windows (2000, 2003, XP, Vista, CE)
• Linux
• Linux Embedded
• Symbian
• QNX
• Palm OS

• DB2 Everyplace Sync Server
• DB2 Everyplace Sync Client:
- secure, bi-directional synchronizing
- Runs on Windows (32-bit), Linux (32-bit), Solaris (64-bit), and AIX (64-bit)
• servlet is provided for simple, low-volume scenarios

WebSphere Application Server Network Deployment

• Local data encryption provided by plugins based on individual platforms
• DSYEncrypt utility encrypts passwords

• SDK, including tutorials and code samples
• IBM website - documentaton, support, community forums

$166 per user; includes license, software subscription and 12 months of support

DB2 Everyplace (Database Edition)

• Mobile Devices Administration Center
• XML Scripting Tool

 

See DB2 Everyplace limits for a list of DB2 limits

• C/C++
• Java
• .NET
• VB
• Subset of standard SQL

 

350KB

• Windows (2000, 2003, XP, Vista, CE)
• Linux
• Linux Embedded
• Symbian
• QNX
• Palm OS

Local data storage

 

• Local data encryption provided by plugins based on individual platforms
• DSYEncrypt utility encrypts passwords

• SDK, including tutorials and code samples
• IBM website - documentaton, support, community forums

$72.50 per user

SQL Anywhere

• Visual Studio
• Eclipse
• PowerBuilder

• 20,000 transactions per minute
• Veritas Cluster Server (VCS) agent
• UltraLiteJ for use on BlackBerry devices and with J2SE
• v.12: Support for spatial data, language extensions, performance improvements, support for iPhone, and more

Hundreds of GB of data

• C#
• VB.NET
• C/C++
• ASP
• XML
• Java
• Special drivers for PERL and PHP

• ODBC
• JDBC
• ADO.NET
• OLE DB
• Open Client

• 10MB hard disk
• 4MB of memory
• UltraLite version: 75KB

• Windows
• Windows Mobile
• Linux
• Linux Embedded
• Mac OSX on Intel
• Sun SolarisIBM AIX
• HP-UX
• MobiLink: Windows, Linux, Mac OS X, Sun Solaris, IBM AIX, HP-UX

Bi-directional replication is accomplished using MobiLink

Deployment Wizard

Optional purchases: RSA and ECC encryption protocols

• Documentation
• Community forums
• Webcasts

Dependent on what you need to do with it, who will be using it, how many will be using it, and what platform you are targeting

SQL Lite

• TCL (Tool Command Language)
• C/C++ interface to SQLite
• Management Tools
• Converter Tools
• SQLite Wrappers
• SQLite Reporting

• Zero-Configuration
• Serverless
• Single Database File
• Stable Cross-Platform Database file

1 terabyte

SQL-92

N/A

<275K

Cross-platform, 32-bit and 64-bit systems

N/A

 

Support for reading and writing encrypted databases using these algorithms: RC4, AES-128 in OFB mode, AES-128 in CCM mode, and AES-256 in OFB mode

• Documentation
• Wiki
• Sample code
• Upgrade guidance
• API references

Public domain



Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date