sam keen's corner of the web

Category Archives: data storage

Amazon Simple Storage Service [S3]

What is S3??
Simple Storage Service: Is a web service that allows any developer to gain access to highly scalable, very reliable, inexpensive storage space. Your data is replicated to multiple servers at multiple data centers.
How to get started
Go to Amazon’s AWS page, then to the S3 page and sign up (check out the other services [...]

Find and Replace in Mysql

Simple but very useful MySQL trick…
UPDATE `table` SET `field` = REPLACE (
`field` ,
‘{string to find}’,
‘{replacement string}’
)

PHP Data Objects

DataObject is a design pattern that incapsualtes the database with a simple to use interface. This alows the Controller to interact with the database layer in an SQL’less way. To acomplish this you build a base DataObject abstract class that implements the base functionality and sets up the interface for a Data Object. Then for [...]