[Sqlgrey-users] DEV RELEASE 1.5.0

[Lionel B. <lio...@bo...>]

Hi,

1.5.0 is out on sourceforge.

 - drop support for obsolete command-line parameters
 - migrate databases to a new layout :
  . first_seen added to the AWLs
  . optimize AWL Primary Keys
  . add indexes

You must either :
- use a 1.4.x database, this version will automagically convert it to 
the new layout,
- start your database from scratch.

SQLgrey 1.2.x (and below) conversions are not supported (yet). If 
someone needs this for SQLgrey 1.6.x, I need to know (I'll have to 
bundle a separate conversion script).

I tested the conversion with MySQL 4.0.22, PostgreSQL 7.4.7 and SQLite 
2.8.15.
This is the SQLgrey's version I'm currently using on my MX...

So it's "worksforme" material.

If you want to test this :
- backup your database (you don't want to sort out the layout changes to 
revert back to the old layout manually),
- if you have a huge database, SQLgrey might take some time to convert 
to the new layout, you may want to disable the policy service 
temporarily in Postfix,
- upgrade then restart SQLgrey,
- monitor the logs to see it upgrading the database,
- when done, enable the policy service,
- enjoy the new indexes :-)

I don't disable the primary keys when copying data around as it probably 
would make the conversion process heavily database dependant (different 
syntaxes...), but I don't create the other indexes until the end of the 
copy.
I'm interested in conversion delays if you have thousands of entries or 
more in your table, please send a note on the list with :
- your database,
- SELECT count(*) for each table,
- the conversion delay you spot in your logs.

Lionel.