Be the first to post a text review of Modular JDBC SQL Engine (ModSQL). Rate and review a project by clicking thumbs up or thumbs down in the right column.

• File released: /modsql/0.40/modsql-0.40.tar.bz2

  posted 2195 days ago

• modsql 0.40 file released: modsql-0.40.tar.bz2

  New in 0.40: ModSQL: * split DatabaseTable into seperate table and index interfaces * implemented CREATE/DROP TABLE and INSERT/UPDATE/DELETE * implemented JDBC PreparedStatement (but not parameters) * major rewrite of expression evaluation and query execution code * new Function interface for database provided SQL functions * support for SQL row constructors * slightly better join order optimization AsciiDatabase: * RCFile is no longer a seperate package, but a part of AsciiDatabase TemporaryDatabase: * new database driver for in-memory temporary (updatable) tables modsql: * SQL command summary help text * client side implementation of PostgreSQL COPY TO/FROM commands * accepts SQL style '--' comments in scripts * implemented '-S' option for squeezed fixed width output * implemented '-F' option for delimited output * implemented '-v' option to output status on stderr * much more thorough testing (especially subqueries and corner cases)

  posted 2196 days ago

• email change for developer

  Please note that the address chris.studholme@canada.com no longer works for sending comments to the developer of this project (ie. me). Please use the address chris,studholme*utoronto,ca (, is .; * is @) to send me any comments, questions, etc. Thanks.

  posted by cstudhol 2417 days ago

• File released: /modsql/0.30/modsql-0.30.tar.gz

  posted 2515 days ago

• modsql 0.30 file released: modsql-0.30.tar.gz

  New in 0.30: ModSQL: * compile fixed for new versions of java * changed to arbitrary Object for rowid values * allow JOIN...USING and JOIN...ON * sort values in IN (...) for better performance * make use of DatabaseTable.findNext() to improve join performance * rewrote sorted index class and implemented hash table indices * allow column names in SELECT to be used in HAVING (and ORDER BY) * rewrote LIKE pattern matching to be simpler and less likely to crash AsciiDatabase: * added filter to append 19 or 20 to 2-digit year (Y2K fix) * allow field descriptions (comments) to be added to table definition * added option for using delimited access * improved seek efficiency SampleDatabase: * minor updates to support DatabaseTable interface changes modsql: * added --null, --true and --false options

  posted 2516 days ago

• modsql 0.20 file released: ModSQL-0.20.tar.gz

  New in 0.20: ModSQL: * removed getIndexFilename() from DatabaseManager interface, now only exists in IndexTable class * rewrote DriverConfig class to read file ModSQL.conf (found in same directory as ModSQL class files) and export interface to it * moved indexpath variable from AsciiDatabase config file to ModSQL.conf * some implementation of Value.evaluate(matchvalue,matchfunction) to better optimize queries involving logical AND, OR and NOT * DatabaseManagers no longer register themselves with MetaManager, MetaManager registers Managers listed in ModSQL.conf SampleDatabase: * rewrote DummyDatabase as SampleDatabase to have a more general design for in-memory database tables AsciiDatabase: * added 'd' column option to AsciiDatabase for divide (found that *1e-3 not as accurate as /1000) New in 0.10: * initial release

  posted 3636 days ago

• File released: /modsql/0.20/ModSQL-0.20.tar.gz

  posted 3636 days ago

• File released: /modsql/0.10/ModSQL-0.10.tar.gz

  posted 3637 days ago

• Code committed

  Anonymous committed patchset 1 of module CVSROOT to the Modular JDBC SQL Engine (ModSQL) CVS repository, changing 11 files

  posted by nobody 3641 days ago

• Forum thread added

  Anonymous created the Welcome to Help forum thread

  posted by nobody 3641 days ago