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

Current Status

• Phase 1: Investigation

• Sprint 1
  • SQLIte shows in console
  • Use schema tool to setup a database
  • Use data load tool to create tables in the database

Project Phases

Phase 1: Investigation

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

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/