Matt Sergeant has created a pretty exciting module for database development : DBD::SQLite. This module is a self-contained relational database system, meaning that the module is the server.
Here's the features of SQLite, straight from the website
- Implements a large subset of SQL92.
- A complete database (with multiple tables and indices) is
stored in a single disk file.
- Atomic commit and rollback protect data integrity.
- Small memory footprint: less than 20K lines of C code.
- Four times faster than PostgreSQL.
Twice as fast as SQLite 1.0.
- Very simple C/C++ interface requires the use of only
three functions and one opaque structure.
- TCL bindings included.
- A TCL-based test suite provides near 100% code coverage.
- Self-contained: no external dependencies.
- Built and tested under Linux and Win2K.
- Sources are uncopyrighted. Use for any purpose.
The only thing that troubles me is that SQLite has no concepts of data types. All the data verification will have to be on the client's end, rather than maintained in the db.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|
