Main Page

From Cristiano da Cunha Duarte

Author

CRISTIANO DA CUNHA DUARTE

Graduated in Computer Science by PUC/MG and specialized in Communication Networks Application and Design by UnB.

C, C++, PHP5, Java, CORBA developer and Linux Server administrator (note: also Windows 2000 administrator).

• Curriculum
• Personal Activities

Articles

DBLink and Materialized View (Snapshot) on PostgreSQL

View full article (First created on 30 Apr 06)

How to make dblinks and materialized views (snapshots) on PostgreSQL. Includes a complete code that allows:

• CREATE DBLINK
• DROP DBLINK
• CREATE SNAPSHOT REFRESH COMPLETE|FAST|FORCE ON PREBUILT TABLE
• DROP SNAPSHOT
• REFRESH SNAPSHOT
• CREATE SNAPSHOT LOG
• DROP SNAPSHOT LOG

Note: Code based on DBI-Link. Covers why DBI-Link does not solve all problems and why, in some cases, the materialized views are the most efficient choice.

How to easily build a VPN with IPSec (Kernel 2.6)

View full article (First created on 04 Jan 05)

This tutorial shows an easy to follow setup for VPNs between two hosts using the KAME IPSec standard present in Linux Kernel 2.6.

CORBA for PHP: PHP5 CORBA Extension

View full article (First created on 20 Oct 03)

CORBA for PHP is a PHP5 extension that enables the use of CORBA objects in PHP. The purpose of this project is to provide:

• an IDL to PHP language mapping specification;
• an IDL to PHP language compiler(idl2php);
• an extension fully compliant with CORBA 2.4 standard(and maybe 3.0).

Links

• ADODB extension for PHP: An object-oriented database abstraction library. It's lightweight and has many optimizations specific to each database implementation. The english tutorial can be viewed at Moving from MySQL to ADODB
• PostgreSQL: A real database(in constrant of MySQL) that complies with ACID(Atomicity Consistency Isolation Durability). It has enterprise level database features like Oracle, an easy of use like MSSQL and a good speed like MySQL. MySQL maybe faster, but does not guarantee the consistency of your data, so, it's not a trustworthy database... We can even compare it to Access... ;)
• Firewall Builder: A powerful graphic interface to IPTables(and many other implementations like Cisco PIX, etc) that centralizes the administration of many firewalls at once. It has options to create user defined objects(services, hosts, networks, etc) and has a simple drag-and-drop way to create filtering and NAT rules. It is also capable, at compile time, to check rule shadowing (a rule that hides another) and emits an administrator warning not allowing the install. Besides, it can install the IPTables script rules remotely into the target firewall.
• RPM pbone.net: If you need a RPM package from any distribution, here you will find it.
• MSX Java Emulador: Play MSX Games Online! An excelent MSX emulator made in Java and running as an applet. Allows playing most of MSX games. Play on-line!