Navicat Blog

MySQL Default Values: Good or Bad? - Part 1: Strict SQL Mode May 22, 2020 by Robert Gravelle

Part 1: Strict SQL Mode

Getting errors when you don't supply a value for a non-null column can be an immense source of frustration. There's a way to minimize the occurrence of such errors by setting a default value for those columns. Seems like an easy fix, but, as in all things, the devil's in the details. You have to be careful that you don't add a bunch of generic - and useless - data to your tables just for the sake of making INSERTs easier. In today's blog, we'll learn about the ramifications of MySQL's Strict SQL Mode, as well as how to view and set it using Navicat for MySQL 15. In part 2 we'll cover when it makes sense to employ default values (and when it doesn't).

Top N Queries by Group May 14, 2020 by Robert Gravelle

A Top N query is one that fetches the top records, ordered by some value, in descending order. Typically, these are accomplished using the TOP or LIMIT clause. Problem is, Top N result sets are limited to the highest values in the table, without any grouping. The GROUP BY clause can help with that, but it is limited to the single top result for each group. If you want the top 5 per category, GROUP BY won't help by itself. That doesn't mean it can't be done. In fact, in today's blog, we'll learn exactly how to construct a Top N query by group.

Is the Database or Application the Best Place for a Custom Function? May 6, 2020 by Robert Gravelle

Deciding whether do create a function in the database or in application code can be a daunting one. All-too-often, you don't realize that you've made the wrong choice until it's a big hassle to make an about-face. Worse still is the fact that many developers base their decision on whether they're most familiar with SQL or application coding! A better approach is to rely on the strengths of a technology to help guide your decision. In today's blog, we'll break down the decision making process when choosing between a user-defined function (UDF) and one that resides on the application side.

Managing Databases Remotely Using Navicat - Part III Apr 29, 2020 by Robert Gravelle

Part III: Navicat Cloud FAQ

While Navicat Cloud has been around for a few years now, it has really come into its own recently, as the Covid-19 pandemic has forced organizations to implement a work from home protocol. We learned the basics of Navicat Cloud in the last blog, Navicat Cloud and Team Collaboration. If you're following along, that was part 2 in the series. In this last installment, we'll pick up were we left off last week and look at how Navicat Cloud can help your team be more productive while working remotely by answering your biggest questions.

Managing Databases Remotely Using Navicat - Part II Apr 22, 2020 by Robert Gravelle

Part II: Navicat Cloud and Team Collaboration

As the Covid-19 pandemic wears on, organizations that can support working from home have continued to remain productive while maintaining physical distancing. In last blog we learned how to access sensitive work data by establishing a secure connection to a remote database via Navicat Premium 15. Today's follow-up will introduce Navicat Cloud, an add-on feature inside Navicat Development and Administration products for collaborating with team members from across town to around the globe.

Navicat Blogs
Feed Entries
Blog Archives