Version 1.7.2.3: Bug fixes

Bug fixes:

• Allow newlines in quoted strings in CSV, TSV files
• ActiveX works more reliably
• Stream.eof works for exec:// streams on Windows

For ActiveX:

The handling of number data types was changed, so that integers returned from ActiveX calls that fit within 31 bits are represented as INTs, while larger integers are automatically promoted to DOUBLEs. Note that the ECMA specification says that all numbers are double-precision floating-point, but INTs may be used for storage convenience. There's still a problem that 64-bit integers can not be represented in JavaScript, but the language standards folks are working on that. Also, a few instances of redundant AddRef() and Release() calls were removed.

Version 1.7.2.2: Minor upgrade + bug fixes

Bug fixes

• Changed uint64 definition in compiler.h to auto-detect 64-bit OSs
• ODBC.table() doesn't crash when returning a null set.
  

New functions

• stream.readInt32() and stream.writeInt32()
• SQLite.tables(), odbc.keys(), odbc.columns(), odbc.escape()
• ODBC.tables(), odbc.keys(), odbc.escape()
• Updated ODBC.exec(query, callback, ...) to match SQLite.exec()
  

New features

• In-memory FIFO streams. new Stream("fifo://")
  
• Thanks, Jason!
  
• Cross-platform Web GUI
• Linux image is relocateable; reads argv[0] from /proc/self/exe
  

Version 1.7.2.1

Bug fixes

• Fixed a byte order error in Stream.readTag() that affected Sparc/PPC
• Fixed a byte order error in Stream.readInt() and Stream.writeInt().

SunOS, Bug Fixes

JSDB now compiles on SunOS. Run makejsdb.sun.

Bug Fixes

• Table.add({field:'value', field:'value'}) works without crashing.
• Table.create() now works when field types are specified.
• On UNIX, ls *.foo no longer crashes when *.foo is not found
• Added _atoi64() to libraries for systems that don't provide it.
  

SQLite! Version 1.7.2

Version 1.7.2 integrates the SQLite3 engine. Here's a test:

db = new SQLite("myfile.db")
if (!db.exec("create table people (name varchar(32), email varchar(32));"))
writeln(db.error)

db.exec("insert into people (name, email) values ('shanti','shanti@shantirao.com')")

db.exec("select * from people",writeln)

function callback(record, tableName)
{
writeln(tableName,' ',record.get('name'))
}

db.exec("select * from people",callback,"people")

New: ODBC.table()

New function, ODBC.table('tablename') for opening read/write tables directly from an ODBC connection.

SQLite coming soon.

Version 1.7

JSDB 1.7 is now available, based on the latest version of the language.

• You can do cool things like multiple return values, and use the new keywords like "let". More on JS 1.7
• ActiveX handling is improved. You should be able to use VARIANT types that JavaScript doesn't understand as opaque variables without crashing.
• OSX is pre-compiled with the iODBC library
• Linux is pre-compiled without ODBC (working on that), but build scripts for unixODBC and for iODBC are included in the source

A few more fixes are in the pipeline, like making the image relocatable under Linux. Thanks for all the feedback.