Autarchy of the Private Cave

Tiny bits of bioinformatics, [web-]programming etc

    • Archives

    • Recent comments

    Archive for the 'Notepad' Category

    Short miscellaneous notes

    NicEdit

    11th April 2008

    NicEdit – lightweight inline configurable rich-text editor for the web. Can fit where both FCKEditor and TinyMCE are too clunky and monstrous.

    Share

    Posted in Links, Notepad, Software, Web | No Comments »

    Developing with Drupal: screencasts

    26th March 2008

    drupaldojo.com – at the moment of writing, has 42 video-lessons (screencasts) of developing with Drupal.

    Share

    Posted in CMS, Drupal, Links, Notepad, Software, Web | No Comments »

    Good techie intro for would-be Drupal developers

    26th March 2008

    Drupal technical introduction
    It’s quite old, but as it describes core functionality, it should be still actual.

    Please comment if you know of any other good high-quality technical Drupal introductions/descriptions.

    Share

    Posted in CMS, Drupal, Links, Notepad, Software, Web | No Comments »

    SystemRescueCD

    15th March 2008

    Earlier, I wrote about Universal boot CD , which is targeted primarily at the hardware testing/diagnosing.

    If not hardware, but “only” software is malfunctioning – try SystemRescueCD, a Linux-based recovery CD/DVD/Flash stick (it all depends on how you burn/install the downloaded file – manuals and how-to’s are available).

    As always, Disclaimer: I am in no way associated with SystemRescueCD, and gain no profit from this post. Any advice I give is provided AS IS, with no guarantees of fitness to your exact case.

    Share

    Posted in *nix, Links, Notepad | 4 Comments »

    How to end (an official) letter

    15th March 2008

    Found useful list and discussion of the complimentary closings.

    It’s the “complimentary close” or “complimentary closing” that business writers are wondering about, those phrases that come before the signature in a letter:

    1. Very truly yours,
    2. Respectfully,
    3. Yours truly,
    4. Sincerely yours,
    5. Sincerely,
    6. Best regards,
    7. Regards,
    8. Cordially,
    9. With many thanks,
    10. Warm wishes,

    Share

    Posted in Links, Notepad | 1 Comment »

    SQL injection: RIAA example

    16th February 2008

    I know it’s kind of old now, but check this image out:

    RIAA screenshot with some SQL injection code

    Via webplanet.ru – reddit.com.

    Share

    Posted in Links, Notepad, Programming, Society, Web | No Comments »

    Convert MySQL database from one encoding/collation into another

    8th February 2008

    Most frequent use: convert database from latin1_swedish to utf8_general_ci.
    Original script found at: MySQL and UTF-8.

    Update: the original script had an error, it would generate queries likes this one (note the bold part):

    ALTER TABLE `links` CHANGE `link_rel` `link_rel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT NULL;

    This is clearly wrong syntax (and logic). I fixed this by making comparison to NULL strict (with three equal signs instead of two):

    // Does the field default to null, a string, or nothing?
    if ($row['Default'] === NULL)

    Update 2: based on comment by banesto, I modified the script; now it does not require specifying the from_collation, it’s sufficient to specify to_collation (which will be used for all the fields and tables). The modified code is:

    if ($row['Collation'] == ” || $row['Collation'] == $convert_to)
    continue;

    Update 3: the long-lasting, re-appearing NOT NULL DEFAULT NULL problem is finally fixed.

    Update 4: incorporated Russ’s fix to skip numeric fields (in order to leave autoincrement values intact).

    Here’s the script itself: (to copy-paste: first click the “Plain text” header)
    Read the rest of this entry »

    Share

    Posted in Links, Notepad, PHP, Programming, Web | 60 Comments »