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 中文
Showing entries 1 to 30 of 47 Next 17 Older Entries

Displaying posts with tag: Information (reset)

MySQL error handling on server side: a NO GO!
+3 Vote Up -2Vote Down

There is no reasonable way to catch and diagnose errors on server side. It is nearly impossible to know exactly what went wrong.

To illustrate, consider the following query:

INSERT INTO my_table (my_column) VALUES (300);

What could go wrong with this query?

  • We might hit a UNIQUE KEY violation
  • Or a FOREIGN KEY violation
  • my_column could be TINYINT UNSIGNED, and with strict sql_mode this makes for out-of-range
  • Or, similarly, it could be an ENUM (2,3,5,8)

Is that it? Not remotely:

  • This could be a read-only MyISAM table
  • We may have issued a LOCK TABLES my_table READ -- this violates our lock
  • Or this could be an
  [Read more...]
OpenDBCamp: Information Lifecycle Architecture
+2 Vote Up -2Vote Down
The Open DB Camp in Sardinia 2011 has had a number of sessions on varying topics. Topics range from MySQL over MongoDB to replication and High Availability.

I decided to tap into the database expert resources present here at Sardegna Ricerche by discussing a non-database issue, where one can expert database experts to have insights beyond those of end users. And they did.

The topic was the particular case of information overload many of us suffer from on our hard disks: Too many files, too hard to find.
  • How do we find the bank statement from April 2007 from the





  [Read more...]
MySQL related bookmark collection
+2 Vote Up -0Vote Down

I am publishing my MySQL related bookmark collection http://www.mysqlpreacher.com/bookmarks/.

Feel free to send me links you think might be good to add in order to help others.

Remember, SHARING IS CARING!!! …. we get so much for free, why shouldn’t we give some back?

Cheers,
Darren

The MySQL Librarian is here!
Employee +8 Vote Up -1Vote Down

I have had a wish for a few years. I wanted to find a way to put together the valuable information that the community produces about MySQL, a way that would let me easily find the interesting content that I may have missed when on vacation, or when busy with a conference, a company meeting, or a long stream of coding.

That wish started to take shape last year, when I was traveling with Dups during the East Coast tour. I drove, he took notes. He drove, I took more notes. During meals and walking breaks we discussed and refined the idea. When we went back home, a plan was ready. Dups started coding in January.

At first, his changes were completely invisible. He was refactoring the Planet MySQL code to integrate it with the advanced

  [Read more...]
The MySQL Librarian is here!
Employee +0 Vote Up -0Vote Down

I have had a wish for a few years. I wanted to find a way to put together the valuable information that the community produces about MySQL, a way that would let me easily find the interesting content that I may have missed when on vacation, or when busy with a conference, a company meeting, or a long stream of coding.

That wish started to take shape last year, when I was traveling with Dups during the East Coast tour. I drove, he took notes. He drove, I took more notes. During meals and walking breaks we discussed and refined the idea. When we went back home, a plan was ready. Dups started coding in January.

At first, his changes were completely invisible. He was refactoring the Planet MySQL code to integrate it with the

  [Read more...]
The MySQL Librarian is here!
Employee +0 Vote Up -0Vote Down

I have had a wish for a few years. I wanted to find a way to put together the valuable information that the community produces about MySQL, a way that would let me easily find the interesting content that I may have missed when on vacation, or when busy with a conference, a company meeting, or a long stream of coding.

That wish started to take shape last year, when I was traveling with Dups during the East Coast tour. I drove, he took notes. He drove, I took more notes. During meals and walking breaks we discussed and refined the idea. When we went back home, a plan was ready. Dups started coding in January.

At first, his changes were completely invisible. He was refactoring the Planet MySQL code to integrate it with the

  [Read more...]
MySQL Workbench 5.1.4 Alpha Available
Employee_Team +0 Vote Up -0Vote Down

We’ve packaged another alpha-version of our current work-in-progress version of workbench - version 5.1.4. We’ve added more features, fixed problems and started to build packages for Fedora Core 9 along with our binaries for Ubuntu 8.04.

MySQL Workbench OSS 5.1.4 Alpha - Linux

Source Tar Ball

ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.4alpha.tar.gz
ftp://ftp.mysql.com/pub/mysql/download/gui-tools/mysql-workbench-5.1.4alpha.tar.gz.md5

Binaries for Fedora Core 9


  [Read more...]
OpenGL and Workbench Canvas News
Employee_Team +0 Vote Up -0Vote Down

Recently, a bug that caused excessive memory usage and slowness (specially in large models) in Workbench has been fixed in its canvas. From the testing I’ve done, the speed for displaying diagrams seems to scale much better and dragging around tables in large models is doable in an acceptable speed. This fix is in the upcoming releases of the 5.0 and 5.1 alpha versions of Workbench.

