Release annoucement for tryton 1.4

tryton_release_announcement

+
+
+Tryton 1.4 is available
+=======================
+
+
+This new series brings new modules, security and performance

[yangoon1, 2009/10/20 00:38:01]

This new series comes up with new modules, security and performance improvements
as well as support for the SQLite database featuring Neso, a standalone version
of Tryton.

[bch, 2009/10/20 08:21:01]

"SQLite database featuring Neso" -> what was wrong with the "and welcome the
arrival of Neso" ?

+improvements as well as the SQLite support and welcome the arrival of
+Neso, the standalone version of Tryton. As usual, database migration
+is completely automated (and works on databases created with both the
+1.0 and 1.2 series). Most of bugfixes that result from the last 6

[yangoon1, 2009/10/20 00:38:01]

Most of the bugfixes from the last 6 months of development have already been
backported to the 1.0 and 1.2 versions.

+month of developments have been already backported and are available

[ced1, 2009/10/19 21:39:49]

months

+in the 1.0 and 1.2 series.

[ced1, 2009/10/19 21:39:49]

(release will come)

+
+
+Database Independence and SQLite Support
+----------------------------------------
+
+The subset of code that handles the database and the database access

[yangoon1, 2009/10/20 00:38:01]

Database handling and access was reworked to provide a more generic way for the
connection of different backends. As a first alternative backend Tryton now
offers support for SQLite.

+becomes more and more generic and offer now the SQLite support.

[ced1, 2009/10/19 21:39:49]

offers

+
+* The server is now able to do the validation of the "NOT NULL" and
+  field length constraints. It was necessary as SQLIte doesn't handle

[yangoon1, 2009/10/20 00:38:01]

... field length constraints providing the ability to switch SQL errors from
SQLite to user friendly messages.

+  them yet and provides more user friendly error messages (in place of
+  SQL error coming from the DBMS).··
+* generalisation of the tables sequences handling and the creation of

[yangoon1, 2009/10/20 00:38:01]

Generalisation of the tables sequences handling and creation of ...

+  pagination clauses ("LIMIT" and "OFFSET"), those two concepts are

[yangoon1, 2009/10/20 00:38:01]

those two concepts now being independent...

+  now independent of the DBMS.
+
+
+Neso
+----
+
+Neso is a standalone version of Tryton: Neso takes advantage of the
+new SQLite support and integrates client and server code of Tryton. So

[yangoon1, 2009/10/20 00:38:01]

...integrates the client and server code...

+it's a pure desktop application with all the power of Tryton, the same

[yangoon1, 2009/10/20 00:38:01]

It is a pure desktop application with the rallied power of Tryton without the
need to configure a separate server or database.

+modules, the same features except that it doesn't need a server to
+operate. Neso is a perfect fit for single user usage or simply for
+demo.

[yangoon1, 2009/10/20 00:38:01]

...demonstration or testing purposes.

+
+To improve the use of Tryton with Neso, it's now possible to launch

[yangoon1, 2009/10/20 00:38:01]

Another facility of Neso is the possibility of an automatic database update
after the restoration.

+the database update just after its restoration. Moreover the field
+with the server address is hidden (as it is useless).

[ced1, 2009/10/19 21:39:49]

I will not talk about hidden field.

[yangoon1, 2009/10/20 00:38:01]

+1

+
+
+Security
+--------
+
+Security has been improved on various points:
+
+* The user is asked for his (old) password when he wants to change it.

[ced1, 2009/10/19 21:39:49]

to prevent change by thirst person when desktop is leaved.

[yangoon1, 2009/10/20 00:38:01]

Password prompt on password change to prevent abuse on a left desktop machine.

+* Evaluation of some code strings now prevent code injection.

[ced1, 2009/10/19 21:39:49]

Evaluation of code strings now prevents code injection.

+* Model access check are also made on property fields.

[yangoon1, 2009/10/20 00:38:01]

...checks are also performed on...

+* The client now warn the server for user logout, hence limiting some

[ced1, 2009/10/19 21:39:49]

warns

[yangoon1, 2009/10/20 00:38:01]

...informs the server on user logout to prevent the possibility of session
hijacking.

