SQLite Adapter

SQLite Adapter for NexJ

Project Goal

Develop an adapter to enable NexJ Express's model interaction with SQLite databases.

Contributors

• Carl Desautels
• Grace Batumbya

Project Status

• Stand Up Reports
• Current Sprint : 1

Project Backlog

Phase 1: Investigation (DONE)

• Get requirements from NexJ (Meeting Friday Sept 23rd)
• Walk-through the code
• Familiarization with SQLite
• Research Summary

Sprint 1

User Story	Score	Details
Initial skeleton of the SQLite adapter	2	Running the jUnit test shows in the console that the adapter is loaded an running.
Use database schema tool to generate the SQL to setup the database	1	Running the DB Schema Tool's "setup" command, appropriate artifacts are created (e.g. sql or bat script) for generating the SQLite database.
Use database schema tool to generate the SQL to create the Core datasource's tables	5	Running the DB Schema Tool's "create" command, appropriate artifacts are created (e.g. a sql file) for creating the tables in an existing SQLite database.

Project Repository

• Central: https://bitbucket.org/cwdesautels/nexj-express-sqlite-adapter

Resources

• Dowloads:
  • http://www.sqlite.org/download.html
• Documentation:
  • Root - http://www.sqlite.org/docs.html
  • About - http://www.sqlite.org/about.html
  • Types - http://www.sqlite.org/datatype3.html
  • Limits - http://www.sqlite.org/limits.html
  • Null Handling - http://www.sqlite.org/nulls.html
  • Omitted Features - http://www.sqlite.org/omitted.html
  • SQL to SQLite - http://www.sqlite.org/lang_expr.html
  • API - http://www.sqlite.org/c3ref/intro.html
• QuickStart:
  • Usage - http://www.sqlite.org/cintro.html
  • C Interface - http://www.sqlite.org/cintro.html
• SQLite JDBC Driver:
  • (Unoffical) http://www.zentus.com/sqlitejdbc/