As we know, the MySQL prepared statements API leaves a bit to be desired, although there is a fair amount of progress. With MySQL, using the "normal" API or the prepared statement API usually doesn't have that much different in terms of performance.

When you use Oracle though, things are different. There is no separate "prepared statement" API, there is just on interface, which has a lot of functions and structures, and isn't the easiest to use, because of the complexity, but it IS very functional and performant.

If we look at the low-level Oracle interface, there used to be three of them:

• Oracle Call Interface (OCI) - This is the the interface that is most complex, but also most functional. It is a C level interface along the lines of the MySQL C API, i.e. you still pass SQL statements, it's not a file level interface of some kind. This is also the interface that is used to build Oracle Data …

Just like "Freedom of Speech" is a basic human right, "Freedom of Software" is a basic right for the technology evolution. GlassFish gives you the freedom:

• To Pick your own framework: Java EE, Ruby-on-Rails, Python/Django, Groovy/Grails, or any other
• Choose your IDE: …

There has been a significant increase in interest in the Memcached, the open source distributed memory object-caching system, in recent months, as a number of vendors look to exploit its popularity in Web 2.0 and social networking environments.

Like Hadoop, which has become the focus of a number of commercial plays, it would appear that the time is right for commercialization of Memcached. But what is it, here did it come from, and what are the chances for vendors to rake in serious cash? Here are the details.

What is it?
Pronounced mem-cash-dee, Memcached was originally created by Danga Interactive (the developer of LiveJournal, which was acquired by Six Apart in 2005) to speed up the performance of dynamic Web applications by alleviating database load. Memcached has become an industry standard for improving the performance of dynamic websites.

The code is available from the …

Forget tedious hours of searching links to the renamed object and replacing them.

To save your efforts, dbForge Studio for MySQL automates renaming of tables, columns of tables, views, aliases, stored routines, local variables, triggers, events, UDFs, and users and even offers a convenient preview of the changes before applying them.

To rename an object in the script, right-click it and select the Rename option from the menu. The Rename dialog box opens where you can enter a new name and view all references to the renamed object in the expressions, strings, and even comments.

All you have to do is to select required references and press OK!

The refactoring functionality is indispensable while working with database projects. You can export a database to a project, rename …

No doubt you want to cast you first vote for my abstract — Developing Plug-ins for Oracle Enterprise Manager by example :)

Every Oracle professional knows about Oracle Enterprise Manager’s extensive monitoring capability for Oracle products. However, only few realize that Oracle Enterprise Manager can be easily extended thanks to its Extensibility framework.

This presentation starts with an introduction of Enterprise Manager’s Extensibility features and walks the audience through the basics of creating a new plug-in. This session will also demonstrate some proven plug-in development steps based on the experience gained from developing MySQL management …

Sometime you may need to populate(sync) local testing table with the production table which is hosted on a remote server.


# This command should be run on local server(SINGLE COMMAND)

mysqldump -t -h [remote_host_ip] -u[remote_User] -p[remote_Password] [remote_DbName] [remote_TableName] | mysql -h localhost -u [local_User] -p[local_Password] [local_DbName]


What if you want to copy last month data only?

mysqldump -t -h [remote_host_ip] -u[remote_User] -p[remote_Password] [remote_DbName] [remote_TableName] -w "column_date_time > NOW() - INTERVAL 1 MONTH"| mysql -h localhost -u [local_User] -p[local_Password] [local_DbName]
7TKU66CE8V5W

Just like "Freedom of Speech" is a basic human right, "Freedom of Software" is a basic right for the technology evolution. GlassFish gives you the freedom:

• To Pick your own framework: Java EE, Ruby-on-Rails, Python/Django, Groovy/Grails, or any other
• Choose your IDE: …

Just like "Freedom of Speech" is a basic human right, "Freedom of Software" is a basic right for the technology evolution. GlassFish gives you the freedom:

• To Pick your own framework: Java EE, Ruby-on-Rails, Python/Django, Groovy/Grails, or any other
• Choose your IDE: …

Baron got a great amount of response from his 50 things to know before migrating Oracle to MySQL. I’m glad I invited him as a fellow MySQL colleague to my presentation to the Federal Government on Best Practices for Migrating to MySQL from Oracle and SQL Server for his inspiration.

Oracle will always be a more featured product then MySQL. There are however features that MySQL has that Oracle does not. While I’ve got a draft of a list of my own, I have several hundred incomplete drafts.

One of these features I was able to demonstrate to a client is the ability to have multiple VALUES clauses for a single INSERT statement. For example.

INSERT INTO t1(c1) VALUES (1), (2), (3), (4), (5);

…

MySQL Connector/Net 6.0.4, a new version of the all-managed .NET driver
for MySQL has been released.  This is the first post-GA release of the new
6.0 connector and includes several bug fixes from the initial GA release. 

This release is approved for use in all scenarios and officially
supports MySQL servers 4.1 and higher.   It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.0.html] and mirror sites
(note that not all mirror sites may be up to date at this point of time
- if you can't find this version on some mirror, please try again later
or choose another download site.)

IMPORTANT
We have had some reports of installer problems with this package. We are working hard to find the problem. For now it appears that making sure your system is fully updated sometimes helps.  We will release …