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.


  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.


    • 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




Just another WordPress.com site

Jing's Blog

Just another WordPress.com site

Start from here......







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 stuff

Cauthy's Blog

paper review...

Cornell Computer Vision Seminar Blog

Blog for CS 7670 - Special Topics in Computer Vision


Life through nerd-colored glasses

Luciana Haill

Brainwaves Augmenting Consciousness



Paul Tennent

Wanderings in the Blogosphere

turn off the lights, please

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


Get every new post delivered to your Inbox.

Join 27 other followers

%d bloggers like this: