• Home
• dp
• dp’s Social Graph
• RSS

ECS A785GM-M

Yazan: dp | 04 June 2010 | 1 Comment
Categories: Computers

FYI, The ECS A785GM-M 1.0 does *not* have a speaker connector. Makes it difficult to have a system beep without the built-in speaker.

Databases and backups

Yazan: dp | 06 May 2010 | No Comments
Categories: Servers

Yesterday, I managed to delete the primary database that we use at work. I won’t go in to how this happened, other than to say: Fuck you MySQL Workbench. I was trying to get a map of the table relations within the database. Needless to say, it didn’t work. After the immediate pants-wiping, I restored [...]

How to fix strange characters in MySQL database – Vinh Pham

Yazan: dp | 26 January 2010 | 4 Comments
Categories: Servers

I admit, I borrowed this from How to fix strange characters in MySQL database – Vinh Pham. But I also added a few more that were missing; update <table> set <field> = replace(<field>, ‘’’, ‘\”); update <table> set <field> = replace(<field>, ‘…’, ‘&hellip;’); update <table> set <field> = replace(<field>, ‘–’, ‘-’); update <table> set <field> [...]

Cleaning up bad data in an SQL database

Yazan: dp | 02 June 2009 | No Comments
Categories: Uncategorized

Recently, I needed to find all of the data in a table that was being used for HTML output, that had non-printable characters. The following SQL statement should do that for you: select id, name from table_name where name not regexp ‘^[a-zA-Z0-9_ ,&;\/<>(²):%*#?$|!+.\"\'-]+$; This code is MySQL specific, but should be applicable anywhere, really.

XFN/FOAF

Yazan: dp | 26 May 2009 | No Comments
Categories: Uncategorized

I’ve been working on getting all of the sites on which I have public profiles compiled together into a list. Currently, the fruits of that effort can be seen in the sidebar of this site. All of those urls should have a rel=”me” attribute on them, so that the social graph is correct, and all [...]