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 61 to 85

Displaying posts with tag: & (reset)

Patent propaganda in an EP motion on the Lisbon Agenda
+0 Vote Up -0Vote Down

On Wednesday of this week (March 15), the European Parliament will vote on this joint motion introduced by the chairmen of the three largest political groups in the EP. The motion is related to the EU’s Lisbon Agenda. Item 43 of the proposed text contains some pro-patent propaganda of the worst kind:

43. Stresses the need for reforming the current intellectual property rights legislation; notes that the cost of registering a patent in the EU varies between ? 37 500 and ? 57 000 while the same process only costs around ? 10 000 in the USA and that the length and complexity of the patent procedures are major

  [Read more...]
Position Paper
+0 Vote Up -0Vote Down

On January 16, the European Commission (EC) announced a consultation on the future of the European patent system. An SAP official has already said that “it’s starting again”, meaning that this is the next round of the European software patent debate!

Companies, organizations and individuals who would like to tell the EU their opinion on what its patent policy should look like have until the end of this month to answer the EC’s questionnaire. But in order to do so, one has to wade through hundreds of pages of legislative proposals and related documentation. That’s why I wrote up a position paper that everyone can use to make his or her contribution and write to the EC:

  [Read more...]
Software patents: two great columns on US Web sites
+0 Vote Up -0Vote Down

I just got a Google News Alert that contained the URLs of two great articles on the issue of software patents: one by eWeek’s Steven Vaughan-Nichols and another one on Computerworld.com by Martin Goetz, who in 1968 received the first US software patent ever. Both articles appeared on the occasion of the settlement of the patent dispute over BlackBerry, which I mentioned in my first blog entry here.

There have been plenty of columns on US Web sites that talked about the negative implications of software patents. However, a mistake made

  [Read more...]
Starting My Own Blog
+0 Vote Up -0Vote Down

This is my first posting in my own blog. Previously I posted a few comments to my Slashdot Journal, but other than that I’m a newbie WRT blogging. I also have a German-language blog (accessible via the German-language section of the Web site, which has its own URL).

The Web site will soon be fleshed out with a lot more content. In a few weeks I’m going to a announce in greater detail my forthcoming book No Lobbyists As Such - The War over Software Patents in the European Union. I decided to start the site and this blog on a preliminary basis because, within a matter of days, I’m going to publish a position paper here in reply to the European Commission’s

  [Read more...]
.NET Sessions at the MySQL UC 2006
+0 Vote Up -0Vote Down

There are four .NET specific sessions at the MySQL User Conference this year:

Tuesday, April 25th, 2006

Creating .Net Applications with Linux and MySQL
Matt Lord, Support Engineer, MySQL AB

MySQL and Windows: Playing Well Together
Reggie Burnett, Software Developer, MySQL AB

Wednesday, April 26th, 2006

MySQL Connector/Net: Work the Way You Want To!

  [Read more...]
Spend Your Life in MySQL
+0 Vote Up -0Vote Down

I was browsing through the session grid for the MySQL User Conference when I cam across a session titled My Second Life Runs on MySQL: War Stories from the Metaverse:

Second Life is a 3D online world where the users call the shots; from creating simple objects to writing complex distributed programs, they build and do pretty much whatever they feel like. And what they feel like doing is often something we never predicted.

This talk will cover the evolution of Second Life’s database architecture over the past three years, as they’ve gone from a handful of users to tens of thousands. Wilkes will discuss the biggest hurdles they’ve overcome along the way, and give an overview of where they plan to go over the next few

  [Read more...]
You too can get Discounted Access to the MySQL User Conference!
+0 Vote Up -0Vote Down

If you can’t get a discount to the registration fees for the MySQL UC, you are either waiting too long or not trying hard enough.

First off, there’s the $200 early registration discount that ends March 6, then there are the various other discounts:

Academic Instructor discount 50% off with proof of full time academic instructor status on organization letterhead, or copy of faculty ID. Fax to (707) 829-1342. Please use mys06ac in the discount field. Academic Staff discount 25% off with proof of full time academic employment status on organization letterhead or copy of faculty ID. Fax to (707) 829-1342. Please use mys06sa in discount field. Alumni discount Have you been a paid attendee at a previous O’Reilly conference? If so, you are eligible for a 15% alumni discount. Please email us at

  [Read more...]
MyComponents: Version 2006.4.3 released - Now with Delphi 2006 Support
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.3 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this forum, as well as Delphi 2006 certification.

What's new?

New: doSingleSQL option which allows an SQL script to be executed as a single SQL statement, thereby enabling you to use the SQL property to define functions and procedures in MySQL.
Fix: Various issues as has been reported to SciBit Support

This update is free of charge for all customers whom own a 2005.4.x MyComponents serial. Everyone still using a pre-2005.4 MyComponents may upgrade to the newest version by logging into their Secure accounts: simply click the Secure link at the top of this

  [Read more...]
Speaking at the 2006 MySQL User Conference
+0 Vote Up -0Vote Down

Well, it's official. I've been accepted for at least two sessions at the 2006 MySQL User Conference.

Get ready to register and you could be watching:

