The goal of this project is to develop a modular SQL engine (JDBC driver) that can be grafted onto any raw database (such as a large flat ASCII file) through a database module API. Writing database drivers is much easier that writing a whole RDBMS.
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.
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)
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.
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
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
Be the first person to add a text review.
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: