Hosting Software News & Commentary Hosting Software News & Commentary Hosting Software News & Commentary

Obviously a noobie post

The surprise here for a SQL Server expert is that “select into” doesn’t work for copying data from a source table into a destination. Perhaps there is some other command, but select into isn’t it.

To dump a few tables (users, bottles, wines, vintages)

mysqldump -p -u drynccom_development users bottles wines vintages > ~/dump.sql

To load:

mysql -udrynccom_admin -psecret />source ~/dump.sql

Recently I had a close look at the mysqli prepared statements. Why use prepared statements in php if you can easily concatenate a statement string and then execute it?

There are several is an interesting issue, for example an article states that prepared statements make a difference.

  • From the programming point of view though one gets character escaping written by someone who went through the trouble to do it properly and it is guaranteed to hapen each time.
  • From the style perspective - most your SQL statements are created once and are generally in one place, therefore it is easy to make changes if your schema has been changed.
  • Let’s start from the beggining. mysqli is an extended version of the well known mysql library. Why is that a good thing? Well most functions are called the same and therefore porting from one to the other will not be as difficult - one does not need to change the approach, just make sure that everything works and the names of functions have a ‘mysqli’ instead of ‘mysql’.

    (more…)

    The procedural aspects of LaTeX markup naturally suggests a connection with scripting languages. Any anyone serious about writing with strutural markup will eventually benefit with some familiarity with a scripting language, be it Perl, Ruby, Lua or what have you. (I have been learning Ruby.) Larry Wall author of Perl has written some reflections on scripting languages. It is an interesting read even for the unitiated. Wall’s background in linguistics and evident humanity shine through. One of the delightful surprises is the connection between Perl and Postmodernism (one may quibble with the implicit characterization of Postmodernism and its description as “liberal”, but I won’t, as it would only detract from what is of genuine interest):

    I tend to take an anthropological view of these things. Many of you here are Perl programmers, but some of you come from other programming tribes. And depending on your tribal history, you might think of a string as a pointer to a byte array if you’re a C programmer, or as a list if you’re a functional programmer, or as an object if you’re a Java programmer. I view a string as a Text, with a capital T.

    Text

    I read that word from a postmodern perspective. Of course, the term Postmodern is itself context-sensitive. Some folks think Postmodernism means little more than the Empowerment of the Vulgar. Some folks think the same about Perl.

    But I take Postmodernism to mean that a Text, whether spoken or written, is an act of communication requiring intelligence on both ends, and sometimes in the middle too. I don’t want to talk to a stupid computer language. I want my computer language to understand the strings I type.

    Perl is a postmodern language, and a lot of conservative folks feel like Postmodernism is a rather liberal notion. So it’s rather ironic that my views on Postmodernism were primarily informed by studying linguistics and translation as taught by missionaries, specifically, the Wycliffe Bible Translators. One of the things they hammered home is that there’s really no such thing as a primitive human language. By which they mean essentially that all human languages are Turing complete.



    Categories

    Site Directory

    Top 10 Web Hosts

    1.  
    StartLogic Hosting
    2.  
    PowWeb Web Host
    3.  
    Yahoo Web Hosts
    4.  
    Just Host
    5.  
    1&1 Hosting
    6.  
    Hostmonster Hosting
    7.  
    IX Web Host
    8.  
    Hostgator Hosting
    9.  
    iPowerWeb Web Host
    10.  
    Dot5 Web Hosting
    -   
    Go Daddy Hosting
    -   
    Network Solutions Hosting

    Blogroll

    Powered by Technorati