via GIPHY I was at a dinner party recently, and talking with some
colleagues. I had worked with them years back on Oracle systems.
One colleague Maria said she really enjoyed my newsletter. Join
38,000 others and follow Sean Hull on twitter @hullsean. She went
on to say how much has changed in the last …

The story of Steven Mapes, an experienced software developer who
has been using SQLyog MySQL GUI since 2002.

We were so thrilled to speak with Steven Mapes for two simple
reasons. One, he is an ardent user of SQLyog. Two, he has been
using the tool since 2002 (we had released the GA version of
SQLyog in 2002). And, it is users like Steven who make the
product successful with their constant support and feedback that
keeps us going.

We go down memory lane and learn some interesting facts about
SQLyog that made Steven stick with the tool for more than a
decade.

Steven Mapes is a self-employed software solutions provider who
develops web-based polyglot solutions for clients often hosted
within the cloud since 2012. Before it, he was the Head of IT for
Moko Social Media in the UK. When asked about how he came across
SQLyog and the need to use the tool, Steven says,”My first
exposure to SQLyog was back in 2002 when the …

SQLyog is a professional-grade GUI tool for the MySQL RDBMS.
SQLyog is available for the Windows operating system starting
from Windows XP/Windows 2003 to Windows 8/Server 2008 R2. It will
also work under Linux, Unix and Mac OS X using the Wine
environment. Moreover, a subset of SQLyog Enterprise/Ultimate
functionalities are available with the free SQLyog Job Agent
(SJA) for Linux as a native Linux utility. This makes it possible
to specify and test ‘scheduled jobs’ on a Windows environment and
port execution parameters seamlessly to a Linux environment.

Why Use a Database Administration Tool

Database administration tools provide a GUI/Web interface to
automate database tasks like querying tables, find and replace
operations, and any other task that you might want to run on a
database. With respect to MySQL, it offers the free MySQL Workbench.
Although it’s far more …

Successful applications often become limited by MySQL
performance. Michael will show you how to get great MySQL
performance using Percona Monitoring and Management (PMM). There
will be a demonstration of how to leverage the combination of the …

via GIPHY I was just responding to some Disqus comments on a
recent blog post. Admittedly it had a provocative title Will SQL
databases just die already. What do you think? Join 34,000 others
and follow Sean Hull on twitter @hullsean. A reader pointed out
that some No-SQL databases do support joins. Huh? My face …
Continue reading A roughneck walk down database
alley →

With tons of new No-SQL database offerings everyday, developers
& architects have a lot of options. Cassandra, Mongodb,
Couchdb, Dynamodb & Firebase to name a few. Join 33,000
others and follow Sean Hull on twitter @hullsean. What’s more in
the data warehouse space, you have Hadoop, which can churn
through terabytes of data and get … Continue reading Will SQL just die already? →

Experts say that the world’s data is doubling every two years.
This epic increase in Big Data in recent times has highlighted
the limitations of reliance on traditional forms of data storage
and management and focused attention on new methods for
addressing the volume and variety and veracity of structured and
unstructured data.

Not long ago, data was stored in physical files that were
archived into racks of folders filling up entire rooms in the
offices of large corporations. Then came computers, and the go-to
technique for storage changed to flat file databases.

Ever since the 1970s, SQL databases have been an integral
part of the IT infrastructure of organizations. And today
MySQL, an RDBMS based SQL implementation for the web, now
powers very large-scale websites like Google, Facebook, Twitter
and even YouTube. In fact, MySQL is the world’s …

This release introduces a new major feature – ‘read-only’
connections – as well as Kerberos authentication
support and a few bug fixes.

Changes as compared to MySQL GUI 12.3.3
include:

Features:

* Added an option for defining a connection as ‘read-only’.
There is a checkbox in the connection settings and when
checked the title bar will inform user about the ‘read-only’
state. In ‘read-only’ state statements that write cannot be
executed. For more details please see note at the bottom.
* Added support for the MariaDB auth_gssapi (Kerberos) plugin.
This plugin is available with the latest 3.0 (alpha)
Connector/C from MariaDB. But there seems to be a
huge popular demand for this already, and we have backported
it to the 2.3 connector version we use in SQLyog. Note that
support …

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.