Articles related to technology, how to use software, ways to work around technology problems, install hardware, install software, upgraded software, etc.
Zencart has four default order status types which are Pending(1), Processing(2), Delivered(3), and Update(4). The number in parenthesis represents the order in which the order type will be located in the drop down so by default the first type in the drop down is Pending. To add a new order status type login to the…
Backing up and restoring PostgreSQL is fairly easy using pg_dump and psql. One more complicated scenario I have run into is doing a complete database backup with pg_dump and at some point down the road needing to just split out one table and restore it. This can be a pain because of how the pg_dump…
The pg_stat_activity table will show you what activity is currently happening on your PostgreSQL database server. The information will detail the database the activity is occuring on, the username initiating the activity, the length of time the acitivy has been occuring for, and much more. Below is example output from running a SELECT query against…
The Linux kill command is used to kill PID’s or process ID’s. This command is beneficial for numerous reasons typically for run away processes, processes caught in some sort of loop, to kick users from a system, or any other number of reasons. Typically kill is used in the below format with 12345 being the…
This post will explain how to post notes from Microsoft OneNote into the WordPress admin. When you copy and paste from most Microsoft products into a visual editor such as TinyMCE that WordPress uses you will typically include a bunch of unwanted tags from the Microsoft application. These tags will make it complicated to format…
To create a PL/pgSQL stored procedure, copy and paste a dummy procedure like this into the “Execute arbitrary SQL queries” window in PgAdmin 1.8.4:
In case you’re not a Rails programmer, ActiveRecord has this great ‘convention over configuration’ feature that defines a many to many relationship called the has_many_and_belongs_to association. For example, if you’re mapping many users to many devices, then the join table must named with both tables names (in this cas devices_users). What I didn’t realize until…
After upgrading the RAM on your Windows XP or Windows Vista computer (laptops and desktops) you should review your performance settings. The primary concern will be your pagefile.sys size to make sure it matches or exceeds the amount of RAM you have in the computer. For those of us that are familiar with Linux more…
Some quick explanations on designing scalable databases (thanks to Jon Sime of the PostgreSQL mailing list and Media Matters for America) Horizontal vs Vertical scaling Horizontal scaling is merely a general concept which, in its simplest form, means “adding more nodes” as opposed to vertical scaling which (very roughly) means making an individual node as…