+  session hijack opportunities.
+* Handling of read, write, create and delete permission on record
+  rules.
+* Salted passwords: This improve encryption robustness against rainbow

[yangoon1, 2009/10/20 00:38:01]

...passwords improving...

+  table attacks.
+
+
+Performances

[yangoon1, 2009/10/20 00:38:01]

Performance

+------------
+
+Amongst other things, network communication and cache handling on

[yangoon1, 2009/10/20 00:38:01]

Among the most important innovations network communication and cache handling
have been improved:

+server side have been improved:
+
+* Gzip compression support for pysocket and XML-RPC queries on the
+  server.
+* Use of the the gzip compression on the client side (via pysocket).

[yangoon1, 2009/10/20 00:38:01]

Use of the the gzip compression on the client side.

+* Cache improvement on the server: the cache have been moved from the

[yangoon1, 2009/10/20 00:38:01]

the cache has been moved...

+  "BrowseRecord" to the cursor, this ensure that each record is read

[yangoon1, 2009/10/20 00:38:01]

ensuring the reduction of read accesses for records to mostly only one per
transaction.

+  at most once in the same transaction.
+* Fill the cursor on search: Most of the database read are preceded by

[yangoon1, 2009/10/20 00:38:01]

Filling the cursor on the search prevents the need of a second access to the
database for modifications on those records.

+  a search on the same records, this modification allow to not access
+  the database anymore for records that have been subject to a search
+  query.
+* New heuristic that allows to sharply reduce the length of queries

[yangoon1, 2009/10/20 00:38:01]

...allowing an important reduction...

+  containing a lot of identifiers.
+* Results are no more ordered if it's no more necessary.

[yangoon1, 2009/10/20 00:38:01]

...ordered without explicit necessity.

+* Support of "delete_all" on "One2Many" fields: This allows to delete

[yangoon1, 2009/10/20 00:38:01]

...fields allowing the deletion of records without read operation providing more
...

+  records without reading them and brings more consistency with the
+  "Many2Many" field which has already this operator.
+
+
+User Interface
+--------------
+
+* Wizards preserve their sizes from successive calls.

[ced1, 2009/10/19 21:39:49]

It is optional.

+* Allow to reset default values.

[ced1, 2009/10/19 21:39:49]

user default values

+* Support for fields that contains time duration: they express hours

[ced1, 2009/10/19 21:39:49]

contain

+  but may contains values like "1d" (1 day) or "3w" (3 weeks).

[ced1, 2009/10/19 21:39:49]

1m 2w 1d
to be more complex.

[yangoon1, 2009/10/20 00:38:01]

contain

+* The status bar can be hidden.
+* Wizard can be opened in tabs (instead of a pop-up).
+* The user can choose to allow or disallow keyboard shortcuts
+  (accelerators) creation from the main menu.
+* Keyboard navigation with keyboards arrows between widgets.
+* New filters "Starts with" and "Ends with" on fields containing
+  strings.
+* Selection fields only shows values that comply with the current
+  domain.
+
+
+Other New Features
+------------------
+
+* Reload of modules if files have changed: This shorten the

[yangoon1, 2009/10/20 00:38:01]

...shortens the development cycle as the server does not need to be restarted on
file modification.

+  development cycle (code - relaunch server - test - code - etc) as
+  the server does not need to be restarted when a module is
+  modified. This also allow to update a production server while

[yangoon1, 2009/10/20 00:38:01]

allows

+  keeping users connected.
+* New field "datetime_field" one "One2Many" and "Many2Many": this
+  allows to read those fields at an arbitrary date in the past.

[ced1, 2009/10/19 21:39:49]

and completes the visualization of history of records.

+* Use the module dependency order to apply views inheritance. View
+  inheritance is now systematic and predictable.
+* New model "ModelSingleton": His main use is for configuration

[yangoon1, 2009/10/20 00:38:01]

...Its main use

+  options that are linked to the database itself (and not the user or
+  the company).
+* OSV is renamed to Model in the Workfow module, this further the

[yangoon1, 2009/10/20 00:38:01]

..in the Workflow module advancing the refactorisation beginning with the 1.2
release.

+  refactorisation that came with the 1.2 release.
+* Improvement of the database migration tools: automatic handling of
+  table sequence and history table when a table is renamed; indexex,

