SQLite Home Page
for Windows CE
An Embeddable SQL Database Engine

  • v3.3.5 is now official!

  • New version is just a copy of the official SQLite source.
    It's available here for people to stop using the last obsolete code.
    Get it (and newer versions) here.

    Powered by:

    [NOTE: some links lead to the official SQLite home page]

    SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

    • ACID (Atomic, Consistent, Isolated, Durable) transactions.
    • Zero-configuration - no setup or administration needed.
    • Implements most of SQL92. (Features not supported)
    • A complete database is stored in a single disk file.
    • Database files can be freely shared between machines with different byte orders.
    • Supports databases up to 2 terabytes (2^41 bytes) in size. (*)
    • Small memory footprint: less than 30K lines of C code, less than 250KB code space (gcc on i486). (*)
    • Faster than other popular database engines for most common operations. (**)
    • Simple, easy to use API.
    • TCL bindings included. Bindings for many other languages available separately. (*)
    • Well-commented source code with over 90% test coverage. (*)
    • Self-contained: no external dependencies.
    • Sources are in the public domain. Use for any purpose.
    (*) Linux and Windows version
    (**) No serious tests performed on WinCE (but it's faster ;-)

    Current Status

    The Windows CE port is complete, including multi-process synchronization for WinCE versions higher than 2.11. It will work on WinCE 2.11, but if two processes are accessing a database at the same time, it could became corrupted.

    The big diference between this port and the Windows version is the fact it doesn't work in a shared folder across the network, only on a single machine (it works, but with no synchronization). But all other functionality is preserved (and can be adjusted with the proper defines, when performance is more important).

    You can use the same source to build it under Windows or Linux. It reverts to the original SQLite version when compiled for other platforms.

    The sqlite application will run on platforms with a working dos shell. Other platforms can use a 3rd party shell, like PocketConsole, to use it.

    There is work underway on making a GUI SQL manager for SQLite, under Windows CE.

    Complete source code for the latest release are available for download on the SourceForge site were this project is hosted. You can also obtain the latest changes by anonymous CVS access:

      cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/sqlite-wince login
      cvs -z3 -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/sqlite-wince co sqlite-wince
    When prompted for a password for anonymous, simply press the Enter key.