123SQL

123SQL is a small portable sqlsyntax browsing relational database.

Data import/insert into the database is TAB delimited spreadsheet data.

123SQL was designed to enable PDA users browse their data in sql manner.

This is an undergoing project aimed to construct a small portable SQL database engine for PDA's, and this is a functional browsing engine that contains data and sample browsing statements.

Data may be imported together with table/column creation. Typically the source data may be spredsheet column TAB delimited export data. Database/table/column creation may be viewed in the included code following the -c switch.

Table names and column names and field byte sizes should be specified, but column/field lengths my also vary in size row by row. The engine performs SQL keyword/syntax checking using the syntax/keywords list files included. Object names check and object attributes read is performed in the system database files named 123SQL_db_1.mar and 123SQL_db_2.mar.

Database structure allows multiple object browsing. The sorting/searching routines require low machine resources thus meeting most modern PDA specifications and their sources were also published under different names.

This project was founded on the authors' unique relational database engine structure design.