[ced1, 2009/10/19 21:39:49]

indexes

+  constrains and foreign keys deletion available on arbitrary tables.

[yangoon1, 2009/10/20 00:38:01]

constraints

+* Fixed words translations in dates (for month names and days of

[ced1, 2009/10/19 21:39:49]

in datetime formatting on server side

[yangoon1, 2009/10/20 00:38:01]

translation of words (strings?)

+  week).
+* Use of a default file name when backup is created.

[yangoon1, 2009/10/20 00:38:01]

Provide a def...

+* Handling of the required attribute in domains.
+* Support of call to "today()" on "ir.data" from XML-RPC: provides to

[ced1, 2009/10/19 21:39:49]

ir.date

+  an external software for what is considered to be the current date
+  by the Tryton server.
+* Authentication code have been moved on "res.user", this allows to

[yangoon1, 2009/10/20 00:38:01]

...has been moved ... allowing ...

+  overload it and provide other authentication mechanism (see

[yangoon1, 2009/10/20 00:38:01]

mechanisms (see ldap_authentication).

+  ldap_authentication here under).
+* Temporary file names containing reports are now the report name

[yangoon1, 2009/10/20 00:38:01]

Temporary report files now contain the report name to be more meaningful.

+  itself instead of a generated one without meanings.
+* Backup creation and restoration are now possible for PostgreSQL
+  connections that need with password.

[yangoon1, 2009/10/20 00:38:01]

that need a password.

+
+
+New modules
+-----------
+
+* calendar: Add CalDAV support.
+* calendar_todo: Add Todo support on CalDAV.
+* company_work_time: define work times in the company.

[yangoon1, 2009/10/20 00:38:01]

Define

+* google_translate: Translate items with Google Translate.
+* ldap_authentication: Authenticate users with LDAP server.

[ced1, 2009/10/19 21:39:49]

and Active Directory

+* ldap_connection: Add basic support for LDAP connection.
+* party_vcarddav: Add CardDAV on parties.
+* product_pricelist: Define price list rules by parties.
+* project: Project management.
+* project_revenue: Add product on timesheet lines and define allowed
+  services for each employees.
+* sale_pricelist: Define price list on party and sale order.

[ced1, 2009/10/19 21:39:49]

Define sale price list

[yangoon1, 2009/10/20 00:38:01]

sale price lists

+* timesheet:Timesheet Module with:
+    - Work
+    - Timesheet line
+
+And with reports:

[ced1, 2009/10/19 21:39:49]

Indentation is not very clear.

[bch, 2009/10/20 08:21:01]

will be fixed in blogger

+    - Hours per work,
+    - Hours per employee per week,
+    - Hours per employee per month.
+
+
+New Features in Existing Modules
+--------------------------------
+
+account
+~~~~~~~
+
+* Origin tax is taken into account in tax rules.
+* Fix digits of amounts on tax and tax lines.
+
+account_invoice
+~~~~~~~~~~~~~~~
+
+* Set invoice date when the invoice is opened.
+* Add the invoice number to the report name.
+
+
+account_statement
+~~~~~~~~~~~~~~~~~
+
+* Fix digits of start and end balance
+
+
+analytic_account
+~~~~~~~~~~~~~~~~
+
+* Use the right currency to compute  balance, debit/credit of accounts
+
+
+currency
+~~~~~~~~
+
+* Add rounding option to currency round (allow other rounding than
+  Half to even)
+* Allow to call "compute" on "currency.currency" from XML-RPC: this
+  provides the currency conversions to external softwares.
+
+
+stock
+~~~~~
+
+* New group of user "Stock Force Assignment": only member of this

[yangoon1, 2009/10/20 00:38:01]

members

+  group will be allowed to force assignations.
+* Migrate "packing_in", "packing_out", etc tables to "shipment_in",
+  "shipment_out", etc. This close the wording correction started with

[yangoon1, 2009/10/20 00:38:01]

closes

+  the 1.2 version of the module and provide more consistency between

[yangoon1, 2009/10/20 00:38:01]

provides

+  the labels shown to the user and the name of the tables. The goal
+  was to keep the module easy to understand and to maintain.