If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the postgres database however there are steps you can take to prevent others from accessing the database and if needed…
Details
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…
Details
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:
This issue came up the other day when explaining to someone how to format articles properly so they are uniform. The WordPress installation I am talking about has the TinyMCE plugin installed which basically takes the default visual editor tool bar and expands it by allowing you to add a lot more options. They wanted…
Details
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…
Details
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…
Details
These are the steps to resetting error codes on the iR5570/iR6570 and other ImageRunner printers. This also refers to eCopy, so follow the additional steps if you have the eCopy setup. The most common errors that I get are from power outages, sometimes after an outage the printer will not reboot correctly and will be…
Details
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…
Details
Using Railroad and Graphviz Blog update (10/22/2007): Thanks to the comment posted by Blog de Kilgore, I tried Railroad (instead of using the below method with starUML) to visualize my RoR app. Very easy to setup and use (see examples on web page). Here’s a quick command to create a .png graphic file of your…
Details