Dump database structure
How do you get a full database structure from Microsoft SQL Server? [sql] select * from INFORMATION_SCHEMA.COLUMNS [/sql]
How do you get a full database structure from Microsoft SQL Server? [sql] select * from INFORMATION_SCHEMA.COLUMNS [/sql]
How do you move certain files from yesterday to another directory? In current directory: [code] find . -type f -atime -1 -exec mv {} /newdirectory/ \; From "/olddirectory/": find /olddirectory/ -type f -atime -1 -exec mv {} /newdirectory/ \; [/code]
du -sk * | sort -nr | more
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. http://codex.wordpress.org/Using_Alternative_Databases I’m sure there must be a way to make WordPress more portable to other databases. What’s your take on this?
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.
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. http://trackthepack.com/
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 …
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 SqlServerCurry.com 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 …
What is the optimized method of parsing a large XML file? Using XMLReader (http://php.net/manual/en/book.xmlreader.php) 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 …
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!!!