http://sqlzoo.net/为大家提供了一个交互式学习 SQL语句的平台，学习的内容包括：SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite 和 Access。

对某些SQL语句无法理解的朋友不妨试试这个网站。

值得一提的是，官方还提供了中文的镜像，镜像地址：http://vzoo.net/

Starting Monday, Google will offer Google Apps for Your Domain, a free package of programs for businesses, universities and other organizations.

Workers will be able to send e-mail with Gmail, Google’s two-year-old Web-based mail service, but messages will carry their company’s domain name. The package also includes Google’s online calendar, instant-messaging service, and Page Creator, a Web page builder.

For more infomation, please visit http://www.google.com/a

查看FIN_WAIT_2连接数：

bsd#netstat -an | grep FIN_WAIT_2 | wc -l
2523

修改Lighttpd配置文件，加入下面这条语句：

server.max-keep-alive-requests = 0

bsd#netstat -an | grep FIN_WAIT_2 | wc -l
91

如果服务器开启了ipfw2防火墙的话，还需要执行：

sysctl -w net.inet.ip.fw.dyn_keepalive=0

p.s. 若为APACHE服务器，同理。

注：此文章由本人CSDN上的BLOG迁移过来

最近在做一个项目，有大量的数据需要实时更新，同时要求多台服务器可共享这些数据，类似于股票系统，因此决定使用B/S+中间层三层架构，其中使用Web Services作为中间层，原因在于，从长远角度来考虑，以后可能会增加C/S结构，所以采用Web Services是个绝好的选择。

系统架构图如下：
Read more…

From Mike Potter’s blog: Today I’m happy to announce that I’ve started a new project called the (unofficial) Adobe PHP SDK, which is intended to enable PHP developers to build solutions with Adobe RIA technologies quickly. The (unofficial) Adobe PHP SDK contains samples and libraries that show how to connect to a PHP backend system with either the Adobe Spry Framework (for Ajax applications) or Adobe Flex (for Flash based applications).

You can download the adobe_php_sdk.zip file immediately, extract it and explore the samples and demos immediately.

In true open source fashion, all the code in the project is currently available in various open source licenses, and the content for the HTML page is available under the Creative Commons license.

There is a project hosted at Google Code for the Adobe PHP SDK, and a mailing list at Google Groups as well.”

You can download the (unofficial) Adobe PHP SDK from http://blogs.adobe.com/mikepotter/adobe_php_sdk.zip You can join the Google project at http://code.google.com/p/adobe-php-sdk/ and you can join the Adobe PHP SDK mailing list at http://groups.google.com/group/adobe_php_sdk/

1. 什么是参照完整性?
——————–
参照完整性(完整性约束)是数据库设计中的一个重要概念，当数据库中的一个表与一个或多个表进行关联时都会涉及到参照完整性。比如下面这个例子：
文章 分类表 – categories
category_id name
1 SQL Server
2 Oracle
3 PostgreSQL
5 SQLite

文章表 – articles
article_id category_id title
1 1 aa
2 2 bb
3 4 cc

可见以上两个表之间是通过category_id，其中categories表有4条记录，articles表有3条记录。
Read more…

There is two method to install marvell 88e8050 nic driver: install the binary version from marvell official website or compile the driver source from andre’s homepage.

1. Install the binary version from marvell official website.
download the driver from http://www.marvell.com/drivers

#tar -xvf mykbsd60x86-8.12.2.3.tar
#cp if_myk.ko /boot/kernel/
#kldload if_myk.ko

Read more…