HSQLDB Study Notes

/lib/hsqldb.jar

• HSQLDB RDBMS
• HSQLDB Driver
• Database Manager (Swing and AWT)
• Query Tool (AWT)
• Sql Tool (Command line)

Running tools

• org.hsqldb.util.DatabaseManager
• org.hsqldb.util.DatabaseManagerSwing
• org.hsqldb.util.Transfer
• org.hsqldb.util.QueryTool
• org.hsqldb.util.SqlTool

Running HSQLDB

• mydb.properties
• mydb.script
• mydb.log
• mydb.data
• mydb.backup

Server Modes

• Hsqldb Server: preferred and fastest
• java -cp hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb
• Hsqldb Web Server: when only http protocol is allowed
• java -cp hsqldb.jar org.hsqldb.WebServer -database.0 file:mydb -dbname.0 xdb
• Hsqldb Servlet: must be installed into web server e.g. Tomcat
• org.hsqldb.Servlet.java
• Connecting to DB
  Class.forName("org.hsqldb.jdbcDriver");
Connection c = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/xdb","sa","");

In-Process(Standalone) Mode

• Connection c = DriverManager.getConnection("jdbc:hsqldb:file:/opt/db/testdb","sa","");

In-Memory database

Table Types

• TEMP
• Persistent
• Memory
• Cached
• Text

Vim Command Reference

Basics
:e filename	Open filename for edition
:w	Save file
:q	Exit Vim
:w!	Exit Vim without saving
Search
Replace
Case
Read/Write files
File explorer
Interact with Unix
Alignment
Tabs
Window splitting
Auto-completion
Mark
Abbreviations
Text indent
:set autoindent	Turn on auto-indent
:set smartindent	Turn on intelligent aotu-indent
:set shiftwidth=4	Define 4 spaces as indent size
ctrl-t, ctrl-d	Indent/un-indent in insert mode
>>	Indent
<<	Un-indent
Syntax highlighting