Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 121 to 150 of 245 Next 30 Older Entries

Displaying posts with tag: Programming (reset)

Four short links: 24 September 2009
+0 Vote Up -0Vote Down

  • Milestones in the History of Thematic Cartography -- This resource provides a comprehensive view of the history of cartography, with examples of maps created throughout the ages and background information about the contexts within which those maps, visualizations and map making technologies were created. Explore each time period, click on the images and stories found throughout each time line, and read more about the history of creating thematic maps as a means of visualizing data. (via Titine on Delicious)
  • Interview with Larry Ellison (Infoworld) -- Asked about MySQL, "No, we're not going to spin it off," even if asked to by the EU, Ellison said. Lots of
  •   [Read more...]
    Comparison Between Solr And Sphinx Search Servers (Solr Vs Sphinx – Fight!)
    +2 Vote Up -0Vote Down

    In the past few weeks I've been implementing advanced search at Plaxo, working quite closely with Solr enterprise search server. Today, I saw this relatively detailed comparison between Solr and its main competitor Sphinx (full credit goes to StackOverflow user mausch who had been using Solr for the past 2 years). For those still confused, Solr and Sphinx are similar to MySQL FULLTEXT search, or for those even more confused, think Google (yeah, this is a bit of a stretch, I know).

    Similarities

    • Both Solr and Sphinx satisfy all of your requirements. They're fast and designed to index and search large bodies of data efficiently.
    • Both
      [Read more...]
    More MySQL connectors
    Employee +1 Vote Up -0Vote Down

    Some time ago I posted a compilation of applications and programming languages that provide an API to connect to the MySQL Server (http://mysql.com/). As it turned out, I forgot a few that I would like to mention here:

    • Apache DBD API: a MySQL driver for mod_apr_dbd is not included in the official distribution, but can be obtained seperately from here. Some distributions (e.g. openSUSE) actually provide installable packages of this driver module.
    • GRASS MySQL driver
      [Read more...]
    ADO.Net Entity Framework on MySQL
    Employee +0 Vote Up -0Vote Down

    Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL (http://mysql.com/news-and-events/web-seminars/display-397.html" target="_blank)", tomorrow at 10 Pacific Time!

    Among other topics, Reggie will discuss how to

    • Develop your application against SQL Server and then switch it to MySQL with zero code changes

    • Optimize your database schema without requiring any code changes in your application

    • Use LinQ syntax for type safety in your applications

    (Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual



      [Read more...]
    ADO.Net Entity Framework on MySQL
    Employee +0 Vote Up -0Vote Down

    Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL (http://mysql.com/news-and-events/web-seminars/display-397.html" target="_blank)", tomorrow at 10 Pacific Time!

    Among other topics, Reggie will discuss how to

    • Develop your application against SQL Server and then switch it to MySQL with zero code changes

    • Optimize your database schema without requiring any code changes in your application

    • Use LinQ syntax for type safety in your applications

    (Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual



      [Read more...]
    Valgrinding Drizzle
    +2 Vote Up -0Vote Down

    Like so many others, I got interested in the Drizzle project when it started. Some good ideas, lots of enthusiasm, and just pure GPL license, no "yes, we will take your work for free and sell proprietary licenses to it" SCA.

    I even started contributing some development, fixing a number of Valgrind-detected bugs in Drizzle. I am proud that we kept the MySQL code 100% free of Valgrind errors, and wanted to help keep the same in Drizzle. So I debugged and fixed quite a few of the Valgrind-detected bugs that had crept in since forking from MySQL.

    As I remember, I got down to two or three remaining or so. However, I it did discourage me somewhat to see how quickly these bugs had been allowed to enter the code. I remember one case where there was a Drizzle patch that had tried to simplify some field types. As I remember, the patch tried to simplify the code by eliminating some of

      [Read more...]
    Learning Python
    +2 Vote Up -1Vote Down

    Among other things, these past few months I have been working on setting up Buildbot, including adding various enhancements and bug fixes that are needed to properly build and test the MariaDB and MySQL code base.

    Since Buildbot is written in Python, this means I have also had to learn Python. I am an old-time Perl hacker, so this exercise feels a bit like living in enemy territory ;-)

    Anyway, Python is often touted as a more "pretty" language. And in many ways it is. Still, it is not without its own gotchas. Think "scope rules". Obviously someone haven't been reading up on the subject before implementing things in Python, causing the language to behave stupidly (and certainly different from what one expects) in the following three cases that I hit during my Buildbot work.

      [Read more...]
    Embedded InnoDB 1.0.3.5325 RPM packages
    Employee +1 Vote Up -0Vote Down

    Shortly after I created the initial packages of embedded InnoDB on the OpenSUSE Build Service, Oracle/Innobase released an updated version (1.0.3.5325). In addition to many improvements and bug fixes, they slightly changed the versioning scheme to better indicate what version of the InnodDB plugin their code is based on (see Vasil's posting on the InnoDB Forums for more information).

    I've now updated my InnoDB packages on the Build Service to this version as well - please note that the naming scheme of the shared library

      [Read more...]
    Hidden Features Of Perl, PHP, Javascript, C, C++, C#, Java, Ruby, Python, And Others [Collection Of Incredibly Useful Lists]
    +2 Vote Up -0Vote Down

    Introduction

    StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

    The Story

    Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to

      [Read more...]
    mylvmbackup-0.12 has been released
    Employee +2 Vote Up -0Vote Down

    After a long hiatus, I am happy to announce that mylvmbackup version 0.12 has now been released. This release includes a large number of improvements, minor code cleanups, as well as some new functionality. In particular, I would like to thank Matthew Boehm, Tim Stoop, Baron Schwartz, Ville Skyttä and Ronald Bradford for their contributions.

    Some notable highlights from the ChangeLog:

    • Removed the absolute path names to external tools (make sure $PATH is correct)
    • Added --log-err to the startup options of the recovery instance to avoid cluttering the server's error log
    • Added support for hooks written as Perl Modules. (Matthew Boehm)
    • Added support for date/time-formatted path names for backupdir and mountdir (Matthew Boehm)

      [Read more...]
    [MySQL] Deleting/Updating Rows Common To 2 Tables – Speed And Slave Lag Considerations
    +1 Vote Up -0Vote Down

    Introduction

    A question I recently saw on Stack Overflow titled Faster way to delete matching [database] rows? prompted me to organize my thoughts and observations on the subject and quickly jot them down here.

    Here is the brief description of the task: say, you have 2 MySQL tables a and b. The tables contain the same type of data, for example log entries. Now you want to delete all or a subset of the entries in table a that exist in table b.

    Solutions Suggested By Others

    DELETE FROM a WHERE EXISTS (SELECT b.id FROM b WHERE b.id = a.id);
    DELETE a FROM a INNER JOIN b on a.id=b.id;
    DELETE FROM a WHERE id IN (SELECT id FROM b)

    The Problem With  [Read more...]

    Sun Contributor Agreement and MySQL
    Employee +0 Vote Up -0Vote Down

    On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

    These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

    In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution as a

      [Read more...]
    Sun Contributor Agreement and MySQL
    Employee +0 Vote Up -0Vote Down

    On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

    These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

    In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution

      [Read more...]
    Sun Contributor Agreement and MySQL
    Employee +0 Vote Up -0Vote Down

    On my last count, there are now 20+ Sun Contributor Agreement (SCA) signatories whose names appear on the master list and who are interested in contributing to MySQL. Only this week, three new members signed the SCA.

    These 22+ signatories have all been added since mid-February when we launched the new, Sun-compliant SCA signing process. Before the end of 2009, if we proceed at this same rate, MySQL SCA signatories list should grow to about 70 to 90 contributors.

    In the meantime, contributions from many of these contributors have already been accepted and integrated. (I had earlier pointed to Armin Schöffmann's contribution

      [Read more...]
    SOUNDEX(), triggers, and stored procedures
    +0 Vote Up -0Vote Down
    MySQL provides a SOUNDEX() function, which returns the soundex of a given string. For details, refer to the manual, but to put it simply, it allows you to compare strings based on how they sound, hence letting you do proximity searches on your database. If you’re just querying for a word, it’s usage is pretty […] Related posts:
  • Extending procedure_analyse My previous post explored a stored procedure that extended procedure_analyse...
  • Making use of procedure analyse() SELECT Field0[,Field1,Field2,...] FROM TABLE PROCEDURE ANALYSE() is a nice tool...
  • YARPP powered by AdBistroPowered by
    Another Pluggable Storage Engine for MySQL
    Employee +0 Vote Up -0Vote Down

    Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

    Another Pluggable Storage Engine for MySQL
    Employee +0 Vote Up -0Vote Down

    Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

    Another Pluggable Storage Engine for MySQL
    Employee +0 Vote Up -0Vote Down

    Kazuho Oku of Cybozu Labs, Inc., a community contributor to MySQL and SCA signatory, gives a talk on Q4M, a message queue stroage engine for MySQL.

    Extending procedure_analyse
    +0 Vote Up -0Vote Down
    My previous post explored a stored procedure that extended procedure_analyse with the intent of helping DBAs optimize table structure. Here’s an improved version. I’ve followed Arjen Lentz‘s suggestion and added support for the max_elements and max_memory parameters. I also added a new Indexed column to the output, which is an ENUM(‘No’,’Yes’,’Overindexed’). Yes and No are […] Related posts:
  • Making use of procedure analyse() SELECT Field0[,Field1,Field2,...] FROM TABLE PROCEDURE ANALYSE() is a nice tool...
  • YARPP powered by AdBistroPowered by
    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    A BoF on Community Code Contributions to MySQL
    Employee +0 Vote Up -0Vote Down

    The BoF schedule for MySQL Conference and Expo (2009) is now published. Lenz Grimmer, Sergei Golubchik, Tomas Ulin and myself will be available during a BoF which focuses on MySQL Community Code Contributions. Lenz will be moderating. For background material, you may start here.


    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    Developing with MySQL Connector/C++
    Employee +0 Vote Up -0Vote Down
    Giri Mandalika has written an article showing how to develop C++ database applications for MySQL and another article showing how to install MySQL Connector/C++ from the source.
    MySQL Conference Notes
    Employee +0 Vote Up -0Vote Down

    MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

    You may want to delve into the notes, as a fast way to learn about the happenings.

    If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here

    There will also be a special BoF geared to community contributors. (I still haven't been able to find out

      [Read more...]
    MySQL Conference Notes
    Employee +0 Vote Up -0Vote Down

    MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

    You may want to delve into the notes, as a fast way to learn about the happenings.

    If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here

    There will also be a special BoF geared to community contributors. (I still haven't been able to find out

      [Read more...]
    MySQL Conference Notes
    Employee +0 Vote Up -0Vote Down

    MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

    You may want to delve into the notes, as a fast way to learn about the happenings.

    If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here

    There will also be a special BoF geared to community contributors. (I still haven't been able to find

      [Read more...]
    Why be vendor specific?
    +0 Vote Up -0Vote Down

    I just read about the release of Honey Monitor for MySQL. I read through the features. I looked at the screenshots. Then I read about the licensing. Then I read about the fact that it only runs on windows XP or Vista. So, my questions for the ages…

    1. Why, in this age of multiple OSes battling each other for market share, would you write an application that is OS specific? Every app should run in a vendor neutral web browser unless there’s a really really good reason. Monitoring software, are you kidding? Monitoring software must be vendor neutral and web-based. I will never use anything that ties me to windows or linux or osx, it has to be cross platform. End of story.
    2. Why, when MySQL is so heavily used on Linux and Solaris, would you write an application for MySQL

      [Read more...]
    Why be vendor specific?
    +0 Vote Up -0Vote Down

    I just read about the release of Honey Monitor for MySQL. I read through the features. I looked at the screenshots. Then I read about the licensing. Then I read about the fact that it only runs on windows XP or Vista. So, my questions for the ages…

    1. Why, in this age of multiple OSes battling each other for market share, would you write an application that is OS specific? Every app should run in a vendor neutral web browser unless there’s a really really good reason. Monitoring software, are you kidding? Monitoring software must be vendor neutral and web-based. I will never use anything that ties me to windows or linux or osx, it has to be cross platform. End of story.
    2. Why, when MySQL is so heavily used on Linux and Solaris, would you write an application for MySQL that can only be

      [Read more...]
    Previous 30 Newer Entries Showing entries 121 to 150 of 245 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.