3 Most Used Database Management/Development System

-
MySQL Workbench, SSMS and Navicat

Managing database can not be done by just using simple command line queries. Sometimes it's to complicated so we need to have a graphical user interface to get things done with our database.

Wit a management tool, you can do many database operations much more quickly, you can just navigate to different menus and buttons that are available on the program you are using.

Here are my top three favorite database management system I usually use when I need to be doing some database operations.

1. MySQL Workbench

It's kind of like the official database  management tool for MySQL. It quit comprehensive on doing some database stuff.

It can only be used if you are using MySQL database, well maybe you can use it for MariaDB, which two databases have no significance differences.

But from my experience. I have tried basic functionalities like queries, schema design only. I am not sure if it can be compatible for more advanced operations.

2. SQL Server Management Studio (SSMS)

This also the official database management studio like Workbench, but as already stated from its name, it can only work for SQL server database. It's completely Microsoft based program for Microsoft product only.

The UI looks so classic, not modern, blurry text, etc. It also laggy on some lower computer specs. I am using 8 gigs with Intel core I7, maybe you need much higher specs.

But sure it's full pledged system, you can do almost everything advanced using SSMS

3. Navicat

Navicat by Premium Soft is the best, perfect, for doing database operation I've ever used. The program is loaded very quick and also everything just work really nice and accurate.

Features so complete for a database management. It's not freeware application, but sure it's worth the many you pay for. This is the perfect tools for doing almost all kind of database system.

Navicat is the perfect one, it's not only capable for managing MySQL database system, but it can also do other system like SQL server. In fact ,it supports many other database systems such as MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite.

It is harder to do some SQL queries on our database just by using a terminal or console. For some simple commands of course maybe we can do it just using console. But it's much more efficient if we use an advanced database management with user interface suited for the specific database you use.

As programmer, those three programs are among the must have application, because i really need them for doing my job. They have been very helpful for my database development tool needs. I hope they can improve to make much more efficient and feature rich.


Popular posts from this blog

ERROR 1348 Column Password Is Not Updatable When Updating MySQL Root Password

-
Image
MySQL and MariaDB password As already mentioned in the title of this blog, this error message sometimes occurred when we are trying to update our root password database, either MySQL or MariaDB, The error says: ERROR 1348 (HY000): Column 'Password' is not updatable This is because if we use this SQL command to update our database root password, and it turn out to be Restricted by MySQL to use update on mysql database. UPDATE mysql.user SET Password=PASSWORD('1234') WHERE User='root'; The solutions for MySQL Error1348 So you can not update a user password using Update commands, to update the password, use ALTER commands instead. like the following. ALTER USER 'root'@'localhost' IDENTIFIED BY '1234'; And then you need to do the flush privileges to commit previous queries (that alter command above) into the system, simply do like this. flush privileges; So now you have your root with password 1234. Although it is recommended to
Read more

How To Create Spring Boot Project Using Netbeans

-
Image
Spring Boot is a handy tool that simplifies the development of Spring Framework applications by reducing the need for cumbersome configuration. In this tutorial, I'll guide you through creating a Spring Boot application using the Netbeans IDE. While you can certainly create a Spring Boot application in Netbeans manually, it's much easier with a plugin designed for Spring development. Here's a step-by-step guide to get you started: 1. Install the Spring Boot Plugin: Open Netbeans and navigate to the Tools menu. Click on "Plugins." Once the Plugins window opens, select the "Available Plugins" tab. Look for the "Nb SpringBoot" plugin, then install and activate it. 2. Create a New Spring Boot Project: After restarting Netbeans IDE, you can create a new project with Spring Boot. Go to File > New Project. Under Categories, select Maven, then choose "Spring Boot Basic." 3. Add Dependencies: With your new project created, open the po
Read more

Spring Kafka - How to use ReplyingKafkaTemplate send and reply synchronously

-
Image
Microservice Spring with Apache Kafka Today, I want to share how to use Kafka. It's quite interesting once you get the hang of it, and I hope my explanation will make it a bit easier for you. So, Kafka is primarily known as an asynchronous messaging queuing system. This means it allows different parts of your application to communicate with each other without waiting for immediate responses. However, there are times when you might need a more immediate reply from another service in your project. Luckily, Kafka can handle this too. Here’s how it works: The client side sends a message to the server side via Kafka. This message includes a special identifier in the Kafka header request, known as KafkaHeaders.CORRELATION_ID, along with a topic where the server should respond. The server, after processing the request, sends a message back to the same topic with the same correlation ID. This way, the client knows that the message is a response to its initial request and can act accordingl
Read more