Tuesday, December 1, 2009

Thursday, October 15, 2009

Wednesday, June 10, 2009

Google AppEngine for Java cons

What is lacking to google appengine java SDK :
- Support for Lucene (or any other indexing service). As an example, how would you do to implement an Ajax Autocomplete functionality?
- "group by" implementation for JPA-QL
- JTA annotations support

What the service should provide :
- A way of hot-deploying the application without service interruption.
- Database bulk export

What is dangerous :
- If you make a mistake in your DB model and you deploy, the model will automatically updated (even dropping columns or tables). And there is no way to recover your data.
- The DataStore is said to be "Transactionnal", but this isn't completely true. As said in the following Google I/O video transations are only valid across datastore's "entity groups" ; and this is a very important limitation to know when designing your business logic.

Thursday, December 4, 2008

netbox

La nouvelle netbox, alias lepacktv chez fnac est disponible.
Je vous propose d'aller voir la vidéo de démo officielle

Wednesday, December 3, 2008

WMDRMSDK avec windows 64 bits

exécuter la commande :
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1*

qui permettra aux pages ASP d'utiliser le mode 32 bits.


Note : la réponse officielle de microsoft était de passer à PlayReady

Tuesday, October 28, 2008

Récupérer le certificat SSL avec wget

#!/bin/sh
# Show website certificate. Usage: check-web www.example.org:443
echo GET / HTTP/1.0 | openssl s_client -connect "$1" 2>&1

Tuesday, September 2, 2008

SQL eviter de faire un update massif par erreur

-- script évitant de faire un update massif plutôt que d'une seule ligne (typiquement lorsque l'on oublie la clause where)

begin transaction

-- votre commande SQL (ex : update from mytable where id=1)

-- exception si plus de 1 ligne updatée
IF (@@ROWCOUNT > 1)
BEGIN
RAISERROR ('too many lines.', 16, 1)
ROLLBACK TRANSACTION
return
END

commit transaction

Tuesday, August 26, 2008

script backup quotidien d'une base mysql

#!/bin/bash

# setup
suffix=`date +%Y%m%d`
cmd='/usr/bin/mysqldump'

echo "backup..."
${cmd} --user=root --single-transaction #db_name | bzip2 -c > db_${suffix}.sql.bz2

echo "ftp..."
# chmod 600 .netrc
ftp -n #ftp_server <<End-Of-Session
user #user #password
binary
put db_${suffix}.sql.bz2
bye
End-Of-Session

echo "backup done"

html:link ayant plus d'un paramètre

sans utiliser cette merde de property avec un Map :
utiliser un tag html:param