headers
Markus Hoenicka | 3 Dec 2007 23:08
Picon

ANN: updated PHP web interface for 0.9.9

Hi,

in an attempt to make the progress in the PHP web interface available
to users independently of major releases, I've compiled a small
archive with the current svn versions of the files. The archive (37kB)
is available for download here:

http://refdb.sourceforge.net/pre/refdb-phpweb-0.9.9-2.tar.gz

The tarball contains instructions how to "install" the files properly.

The new features of this prerelease are:

- the output of reference and index searches is now chunked. You can
  page through the output with "previous" and "next" buttons as
  appropriate. By default, 10 references and 50 index entries are
  displayed

- the number of reference entries and of index entries per page can
  now be set in the preferences tab

Your continued feedback is more than welcome.

regards,
Markus

--

-- 
Markus Hoenicka
markus.hoenicka <at> cats.de
(Spam-protected email: replace the quadrupeds with "mhoenicka")
(Continue reading)

Permalink | Reply | 0 comments |
headers
Markus Hoenicka | 12 Dec 2007 11:03
Picon

Possible data corruption in MySQL

Hi all,

I'd like to make you aware of a problem with the libdbi MySQL driver  
which you are using if you run MySQL as your database engine for  
RefDB. There is a bug which may screw up your data under the following  
circumstances (other scenarios are possible though):

1) Your database uses UTF-8 encoding

2) You store multibyte characters (like UTF-8 umlauts)

Now what happens is that the MySQL driver incorrectly causes the data  
to be transformed to "UTF-8" again, making umlauts take up 4 instead  
of 2 bytes. If you retrieve your data with RefDB again, the problem  
may be silent as the data are transformed back again. Assume your  
dataset with the ID 1 has an author called "Bäuml". Using the current  
MySQL driver the author name will be stored with the umlaut "ä"  
encoded as 4 byte.

1) if you retrieve the dataset using "getref :ID:=1", the query will  
succeed, and the author will be returned as "Bäuml" with the "ä"  
taking up 2 byte.

2) if you attempt to retrieve the dataset using "getref :AX:~Bäuml",  
the query will fail as the "ä" in your query string uses 2 bytes  
whereas the author name in the database uses 4 bytes for the same  
character.

A fixed version of the MySQL driver will be available shortly. It is  
important to understand that you have to export your data using the
(Continue reading)

Permalink | Reply | 0 comments |
headers
Markus Hoenicka | 27 Dec 2007 01:42
Picon

ANN: refdb-publist-1.1 available

Hi,

refdb-publist is essentially a brushed-up refdbnd project which allows
you to generate publication lists dynamically from the data stored in
your RefDB database. Be it the publication list in your CV, or an
annual department report, maintenance is simplified to running
e.g. "make pdf" whenever you need an updated version. A real-world
example can be viewed here:

http://www.mhoenicka.de/mhoenicka-publist.pdf

I've updated the refdb-publist package to work with RefDB 0.9.9. In
addition to the changes mandated by the new RefDB version, I've
rearranged the package a bit to make things easier to understand.

The package is available on the SF download page, see

http://sourceforge.net/projects/refdb

The documentation was updated and is available online now, see

http://refdb.sourceforge.net/doc.html#refdb-publist

Feel free to send comments, suggestions, and bug reports to this list.

regards,
Markus

--

-- 
Markus Hoenicka
(Continue reading)

Permalink | Reply | 0 comments |

Gmane