Sunday, May 30, 2010
Sunday, May 9, 2010
Postgresql user defined function tutorial
http://npgsql.projects.postgresql.org/docs/manual/UserManual.html
http://developer.postgresql.org/pgdocs/postgres/xfunc-sql.html
http://www.postgresonline.com/journal/index.php?/archives/129-Use-of-OUT-and-INOUT-Parameters.html
Posted by WadeLiu at 1:19 AM 0 comments
Saturday, May 8, 2010
Postgresql dev tool
Oracle 开发, 一直在用PL/SQL developer , 非常顺手, 现在想搞搞Postgresql, 如果单看sql 编程, Postgresql安装包带的pgAdm III功能太弱, 没有code completion功能, 所以 一直想找一个类似PL/SQL developer的工具, 终于找到2个free tool, 尤其EMS的产品, 非常棒.
EMS SQL Manager for PostgreSQL Freeware
http://www.sqlmanager.net/en/about/contact
DreamCoder for PostgreSQL Freeware (相比EMS的产品, 差得比较远, 不过也带有code completion功能, 将就着能用)
http://www.sqldeveloper.net/database-tools/postgresql/overview.html
Posted by WadeLiu at 6:22 AM 0 comments
Monday, May 3, 2010
Sunday, May 2, 2010
utilize the existed product/project to create your own .Net application cross common databases
dblinq2007是一个Linq provider, 支持很多数据库, 可以参考它的example数据库脚本和源码
http://code.google.com/p/dblinq2007/
Toad® for Data Analysts是一个支持很多种类数据库的.Net程序, 可以参考一下它的各类数据库的dll文件. http://www.quest.com/toad-for-data-analysts/
Posted by WadeLiu at 11:27 PM 0 comments