Posts Tagged ‘database’

Making Site Wide Changes on Your WordPress Blog

16
responses
by
on
January 22nd, 2010
in
WordPress, WordPress Plugins

Last week I wrote up a post to review the Real-Time Find and Replace Plugin and the comments on that story about other methods to make site wide changes permanent sent me in search of another way to search and replace information in my SQL database. Now I consider myself pretty decent at geeky things but directly editing and messing with my site’s SQL database does not top my list of things to do.  Neither does manually going through nearly 1,000 postings to make changes. What I found was a terrific plug-in that lets me perform a few different functions to make corrections or change info throughout my site. Caveat: Before I get started – this plugin does make changes to your database. Play it safe and back up your info to protect your original data. With that said let me now introduce you to the Search Regex Plugin written […]

[Continue Reading...]

Top 10 Characteristics of a Great WordPress Plugin

41
responses
by
on
March 28th, 2009
in
WordPress Tips

Like most of you, I have experimented with many WordPress plugins. I have seen a lot of great plugins and also a lot of bad plugins. I am a bit of a WordPress plugin developer myself, and I admit that I borrow many ideas from other good WordPress plugins. From that experience I have consolidated these good ideas into a checklist that you can follow when reviewing or coding a new WordPress plugin. Here are my picks of the top characteristics that make a great WordPress plugin. 10. Easy Installation I have seen plugins that require you to modify code after plugin activation to be able to get it to work properly. The instructions were documented clearly in the readme.txt file, but most of the users seem to have missed it (I could tell from the frustration in the plugin support thread). Not everybody reads the installation instructions inside the […]

[Continue Reading...]

2.3 to 2.5 Database Changes

50
responses
by
on
March 23rd, 2008
in
WordPress

I’ve seen a number of people tell others that WordPress 2.5 will have little to no database schema changes. It looks like that is no longer the case as MichaelH has pointed out. Changes to database schema from Version 2.3 to 2.5. *Table: comments Changed ‘comment_approved’ to varchar(20) NOT NULL default ‘1’ Added KEY ‘comment_approved_date_gmt’ (comment_approved, comment_date_gmt) Added KEY ‘comment_date_gmt’ (comment_date_gmt) *Table: links Changed ‘link_visible’ to varchar(20) NOT NULL default ‘Y’ *Table: options Changed ‘autoload’ to varchar(20) NOT NULL default ‘yes’ *Table: posts Changed ‘post_status’ to varchar(20) NOT NULL default ‘publish’ Changed ‘comment_status’ to varchar(20) NOT NULL default ‘open’ Changed ‘ping_status’ to varchar(20) NOT NULL default ‘open’ *Table: term_relationships Added ‘term_order’ int(11) NOT NULL default 0 Thanks to MichaelH for putting these changes together. This information is especially useful to plugin and theme authors as it lets them know if their particular project will break.

[Continue Reading...]

Closed, Open Source Share Compatibility Problems

2
responses
by
on
December 13th, 2005
in
Blogging News, LinkyLoo

Closed, Open Source Share Compatibility Problems: Interesting take on the compatibility problems brought onto WordPress by the latest versions of Mysql running in “strict” mode as default. Especially poignant here because I see well greased programmers moving to the postgresql model because of a shift of ideologies of the mysql group. I should look into the added benefits that the strict model provides to the system.

[Continue Reading...]

MYdbPAL Free Download

No
responses
by
on
October 19th, 2005
in
LinkyLoo

MYdbPAL Free Download: I am not sure of this program and you are on your own to figure out how this works but from my initial reaction, though the user interface is hideous, it can be a useful database education tool and provide good insight into existing database schemas. Thanks SlickDeals

[Continue Reading...]


Obviously Powered by WordPress. © 2003-2013

css.php