aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--build.moxie2
-rw-r--r--releases.moxie7
-rw-r--r--src/main/java/com/iciql/Constants.java2
-rw-r--r--src/site/performance.mkd2
4 files changed, 9 insertions, 4 deletions
diff --git a/build.moxie b/build.moxie
index 51034cc..11f91d8 100644
--- a/build.moxie
+++ b/build.moxie
@@ -10,7 +10,7 @@ name: Iciql
description: 'a model-based database access wrapper for JDBC'
groupId: com.iciql
artifactId: iciql
-version: 1.3.1-SNAPSHOT
+version: 1.4.0-SNAPSHOT
packaging: jar+zip
inceptionYear: 2011
diff --git a/releases.moxie b/releases.moxie
index 887eb08..abb4b56 100644
--- a/releases.moxie
+++ b/releases.moxie
@@ -10,13 +10,16 @@ r22: {
text: ~
security: ~
fixes: ~
- changes: ~
+ changes:
+ - Table constraints are now defined as part of CREATE TABLE instead of afterwards with indivudual ALTER TABLE statements. This is more portable across database backends.
additions:
- Support for specifying custom data type adapters in @IQColumn and Define.typeAdapter()
- Added com.iciql.SQLDialectPostgreSQL.JsonStringAdapter
- Added com.iciql.SQLDialectPostgreSQL.XmlStringAdapter
- Added com.iciql.JavaSerializationTypeAdapter to (de)serialize objects into a BLOB column
- dependencyChanges: ~
+ - Added an SQLite dialect
+ dependencyChanges:
+ - SQLite 3.8.7
contributors:
- James Moger
}
diff --git a/src/main/java/com/iciql/Constants.java b/src/main/java/com/iciql/Constants.java
index 82b6d79..30fcb77 100644
--- a/src/main/java/com/iciql/Constants.java
+++ b/src/main/java/com/iciql/Constants.java
@@ -25,7 +25,7 @@ public class Constants {
// The build script extracts this exact line so be careful editing it
// and only use A-Z a-z 0-9 .-_ in the string.
- public static final String VERSION = "1.3.1-SNAPSHOT";
+ public static final String VERSION = "1.4.0-SNAPSHOT";
// The build script extracts this exact line so be careful editing it
// and only use A-Z a-z 0-9 .-_ in the string.
diff --git a/src/site/performance.mkd b/src/site/performance.mkd
index 671345e..3ef2451 100644
--- a/src/site/performance.mkd
+++ b/src/site/performance.mkd
@@ -13,6 +13,8 @@ The following data was generated by running the *single-threaded* iciql test sui
Connections are pooled to normalize embedded database performance with out-of-process database performance. Some of the Java embedded database configurations have a very high startup-time penalty. Notably, H2 is slow to open a database and its performance is substantially affected if connection pooling is not enabled to keep the embedded database open.
+SQLite uses the default [DELETE journaling mode](https://www.sqlite.org/lockingv3.html#rollback). About a 4x performance improvement can be achieved when using the [WAL journaling mode](https://www.sqlite.org/wal.html) (`PRAGMA journal_mode = WAL`).
+
External process databases (MySQL & PostgreSQL) use the default settings as provided by the platform.
All tables are created as CACHED when the database distinguishes between CACHED and MEMORY tables.