SQLiteDBMS / News: Recent posts

SQLiteDBMS 0.5.1 has been released, containing a patch for some bugs.

• replication slave leaks fixed.
• libsqlited's bugs fixed.
• more stability

Release note: http://sourceforge.net/project/shownotes.php?release_id=463774&group_id=106881

Homepage: http://www.sqlitedbms.org/

Version 0.5.0 of SQLiteDBMS has been released.
This version patches some new features.

1. Replication support(1:n multi slave)
2. logger(daily rotate)
3. Support for memory DB(:memory:, session implement)
4. fix some bugs

New document for libsqlited: http://sqlitedbms.sourceforge.net/doc/libsqlited.htm

Release note: http://sourceforge.net/project/shownotes.php?release_id=450338&group_id=106881

Homepage: http://sqlitedbms.sourceforge.net/

SQLiteDBMS 0.4.2 has been released, containing a patch for some bugs and new features.

• fix bug wrong client socket ( IMPORTANT )
• load & run shared object's external method
• fix bug on load config file

Release note: http://sourceforge.net/project/shownotes.php?release_id=429385&group_id=106881

Homepage: http://www.sqlitedbms.org/

SQLiteDBMS 0.4.1 released.

1. perfomance improvements
   1-1. query cache(req. SQLite >= 3.3.5)
   1-1-1. global query cache pool
   1-1-2. add "cache use", "cache slot", "cache size" config entry
   1-2. improve SQL switcher. "INSERT", "DELETE" SQL is faster than older version
2. no limit timeout: timeout set to 0
3. SQLiteDBMS Client implove FireFox compatible(move and resize box)
4. HTML Client support for SSL... read more

Version 0.4.0 of SQLiteDBMS has been released.
This version patches some new features.

1. Support for SSL
2. add "-s" option for SSL
3. libsqlited(now beta) supports SSL too
4. fix some bugs

New document for libsqlited: http://sqlitedbms.sourceforge.net/doc/libsqlited.htm

Release note: http://sourceforge.net/project/shownotes.php?release_id=427528&group_id=106881

Homepage: http://sqlitedbms.sourceforge.net/

SQLiteDBMS 0.3.1 released.

1. Support prepared statement
2. Support MacOS X(tested on intel macmini)
   .. and more fix and improve

libsqlited document: http://sqlitedbms.sourceforge.net/doc/libsqlited.htm

Release note: http://sourceforge.net/project/shownotes.php?release_id=423823&group_id=106881

Homepage: http://sqlitedbms.sourceforge.net/

Version 0.3.0 of SQLiteDBMS has been released.
This version patches some new features.

1. Support WebDAV(via PUT/DELETE HTTP method)
2. libsqlited(now beta) supports large response

New document for libsqlited: http://sqlitedbms.sourceforge.net/doc/libsqlited.htm

Release note: http://sourceforge.net/project/shownotes.php?release_id=416551&group_id=106881

Homepage: http://sqlitedbms.sourceforge.net/

SQLiteDBMS 0.2.4 released.

1. Add libsqlited(C client API) alpha
2. Fix configure script error

libsqlited document: http://sqlitedbms.sourceforge.net/doc/libsqlited.htm

Release note: http://sourceforge.net/project/shownotes.php?release_id=416395&group_id=106881

Previous release note: http://sourceforge.net/project/shownotes.php?release_id=410443&group_id=106881

Homepage: http://sqlitedbms.sourceforge.net/

SQLiteDBMS 0.2.3 has been released, containing a patch for some new features.

1. new HTTP protocol parser
   1-1. 3x faster for GET method
   1-2. 2~3x faster for POST method(DB process)
2. add "ALTER USER" extended SQL

Release note: http://sourceforge.net/project/shownotes.php?release_id=410443&group_id=106881

Previous release note: http://sourceforge.net/project/shownotes.php?release_id=409821&group_id=106881... read more

SQLiteDBMS 0.2.2 has been released, containing a patch for some bugs

1. "SHOW STATUS"
   1-1. fix returning wrong dbname
   1-2. result's format is same as data result
   1-3. "SHOW" extended SQL access control
2. fix authorizer's wrong dbname pointer
3. result includes process time
   3-1. SQLiteDBMS client show process time on status bar
4. fix memory leak

Release note: http://sourceforge.net/project/shownotes.php?release_id=409821&group_id=106881... read more

SQLiteDBMS 0.2.1 has been released, containing a patch for some bugs and new features.

1. add "SHOW USER" extended SQL
2. support access control
   2-1. add "GRANT [CREATE]" extended SQL
   2-2. add "REVOKE [CREATE]" extended SQL
   2-3. add "access control" configuration entry
3. improve SQLiteDBMS client and fix some bug
   3-1. improve grid
   3-2. improve/fix syntax highright
4. load user/auth info to memory when startup(auto refresh when grant/revoke)
5. "CREATE USER" extended SQL change to "CREATE USER id password [superuser]"... read more

SQLiteDBMS 0.2.0 has been released, containing a patch for some bugs and new features.
0.2.0 is first beta release. This version includes new client tool.

1. Add "SHOW" extended SQL
   1-1. add "SHOW DATABASE" extended SQL
   1-2. change "SHOW TABLES" to "SHOW TABLE"
   1-3. add "SHOW INDEX" extended SQL
   1-4. add "SHOW TRIGGER" extended SQL
   1-5. add "SHOW VERSION" extended SQL
2. Add "DESC" extended SQL
3. Add JavaScript version client
   3-1. web base GUI
   3-2. support Firefox and MS-IE
   3-3. include XMLHTTPRequest lib(like AJAX)
   3-4. MDI box model
   3-5. table/view/index/trigger designer
   3-6. SQL syntax highright
   3-7. data editor(support transaction)
4. configure script support RPM version of sqlite3... read more

SQLiteDBMS 0.1.6 has been released, containing a patch for some bugs

bug #1450192: "Wrong idle time on show status SQL" fixed.
bug #1450184: "Wrong Content-length response headers" fixed.
improve #1450193: "ctrl+enter -> execute on HTML version client tools" reflected

and, beta 0.2.0 will release soon.

Minor release 0.1.5 patches critical crash

SQLiteDBMS 0.1.5 has been released, containing a patch for a critical crash bug.

SQLiteDBMS 0.1.4(last alpha) Release

• support large response bigger than 1MB(chunked transfer encoding)
• polling when send
• add documents

This release is lastest alpha version. Next version is 0.2.0

CVS and Homepage are not available
http://sqlitedbms.sourceforge.net/

CVS of the SQLiteDBMS and homepage are available

SQLiteDBMS CVS : http://sourceforge.net/cvs/?group_id=106881

SQLiteDBMS Homepage : http://sqlitedbms.sourceforge.net/

last release: 0.1.3

• add session monitor
• add "SHOW STATUS" extend SQL
• show session list with informations.
• fix session bug
• remove document-length header where 304 response
• add -v flag(show version)

• add "SHOW TABLES [TABLENAME]" SQL
• add "SHOW INDEX [TABLENAME]" SQL
• add Documents

Only visit "http://YOUR_SERVER_IP:6543/"

SQLiteDBMS 0.1.1 release

SQLiteDBMS supports sqlite 3.x
HTTP request, XML response, DB session auth.

and support extended SQL

1. CREATE DATABASE
2. DROP DATABASE
3. CREATE USER
4. DROP USER

and includes simple web server

1. simple client(HTML version)
2. static files serve(GET request, POST db process)

please type in web browser "http://SERVER_IP:6543/" and see start page

http://sourceforge.net/projects/sqlitedbms/... read more