Squio.blog

Tagged: database Toggle Comment Threads | Keyboard Shortcuts

• 

  Joe 17:06 on February 9, 2009 Permalink
  Tags: add-on ( 4 ), database, firefox ( 8 ), mozilla ( 3 ), sqlite, sqlite3   

  sqlite3 db in Firefox: SQLite Manager Add-on! 

  

  Image via Wikipedia

  So you want to peek under the hood of all those mysterious Firefox 3.x databases? Easy does it: just install SQLite Manager in… Firefox itself (for easy installation visit SQLite Manager on the AMO site).

  This add-on can be activated from the Tool menu and opens in a separate window. By default, a shortcut to your profile directory is provided, but there is nothing preventing you from opening other sqlite3 databases when you’re done staring at the places.sqlite database.

  On Mac OSX there is lots to explore about your Mail.app settings in your ~/Library/Mail directory, e.g to optimize mail performance. Just be careful that you don’t make any changes on the live database (you work on a back-up copy, right?).

  

  Tweet This Delicious Reddit This Post Stumble This Post

   
• 

  Joe 22:32 on January 6, 2009 Permalink
  Tags: Character encoding ( 2 ), charset, database, encoding, UTF-8 ( 2 ), utf8, wordpress ( 7 )   

  WordPress config & database charset 

  

  Image via CrunchBase

  As part of upgrading to WordPress 2.7, the character encoding of some existing posts appeared suddenly broken.

  Turns out that the charset specification from wp-config.php was not interpreted correctly any longer as UTF-8; changing the name from ‘utf8‘ (without dash) to ‘utf-8‘ did the trick.

  Update Feb 24: my error log shows lots and lots of warnings like these:

  WordPress database error Unknown character set: 'utf-8' for 
    query SET NAMES 'utf-8' made by require, require_once,
    require_once, require_once, require_wp_db, require_once

  The right solution seems to remove (comment) the line specifying the DB_CHARSET alltogether:

  /** Database Charset to use in creating database tables. */
  // define('DB_CHARSET', 'utf8');

  Read more about editing wp-config (wordpress.org)…

  

  Tweet This Delicious Reddit This Post Stumble This Post

  gemp is discussing. Toggle Comments

   
  • 

    gemp 20:56 on January 16, 2009 Permalink | Reply

    You just saved my life (and a friendship).

    Thanks