Apart from that, we’ve been doing some work on reintroducing OpenGL support to the Workbench canvas. Unlike the initial implementation, this time OpenGL is used directly instead of going through Cairo’s experimental (and not quite reliable) support through the Glitz layer. This means that in machines with a recent graphics card, hardware acceleration will be used and working with large diagrams will be a lot smoother and faster. Of course, software rendering backends (GDI+, Quartz and Xlib) will still be

  [Read more...]
MySQL Workbench 5.0.25 coming next week
Employee_Team +0 Vote Up -0Vote Down

As you may have noticed we’re going for a major milestone on our Workbench 5.1 roadmap. So our resources are pretty much concentrated on this  task at the moment. But it’s just as important to keep improving our 5.0 GA version, so we will reserve the first days next week to make progress here as well. We will publish the next release of 5.0 mid-next-week. So stay tuned for a better 5.0 next week and the upcoming 5.1 alpha later this month.

MySQL Workbench 5.1 OS X Screen Designs
Employee_Team +0 Vote Up -0Vote Down

Before I am leaving for my summer vacation I wanted to share the first screen designs for the Mac version of Workbench. Click on the small images below to view the screenshots at full size.

The first shot shows the new Overview Page. It holds the Workbench Central panel (that can be collapsed of course), the Machine-Group panels and a Notes panel. Each machine tab holds a list of Database Connections and MySQL Models that are associated with that particular machine. (The list of Database Instances shown in this screenshot - which will give you access to administrative features - are a WB 6.0 feature coming later next year).

When you double-click a Database Connection you will get to the new SQL Query interface that is

  [Read more...]
Preparing For Next Release - MySQL Workbench 5.0.24 Coming Soon
Employee_Team +0 Vote Up -0Vote Down

Due to summer vacations - yes, even we take some time off - our release-cycle has slowed down quite a bit so it has already been more than 4 weeks since we aired an update of Workbench. Right in the middle of testing and preparing the next build, our build-server has raised the white flag. Looks like the cooling system above the unit decided, that its too hot, and put a cold shower right down on our machine. Our engineers are quickly gathering some new iron and we are meanwhile preparing the build manually this time. There are a few bugs remaining but next package will be ready soon and we put it on our download servers - so stay tuned for the next Workbench 5.0 release.

Nice Blog Postings About MySQL Workbench
Employee_Team +0 Vote Up -0Vote Down

Quite a few Blog postings pop up recently, let me outline two of them.

Gerry Narvaja talks about multi-page printing by using the MySQL Workbench community edition utilizing the PDF output. Find his posting here.

Weizh posted a nice step-by-step tutorial on how to use Workbench to show differences between two databases. Find it here.

