Thursday, October 1, 2009

Oracle Views, SQL Developer, PHP Scripts to store CLOBS













Used SQL Developer to auto generate the SQL needed to create views for use on the GIS Portal to create reports. Wrote a PHP script to store CLOBS into Oracle.

Table Menu Example

Table Menu Example v2

Tuesday, September 22, 2009

Web Navigation Tool






source:
Web Navigation Tool




This tool was developed using extjs 2.2, php, AJAX, JSON, and oracle. This tool helps users of the GIS Portal to update three oracle tables to reflect the correct link on the GIS Portal Navigation.



Web Nav Tool V2

Monday, August 17, 2009

Microsoft Expression Studio 3

Silverlight 3 Development:
Source: http://silverlight.net/GetStarted/
Requirements:
VS2008
VS2008 SP1
SILVERLIGHT 3 TOOLS
Expression Studio 3
.NET RIA SERVICES

Fresh install takes 3 hours with VS08 and Expression Studio 3
upgrading from sl2 to sl3 takes about 1 hour

Saturday, August 8, 2009

Technologies I learned at e7 Architecture Studio

Software Development
Orcale SQL Developer
Microsoft SQL Management Studio 2005
Visual Studio 2005
Visual Studio 2008
Expression Blend 2 (in progress)
Expression Blend 3 (in progress)

Software Applications
Microsoft Office 2007 Suite
Infopath 2007

Programming Languages
PHP
Transact-SQL (Microsft SQL Server 2005)
PL/SQL (Oracle)
C#

Software Development Kits / Libraries
extJS-2.2
.NET SDK 2.0
Windows Presentation Foundation (WPF)
(silverlight is a subset of WPF)
Silverlight 2.0 (in progress)
Silverlight 3.0 (in progress)

Operating Systems

Windows 7
Windows XP Service Pack 2
Windows Vista Business Premium
Windows 2003 Server Enterprise
Vmware ESX 3.5 Hypervisor
Open Solaris 10
Linux Redhat Enterprise Workstation 4
Mac OS X

Database Systems
Microsoft SQL Server 2005
Oracle 10g
mySQL 4.0.25

Web Servers
Internet Information Services 6.0 (IIS)
Apache Web Server

Content Management System
Microsoft Sharepoint 2003
Microsoft Sharepoint 2007
phpNUKE

Friday, August 7, 2009

Microsoft Silverlight e7 Streaming: Intern Success Stories and Build-LACCD Campus Video Fly Throughs

Project assigned to me to work on at e7 Architecture Studio.

"e7Streaming: Intern Success Stories and LACCD Campus Video Fly Throughs" with Microsoft Sivlerlight 2. I had to modify the Silverlight interface that display's the videos for Intern Success Stories.

http://sl.e7studio.net/

Aesthetic Guideline Database (AGL_DB)

Programming task I did at e7 Architecture Studio.

I had to restructure the AGL_DB. I used Microsoft SQL Server 2005, Microsoft SQL Management Studio, I wrote stored procedures, and used PHP scripts. The PHP scripts to retrieve from AGL_DB was rewritten so the FLASH front end interface can just reference one php file.

Complete Project: http://aesthetic.e7studio.net/

My portion:
http://aesthetic.e7studio.net/PHP/Request.php?op=lst&type=cat&id=01c
http://aesthetic.e7studio.net/PHP/_getimg.php?picid=1000&type=category&thumb=true