Category: Tidbits

Posted on: November 8, 2011 Posted by: JJ Comments: 0

Dump database structure

How do you get a full database structure from Microsoft SQL Server? [sql] select * from INFORMATION_SCHEMA.COLUMNS [/sql]

Posted on: August 9, 2011 Posted by: JJ Comments: 0

Use Postgresql for WordPress?

I would love to run WordPress on Postgresql database, simply because most of DBs I use are Postgresql-based. Here’s what WordPress says about it. I’m sure there must be a way to make WordPress more portable to other databases. What’s your take on this?

Posted on: August 9, 2011 Posted by: JJ Comments: 0

New framework for PHP?

I’ve been watching FuelPHP framework for sometime and they finally released v1.0. If you are used to Codeigniter, you may not be all enthusiastic about how FuelPHP does things. It’s different and I’m willing to dig in deeper. It would be nice to see a chart of comparisons.

Posted on: June 10, 2011 Posted by: JJ Comments: 0

Track shipments on iphone

Here’s a simple idea… get all tracking numbers, UPS, FedEx, or any other common carrier’s into your iphone. Have the iphone alert you when shipment status change. Well.. looks like someone already thought of that. Trackthepack has an iphone that does this sort of thing.

Posted on: May 20, 2011 Posted by: JJ Comments: 0

Best CodeIgniter Editors

10 million years old question… What is your PHP IDE editor? This question should be more specific to CodeIgniter. So, what is your best CodeIgniter editor? For multi-platform? I’ve come up with below. Suggestions welcomed. Multi-platform o Aptana o Dreamweaver o Eclipse o Komodo Edit o Netbeans o PHPStorm o …

Posted on: February 17, 2011 Posted by: JJ Comments: 0

Find first and last sunday

This is a nifty query that I can use on reporting, I’m sure there are other uses for it. [sql] declare @year int set @year =2011 — First and Last Sunday by select min(dates) as first_sunday,max(dates) as last_sunday from ( select dateadd(day,number-1,DATEADD(year,@year-1900,0)) as dates from master..spt_values where type=’p’ and …

Posted on: February 15, 2011 Posted by: JJ Comments: 0

Processing large XML

What is the optimized method of parsing a large XML file? Using XMLReader ( is the best method AFAIK. Because XMLReader is stream-based pull parser, the memory usage should be much less than loading the XML file. I’ve tested on a large xml report generation and worked very well. Additional …

Posted on: February 7, 2011 Posted by: JJ Comments: 0

Codeigniter 2.0 Command Line Interface

Command Line Interface for Codeigniter is now built-in! Woohoo~~~ So now you can add your cronjob as: [sourcecode] php /YOURFULLAPPLICATIONDIRECTORY/index.php /CONTROLLER/METHOD [/sourcecode] This is all you need!!!