Managing Hierarchical Data in MySQL
The Sakila Sample Database

Which of course means I need to get the Sakila sample DB released *soon* so that I can tweak it before the conference gets too close.

I'm looking forward to this year's conference, every year is bigger and better than the last.

Yet another session idea
+0 Vote Up -0Vote Down

Thanks to all those who have provided feedback on my session ideas so far.

I have another session proposal that I would appreciate feedback on at:


This one discusses the new MySQL Sakila sample database, how to use it, and how it was implemented.

Another UC2006 Proposal
+0 Vote Up -0Vote Down

I have another MySQL UC2006 session proposal I am working on at http://www.openwin.org/mike/index.php/presentations/securing-a-mysql-server-in-12-easy-steps-proposal/

Any input would be appreciated.

Working on Session Proposals for the MySQL UC 2006
+0 Vote Up -0Vote Down

I'm working on some session proposals for the 2006 MySQL User Conference, and I have the first one pretty fleshed out. If you have a minute please click the following link and provide some feedback for the proposal: is it a session you would attend? Is there any information you think is missing, topics you would like to see?



MySQL 5 Release Candidate is Here Bearing Prizes
+0 Vote Up -0Vote Down

Well, we are getting very close indeed to a production release of MySQL 5. Today MySQL is releasing MySQL 5.0.13, a Release Candidate (formerly known as Gamma) version.

You can read all about it at http://www.mysql.com/news-and-events/news/article_959.html (http://www.mysql.com/news-and-events/news/article_959.html), but here's the feature highlights:

The new ANSI SQL features include:

  • Views (both read-only and updatable views)
  • Stored Procedures and Stored Functions, using the SQL:2003 syntax, which is also used by IBM's DB2
  • Triggers (row-level)
  • Server-side cursors (read-only, non-scrolling)

Implementing ANSI SQL standard ways of using existing MySQL features means there will be fewer

  [Read more...]
The 2006 MySQL User?s Conference & Expo
+0 Vote Up -0Vote Down

Well, it looks like preparation for the 2006 MySQL User's Conference and Expo is underway, with the http://www.mysqluc.com/ site updated to reflect the 2006 conference.

What we can discern so far is that the theme is this:

Discover. Connect. Succeed. Scale Your Business with MySQL

The dates will be April 24-27, 2006, and the conference is going back to last year's location is Santa Clara, California.

The Call for Participation is open till November 7, and I am starting to brainstorm some sessions. This will be my fourth MySQL User's conference, and I want to try some new content. In 2003 I spoke on VB development with MySQL, in 2004 I spoke on Migrating Access and SQL Server data to MySQL, and in 2005 I spoke on Migrating Access and SQL Server

  [Read more...]
New Function
+0 Vote Up -0Vote Down

Here's a quick function you may find useful, it calculates a timespan in hours and quarter hours (4.25, 5.5, 6.75, etc):

DROP FUNCTION IF EXISTS `upto`.`hours_and_quarter_hours`$$
CREATE FUNCTION `upto`.`hours_and_quarter_hours`(p_start_time DATETIME, p_end_time DATETIME) RETURNS decimal(5,2)
    DECLARE quarter_hours INTEGER;
    SET quarter_hours = CEILING((UNIX_TIMESTAMP(p_end_time) - UNIX_TIMESTAMP(p_start_time)) / 900);
    RETURN FLOOR(quarter_hours / 4) + (MOD(quarter_hours,4) * .25);
A new Machine
+0 Vote Up -0Vote Down

In order to better document MySQL on Mac, I have recently acquired a Mac Mini. This brings my collection of desktop machines to three:

The black machine is a Windows box, the white machine runs Linux, and now a Mac Mini.

The new addition closer up:

This is the first Mac I have had regular use of, so I am sure I have some learning to do. For now I just need to get MySQL and the GUI tools installed, then find where they hide the command-line.

MyCon & Mascon: 2005.2.9 Released
+0 Vote Up -0Vote Down
SciBit has released update MyCon MySQL GUI v2.9 today. This is primarily a bugfix and existing feature enhancement update for v2.8.x. In short, it contains all the fixes which SciBit could already release without having our customers wait for the upcoming MyCon version 3.0 release:

* Added: MyLook ActiveX API for MyCon.
* Added: Another couple of Import & Export formats for your table's data, see features for more details.
* Added: Close Connection Action command
* Added: Bolding of folders to designate live connections
* Added: Support for auto 30 day trial generation and an easy to click "Get trial codes" button in the About dialog to automatically fetch trial extensions.
* Fixed/Added: SQL

  [Read more...]
Lamenting a Loss of Language
+0 Vote Up -0Vote Down