Both workflows get you what you want by using the Community Edition. For those of you who want everything on a silver plate there is the Standard Edition (http://mysql.com/products/workbench/) of course, which simplifies these tasks even more.

On a side note: To get more information about the printing topic Gerry joined us on our IRC #workbench

  [Read more...]
Printing in Workbench
Employee_Team +0 Vote Up -0Vote Down

A common misunderstanding seems to be that the only way to increase the available “paper space” for a diagram is by increasing the size of the paper. But there is another way to do that, which is in the Model -> Diagram Size dialog, where you can set the number of pages your diagram has, vertically and horizontally (perhaps it’s not very obvious to first time users, so we’ll be working on making it more easily accessible).

  [Read more...]
New MySQL Workbench Auto-Update Feature for SE in 5.0.22
Employee_Team +0 Vote Up -0Vote Down

We introduced a new library to use with our update-feature inside Workbench. With the new lib (yassl) it’s possible to use SSL encryption for the authentication/download of new SE releases. This was not possible with libcurl because we’re not allowed to use/bundle openSSL. As this update is included staring with 5.0.22 all SE users will have to download version 5.0.22 manually from the enterprise pages one more time. Please logon to https://enterprise.mysql.com/software/gui_tools.php with your mysql username and password, download the latest release and launch the installer manually. Sorry for the inconvenience.

ID group in the EP filed motion calling for balanced patent policy, criticizing the EPLA
+0 Vote Up -0Vote Down

Yesterday three groups in the European Parliament (PES, Greens/EFA, GUE/NGL) announced their motion for a resolution on patent policy. I published their press release earlier today on this Web site.

In parallel, the Independence/Democracy group in the European Parliament (commonly abbreviated as ID or IND/DEM) filed this motion for a resolution on patent policy. The motion was put forward by Tom Wise, an MEP from the UK Independence Party who spoke out in strong terms against the software patent directive.

The ID motion is

  [Read more...]
PRESS RELEASE: European patent controversy heating up again
+0 Vote Up -0Vote Down

Three groups in the European Parliament (i.e., international-level parties) yesterday authorized me to distribute the press release below to my media contacts:

European patent controversy heating up again

PES, Greens/EFA and GUE/NGL groups in European Parliament file motion for resolution — Proposal calls for “balance between the interests of patent holders and the broader public interest in innovation and competitive markets” — Commissioner McCreevy’s preference, the EPLA, is seen as weakening EU democracy, increasing litigation costs and “exposing SMEs to greater

  [Read more...]
EU commissioner McCreevy: software patents are ?a goal worth pursuing?
+0 Vote Up -0Vote Down

On Friday, EU internal market commissioner Charlie McCreevy (whose historical ties with Microsoft and similar companies are mentioned in my book) delivered this speech on his intellectual property rights (IPR) strategy. He flew all the way up to Helsinki for an informal meeting of the ECOFIN (economic & finance) Council of the European Union.

In his speech, he said the European Patent Litigation Agreement (EPLA) “is a goal worth pursuing” and that he wanted to involve the EU in the EPLA negotiations “and bring them to finality”. He falsely claims that the EPLA would “offer valuable cost savings”: even Nokia

  [Read more...]
Release 1.03 of my book No Lobbyists As Such
+0 Vote Up -0Vote Down

I fixed a couple of typos in my book No Lobbyists As Such - The War over Software Patents in the European Union. Thanks to Marco Menardi for having pointed me to those typos.

At a glance: How they?re trying (again) to legalize software patents in Europe
+0 Vote Up -0Vote Down

I have previously reported in this blog how certain European politicians and patent bureaucrats are trying, once again, to give software patents a stronger legal basis in Europe. On 12 July, the European Commission held a public hearing in Brussels, and the European Parliament is shooting for a vote on a patent policy resolution toward the end of this month.

If you’d like to know why the European Patent Litigation Agreement (EPLA) is, among other bad things, a road to software patents, please have a look at this two-page diagram (PDF file). And if you’re subsequently interested in some more background information and facts, this three-page briefing document

  [Read more...]
Working on post-hearing matters
+0 Vote Up -0Vote Down

As I explained in this blog, it’s always a difficult decision for me to keep postponing my own project in order to work on the patent policy front. But once again, like so many times before, I have decided to do so for some more time. Given what happened at the July 12 hearing, there are some important things to do right away. I’ll talk a little more about my personal future on some other occasion, but suffice it to say that I’m still actively involved in the European patent policy debate!

A career apart from campaigning
+0 Vote Up -0Vote Down

After I mentioned in this blog posting a week ago that I’d make an announcement on August 28 concerning my future priorities, I received different reactions. Mostly there seems to be a lot of understanding and appreciation for what I’ve contributed to the fight for balanced patent policy, and that’s great. But some people misunderstood my remark: the decision hasn’t been taken yet, and it’s not an appropriate point in time to say which outcome is more likely because a lot can still happen in one week. Come August 28, I’ll decide and announce.

What transpired from of the responses isn’t really a surprise: to many people I’m simply “Mr. NoSoftwarePatents” because that’s the context in which they first came to know me.

  [Read more...]
Sun?s Simon Phipps? personal opinion: No Software Patents!
+0 Vote Up -0Vote Down

I just saw this article:
http://opensource.sys-con.com/read/261119.htm

It quotes from the personal (not corporate!) blog of Simon Phipps, Sun’s chief open source executive. The first time I heard Simon speak out on patents was in November 2004 at an FFII conference in Brussels. A couple of months earlier, I had criticized him in the forum of NoSoftwarePatents.com in a way that I later on regretted. Even though the NoSoftwarePatents campaign was highly successful, there are three or four things that I shouldn’t have said or written during those days, and what I said about Simon’s credibility has the top spot among that list of


  [Read more...]
Two more weeks of political summer hiatus
+0 Vote Up -0Vote Down

On August 28 — i.e., in two weeks from tomorrow — the European Parliament will return from its summer vacation. You can find the EP’s calendar here: There are different color codes, and those days which have no color at all are holidays and vacation days.

While the EP is not the only EU institution, it’s clearly one of the most important ones, and its return marks the end of what is usually the slowest part of the summer season in Brussels. Upon its return, the parliament is going to take a look at patent policy again, and is in particular going to evaluate the outcome of the European Commission’s patent policy hearing that took place in Brussels on July 12. In late May, several

  [Read more...]
GPL 3: FSF should stand firm on patents no matter what HP and other large corporations say
+0 Vote Up -0Vote Down

I just saw this article on how Linus Torvalds on the one hand and Hewlett-Packard on the other hand reacted to the Free Software Foundation’s (FSF) second draft of its GPL v3 license.

Just like Linus, I, too, have said all along that digital rights management (DRM) is not categorically illegitimate and thus must not be ostracized as a whole. While Linus still seems dissatisfied with the FSF’s proposed GPLv3 in this respect, the aforementioned article quotes Hewlett-Packard (HP) saying that based on a preliminary analysis, there’s been a lot of progress on that front.

But the article also reports that HP wants the FSF to soften its stance on patents. I can only hope that the FSF will continue to stand firm on this issue. It’s obvious that certain

  [Read more...]
Renominated to Managing Intellectual Property magazine?s ?top 50 most influential persons in intellectual property? list
+0 Vote Up -0Vote Down

A couple of days before Wednesday’s European Commission hearing, I learned that Managing Intellectual Property magazine, the leading international magazine for IP owners which has more than 10,000 readers around the globe, renominated me to its annual list of the “top 50 most influential persons in intellectual property”.

The first time I appeared on that who-is-who list was a year ago, and ZDNet reported on that fact under the humorous headline “Anti-patent campaigner hailed as IP hero”.

  [Read more...]
Day One of New EU Patent War
+0 Vote Up -0Vote Down

- PRESS RELEASE -

DAY ONE OF NEW EU PATENT WAR:
EU COMMISSION PUSHES FOR LITIGATION AGREEMENT

EU internal market commissioner McCreevy said at yesterday’s hearing
on the future of European patent policy in Brussels that he wants to
“move forward” with the European Patent Litigation Agreement (EPLA) -

Anti-software patent campaigners vehemently oppose the EPLA,
claiming it is “from a software patents point of view […] far worse”
than the directive they defeated in the European Parliament last year

Brussels (July 13, 2006) - At yesterday’s European Commission hearing in Brussels on the future of European patent policy (






  [Read more...]
European Commission may ask European Court of Justice for opinion on EPLA ratification
+0 Vote Up -0Vote Down

As I explained in my previous blog entry, EU internal market commissioner Charlie McCreevy is going to announce pretty soon that he wants to help to get the European Patent Litigation Agreement (EPLA) ratified. The EPLA is a new attempt to make software and business method patents more enforceable in Europe, and beyond that effect, it would generally encourage certain types of patent holders to litigate.

But there’s a technical problem (”technical” in terms of “legally technical”): The European Commission’s legal services say the EPLA is a so-called “mixed agreement” that the member states of the EU cannot conclude on their own: they need the EU involved. To be very precise, it’s not the EU (European Union), but the EC (European

  [Read more...]
No doubt: EU Commissioner McCreevy is determined to back the EPLA (European Patent Litigation Agreement)
+0 Vote Up -0Vote Down

Superficially, it appears that the European Commission is going to evaluate the 2,500+ replies it received to its January 2006 questionnaire on patent policy as well as the input it will receive at this coming Wednesday’s (July 12) hearing prior to deciding how to move forward in the area of patent policy.

However, it would be naive to believe there is even the smallest doubt as to what EU internal market commissioner Charlie McCreevy intends to do. He has decided on that a long time ago, at least a number of months, possibly as early as last fall.

McCreevy has a new game plan after his failure to push the software patent directive through last year. That directive was not his baby originally:

  [Read more...]
What?s the gist of a hearing?
+0 Vote Up -0Vote Down

Yesterday I published the text of the short speech I’m going to give at the European Commission’s patent policy hearing on Wednesday (July 12). I think I should explain to the non-politicos among you what the term “hearing” means in this context.

Governments, quasi-governmental bodies (which is how I’d describe the European Commission, non-judgmentally) and legislators (for the most part, that means parliaments or subsets of a parliament, such as a committee or a party) frequently conduct hearings. At a hearing on a particular topic (in this case, patent policy), politicians and their staffs listen to people who are, personally or professionally, affected by a future

  [Read more...]
Manuscript for my speech at the European Commission?s upcoming hearing on the future of the European patent system
+0 Vote Up -0Vote Down

This coming Wednesday (July 12), I am going to speak during the litigation part of the European Commission’s patent policy hearing in Brussels. The hearing marks the end of a consultation process that began in January when the Commission published a questionnaire, in reply to which I wrote a position paper. At the hearing I am going to deliver the following short speech:

Ladies and Gentlemen,

Some of you may already know me as the founder of the NoSoftwarePatents campaign, but let me start by introducing myself a little more specifically. I’m an

  [Read more...]
Showing entries 1 to 30 of 47 Next 17 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.