SQLite and MySQL for iPhone Development

SQLite

SQLite is a library, a relational database system contains. SQLite supports a large part of the SQL-92 standard defined SQL language command. SQLite implements among other transactions, sub-queries (sub-queries), views (views), triggers and UDFs. The system is primarily for embedded use-designed, therefore, lacking features like the ability to manage object permissions (GRANT, REVOKE). For many programming language  appropriate database interfaces. Even in the console and shell scripts is present-to-use, simple front-end. The entire database is in a single file, not a client or server architecture is present. The SQLite library can be integrated directly into these applications so that no additional server software required. The latter is the crucial difference from other database systems. By including the library, the application will be expanded to include database functionality without having to rely on external software packages.

SQLite has some peculiarities compared to other databases; the library is only a few hundred kilobytes in size. An SQLite database is a single file containing all tables, indexes, views, triggers etc. This simplifies the exchange between different systems, even between systems with different byte orders. Each column can contain data of arbitrary types at run time is necessary to convert. Used SQLite is among other things, in operating systems for mobile phones such as Symbian or Android. In addition, the browser uses Mozilla Firefox since version 3 SQLite - for example, bookmarks and cookies - after they had already used in version 2 of SQLite for internal program database.

MySQL

The name MySQL is composed of the first names my, the daughter of the co-founder Michael Widenius bears, and SQL. MySQL is available on many Unix variants, Mac OS X and Linux, but also on Windows, OS / 2 and i5/OS (formerly OS/400) run. Since early 2008, there is also a Symbian version. For Windows, however, some limitations called. MySQL is designed so that a database management system engine, multiple databases can be assigned. In a database, multiple tables can be created. The tables can be of different types. The maximum size of the tables is in principle only by the operating system limits. While earlier versions of MySQL support only part of the SQL3 language scope (e.g. There were no possible view definitions), version 5.0 offers a greatly expanded language support, which largely corresponds to the SQL3 standard.

Since version 3.23.xx is a replication system. It is designed for use in a computer cluster designed. Here are the database management system (DBMS) have multiple databases on different computer nodes assigned. One of the databases is the master, where the database contents are changed. The replication system then distributes the data changing SQL commands on the other databases that track these changes locally on their tables. It is therefore, an asynchronous replication of SQL commands.

SQLite and MySQL are better for iPhone Developmentbecause of their enhancing factors which makes the systems management database to work faster and easier.