SQLite Adapter for NexJ
Project Goal
Develop an adapter to enable NexJ Express's model interaction with SQLite databases.
Contributors
Supported Versions
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
Resources
- Dowloads:
- 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/