I went to the annual local airshow today, got to see some nice planes, got a great sunburn, and got another reminder that I am slowly losing my second language. From 1996 to 1998 I lived in southern Japan and became a pretty good speaker of Japanese. Not pretty good in the sense that a guy who watches too much Anime considers himself pretty good at Japanese, but pretty good in the sense that I spoke Japanese every day, did spoken translations at meetings, and on more than one occasion would get a good ways into a telephone conversation before the person on the other end of the phone would realize I was not my Japanese roommate. I was almost illiterate when it came to the written word, but at spoken language I was pretty darn good, all I needed was more and more words in my vocabulary (Japanese grammar is a breeze once you know the rules, and there are no

  [Read more...]
Cancel the Display of a ContextMenuStrip in VB.NET 2005
+0 Vote Up -0Vote Down

I encountered a bug recently in my tool where I could right-click on a listview, even if I was not right-clicking on a listview item, and still use the item related entries of a contextMenuStrip. The problem is that unlike the TreeView, the ListView does not allow you to assign a ContextMenuStrip to individual items, just the control as a whole.

The solution was to use the new Opening event of the ContextMenuStrip:

Private Sub eventMenu_Opening(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs) Handles eventMenu.Opening
        If lvwEvents.SelectedItems.Count = 0 Then
            e.Cancel = True
        End If
End Sub

By setting e.Cancel to True, the menu is never shown. I determine whether an item was clicked on by checking the count of selecteditems.

MyComponents: Version 2005.4.2 released - Now with piping support
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.2 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this forum, as well as some new functionality. Without explicitly setting the new properties, and thereby using the new features, should this version be completely compatible with your existing code.

What new?

ptTCP/ptPipe: now sports connection capabilities which includes tcp (default), as well as using the MySQL pipe on the localhost.

New: Carry over support for previously set macro values
New: Added QueryInfo public method to obtain MySQL query informative result string
New: Added support for MySQL 5.0.3 FIELD_TYPE_BIT as ftBoolean
New: Added support for MySQL 5

  [Read more...]
MyCon & Mascon: MyCon Tip 4: How to deploy MyCon on different computers?
+0 Vote Up -0Vote Down
Once installed, has MyCon very little dependence on its environment. In fact, it can run and function fully, without any formal installation on the target computer. The only reasons MyCon relies the installation are:

1. The mylook:// URL is registered in the registry. So if you use any external shortcuts to mylook folders, then this will not function without a formal installation.
2. The mylook installation directory is registered in the registry so that any subsequent updates/patches can automatically find mylook/mycon to update files. If you update manually, will this therefore not be important either.

So, installing MyCon on a secondary computer, is as simple as:
1. Copying your current directory to the

  [Read more...]
MyComponents: Quick Tip 1: Flying Datasets
+0 Vote Up -0Vote Down
Due to popular demand, are we reposting our flying dataset MyComponents Quick Tip from almost a year back.

Many times in development, do you find yourself just quickly looking for a dataset containing something from the database. Usually will such a dataset not be connected to visual controls. TMySQLServer is capable of creating, maintaining and destroying just such dynamic "in-memory" datasets. These datasets closely resemble ADO or ASP style coding and each dataset is referenced by a userdefined name. You can even connect such datasets up master-detail. The aim is of course to minimize the number of lines you have to write and your effort in general. Here are a couple of examples:

Example 1 (Usage):

with TMySQLDataset(MySQLServer1.Dataset) do begin

  [Read more...]
MyComponents: MySQL ClientLibrary 4.1.10 released
+0 Vote Up -0Vote Down
SciBit now also maintains our own libmysql.dll which supports both old and new authentication and is only 157KB in size. So if you absolutely have to use a dll (instead of the Direct driver), then you can download it from MyComponents

Unlike MySQL's newest clientlibraries, which are 1-2MB in size and is usually not versioned, does the SciBit library contain full version info, is small and works 100% with the MyComponents. NOTE: It only implements the API needed by the MyComponents, which is minimilistic, so don't go replace all your other apps' libmysql.dll with it!

It is also free, and contains 0% MySQL source code (it is written 100% in native Delphi) and therefore does not carry any licensing issues for your commercial applications.

Regards, Support
MyComponents: Campus: MYSQLTABLE1
+0 Vote Up -0Vote Down
SciBit is proud to announce the availability of our newest portal: http://campus.scibit.com.

This site is open to any and all whom which to publish or present a course on any subject. Of course, we will appreciate it very much if some of your courses do address solutions and work arounds to problems you might have experienced in regards to products and/or environments in which some SciBit products function, ex. MySQL, Delphi, Kylix, ASP, etc. But, as mentioned, your courses can be on any subject you choose, and is a way for you to give back some of your acquired knowledge to the world. We have added a few categories already and any one can register as a teacher, to compile your own courses, or as a student, to signup for courses (if they are hidden from public view).

If you wish to compile private courses and do so as a commercial venture

  [Read more...]
MyComponents: Quick Tip 7: How do I get any file contents into a blob?
+0 Vote Up -0Vote Down
This question pops up often, but the solution is not specific to MyComponents, and will work in and with any Borland dataset component (in fact, this is how you are suppose to do it in Delphi/Kylix):


the following of course also works:

or you can also use the LoadFromStream and SaveToStream methods.

NOTE: If you post blobs to a table in MySQL you should keep a couple of things in mind:
1. The blob value is sent to the MySQL using a standard SQL statement. For this purpose, the value is hexed by the dataset and thus 2 SQL characters=1 blob byte.
2. Most MySQL servers' "max_allowed_packet" variable is set to a default value of

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 85

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.