SQLite vs MySQL

  • A flat-file database would use “flat” files, e.g. fixed-record or CSV
  • SQLite stores data in structured files with indexes.  an embedded database which has no network capabilities (unless you add them).  It’s a small library which runs SQL on local files (using locking to ensure that multiple processes don’t screw the file up).
  • MySQL is a normal database. a standalone database.You don’t embed the database engine of MySQL inside your app because it is too big; rather, you access the database via a running instance over some access interface, and doesn’t require a host application of any sort.

Comparison

  1. SQLite is no less “relational” than MySQL.
  2. SQLite is great for testing and prototyping, or for embedding in applications.  MySQL is worthy of (large scale) production environments.
  3. SQLite is appropriate for sites that get up to 100k hits/day. SQLite is used by Google, Adobe, Mozilla, Opera and many others.
  4. SQLite:
    • easier to setup
    • great for temporary (testing databases)
    • great for rapid development
    • great for embedding in an application
    • not fit for production (in large scale)
    • doesn’t have user management
    • doesn’t have many performance features
    • doesn’t scale well.

    MySQL:

    • far more difficult/complex to set up
    • better options for performance tuning
    • fit for a production database
    • can scale well if tuned properly
    • can manage users, permissions, etc.

Situations Where SQLite Works Well

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

生活在西班牙

自己动手丰衣足食

BlueAsteroid

Just another WordPress.com site

Jing's Blog

Just another WordPress.com site

Start from here......

我的心情魔方

天才遠私廚

希望能做一個分享各種資訊的好地方

语义噪声

西瓜大丸子汤的博客

Augmented Reality Blog

An augmented point of view

笑对人生,傲立寰宇

Just another WordPress.com site

Where On Earth Is Waldo?

A Project By Melanie Coles

the Serious Computer Vision Blog

A blog about computer vision and serious stuffs

Cauthy's Blog

paper review...

Cornell Computer Vision Seminar Blog

Blog for CS 7670 - Special Topics in Computer Vision

datarazzi

Life through nerd-colored glasses

Luciana Haill

Augmenting Consciousness with EEG

槑烎

1,2,∞

Paul Tennent

Wanderings in the Blogosphere

turn off the lights, please

A bunch of random, thinned and stateless thoughts around the Web

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: